Re: Create Table Key

Vladimir Tsvetkov wrote:

> Hallo,
> I want to create the new records in my table. Must I manage self the UUID
> Column in my table or I can create the constraints, wich automate the
> process of UUID creation??
>
> Regards
> Vladimir Tsvetkov

I have no idea what UUID column is and I doubt anyone else will though we can probably all guess.

You should not populate it with a trigger but rather create a SEQUENCE and use that sequence in your insert statement like this:

INSERT INTO mytable
(uuid, field2)
VALUES
(uuidseq.NEXTVAL, somevalue);

Daniel A. Morgan Received on Thu Aug 02 2001 - 14:03:19 CDT