Re: strange apllicaion error
От | mike g |
---|---|
Тема | Re: strange apllicaion error |
Дата | |
Msg-id | 1088135464.2640.17.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | strange apllicaion error (spied@yandex.ru) |
Ответы |
Re: strange apllicaion error
|
Список | pgsql-general |
What language are you using to execute your code? Maybe it has the same problem that pl/pgsql does with caching temp tables? It would be created the first time it looped through your code, the 2nd time it would crash trying to create the table again. On Thu, 2004-06-24 at 06:37, spied@yandex.ru wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
В списке pgsql-general по дате отправления: