Tom Lane wrote:
psql may indeed work with no changes, because it's too stupid to know when you're defining a function, and so it would not be surprised to get a Start Copy In back from a CREATE FUNCTION command. This would not be true of nearly any other client that one might use to define a function. pgAdmin and other GUI tools all have code that knows perfectly well when they're defining a function, and it would take nontrivial surgery to make them able to use a COPY-based function definition mode.
Frontends would not be forced to use something that triggered this - after all we have to stay backwards compatible and support the existing inline string, no?
cheers
andrew
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings