Re: \connect case-folding change maybe not such a good idea - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: \connect case-folding change maybe not such a good idea
Date
Msg-id Pine.LNX.4.30.0202212021380.683-100000@peter.localdomain
Whole thread Raw
In response to Re: \connect case-folding change maybe not such a good idea  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane writes:

> I said:
> > I think the wisest course may be to revert to the 7.1 \connect behavior
>
> There is another possibility, which is to migrate to the new behavior
> over time.  I like having pg_dump quote the names in \connect, because
> that gives us a shot at working with names that have embedded spaces.
> We could leave pg_dump as it stands in CVS tip, and modify psql to
> work as follows:
>     1. Quoted names in \connect are taken as quoted identifiers.
>     2. Unquoted names are taken literally (not downcased).
> Point 2 would allow forwards compatibility of existing dump files,
> while point 1 makes the new pg_dump behavior work.  After a release
> or two we could migrate to regular SQL-identifier handling in \connect.

Fine with me.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: SET NULL / SET NOT NULL
Next
From: SAKAIDA Masaaki
Date:
Subject: Re: pgbash-2.4 released