Skip site navigation (1) Skip section navigation (2)

UPDATE and DELETE fail in strange way

From: Danny Aldham <danny(at)lennon(dot)postino(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: UPDATE and DELETE fail in strange way
Date: 2001-09-21 19:57:44
Message-ID: 200109211957.f8LJvjH22051@lennon.postino.com (view raw or flat)
Thread:
Lists: pgsql-novice

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: hodgesDate: 2001-09-22 17:55:04
Subject: how to change or set password for a database
Previous:From: Tom LaneDate: 2001-09-20 14:13:11
Subject: Re: VACUUM vs VACUUM ANALYZE vs CLUSTER

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group