| From: | Chairudin Sentosa Harjo <chai(at)dnet(dot)net(dot)id> |
|---|---|
| To: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Lock vs Update |
| Date: | 1998-08-14 07:58:26 |
| Message-ID: | 35D3EE21.E24F5F49@dnet.net.id |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi all,
I have a question regarding lock.
I want to update a table, so I want to make sure nobody else
is trying to update the same table, that's why I use lock.
What is the meaning of the NOTICE when I update the "mytable" ?
#########################################
mytable=> begin;
BEGIN
mytable=>lock table mytable;
DELETE 0
update mytable set status='INVALID' where number=12;
NOTICE: (transaction aborted): queries ignored until END
*ABORT STATE*
#########################################
I can only update the "mytable" after I type:
#########################################
mytable=> end;
END
mytable=> update mytable set status='INVALID' where number=12;
UPDATE 1
##########################################
Regards
Chai
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgres | 1998-08-14 13:43:16 | |
| Previous Message | Karin Probost | 1998-08-14 07:23:48 | test subscribed |