Re: [COMMITTERS] pgsql: Arrange for quote_identifier() and pg_dump to not quote keywords - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: [COMMITTERS] pgsql: Arrange for quote_identifier() and pg_dump to not quote keywords
Date
Msg-id 46812671.5000405@dunslane.net
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Arrange for quote_identifier() and pg_dump to not quote keywords  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: [COMMITTERS] pgsql: Arrange for quote_identifier() and pg_dump to not quote keywords  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [COMMITTERS] pgsql: Arrange for quote_identifier() and pg_dump to not quote keywords  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers

Gregory Stark wrote:
> I'm thinking it may make sense to lie about all of these in quote_identifier
> so that someone who upgrades from 8.2 to 8.3 can then upgrade to 8.4. If we
> add reserved words in one step then there's no way to upgrade except to rename
> things before dumping. Any comments?
>
>
>   

I'm confused. Won't pg_dump quote the keywords it knows its postgres 
version will need quoted? We can't expect it to have knowledge of future 
requirements for quoting, unless someone really does invent time travel 
(in which case someone could just go to the future and bring back 
version 107.6 and save us all the trouble).

cheers

andrew


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: Frustrating issue with PGXS
Next
From: "A.M."
Date:
Subject: Re: no cascade triggers?