Обсуждение: creatng a new interface to postgresql, how do I update a field with a particular oid?

Hello!

I think this might be a better place to post messages than the hackers
mailing list. I didn't catch this one the first time.

Anyways, I don't know if a web version currently exists, but I have gotten
a web interface to at least be able to view data from tables. Now I want
to update data.

If people are interested in what I am doing and would like to help out,
I am using ePerl, apache, and Javascript and you can e-mail me at
psql@tcu-inc.com

Anyways, my question is, I want to update specific rows according to their
oids. Oh, I am also using the perl module Pg. I can find out the oid of
the data retrieved, but I want to update data according to their oid.

Is there any easy way to do this using the moduel Pg or a select
statement? I couldn't find anything with the select statement and was
hoping Pg had something in it, but I couldn't find anything in it as well.

Thanks!

Mark

Mark Nielsen wrote:
>
> Hello!
>
>
> Anyways, my question is, I want to update specific rows according to their
> oids. Oh, I am also using the perl module Pg. I can find out the oid of
> the data retrieved, but I want to update data according to their oid.

update my_table
set
 field1 = value1,
 field2 = value2
where
 oid = my_oid
;

to make it faster you can create an index on the oid column.

It used to require a cast for pg to use the index, i.e.

where oid = const_oid::oid

but I don't know if it is still the case.

postgresql does not yet have a "select for update" syntax or
mechanics implemented.

----------
Hannu