Re: Connection string

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Connection string
Date: 2006-08-19 14:34:32
Message-ID: 20060819143432.GA90402@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Aug 19, 2006 at 03:36:42PM +0200, Michael Meskes wrote:
> On Fri, Aug 18, 2006 at 02:54:19PM -0600, Michael Fuhr wrote:
> > It works with a double-quoted string but not with a single-quoted
> > string as the documentation mentions.
>
> It's not supposed to work with single-quoted strings. This is a
> documentation bug. Or does anyone think we should support single quotes
> too?

It doesn't matter to me; I'd just like to be sure the code is
behaving as expected (whatever "expected" is) before I submit a
documentation patch.

Here's an excerpt from 5WD-02-Foundation-2003-09.pdf, 17.1 <connect
statement>:

<connection target> ::=
<SQL-server name> [ AS <connection name> ] [ USER <connection user name> ]
| DEFAULT

Excerpt from 5.4 Names and identifiers:

<connection name> ::= <simple value specification>

<SQL-server name> ::= <simple value specification>

<connection user name> ::= <simple value specification>

Following along to 6.4 <value specification> and <target specification>
and 5.3 <literal> suggests that single-quoted strings should be
allowed. So far I haven't found anything to contradict that but I
could be overlooking or misinterpreting something.

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Gunther 2006-08-19 15:40:39 Confused about locales
Previous Message Tom Lane 2006-08-19 14:02:28 Re: Arrays and backslashes