On 4/7/11, Robert Haas <robertmh...@gmail.com> wrote: > On Wed, Apr 6, 2011 at 4:23 PM, Vladimir Kokovic > <vladimir.koko...@gmail.com> 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 state: 42601 > > Treat them as what?
Even nextval('"s''d".s''d""."s''d".d"s''"') is correct literal, PostgreSQL parser treats them like error. I think that only solution is to prohibit ". (double quote and dot) to be part of schema or sequence name. Best regards, Vladimir Kokovic, DP senior, Belgrade, Serbia -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers