Re: alter sequence
От | Guillaume Lelarge |
---|---|
Тема | Re: alter sequence |
Дата | |
Msg-id | 1354455924.4185.9.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: alter sequence (Jasen Betts <jasen@xnet.co.nz>) |
Список | pgsql-general |
On Sun, 2012-12-02 at 11:42 +0000, Jasen Betts wrote: > On 2012-11-24, Peter Kroon <plakroon@gmail.com> wrote: > > --f46d04389321c8f47d04cf3c0f32 > > Content-Type: text/plain; charset=ISO-8859-1 > > > > ALTER SEQUENCE (select pg_get_serial_sequence('table', 'id')) RESTART WITH > > 1; > > > The query fails: > > ALTER SEQUENCE (select pg_get_serial_sequence('table... > > it's because of the ( > > you can end-run this problem by using the (undocumented ?) function setval: > > select pg_catalog.setval(pg_get_serial_sequence('table','id') ,1,false); > It's documented: http://www.postgresql.org/docs/9.2/interactive/functions-sequence.html for setval and http://www.postgresql.org/docs/9.2/static/functions-info.html for pg_get_serial_sequence. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
В списке pgsql-general по дате отправления: