Received: from vpcit.ru (qmailr@dialup.vpcit.ru [195.38.52.246]) by hub.org (8.10.1/8.10.1) with SMTP id e7G6qen09401 for ; Wed, 16 Aug 2000 02:52:41 -0400 (EDT) Received: (qmail 14104 invoked from network); 16 Aug 2000 06:51:17 -0000 Received: from nt4.vpcit.ru (HELO vpcit.ru) (195.38.52.237) by dialup.vpcit.ru with SMTP; 16 Aug 2000 06:51:17 -0000 Message-ID: <399A398F.59E09EC7@vpcit.ru> Date: Wed, 16 Aug 2000 12:49:51 +0600 From: Yury Don Organization: gercon X-Mailer: Mozilla 4.74 [en] (X11; U; Linux 2.2.15 i686) X-Accept-Language: ru, en MIME-Version: 1.0 CC: pgsql-bugs@postgresql.org Subject: serial field dump bug References: Content-Type: multipart/mixed; boundary="------------8AD7513C2485600B461B15FB" X-Archive-Number: 200008/35 This is a multi-part message in MIME format. --------------8AD7513C2485600B461B15FB Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit Dear Madam or Sir, Looks like I've found a bug in PostgreSQL, bug report is in attachment. -- Sincerely yours, Yury --------------8AD7513C2485600B461B15FB Content-Type: text/plain; charset=koi8-r; name="bug.txt" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="bug.txt" ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name :Yury Don Your email address :gercon@vpcit.ru System Configuration --------------------- Architecture (example: Intel Pentium) :Intel Pentium Operating System (example: Linux 2.0.26 ELF) :Linux 2.2.15 Debian PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.2 Compiler used (example: gcc 2.8.0) :gcc 2.95.2 Please enter a FULL description of your problem: ------------------------------------------------ After creating table with serial field if table or this field name has an uppercase letters, sequence creating for this field doesn't double quoted. Consequently after dump and restore of table "default nextval" clause contains name of sequence with all characters in lower case and when user inserts data into table an error occured "Relation '...' does not exist". Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ---------------------------------------------------------------------- $ psql mdb ... mdb=# create table "Qq"("Id" serial, "Name" text); NOTICE: CREATE TABLE will create implicit sequence 'Qq_Id_seq' for SERIAL column 'Qq.Id' NOTICE: CREATE TABLE/UNIQUE will create implicit index 'Qq_Id_key' for table 'Qq' CREATE mdb=# \q $ pg_dump -c -t qq -f qq_dump mdb $ psql -e mdb