Skip site navigation (1) Skip section navigation (2)

Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Hartmut Goebel" <h(dot)goebel(at)goebel-consult(dot)de>, "Stephen Frost" <sfrost(at)snowman(dot)net>
Cc: <pgsql-bugs(at)postgresql(dot)org>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Date: 2010-06-04 18:53:17
Message-ID: 4C09054D0200002500031FD7@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
Hartmut Goebel <h(dot)goebel(at)goebel-consult(dot)de> wrote:
 
> The application already quotes all column names :-) It's using a
> generic framework which does not (and must not) rely on column
> names being non-keywords.
 
Same here.  I suspect that this is much more commonn than many
PostgreSQL developers realize; and I think it makes a reasonable
case for at least an *option* to quote all identifiers emitted by
pg_dump.
 
-Kevin

In response to

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2010-06-04 18:59:48
Subject: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Previous:From: Farid ZidanDate: 2010-06-04 18:18:43
Subject: Re: BUG #5490: Using distinct for select list causes insert of timestamp string literal to fail

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group