Re: Moving sequences to another schema - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Moving sequences to another schema
Date
Msg-id 42C0AA30.7060304@familyhealth.com.au
Whole thread Raw
In response to Moving sequences to another schema  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: Moving sequences to another schema
List pgsql-hackers
> 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



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: GiST concurrency commited
Next
From: Christopher Browne
Date:
Subject: Re: Implementing SQL/PSM for PG 8.2