Re: COPY Hacks (WAS: RE: [PERFORM] Postgresql vs SQLserver for this application ?)

2005-04-07 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Using COPY ... FROM STDIN via the Perl DBI (DBD::Pg) interface, > I accidentally strung together several \n-terminated input lines, > and sent them to the server with a single "putline". ... > So. Is it a feechur? Worth stress-testing? Could be VER

Re: COPY Hacks (WAS: RE: [PERFORM] Postgresql vs SQLserver for this

2005-04-06 Thread Christopher Kings-Lynne
Using COPY ... FROM STDIN via the Perl DBI (DBD::Pg) interface, I accidentally strung together several \n-terminated input lines, and sent them to the server with a single "putline". To my (happy) surprise, I ended up with exactly that number of rows in the target table. Is this a bug? Is this fund

Re: COPY Hacks (WAS: RE: [PERFORM] Postgresql vs SQLserver for this application ?)

2005-04-06 Thread Tom Lane
Mischa <[EMAIL PROTECTED]> writes: > Using COPY ... FROM STDIN via the Perl DBI (DBD::Pg) interface, > I accidentally strung together several \n-terminated input lines, > and sent them to the server with a single "putline". > To my (happy) surprise, I ended up with exactly that number of rows > in

Re: COPY Hacks (WAS: RE: [PERFORM] Postgresql vs SQLserver for this application ?)

2005-04-06 Thread Dave Held
> -Original Message- > From: Mischa [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 06, 2005 1:47 PM > To: pgsql-performance@postgresql.org > Subject: COPY Hacks (WAS: RE: [PERFORM] Postgresql vs > SQLserver for this > application ?) > > [...] > Using COPY ... FROM STDIN via the Perl D