two buglets: createlang and pg_get_triggerdef

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)

Responses

Browse pgsql-hackers by date

  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