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)