On 4/13/08, Jochem Maas <jochem@...> wrote:

> the field doesn't allow a NULL, that's why you get the error.
> one way to tackle this is use an insert trigger that sets
> the new.id (from the relevant generator) when the given insert id
> is not set ... and change your query to:

I have a before insert trigger.

> update or insert into polls (question, visible) values (?, ?) returning new.id

But this isn't same as mine. This will do insert every time.

--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com