Hi,
On Sat, Nov 27, 2004 at 10:45:54PM -0600, [EMAIL PROTECTED] wrote:
>
> I'm using v. 7.4.2, and am encountering a problem with serial types. On an
> insert into a table that results in failure for any number of reasone (mostly
> violation of contraints) I've found that the Sequence for the co
On Sat, Sep 25, 2004 at 07:20:23PM -0400, Tom Allison wrote:
>
> Any idea how to set up a timestamp=now on every insert/update ?
when you create your table, use:
create table mytable (
id serial primary key,
updated timestamp default(now()),
mydata int4
);
Joe
-
