two buglets: createlang and pg_get_triggerdef

Поиск
Список
Период
Сортировка
От Alvaro Herrera Munoz
Тема two buglets: createlang and pg_get_triggerdef
Дата
Msg-id 20030731203253.GB13469@dcc.uchile.cl
обсуждение исходный текст
Ответы Re: two buglets: createlang and pg_get_triggerdef  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hackers,

Two buglets:

The first one is in createlang, trying to create a language without
enough permission:

$ createlang -d alvherre plpgsql
createlang: language installation failed: ERROR:  c: permission denied

What's the "c" it's complaning about?


The second one is in pg_get_triggerdef():

alvherre=> create table test (foo int);
CREATE TABLE
alvherre=> create function foofun() returns trigger as 'select 1' language plpgsql;
CREATE FUNCTION
alvherre=> create trigger my_little_trigger before update on test execute procedure foofun();
CREATE TRIGGER
alvherre=> \d test    Table "public.test"Column |  Type   | Modifiers
--------+---------+-----------foo    | integer |
Triggers:   my_little^trigger BEFORE UPDATE ON test FOR EACH STATEMENT EXECUTE PROCEDURE foofun()

Note that the 9th character has been changed to "^".  I've seen the 9th
character change in all triggers here.  If I look at pg_trigger the name
is fine:

alvherre=> select tgname from pg_trigger where tgname='my_little_trigger';     tgname
-------------------my_little_trigger
(1 row)

This is not on latest CVS, but I haven't seem them reported nor fixed.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"El sentido de las cosas no viene de las cosas, sino de
las inteligencias que las aplican a sus problemas diarios
en busca del progreso." (Ernesto Hern�ndez-Novich)


В списке pgsql-hackers по дате отправления:

Предыдущее
От: ivan
Дата:
Сообщение: Re: now about psql and one function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: two buglets: createlang and pg_get_triggerdef