Re: [SQL] Trigger question

2001-02-14 Thread Jan Wieck
Dave Wedwick wrote: > Hi! > > I have a table with an int4 field called inserttime. Regardless of what > the user enters in this field, I want a trigger to put now() into it. > > What's the syntax for the trigger? Sample: CREATE TABLE t1 ( id serial PRIMARY KEY,

[SQL] Trigger question

2001-02-14 Thread Dave Wedwick
Hi! I have a table with an int4 field called inserttime. Regardless of what the user enters in this field, I want a trigger to put now() into it. What's the syntax for the trigger? Thanks!

[SQL] Trigger question

2001-02-14 Thread Dave Wedwick
Hi! I have a table with an int4 field called inserttime. Regardless of what the user enters in this field, I want a trigger to put now() into it. What's the syntax for the trigger? Thanks!

[SQL] trigger question

2000-10-02 Thread Carolyn Lu Wong
I have created a trigger when updating/inserting into a table, the row is inserted into a log table. I get the following error when i tried to update the table: ERROR: Unable to locate type oid 0 in catalog what does this mean?