Re: Trigger problem - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Trigger problem
Date
Msg-id 20050720182359.GA44949@winnie.fuhr.org
Whole thread Raw
In response to Trigger problem  ("Alejandro D. Burne" <alejandro.dburne@gmail.com>)
List pgsql-general
On Wed, Jul 20, 2005 at 03:00:42PM -0300, Alejandro D. Burne wrote:
> Hi, I'll be trying to write a my first trigger which fire when an user
> makes an insert into a table; this insert records in others tables.
> But when I try to insert a record in trigger's table generate an error:
>  - Syntax error near "into" in char 9. -

The INSERT statement itself might be at fault instead of the trigger
function.  Please post the INSERT statement and the complete, exact
error message (there are probably multiple lines).  If that doesn't
tell us what's wrong, then we'll need to see a self-contained
example, i.e., all SQL statements that somebody could execute in
an empty database to reproduce the problem.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: "Alejandro D. Burne"
Date:
Subject: Trigger problem
Next
From: Dan Armbrust
Date:
Subject: Re: index row size exceeds btree maximum, 2713 - Solutions?