Received: from binarna.schizofrenia.sk (root@binarna.schizofrenia.sk [195.98.10.23]) by hub.org (8.10.1/8.10.1) with ESMTP id e84CGNC73905 for ; Mon, 4 Sep 2000 08:16:23 -0400 (EDT) Received: from adiemus ([195.28.79.18]) by binarna.schizofrenia.sk (8.9.0/8.9.0) with SMTP id OAA25010 for ; Mon, 4 Sep 2000 14:23:02 +0200 Message-Id: Date: Mon, 4 Sep 2000 14:15:53 +0200 X-Priority: 3 From: Ice Planet X-Mailer: Mail Warrior To: pgsql-sql@postgresql.org MIME-Version: 1.0 Subject: drop sequence in transaction Content-Type: Text/Plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8Bit X-Mailer-Version: v3.55 Organization: Adiemus o.c.p. a.s. X-Archive-Number: 200009/14 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@adiemus.sk ICQ#: 67765483