From: Tomas S. <tom...@gm...> - 2010-07-30 07:10:32
|
In order not to goo too deep into internals (as Ivan says), I will try adding a rowid to a query and then hiding that column. Then upon update/delete TOra can check if rowid exists and if so - use that, otherwise use current method (construct a fat where clause). P.S. Showing an error message when number of records affected is > 0 is a problem for other databases, which are not using transactions (records will already be deleted). Just for the record: If I open a table without primary key in pgAdminIII I get a message saying that "this table does not have OID or primary key so you cannot edit it...". -- Tomas Straupis |