Re: schema rename sequence issue - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: schema rename sequence issue
Date
Msg-id 5BABE4D8-15C5-47D3-B7A0-45ABE308E98F@myrealbox.com
Whole thread Raw
In response to schema rename sequence issue  (Sim Zacks <sim@compulab.co.il>)
Responses Re: schema rename sequence issue
List pgsql-general
On Jan 30, 2006, at 18:51 , Sim Zacks wrote:

> However, when I try to insert into the table I get an error that
> public.sequence name is not found
>
> Am I missing a reference or table update somewhere?

You probably need to update the defaults for the columns that call
the sequences. They may still be using the previous schema in their
nextval calls.

Hope this helps.

Michael Glaesemann
grzm myrealbox com




pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: schema rename sequence issue
Next
From: Sim Zacks
Date:
Subject: Re: schema rename sequence issue