Tom Lane wrote:

Also ... the visibility issue doesn't seem to explain the other symptom
you reported:



With the original function, the log messages were slightly different and
usually caused the server to reset:
ERROR: duplicate key violates unique constraint
"pg_type_typname_nsp_index"



What was the "original function" exactly?

regards, tom lane


It's included in the schema call uspgetcompositeids2_orig. The only differences is that this function creates and drops the temp table within the function, the newer function keeps the temp table around for the life of the connections.

-michael


---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to