I have a postgresql version 7.1.2 running on RH Linux 2.4.2-2 .
psql DELETE and UPDATE commands are failing in a strange way.
If I do an : UPDATE table set column = 'data' ;
it is actually adding rows. And if I do a : DELETE from table ;
it is removing all but one row. Almost like it exits before it is finished.
Any pointers appreciated.
--
Danny Aldham Providing Certified Internetworking Solutions to Business
www.postino.com E-Mail, Web Servers, Web Databases, SQL PHP & Perl