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 (<[EMAIL PROTECTED]>)
"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)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
