Re: [BUGS] BUG #3920: sequence not generated for postgres using toplink jpa

2008-02-02 Thread Arun ViswanathanChandrika
Hi Solution is available at http://forums.oracle.com/forums/thread.jspa?messageID=2325330� -Original Message- From: Arun ViswanathanChandrika Sent: Friday, February 01, 2008 8:22 PM To: pgsql-bugs@postgresql.org Subject: BUG #3920: sequence not generated for postgres using toplink jpa

Re: [BUGS] BUG #3922: Problems migrating databases.

2008-02-02 Thread Peter Eisentraut
Maximiliano wrote: > While I migrated the data I had no problems, but in PostgreSQL 7.3 I had > the function varchareq and the system functioned perfectly, now that I have > the 8.2 version this function is not functioning. I don't know what > happened, I hope to recieve an answer soon. Thanks. Th

[BUGS] BUG #3924: Create Database with another encoding as the encoding from postgres

2008-02-02 Thread Stefan Kunick
The following bug has been logged online: Bug reference: 3924 Logged by: Stefan Kunick Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC2 Operating system: Windows Longhorn Description:Create Database with another encoding as the encoding from postgres Detail

Re: [BUGS] BUG #3924: Create Database with another encoding as the encoding from postgres

2008-02-02 Thread Peter Eisentraut
Stefan Kunick wrote: > I installed postgres with the encoding 1252. After this, i started the > program createdb (createdb -E LATIN1 -O postgres -p -U postgres). The > program stopped with the error message: createdb: database creation failed. > Error: encoding LATIN1 does not match server's l

[BUGS] BUG #3925: You can delete enum elements from pg_enum, but it is used in a table

2008-02-02 Thread Stefan Kunick
The following bug has been logged online: Bug reference: 3925 Logged by: Stefan Kunick Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC2 Operating system: Windows Longhorn Description:You can delete enum elements from pg_enum, but it is used in a table Detai

Re: [BUGS] BUG #3924: Create Database with another encoding as the encoding from postgres

2008-02-02 Thread Heikki Linnakangas
Stefan Kunick wrote: PostgreSQL version: 8.3RC2 Operating system: Windows Longhorn Description:Create Database with another encoding as the encoding from postgres Details: I installed postgres with the encoding 1252. After this, i started the program createdb (createdb -E LATIN1 -O p

Re: [BUGS] BUG #3925: You can delete enum elements from pg_enum, but it is used in a table

2008-02-02 Thread Tom Lane
"Stefan Kunick" <[EMAIL PROTECTED]> writes: > I create a enumeration. After this, i used the enumeration in a table. I > delete the enumeration in the table pg_enum (delete from pg_enum where > enumtypid=16631 and enumlabel='center'; The delete don't check, that the > element is used in a table. M