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
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 |