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