On Tue, Oct 12, 2004 at 06:10:12PM -0700, Michael Hannon wrote: > > We expect that we WILL eventually rebuild the database, but right now > we're looking for a quick fix. Our current programmer tells me that he > can't find a way to simply change the primary key "in place" in Postgres.
Does ALTER TABLE not work? http://www.postgresql.org/docs/7.3/static/sql-altertable.html Whatever you decide to do, hopefully you have a development system on which to test your changes. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster