Using pg_exec during a copy transaction
| From: | Robert Fitzpatrick | Date: | Wed, 21 Jul 2004 01:36:25 +0000 |
| Subject: | Using pg_exec during a copy transaction | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35424@lists.php.net to get a copy of this message | ||
Is it possible when using PostgreSQL to copy data with 'pg_exec($dbh,
"COPY tbl FROM stdin");' to issue another pg_exec transaction before
'pg_end_copy($dbh);' is called? My script is hanging after issuing the
COPY to read data and then issuing a pg_exec SELECT statement to lookup
that data for validity.
--
Robert