Tom Lane wrote:
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.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
-michael
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org