Hi,
We're currently experiencing a problem where SQL statements are failing when entring a '' for not not-null integer columns:
ERROR: pg_atoi: zero-length string
This was discovered just after a database migration from 7.2 to 7.3.4.
Example:
insert into renewal_cache
(dom, expiry, issued, aid) values
('data','2004-03-05','19980305','')The above example in just one case where 'aid' can accept a null value. The use of quotes around all values was established as IIRC pg7.2 wouldn't accept statements without them. The use of this convention is extensive.
Cheers,
Rob Fielding Development Designer Servers Ltd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
