Thread: drop sequence in transaction

drop sequence in transaction

From
Ice Planet
Date:
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