Re: [GENERAL] ALTER Bigserial error

2010-05-25 Thread Little, Douglas
iginal Message- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Monday, April 26, 2010 3:49 PM To: Little, Douglas Cc: Tom Lane; pgsql-general@postgresql.org Subject: Re: [GENERAL] ALTER Bigserial error On Mon, Apr 26, 2010 at 12:59 PM, Little, Douglas wrote: > Thanks for the response

Re: [GENERAL] ALTER Bigserial error

2010-04-26 Thread Scott Marlowe
On Mon, Apr 26, 2010 at 12:59 PM, Little, Douglas wrote: > Thanks for the response tom, > I agree it's more of an missing feature. > Regarding the concensus for direction.  I'd like to see the product move in > the direction of the sql standard. Curiously, what does the SQL spec have to say abou

Re: [GENERAL] ALTER Bigserial error

2010-04-26 Thread Little, Douglas
Thanks for the response tom, I agree it's more of an missing feature. Regarding the concensus for direction. I'd like to see the product move in the direction of the sql standard. Overloading types with macro's probably wasn't a good idea, since it leads people like me astray. Maybe the doc

Re: [GENERAL] ALTER Bigserial error

2010-04-25 Thread Tom Lane
"Little, Douglas" writes: > I'm trying to alter in a bigserial on GP/PG 8.1 I'm getting the error > ERROR: type "bigserial" does not exist > SQL state: 42704 > I understand that bigserial isn't a 'true' type, that it's a notational > convenience. > And that I can alter in the default. > But i

[GENERAL] ALTER Bigserial error

2010-04-25 Thread Little, Douglas
Hi, I'm trying to alter in a bigserial on GP/PG 8.1 I'm getting the error ERROR: type "bigserial" does not exist SQL state: 42704 I understand that bigserial isn't a 'true' type, that it's a notational convenience. And that I can alter in the default. But it is listed in the type table in the