Error 'Named portals'
От | wojtek |
---|---|
Тема | Error 'Named portals' |
Дата | |
Msg-id | 35BE161F.B78903D9@itl.waw.pl обсуждение исходный текст |
Список | pgsql-interfaces |
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
В списке pgsql-interfaces по дате отправления: