hi guys.
i'm using microsoft odbc and i close and open a lot of connections
through my code at a regular basis. for some reason, sometimes, not
always, i get the following error when i try to open a new connection
to the DB: ERROR [IM005] [Microsoft][ODBC Driver Manager] Driver's
hi,
i have a btree index on col1 in table1. The column has either values
1,2,3, or 4. 4 does not appear that much in the table (only 5 times).
there are about 20 million rows in the table. when i do a select *
from table1 where col1=4 it takes very long time to get back to me
(around 4
col2=6
RETURN NEXT row;
END LOOP;
RETURN;
END;
'
LANGUAGE 'plpgsql' VOLATILE;
thanx, amir
On Tue, 10 Aug 2004 15:53:33 -0700, Amir Zicherman
[EMAIL PROTECTED] wrote:
will locks work inside functions or only in transactions?
will this lock?
CREATE OR REPLACE FUNCTION
will locks work inside functions or only in transactions?
will this lock?
CREATE OR REPLACE FUNCTION public.sample(varchar)
RETURNS SETOF record AS
'
DECLARE
row RECORD;
BEGIN
LOCK TABLE URL IN ROW SHARE MODE;
FOR urlrow in EXECUTE \'SELECT * FROM table1\'
LOOP
UPDATE table1 SET
what does it mean when one lock mode conflicts with another like is
says in the documentation? can somebody explain and maybe give an
example.
thanx, amir
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an