2010/3/13 dario@libero.it :
>>Messaggio originale
>>Da: t...@sss.pgh.pa.us
>>Data: 12/03/2010 17.51
>>A: "dario@libero.it"
>>Cc:
>>Ogg: Re: [GENERAL] Function with DEFAULT arguments
>>
>>"dario@libero.it" writes:
>>> I'm trying to use the DEFAULT option to pass parameters to t
Bruce Momjian wrote:
Also, you can do:
NET USER postgres /delete
as an administrator.
or NET USER postgres *
and then enter a new password. I dislike deleting the account in case
there are any files left behind by the old postgres such as the old
pgdata directory, a new one is
John R Pierce wrote:
> Harry Gold wrote:
> > Hello im running Windows XP and removed an older version of Postgres
> > using windows software remover, now when i try to install the newest
> > one it keeps asking for a password from Superuser? Thanks
>
> go into Windows' "Local Users and Groups"
Harry Gold wrote:
Hello im running Windows XP and removed an older version of Postgres
using windows software remover, now when i try to install the newest
one it keeps asking for a password from Superuser? Thanks
go into Windows' "Local Users and Groups" in Computer Management, and
set a ra
Hello im running Windows XP and removed an older version of Postgres using
windows software remover, now when i try to install the newest one it keeps
asking for a password from Superuser? Thanks
Thanks, but I do want 1%.
On Fri, Mar 12, 2010 at 5:19 PM, Joshua D. Drake wrote:
> On Fri, 2010-03-12 at 16:45 -0700, Gordon Shannon wrote:
> > This is 8.4, there is no pg_autovacuum table. I set it like this:
> >
> > alter table foo set (autovacuum_analyze_scale_factor=0.01);
>
> That is 1% ch
>Messaggio originale
>Da: t...@sss.pgh.pa.us
>Data: 12/03/2010 17.51
>A: "dario@libero.it"
>Cc:
>Ogg: Re: [GENERAL] Function with DEFAULT arguments
>
>"dario@libero.it" writes:
>> I'm trying to use the DEFAULT option to pass parameters to the arguments of
a
>> function.
>> Whe
On Fri, 2010-03-12 at 16:45 -0700, Gordon Shannon wrote:
> This is 8.4, there is no pg_autovacuum table. I set it like this:
>
> alter table foo set (autovacuum_analyze_scale_factor=0.01);
That is 1% changes. I think you want .10
Sincerely,
Joshua D. Drake
>
--
PostgreSQL.org Major Contr
This is 8.4, there is no pg_autovacuum table. I set it like this:
alter table foo set (autovacuum_analyze_scale_factor=0.01);
On Fri, Mar 12, 2010 at 4:31 PM, Alvaro Herrera
wrote:
> Gordon Shannon escribió:
>
> > One possibly interesting thing is that this seems to have started just
> after
Gordon Shannon escribió:
> One possibly interesting thing is that this seems to have started just after
> I set foo's autovacuum_analyze_scale_factor to 0.01, since I wanted more
> frequent analyze runs. I wonder if that could be related.
You probably set the other values to 0, which includes th
It appears to me that in my 8.4.0 system, autovacuum is running to prevent
wraparound contrary to the documentation. I have it set to a tables'
relfrozenxid has to get to 1.5 billion before that kicks in:
> show autovacuum_freeze_max_age;
15
> show vacuum_freeze_table_age;
13
Hi,
I am trying to build postgres static with mysis and as far as I can find
any hints with google I tried the following:
./configure --without-zlib --disable-shared
make
It stops with this error:
make[3]: Entering directory
`/home/postgresql-8.4.2-src/src/interfaces/libpq'
make[3]: *** No
Ok. What was I thinking, the "curved single quote" that you talked about is
the apostrophe. It makes sense now.
Thanks
Mary
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Wang, Mary Y
Sent: Friday, March 12, 2010 12
Thanks Alvaro. What do I do with a apostrophe (such as I've)?
Mary
Original Message-
From: Alvaro Herrera [mailto:alvhe...@commandprompt.com]
Sent: Friday, March 12, 2010 12:48 PM
To: Wang, Mary Y
Cc: Michał Pawlikowski; pgsql-general@postgresql.org
Subject: Re: [GENERAL] ERROR: inva
Wang, Mary Y escribió:
> Hi Michal,
>
> Thanks for the info. However, the text that the user entered is all in
> English letters. I saw this error, when I restored my database with the
> pg_dump --insert option. That row didn't get inserted to the table. What's
> interesting about this prob
Hi Michal,
Thanks for the info. However, the text that the user entered is all in English
letters. I saw this error, when I restored my database with the pg_dump
--insert option. That row didn't get inserted to the table. What's
interesting about this problem is that when I manually entered
Garrett Murphy wrote:
Jeff:
I may not fully understand the situation or the data you're trying to retrieve, but if
you're trying to get "show me all trainers whose current status is Pending", I
would go backwards to how you're doing it. If you're only concerned about those records
with tr_da
Hello,
I would like to receive comments/suggestions about this project:
http://github.com/drotiro/postpic.
In short, it's an extension that enables image processing within the
database, adding a new type (image) and several functions.
The SQL and Java interfaces are documented on the project's wik
Scott Bailey writes:
> Tom Lane wrote:
>> You can only omit arguments from right to left, so basically what this
>> requires is some foresight while choosing the function's argument order.
> What do you think about allowing 'default' as a parameter the way we do
> when inserting a record?
Seems
Hello,
I would like to receive comments/suggestions about this project:
http://github.com/drotiro/postpic.
In short, it's an extension that enables image processing within the
database, adding a new type (image) and several functions.
The SQL and Java interfaces are documented on the project's wik
Tom Lane wrote:
"dario@libero.it" writes:
I'm trying to use the DEFAULT option to pass parameters to the arguments of a
function.
When I call that function, how can I change the default value of some
arguments and leave as default the value of other arguments?
You can only omit argument
"dario@libero.it" writes:
> I'm trying to use the DEFAULT option to pass parameters to the arguments of a
> function.
> When I call that function, how can I change the default value of some
> arguments and leave as default the value of other arguments?
You can only omit arguments from righ
Ok, thanks for the quick reply and the link!
Dario
>Messaggio originale
>Da: dep...@depesz.com
>Data: 12/03/2010 17.38
>A: "dario@libero.it"
>Cc:
>Ogg: Re: [GENERAL] Function with DEFAULT arguments
>
>On Fri, Mar 12, 2010 at 05:28:57PM +0100, dario@libero.it wrote:
>> Hello,
>>
On 12/03/10 15:34, Tom Lane wrote:
> Franclin Foping writes:
>
>> I am running PostgreSQL 8.4 offered with OpenSUSE 11.2. It works
>> exceptionally well. I have installed the contrib package in order to use
>> the functions provided by XML2/pg_xml as explained in this page:
>> http://www.postg
On Fri, Mar 12, 2010 at 05:28:57PM +0100, dario@libero.it wrote:
> Hello,
>
> I'm trying to use the DEFAULT option to pass parameters to the arguments of a
> function.
> When I call that function, how can I change the default value of some
> arguments and leave as default the value of other
Hello,
I'm trying to use the DEFAULT option to pass parameters to the arguments of a
function.
When I call that function, how can I change the default value of some
arguments and leave as default the value of other arguments? In other words, is
there a way to 'call' the arguments by their name
Franclin Foping writes:
> I am running PostgreSQL 8.4 offered with OpenSUSE 11.2. It works
> exceptionally well. I have installed the contrib package in order to use
> the functions provided by XML2/pg_xml as explained in this page:
> http://www.postgresql.org/docs/8.4/static/xml2.html
> [ but it
Le 12/03/2010 16:00, jody a écrit :
> [...]
> In the postgres documentation under "1.2. Architectural Fundamentals"
> it is said that a session consists of a server process and a client
> application.
>
> But i don't really understand when a session begins and when it ends.
> Does a session corre
We are getting the data by invoking a webservice in which I found these
strange characters. we have a job that takes the data from XML and dumps
into our tables. What I am guessing is, it should be fixed at the source. If
that's not possible, I might have to take it some how?
Regards
On Tue, Mar
Adrian von Bidder wrote:
> Heyho!
>
> As far as I understand, REVOKE .. FROM PUBLIC revokes rights that were given
> to everybody. Is there a way to revoke rights given to *any*body? (all
> users)? Or do I misunderstand PUBLIC?
You're misunderstanding -- if you revoke from public, only the g
Hi
In the postgres documentation under "1.2. Architectural Fundamentals"
it is said that a session consists of a server process and a client application.
But i don't really understand when a session begins and when it ends.
Does a session correspond to a connection such as when
calling the php-fun
Hi All,
I am running PostgreSQL 8.4 offered with OpenSUSE 11.2. It works
exceptionally well. I have installed the contrib package in order to use
the functions provided by XML2/pg_xml as explained in this page:
http://www.postgresql.org/docs/8.4/static/xml2.html
However, when I try to run this SQ
Heyho!
As far as I understand, REVOKE .. FROM PUBLIC revokes rights that were given
to everybody. Is there a way to revoke rights given to *any*body? (all
users)? Or do I misunderstand PUBLIC?
cheers
-- vbi
--
featured product: ClamAV Antivirus - http://www.clamav.net/
signature.asc
Desc
33 matches
Mail list logo