strange apllicaion error

From: spied(at)yandex(dot)ru
To: pgsql-general(at)postgresql(dot)org
Subject: strange apllicaion error
Date: 2004-06-24 11:37:18
Message-ID: 108186789281.20040624153718@yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i get this error messages in my application:

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Marques 2004-06-24 11:59:37 Re: PHP: Too many open links (0) with libpg7.4.3
Previous Message NTPT 2004-06-24 11:19:03 PHP: Too many open links (0) with libpg7.4.3