postgresql 8.1

Ben Suffolk <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.