I have just compiled kannel 1.4.1 stable release on a new box with a
fresh install of postgresql 8.1 for some testing.
I'm using postgresql for the DLRs. I get the following error :-
2006-10-18 10:50:13 [12100] [6] ERROR: PGSQL: DELETE FROM kannel_dlr
WHERE oid = (SELECT oid FROM kannel_dlr WHERE smsc='FAKE' AND
ts='56f393d6-1b05-4be8-912b-76c23cebfbc9' LIMIT 1);
2006-10-18 10:50:13 [12100] [6] ERROR: PGSQL: ERROR: column "oid"
does not exist
Having checked up on this it seems the default behavior for oids in
8.1 is to be off as to quote the manual for 8.1 "The use of OIDs in
user tables is considered deprecated, so most installations should
leave this variable disabled. Applications that require OIDs for a
particular table should specify WITH OIDS when creating the table."
So I wonder if using OIDs is the right way forward? I know it fixes
the bug which used LIMIT 1 on the delete with postgresql 7. Are we
better off just using delete without a limit do you think?
Regards
Ben
