Re: too many dotted names - Mailing list pgsql-hackers

From Tom Lane
Subject Re: too many dotted names
Date
Msg-id 7064.1302160098@sss.pgh.pa.us
Whole thread Raw
In response to Re: too many dotted names  (Vladimir Kokovic <vladimir.kokovic@gmail.com>)
List pgsql-hackers
Vladimir Kokovic <vladimir.kokovic@gmail.com> writes:
> On 4/7/11, Robert Haas <robertmhaas@gmail.com> wrote:
>> On Wed, Apr 6, 2011 at 4:23 PM, Vladimir Kokovic
>> <vladimir.kokovic@gmail.com> wrote:
>>> ALTER TABLE "s'd"".s'd"""."s's'd""." ADD COLUMN id bigint DEFAULT
>>> nextval('"s''d".s''d""."s''d".d"s''"');
>>> ERROR: improper relation name (too many dotted names): s'd.s'd"".s'd.d"s'"

>> Treat them as what?

> Even nextval('"s''d".s''d""."s''d".d"s''"') is correct literal,

Really?  According to whom?  This works for me:

regression=# create schema "s'd"".s'd""";
CREATE SCHEMA
regression=# create table "s'd"".s'd"""."s's'd""." (f1 int);
CREATE TABLE
regression=# create sequence "s'd"".s'd"""."s's'd"".s" ;       
CREATE SEQUENCE
regression=# ALTER TABLE "s'd"".s'd"""."s's'd""." ADD COLUMN id bigint DEFAULT
nextval('"s''d"".s''d"""."s''s''d"".s"');    
 
ALTER TABLE

I think you've made up some theory about how to quote funny characters
in nextval's argument, and it's a wrong theory.  You have to double
single quotes because you're writing a string literal, but other than
that it should look just like a quoted identifier in SQL.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Brendan Jurd
Date:
Subject: Re: [BUGS] Failed assert ((data - start) == data_size) in heaptuple.c
Next
From: yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi)
Date:
Subject: Re: SSI bug?