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

Re: [HACKERS] Re: Case-folding bogosity in new psql

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Re: Case-folding bogosity in new psql
Date: 2000-01-31 15:26:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
have to agree ... psql behaviour should be an extension of the backend's

On Mon, 31 Jan 2000, Tom Lane wrote:

> Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> writes:
> > This is not a bogosity if you read and understand the psql grammar.
> In other words, you have (by fiat and with no discussion AFAIR) decided
> to change psql's "grammar" so that its handling of names is inconsistent
> with the backend's.  That might be OK if psql were an independent
> product, but it's not.  There are already enough discrepancies between
> parsing of backslash commands and parsing of SQL commands; do we need
> to add more?
> > Quotes
> > are for protecting whitespace and other metacharacters. For example, in
> > 6.5 there was no good way to connect (\c) to a database with a space in
> > the name.
> That indicates that \c failed to accept quoted names properly --- but
> that's just a bug in \c, not a reason to transfer the same breakage
> to other places.
> > The conceptual problem I would have with your idea is that command option
> > interpretation would be inconsistent. For example \e FILE should surely
> > not cause any lower-casing to happen.
> No, but a filename is not an SQL name.  Claiming that filename
> interpretation must govern SQL name interpretation is about like
> claiming that psql should misinterpret SQL names that happen to
> match file names in your current directory.
> I think that you have reduced usability considerably in order not to
> have to distinguish SQL names and file names in some parts of your
> code.  That's a design error IMHO.
> > What do other people say about this?
> I'll wait for other reactions ... but I am not happy.
> 			regards, tom lane
> ************

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ 
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org 

In response to


pgsql-hackers by date

Next:From: Peter EisentrautDate: 2000-01-31 15:29:07
Subject: Re: Case-folding bogosity in new psql
Previous:From: Tom LaneDate: 2000-01-31 15:24:23
Subject: Re: [HACKERS] Another nasty cache problem

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