Re: [HACKERS] too many dotted names

Vladimir Kokovic writes: > On 4/7/11, Robert Haas wrote: >> On Wed, Apr 6, 2011 at 4:23 PM, Vladimir Kokovic >> 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.

Re: [HACKERS] too many dotted names

On 4/7/11, Robert Haas wrote: > On Wed, Apr 6, 2011 at 4:23 PM, Vladimir Kokovic > wrote: >> Hi, >> >> Does it make sense to treat these ? >> >> 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 ma

Re: [HACKERS] too many dotted names

On Wed, Apr 6, 2011 at 4:23 PM, Vladimir Kokovic wrote: > Hi, > > Does it make sense to treat these ? > > 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'" > SQL

[HACKERS] too many dotted names

Hi, Does it make sense to treat these ? 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'" SQL state: 42601 PostgreSQL 9.1devel on i686-pc-linux-gnu, compiled by GCC