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
pgsql-novice by date
|Next:||From: hodges||Date: 2001-09-22 17:55:04|
|Subject: how to change or set password for a database|
|Previous:||From: Tom Lane||Date: 2001-09-20 14:13:11|
|Subject: Re: VACUUM vs VACUUM ANALYZE vs CLUSTER |