pg_dump quoting bug

From: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: pg_dump quoting bug
Date: 1999-07-19 22:20:15
Message-ID: 19990719172015.B30250@wallace.ece.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

One last missing quoting bug in pg_dump:
now that sequence names are properly quoted for field defaults, mixed
case sequence names are generated. These are properly quoted in the
CREATE SEQUENCE lines, but not in the SELECT nextval lines, as per below:

CREATE SEQUENCE "Teams_TeamID_seq" start 10 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
SELECT nextval ('Teams_TeamID_seq');

This needs to be:
SELECT nextval ('"Teams_TeamID_seq"');

Patch included below.
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005

Attachment Content-Type Size
pg_dump.diff text/plain 715 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Uncle George 1999-07-20 00:21:10 RedHat6.0 & Alpha
Previous Message Ross J. Reedstrom 1999-07-19 22:06:34 VIEW definitions broken in 6.5.0