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,
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!
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!
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?