Re: [SQL] SEQUENCE and PRIMARY KEY

2003-07-03 Thread Rod Taylor
> >A trigger (maybe a rule) is the way to go about this. > > > >The alternative is to teach the bad clients to use DEFAULT rather than > >NULL when they expect the GENERATOR to create the value for them. > > > Hmm, Rod, there really seems a demand for the GENERATOR feature :-) > Do you see any perf

Re: [SQL] SEQUENCE and PRIMARY KEY

2003-07-02 Thread Rod Taylor
On Wed, 2003-07-02 at 11:30, Ralf Werny wrote: > Hi, > many clients like webmin and openoffice makes an > INSERT NULL if i give no value for a field because it is a sequence. > Is there a better way to solve this problem as using a trigger ? A trigger (maybe a rule) is the way to go about th

[SQL] SEQUENCE and PRIMARY KEY

2003-07-02 Thread Ralf Werny
Hi, many clients like webmin and openoffice makes an INSERT NULL if i give no value for a field because it is a sequence. Is there a better way to solve this problem as using a trigger ? CREATE TABLE test ( id integer PRIMARY KEY ); CREATE SEQUENCE test_seq_id MINVALUE