Received: from victoria.host4u.net (victoria.host4u.net [216.71.64.77]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6P8Ggf89478; Wed, 25 Jul 2001 04:16:42 -0400 (EDT) (envelope-from mcurley@e4media.com) Received: from morganc.e4media.com (adsl-162-83-164-253.nyc.adsl.bellatlantic.net [162.83.164.253]) by victoria.host4u.net (8.8.5/8.8.5) with ESMTP id CAA19962; Wed, 25 Jul 2001 02:10:14 -0500 Message-Id: <4.3.2.7.2.20010725030649.024f7de8@e4media.com> X-Sender: mcurley@e4media.com X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Wed, 25 Jul 2001 03:11:48 -0400 To: , From: Morgan Curley Subject: Inserts in triggers In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_152249002==_.ALT" X-Archive-Number: 200107/898 X-Sequence-Number: 13019 --=====================_152249002==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Are there server setting that need to be set in order to do inserts from trigger functions? I have been trying to load data into a table which would trigger an insert into another table with one or more of the NEW values. I keep getting: ERROR: parser: parse error at or near "$1" and the DEBUG log entry points to the line with the insert on it. i.e. INSERT events ( event_id, sport_id ,name ,feed_code, start_time, active_flag, create_timestamp, update_timestamp ) VALUES ( event_id ,sport_id ,feed_code ,feed_code, create_timestamp, 1, create_timestamp, create_timestamp ); where the values list is a list of predefined vars. Does anyone see why this statement wouldn't work. All required fields are present ant not null, all foreign keys exist. thanks, Morgan --=====================_152249002==_.ALT Content-Type: text/html; charset="us-ascii" Are there server setting that need to be set in order to do inserts from trigger functions?

I have been trying to load data into a table which would trigger an insert into another table with one or more of the NEW values.

I keep getting:  ERROR:  parser: parse error at or near "$1"
and the DEBUG log entry points to the line with the insert on it.
i.e.
INSERT events ( event_id, sport_id ,name ,feed_code, start_time, active_flag, create_timestamp, update_timestamp ) VALUES ( event_id ,sport_id ,feed_code ,feed_code, create_timestamp, 1, create_timestamp, create_timestamp );

where the values list is a list of predefined vars.

Does anyone see why this statement wouldn't work.

All required fields are present ant not null, all foreign keys exist.

thanks,
Morgan
--=====================_152249002==_.ALT--