logo       
Google Custom Search
    AddThis Social Bookmark Button

Re: SEQUENCE and PRIMARY KEY: msg#00049

Subject: Re: SEQUENCE and PRIMARY KEY
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 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.

-- 
Rod Taylor <rbt@xxxxxx>

PGP Key: http://www.rbt.ca/rbtpub.asc

Attachment: signature.asc
Description: This is a digitally signed message part


Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>