schema rename sequence issue
| От | Sim Zacks |
|---|---|
| Тема | schema rename sequence issue |
| Дата | |
| Msg-id | drknmg$2kj8$1@news.hub.org обсуждение |
| Ответы |
Re: schema rename sequence issue
Re: schema rename sequence issue |
| Список | 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
В списке pgsql-general по дате отправления: