Re: [BUGS] BUG #4330: Bonjour connections ignore hba config METHOD and always trusted

2008-07-28 Thread Tom Lane
William Kyngesburye <[EMAIL PROTECTED]> writes: >> What exactly have you got in pg_hba.conf? > The default: > # "local" is for Unix domain socket connections only > local all all trust > # IPv4 local connections: > hostall all 127.0.0.1/

Re: [BUGS] BUG #4330: Bonjour connections ignore hba config METHOD and always trusted

2008-07-28 Thread William Kyngesburye
On Jul 28, 2008, at 3:35 PM, Tom Lane wrote: "William Kyngesburye" <[EMAIL PROTECTED]> writes: When connection with the Bonjour name of the postgres server, it ignores the md5 setting and always trusts the connection. I tried with other auth methods with the same effect. What exactly hav

Re: [BUGS] BUG #4330: Bonjour connections ignore hba config METHOD and always trusted

2008-07-28 Thread Tom Lane
"William Kyngesburye" <[EMAIL PROTECTED]> writes: > When connection with the Bonjour name of the postgres server, it ignores the > md5 setting and always trusts the connection. I tried with other auth > methods with the same effect. What exactly have you got in pg_hba.conf? AFAIK there is no suc

[BUGS] BUG #4330: Bonjour connections ignore hba config METHOD and always trusted

2008-07-28 Thread William Kyngesburye
The following bug has been logged online: Bug reference: 4330 Logged by: William Kyngesburye Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Mac OS X 10.4.11 Description:Bonjour connections ignore hba config METHOD and always trusted Detai

Re: [BUGS] BUG #4327: Primary key not refresh after cascaded deleted

2008-07-28 Thread Tom Lane
"Sam Wong" <[EMAIL PROTECTED]> writes: > Then when I try to insert the following into B: > A,4 > it will say > duplicate key value violates unique constraint "B_primary_column_pkey". Works for me: regression=# create table a (A_primary_col int primary key); NOTICE: CREATE TABLE / PRIMARY KEY wil

Re: [BUGS] BUG #4329: Transaction model changed?

2008-07-28 Thread Tom Lane
"Gerd Grossmann" <[EMAIL PROTECTED]> writes: > Executing the following > createStmnt:='CREATE TABLE test (val integer);INSERT INTO test (val) > VALUES (1);'; > EXECUTE createStmnt; > would just work fine under postgresql 8.3 but does not work with postgresql > 8.0. It complains that the t

Re: [BUGS] BUG #4328: help in creating database encoded with LATIN1

2008-07-28 Thread Alvaro Herrera
andrew victoria wrote: > i got an error message > createdb: database creation failed: ERROR: encoding LATIN1 does not match > server's locale en_US.utf8 > DETAIL: The server's LC_CTYPE setting requires encoding UTF8. > > when im trying to create a database encoded with LATIN1 which is needed i

RES: [BUGS] BUG #4322: Problems with field not updatable

2008-07-28 Thread Alexandre Caneo
Magnus, I've tried open cursor with adOpenStatic or adOpenForwardOnly, but it didn't work. Do you have others suggestions? Tks. Alexandre. -Mensagem original- De: Magnus Hagander [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 28 de julho de 2008 08:34 Para: Alexandre Caneo Cc:

Re: [BUGS] BUG #4322: Problems with field not updatable

2008-07-28 Thread Magnus Hagander
Alexandre Caneo wrote: > The following bug has been logged online: > > Bug reference: 4322 > Logged by: Alexandre Caneo > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.6 > Operating system: WIN XP > Description:Problems with field not updatable > Details:

[BUGS] BUG #4329: Transaction model changed?

2008-07-28 Thread Gerd Grossmann
The following bug has been logged online: Bug reference: 4329 Logged by: Gerd Grossmann Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.17 Operating system: Red Hat Enterprise Linux 4 Description:Transaction model changed? Details: Executing the following

[BUGS] BUG #4328: help in creating database encoded with LATIN1

2008-07-28 Thread andrew victoria
The following bug has been logged online: Bug reference: 4328 Logged by: andrew victoria Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: fedora core 9 Description:help in creating database encoded with LATIN1 Details: i got an error mess

[BUGS] BUG #4327: Primary key not refresh after cascaded deleted

2008-07-28 Thread Sam Wong
The following bug has been logged online: Bug reference: 4327 Logged by: Sam Wong Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Linux Debian Description:Primary key not refresh after cascaded deleted Details: Say, I have two table A an