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
|
Список | 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 по дате отправления: