From: | Ice Planet <ice(at)adiemus(dot)sk> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | drop sequence in transaction |
Date: | 2000-09-04 12:15:53 |
Message-ID: | SAK.2000.09.04.oemrtdlm@adiemus |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 | name
last_value | integer
increment_by | integer
max_value | integer
min_value | integer
cache_value | integer
is_cycled | char
is_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(at)adiemus(dot)sk
ICQ#: 67765483
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-09-04 16:10:38 | Re: Order by in stored functions |
Previous Message | Jan Wieck | 2000-09-04 10:19:35 | Re: pg_hba.conf |