Re: [HACKERS] too many dotted names

2011-04-07 Thread Vladimir Kokovic
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.ds'''); ERROR: improper relation

Re: [HACKERS] too many dotted names

2011-04-07 Thread Tom Lane
Vladimir Kokovic vladimir.koko...@gmail.com writes: 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: ALTER TABLE s'd.s'd.s's'd. ADD COLUMN id bigint DEFAULT nextval('s''d.s''d.s''d.ds'''); ERROR: improper

[HACKERS] too many dotted names

2011-04-06 Thread Vladimir Kokovic
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.ds'''); ERROR: improper relation name (too many dotted names): s'd.s'd.s'd.ds' SQL state: 42601 PostgreSQL 9.1devel on i686-pc-linux-gnu, compiled by GCC gcc (Ubuntu/Linaro

Re: [HACKERS] too many dotted names

2011-04-06 Thread Robert Haas
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.ds'''); ERROR: improper relation name (too many dotted names): s'd.s'd.s'd.ds' SQL