From: | Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | two buglets: createlang and pg_get_triggerdef |
Date: | 2003-07-31 20:32:53 |
Message-ID: | 20030731203253.GB13469@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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[(at)]dcc(dot)uchile(dot)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 Hernndez-Novich)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-31 21:06:12 | Re: two buglets: createlang and pg_get_triggerdef |
Previous Message | ivan | 2003-07-31 20:21:22 | Re: now about psql and one function |