drop sequence in transaction
От | Ice Planet |
---|---|
Тема | drop sequence in transaction |
Дата | |
Msg-id | SAK.2000.09.04.oemrtdlm@adiemus обсуждение исходный текст |
Список | pgsql-sql |
Hello I have a litle problem with sequences. I use drop sequence in transaction, is this possible? If yes, then i have done: 1. begin 2. get some data 3. drop sequence s_acc 4. create sequence s_acc... 5. rollback And after this the database responds like this: test=# \d s_acc Sequence "s_acc" Attribute | Type ---------------+---------sequence_name | namelast_value | integerincrement_by | integermax_value | integermin_value | integercache_value | integeris_cycled | charis_called | char test=# select * from s_acc; NOTICE: mdopen: couldn't open s_acc: No such file or directory NOTICE: mdopen: couldn't open s_acc: No such file or directory NOTICE: mdopen: couldn't open s_acc: No such file or directory NOTICE: mdopen: couldn't open s_acc: No such file or directory NOTICE: mdopen: couldn't open s_acc: No such file or directory ERROR: cannot open relation s_acc test=# select last_value from s_acc; NOTICE: mdopen: couldn't open s_acc: No such file or directory NOTICE: mdopen: couldn't open s_acc: No such file or directory NOTICE: mdopen: couldn't open s_acc: No such file or directory NOTICE: mdopen: couldn't open s_acc: No such file or directory ERROR: cannot open relation s_acc test=# I realy don't know what means this? Thank's for help... Best regards Ice Planet e-mail: ice@adiemus.sk ICQ#: 67765483
В списке pgsql-sql по дате отправления: