Re: [GENERAL] copy from with trigger

2009-04-06 Thread Chris Spotts
That's a dead link for me. -Original Message- From: Alvaro Herrera [mailto:alvhe...@commandprompt.com] Sent: Monday, April 06, 2009 12:42 PM To: Chris Spotts Cc: 'Tom Lane'; pgsql-general@postgresql.org Subject: Re: [GENERAL] copy from with trigger Chris Spotts escribió:

Re: [GENERAL] copy from with trigger

2009-04-06 Thread Alvaro Herrera
Chris Spotts escribió: > Well that's a bummer, ok. Thanks. See also http://archives.postgresql.org/message-id/20090406173912.GB4525%40alvh.no-ip.org -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 suppo

Re: [GENERAL] copy from with trigger

2009-04-06 Thread Alvaro Herrera
06, 2009 12:42 PM > To: Chris Spotts > Cc: 'Tom Lane'; pgsql-general@postgresql.org > Subject: Re: [GENERAL] copy from with trigger > > Chris Spotts escribió: > > Well that's a bummer, ok. Thanks. > > See also > > http://archives.postgresql.org/mes

Re: [GENERAL] copy from with trigger

2009-04-06 Thread Chris Spotts
Well that's a bummer, ok. Thanks. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Sunday, April 05, 2009 10:27 PM To: Chris spotts Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] copy from with trigger Chris spotts writes: > I'm trying to co

Re: [GENERAL] copy from with trigger

2009-04-05 Thread Tom Lane
Chris spotts writes: > I'm trying to copy from a tab delimited file. The dates inside the file > are Unix timestamp style dates. > I thought the following script would do the trick, but it just gives me > an error saying > ERROR: invalid input syntax for type timestamp: "1238736600" > CONTEXT:

[GENERAL] copy from with trigger

2009-04-05 Thread Chris spotts
I'm trying to copy from a tab delimited file. The dates inside the file are Unix timestamp style dates. I thought the following script would do the trick, but it just gives me an error saying ERROR: invalid input syntax for type timestamp: "1238736600" CONTEXT: COPY testtable line 1, column acq