> >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
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
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