now about psql and one function
От | ivan |
---|---|
Тема | now about psql and one function |
Дата | |
Msg-id | Pine.LNX.4.56.0307282155340.24554@rex.anfa.pl обсуждение исходный текст |
Ответы |
Re: now about psql and one function
|
Список | 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 ' DECLAREcnt INT; BEGINCREATE 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 ?
В списке pgsql-hackers по дате отправления: