Hi,
I've recently started with pgsql after having used mysql. Oddly, a problem
the latter seems to have followed me.
When I set up a field with a default value to use a sequence (with "nextval"),
It doesn't work automatically. Both using DBI and the pgsql cli, if I do
INSERT INTO foo VALUES (NULL);
or
INSERT INTO foo VALUES ('');
I get an error or null is inserted in the first case, if the field is set
non-null, or a 0 in the second case.
Of course without this, a good part of the convenince of auto-incrementing is
defeated. I can work around it by looking up the appropriate value, but then
I need to do locking as well, which is likely slower and definitely more
annoying.
Is there some settable option that determines what will cause a default value
to be inserted? Is this a compile-time option of some sort? I've been
searching around for a couple of weeks on this, with no luck in the docs. I
would be very grateful for any assistance.
--JB
--
------------------------------------------------------------------
J B Bell | /~\
Systems Administrator | ASCII \ / Against
Internet Gateway | Ribbon X HTML
| Campaign / \ Mail
