| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Joseph Bonnet" <Joseph(dot)Bonnet(at)Sodebo(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: plpgsql and COPY |
| Date: | 2001-07-03 23:08:56 |
| Message-ID: | 26326.994201736@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Joseph Bonnet" <Joseph(dot)Bonnet(at)Sodebo(dot)fr> writes:
> Y want to use COPY command in a PLpgSQL procedure like this:
> Y have always the response : CopyObjet: don't know to copy 610
Doesn't work in <= 7.0. Update to 7.1.
If you are going to drop and recreate the table each time, you
might also find that you need to invoke the commands via EXECUTE,
not directly. Not sure about that. For utility commands with
no plans, it might work to do it directly as you have here.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-07-04 00:17:06 | Re: Re: 7.1.2 ERROR: UNIQUE constraint matching given keys for referenced table ...... |
| Previous Message | Scott Holmes | 2001-07-03 23:04:46 | lo wrappers |