Skip site navigation (1) Skip section navigation (2)

Re: schema rename sequence issue

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: schema rename sequence issue
Date: 2006-01-30 10:03:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I thought the pg_attrdef table was the defaults.
Is there another table that contains the defaults

Thank You

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


pgsql-general by date

Next:From: Michael GlaesemannDate: 2006-01-30 10:11:21
Subject: Re: schema rename sequence issue
Previous:From: Michael GlaesemannDate: 2006-01-30 10:02:25
Subject: Re: schema rename sequence issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group