On Tue, Jun 28, 2005 at 01:43:27AM +0200, Bernd Helmle wrote: > 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...
I think this is done by AddRelationRawConstraints. You'd have to get the parsetree of the default expression. I think you could get that by applying raw_parser() to pg_attrdef.adsrc. -- Alvaro Herrera (<alvherre[a]surnet.cl>) "The Postgresql hackers have what I call a "NASA space shot" mentality. Quite refreshing in a world of "weekend drag racer" developers." (Scott Marlowe) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
