From: | ivan <iv(at)psycho(dot)pl> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | now about psql and one function |
Date: | 2003-07-28 20:05:40 |
Message-ID: | Pine.LNX.4.56.0307282155340.24554@rex.anfa.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
in psql , file command.c : 1473 there is a query to check state for
superuser, and this query is in begin/end transaction.
When user dont have perm to read pg_user its fail but transation is never
end, and ist make some confusion because user have to write "END;" or
"ROLLBACK;" themself. I just removed BEGIN and END from this query.
ok, and this function :
create or replace func () returns INT as '
DECLARE
cnt INT;
BEGIN
CREATE TEMP TABLE ble (i INT);
SELECT INTO cnt count(*) FROM ble;
DROP TABLE ble;
RETURN cnt;
END;
' LANGUAGE 'plpgsql';
and at first time everythink is ok, but in next time is error like this :
pg_class_aclcheck : relation <nr> not found .
(This function is only example , and i know that it doesnt sens)
I think its by SysCache, how can i reset it ? or turn off ? or reload ?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-28 20:13:13 | Re: Regression test failure date. |
Previous Message | Bruce Momjian | 2003-07-28 19:46:54 | Re: Regression test failure date. |