|
From: Kevin G. <ke...@go...> - 2003-10-29 16:26:19
|
> Well, your code produce the same error like mine. Maybe this is a matter
> of PostgreSQL version, what's yours ? Mine is 7.3.3.
>
> One can read this in 7.3 release notes :
>
> "An empty string ('') is no longer allowed as the input into an integer
> field. Formerly, it was silently interpreted as 0."
Well, darn, mine is a venerable 7.1.3, nice find. If postgres is
requiring at least a 0 but only for numeric fields, not for all fields,
I don't see a way for the MDC stuff to have a 'conditional default'
value, it seems to me the solution is that you have to set the MDC value
to 0 as soon as you start up. What do you think?
--
Happy Trails . . .
Kevin M. Goess
(and Anne and Frank)
904 Carmel Ave.
Albany, CA 94706
(510) 525-5217
|