> When altering a sequence created by a SERIAL column type (i do this by
> examining pg_depend to avoid moving any other sequences that are
> 'foreign'), i need to recreate the default expression for the SERIAL
> column (stored in pg_attrdef.adbin). Is there an API to do that, or do i
> have to recreate the executable expression tree from scratch? Or am i
> missing something completely...
Does ALTER TABLE/RENAME code help you? You can rename sequences with
that...
Chris