temp sequence
От | Sim Zacks |
---|---|
Тема | temp sequence |
Дата | |
Msg-id | fo3nnb$cfd$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: temp sequence
Re: temp sequence Re: temp sequence |
Список | pgsql-general |
"PostgreSQL 8.2.4 on i386-pc-linux-gnu, compiled by GCC i386-pc-linux-gnu-gcc (GCC) 4.1.1 (Gentoo 4.1.1)" I am creating a temporary sequence in a function and it seems like it is not going away after the function finishes. The front end is in MS Access 2000 and I have a single connection. When I call the function once it works, when I call it a second time, it gives me an error that the sequence already exists. When I restart the application, I can call the function again. I solved the problem by using: alter sequence seq_linenum restart with 1; The manual states: If specified, the sequence object is created only for this session, and is automatically dropped on session exit. Existing permanent sequences with the same name are not visible (in this session) while the temporary sequence exists, unless they are referenced with schema-qualified names. I thought that a function would be considered its own session, is that incorrect? Thank you Sim
В списке pgsql-general по дате отправления: