Re: [SQL] import ignoring duplicates

2010-05-17 Thread Scott Marlowe
On Sun, May 16, 2010 at 12:38 PM, Mark Fenbers mark.fenb...@noaa.gov wrote: I am using psql's \copy command to add records to a database from a file.  The file has over 100,000 lines.  Occasionally, there is a duplicate, and the import ceases and an internal rollback is performed.  In other

Re: [SQL] [Trigger] Help needed with NEW.* and TG_TABLE_NAME

2010-05-17 Thread Torsten Zühlsdorff
Jasen Betts schrieb: On 2010-05-11, Torsten Zühlsdorff f...@meisterderspiele.de wrote: Hello, i have a problem with a trigger written in pl/pgsql. It looks like this: CREATE OR REPLACE FUNCTION versionize() RETURNS TRIGGER AS $$ BEGIN NEW.revision := addContentRevision (OLD.content_id,