Re: [BUGS] BUG #1933: ADD COLUMN with DEFAULT resets table oids

2005-10-02 Thread Tom Lane
"Duncan Crombie" <[EMAIL PROTECTED]> writes: > The following command causes all oids in the affected table to be reset to > new values: > ALTER TABLE items ADD COLUMN publish bool DEFAULT true; Yup, that's an oversight. Fix committed, will appear in 8.0.4. Thanks for the report!

Re: [BUGS] BUG #1908: sql support chinese char error

2005-10-02 Thread William ZHANG
It looks strange. Can you show us more information: 1. Database encoding: show server_encoding; 2. SQL scripts do create and insert the values. ""wally"" <[EMAIL PROTECTED]> wrote > > The following bug has been logged online: > > Bug reference: 1908 > Logged by: wally > Email addr

Re: [BUGS] BUG #1932: initdb.log

2005-10-02 Thread William ZHANG
Also reported on http://archives.postgresql.org/pgsql-hackers/2005-09/msg00841.php. ""zhangsijing"" <[EMAIL PROTECTED]> wrote > > The following bug has been logged online: > > Bug reference: 1932 > Logged by: zhangsijing > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8

Re: [BUGS] BUG #1815: ECPGdebug causes crash on Windows XP

2005-10-02 Thread William ZHANG
I remember that I have posted the answer to pgsql.bugs, but now it can only be found here: http://www.talkaboutdatabases.com/group/pgsql.bugs/messages/2346.html Do not know what's wrong with the mail list or my mails. "Bruce Momjian" wrote > > Ah, I have found the cause of the crash, and added

[BUGS] Error While Connectint to Database

2005-10-02 Thread Balaji NV
Dear Sir/Madam,   My name is N.V.Balaji i am working in Govt. Organisation as Software Engineers, we are using postgresql 8.0 as database, for the Linux operating system the postgres is working well where as for the Windowx XP Operating System while connecting to the database we are get

[BUGS] BUG #1933: ADD COLUMN with DEFAULT resets table oids

2005-10-02 Thread Duncan Crombie
The following bug has been logged online: Bug reference: 1933 Logged by: Duncan Crombie Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Darwin (OSX) Description:ADD COLUMN with DEFAULT resets table oids Details: The following command cau

Re: [BUGS] BUG #1930: Cannot create foreign key constraint

2005-10-02 Thread Tom Lane
"Warren Little" <[EMAIL PROTECTED]> writes: > pg_restore: [archiver (db)] could not execute query: ERROR: insert or > update on table "asientry" violates foreign key constraint "asientry_r0" > DETAIL: Key (pid)=(AA0003403544) is not present in table "pobject". > Command was: ALTER TABLE ONLY

Re: [BUGS] BUG #1932: initdb.log

2005-10-02 Thread Tom Lane
"zhangsijing" <[EMAIL PROTECTED]> writes: > creating template1 database in C:/Program > Files/PostgreSQL/8.1-beta2/data/base/1 ... FATAL: syntax error in file > "C:/Program Files/PostgreSQL/8.1-beta2/data/postgresql.conf" line 386, near > token "'s Republic of China'" Known problem, should be fix

[BUGS] BUG #1930: Cannot create foreign key constraint

2005-10-02 Thread Warren Little
The following bug has been logged online: Bug reference: 1930 Logged by: Warren Little Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: 2.6.10-1.770_FC3smp #1 SMP Thu Feb 24 18:36:43 EST 2005 x86_64 x86_64 x86_64 GNU/Linux Description:Canno

[BUGS] BUG #1932: initdb.log

2005-10-02 Thread zhangsijing
The following bug has been logged online: Bug reference: 1932 Logged by: zhangsijing Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1-beta2 Operating system: WindowsXP Description:initdb.log Details: When install PostgreSQL/8.1-beta2,I select "Chinese,People