Re: [BUGS] BUG #5763: pg_hba.conf not honored

2010-11-28 Thread Robert Haas
On Tue, Nov 23, 2010 at 10:29 AM, Tom Lane wrote: > "Kaiting Chen" writes: >> From this pg_hba configuration as the user 'kaiting.chen' is not in role >> 'service' the second entry in the table should be skipped and he should >> authenticate via GSSAPI. However this does not happen. > > I believe

Re: [BUGS] Documentation bug: Chapter 35.4, paragraph 4

2010-11-28 Thread Robert Haas
On Tue, Nov 23, 2010 at 1:08 PM, Jonathan Pool wrote: > Chapter 35.4, paragraph 4, of the PostgreSQL 9.0.1 Documentation says: > > Any collection of commands in the SQL language can be packaged together and > defined as a function. Besides SELECT queries, the commands can include data > modifica

[BUGS] BUG #5774: VACCUM & REINDEX kills production environement

2010-11-28 Thread Bala Murugan
The following bug has been logged online: Bug reference: 5774 Logged by: Bala Murugan Email address: b...@a-cti.com PostgreSQL version: 8.3.7 Operating system: openSUSE 10.3 (X86-64) - Kernel \r (\l). Description:VACCUM & REINDEX kills production environement Details:

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-28 Thread Balamurugan Mahendran
Thanks all for your help!! I am not sure that I'll get all my needed function from built-in UUID. I got the source from the below link also this works perfectly fine with 8.3 version(in my understanding). http://ring.nict.go.jp/archives/misc/db/postgresql/projects/gborg/uniqueidentifier/stable/un

Re: [BUGS] BUG #5774: VACCUM & REINDEX kills production environement

2010-11-28 Thread hubert depesz lubaczewski
On Sun, Nov 28, 2010 at 07:25:52AM +, Bala Murugan wrote: > > The following bug has been logged online: > > Bug reference: 5774 > Logged by: Bala Murugan > Email address: b...@a-cti.com > PostgreSQL version: 8.3.7 > Operating system: openSUSE 10.3 (X86-64) - Kernel \r (\l

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-28 Thread Tom Lane
Balamurugan Mahendran writes: > I am not sure that I'll get all my needed function from built-in UUID. I got > the source from the below link also this works perfectly fine with 8.3 > version(in my understanding). > http://ring.nict.go.jp/archives/misc/db/postgresql/projects/gborg/uniqueidentifie

Re: [BUGS] BUG #5763: pg_hba.conf not honored

2010-11-28 Thread Tom Lane
Robert Haas writes: > On Tue, Nov 23, 2010 at 10:29 AM, Tom Lane wrote: >> I believe the definition of "in role" we use here is "has the privileges >> of role".  Since kaiting.chen is a superuser, all privilege tests will >> succeed for him, including that one.  IOW, a superuser is automatically

Re: [BUGS] BUG #5763: pg_hba.conf not honored

2010-11-28 Thread Robert Haas
On Sun, Nov 28, 2010 at 11:46 AM, Tom Lane wrote: > Robert Haas writes: >> On Tue, Nov 23, 2010 at 10:29 AM, Tom Lane wrote: >>> I believe the definition of "in role" we use here is "has the privileges >>> of role".  Since kaiting.chen is a superuser, all privilege tests will >>> succeed for him

Re: [BUGS] BUG #5771: C:\Program Files\PostgreSQL\8.3\Data is not accessible.

2010-11-28 Thread Shafqat Ali
Hi Kevin, Thanks for prompt reply. I will make sure about all you have mentioned here and will let you know if find any other issue. Thanks and Regards, Shafqat -Original Message- From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] Sent: Saturday, November 27, 2010 1:51 AM To: