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
SQLAllocHand
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 minute
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 appropriate
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"
PDATE "table1" SET col1=5 WHERE "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 o
