Re: strange apllicaion error

mg> What language are you using to execute your code?

с with modified pgeasy library

mg>  Maybe it has the same  problem that pl/pgsql does with caching
mg> temp tables?  It would be  created the first time it looped
mg> through your code, the 2nd time it  would crash trying to create
mg> the table again.

i think i understood:
 - after SELECT INTO, but before DROP TABLE i get error from some sql
command
 - transation is aborted and any commands (include DROP TABLE) are
ignored
 - after commit temporary table exist and on next loop i get error on
SELECT INTO

>> query error:  ERROR:  duplicate key violates unique constraint "pg_type_typname_nsp_index"
>>
>> failed query:  SELECT packv_uid INTO TEMPORARY my_new_to1c FROM new_to1c
>> connection error:  no connection to the server
>>
>> it's my code:
>> for (;;) {
>>   doquery("begin work");
>>   doquery("SELECT packv_uid INTO TEMPORARY my_new_to1c FROM new_to1c");
>>   ....
>>   doquery("DROP TABLE my_new_to1c");
>>   doquery("commit");
>>   sleep(1);
>> }
>> new_to1c is view
>> may be it's related with
>> http://archives.postgresql.org/pgsql-general/2004-06/msg00394.php