Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: alter table serial->int
- From: "Erik Aronesty" <erik(at)q32(dot)com>
- To: "Erik Aronesty" <erik(at)q32(dot)com>, pgsql-admin(at)postgresql(dot)org
- Subject: Re: alter table serial->int
- Date: Sun, 11 Nov 2007 07:15:01 -0500
CREATE TABLE x ( a serial NOT NULL ); alter table x alter a drop default; alter table x alter a set default 999; still doesn't help. i supposed i can dump the whole table and rebuild it.... but that's going to be a bit slow.
- Follow-Ups:
- Re: alter table serial->int
- From: Tom Lane
- Re: alter table serial->int
- References:
- alter table serial->int
- From: Erik Aronesty
- Re: alter table serial->int
- From: Tom Lane
- Re: alter table serial->int
- From: Erik Aronesty
- Re: alter table serial->int
- From: Alvaro Herrera
- alter table serial->int
- Prev by Date: Re: shared memory settings on MAC OS X
- Next by Date: Re: alter table serial->int
- Previous by thread: Re: alter table serial->int
- Next by thread: Re: alter table serial->int
- Indexes: