Re: schema rename sequence issue

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Sim Zacks <sim(at)compulab(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: schema rename sequence issue
Date: 2006-01-30 10:02:25
Message-ID: 5BABE4D8-15C5-47D3-B7A0-45ABE308E98F@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2006-01-30 10:03:41 Re: schema rename sequence issue
Previous Message Sim Zacks 2006-01-30 09:51:55 schema rename sequence issue