schema rename sequence issue

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: schema rename sequence issue
Date: 2006-01-30 09:51:55
Message-ID: drknmg$2kj8$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

PostGreSQL 8.01 Gentoo
I renamed my schema from public to stock, and then I found out it didn't
change the schemas of the sequences. After searching through the
archives, I found that this was on a bug list and would probably be
fixed in version 8.2

I needed to fix the sequences in any case, so I tried to do it manually
using this code:

update pg_attrdef set
adsrc=replace(adsrc,'public.','stock.'),adbin=replace(adbin,'112 117 98
108 105 99 46','115 116 111 99 107 46');

I checked the table and it looked correct.

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?

Thank You
Sim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2006-01-30 10:02:25 Re: schema rename sequence issue
Previous Message Martijn van Oosterhout 2006-01-30 09:27:34 Re: postgresql performace degrading after a while