Re: COPY FROM STDIN fails inside Pl/pgSQL function or in PgAdmin , but ok in psql

smacedo@calmetric.pt ("Silvio Macedo") writes:
> (Pg 8.0.3 on Windows XP SP2, client psql, ODBC and pgAdmin )
>
> Summary: COPY FROM STDIN works on psql, but not inside a Pl/pgSQL
> function, nor a pgAdmin SQL window, and not on a ODBC command...

I believe that it's because inside "those places," you don't have
either a stdin or a stdout.

One of our folks ran into the same situation, and the same surprise.

See:
<http://archives.postgresql.org/pgsql-hackers/2005-07/msg00949.php>
<http://archives.postgresql.org/pgsql-hackers/2005-07/msg01067.php>
<http://archives.postgresql.org/pgsql-hackers/2005-07/msg00997.php>

Bruno Wolfe suggests the problem is because pl/pgsql is considered a
"trusted" language, which thus shouldn't be able to read/write files.

In a more recent CVS, Tom points out that this elicits a more
meaningful error message:

ERROR:  cannot COPY to/from client in PL/pgSQL
CONTEXT:  PL/pgSQL function "build_table" line 2 at execute statement

He also points out that this is taking place inside a SELECT, and that
the client library would likely get confused at this 'abuse' of the
protocol...
-- 
let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/emacs.html
Rules of  the Evil Overlord #127.  "Prison guards will  have their own
cantina featuring  a wide  variety of tasty  treats that  will deliver
snacks to the  guards while on duty. The guards  will also be informed
that  accepting food or  drink from  any other  source will  result in
execution." <http://www.eviloverlord.com/>