Message-ID: <35BE161F.B78903D9@itl.waw.pl>
Date: Tue, 28 Jul 1998 20:19:11 +0200
From: wojtek <wojtek@itl.waw.pl>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Error 'Named portals'
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit

Hello,
I use PsqlODBC 6.30.0248 with Access97.
My problem is illustrated by an example:
I have an Access97 base 'mybase'. It is edited on PC
under Win95. After all I want to have it and its backup
in Postgresql on SunOS. I connect it by PsqlODBC. I put
two commands in 'Connect settings'(Advanced options - connection):

DROP TABLE mybackup;ALTER TABLE mybase RENAME TO mybackup;

At the very beginning the Postgresql base is empty. After connecting
the base 'mybase' should be copied into Postgresql.
On first connection I get the following notes in logs (#-s are my
comments):

ERROR:  Relation mybackup Does Not Exist!
#I agree - this is correct. There is no relation 'mybackup' yet.
ERROR:  Named portals may only be used in begin/end transaction blocks
#I don't understand it. What does it mean? What happened with
#rename operation? There should appear error message, because
#there was no 'mybase' base yet.

On disconnect the sent base 'mybase' appears in Postgresql. It is OK.

On second connection I get this:

ERROR:  Relation mybackup Does Not Exist!
#I agree - this is correct. There is no relation mybackup yet.
ERROR:  Named portals may only be used in begin/end transaction blocks
#Still can't understand.
ERROR:  amcreate: mybase relation already exists
#It looks like the rename operation was not successed and this is
#the reason for this message.

My question:
1.What does this message mean:
ERROR:  Named portals may only be used in begin/end transaction blocks
Is it the reason of failing the rename operation? How can I avoid it?
2.(not question but suggestion)I think it would be a good idea to
equip driver with the ability of running SQL commands just before
disconnection from Postgresql.

BTW, I want to thank Byron Nikolaidis for quick response and useful
patch.

Thanks in advance
Wojciech Pietron