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
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
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
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
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
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
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
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
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
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
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,
>>
"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
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
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
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
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
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
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
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
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
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
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
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
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
>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
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
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
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
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"
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
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
33 matches
Mail list logo
