From: wojtek <wojtek@itl.waw.pl>
To: pgsql-interfaces@postgresql.org
Subject: Error 'Named portals'
Date: Tue, 28 Jul 1998 20:19:11 +0200
Message-ID: <35BE161F.B78903D9@itl.waw.pl> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: wojtek@itl.waw.pl
Subject: Re: Error 'Named portals'
In-Reply-To: <35BE161F.B78903D9@itl.waw.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox