2006/8/8, Chris Hoover <[EMAIL PROTECTED]>:
(...)
The reason for the null being passed to to_date is this is on of almot 90k
lines of data we are trying to load, and the script was built to generate
this code. Since to_date(null,'yyyymmdd') returns a null, why is the
default not working?
Because you're trying to explicitly insert a NULL into a column which
is specified as NOT NULL.
(If you can't change the script to output DEFAULT or the explicit
default value, the best workaraound would be to create a trigger which
converts any attempt to insert a NULL value into that column to the
intended default value).
Ian Barwick
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
