On 7/12/06 3:32 AM, "Rafal Pietrak" <[EMAIL PROTECTED]> wrote:
> On Tue, 2006-07-11 at 15:24 -0500, Ron Johnson wrote:
>> Joshua D. Drake wrote:
>>> It is also something that users are clammoring for (and my customers). To
>>> the point that I have customers using unions to emulate the behavior. Why?
>>> Because it is really, really fast.
>>
>> When inserting multiple rows in the same INSERT statement, how do
>> you tell which row fails on a constraint or datatype-mismatch violation?
>
> BTW. COPY from psql client is quite trivial (we learn that from
> pg_dump), but can someone hint on how to use it from perl scrypt? With
> "use DBI" module?
>
See the DBD::Pg documentation, under "copy support".
Sean
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
