strange apllicaion error - Mailing list pgsql-general

From spied@yandex.ru
Subject strange apllicaion error
Date
Msg-id 108186789281.20040624153718@yandex.ru
Whole thread Raw
Responses Re: strange apllicaion error  (mike g <mike@thegodshalls.com>)
List 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


pgsql-general by date:

Previous
From: "NTPT"
Date:
Subject: PHP: Too many open links (0) with libpg7.4.3
Next
From: Martin Marques
Date:
Subject: Re: PHP: Too many open links (0) with libpg7.4.3