Re: schema rename sequence issue

[Michael Glaesemann <grzm@xxxxxxxxxxxxx>]

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