| Lists: | pgadmin-support |
|---|
| From: | Michał Sienicki <Michal(dot)Sienicki(at)instytut(dot)com(dot)pl> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | problem with empty arguments of trigger procedure |
| Date: | 2012-07-03 08:05:18 |
| Message-ID: | 4FF2A7BE.5040005@instytut.com.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
Bug report - pgAdmin 1.14.3, Windows
Trigger definition is not shown properly when function contains "empty" arguments.
Example
Trigger definition:
CREATE TRIGGER test_trigger
BEFORE INSERT
ON test_table
FOR EACH ROW
EXECUTE PROCEDURE test_function('arg1', '', 'arg3');
is displayed in pgAdmin as:
CREATE TRIGGER test_trigger
BEFORE INSERT
ON test_table
FOR EACH ROW
EXECUTE PROCEDURE test_function('arg1', 'arg3');
MS
| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Michał Sienicki <Michal(dot)Sienicki(at)instytut(dot)com(dot)pl> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: problem with empty arguments of trigger procedure |
| Date: | 2012-07-04 19:55:17 |
| Message-ID: | 1341431717.13931.4.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
On Tue, 2012-07-03 at 10:05 +0200, Michał Sienicki wrote:
> Bug report - pgAdmin 1.14.3, Windows
>
> Trigger definition is not shown properly when function contains "empty" arguments.
>
> Example
>
> Trigger definition:
>
> CREATE TRIGGER test_trigger
> BEFORE INSERT
> ON test_table
> FOR EACH ROW
> EXECUTE PROCEDURE test_function('arg1', '', 'arg3');
>
> is displayed in pgAdmin as:
>
> CREATE TRIGGER test_trigger
> BEFORE INSERT
> ON test_table
> FOR EACH ROW
> EXECUTE PROCEDURE test_function('arg1', 'arg3');
>
You're right, this is a bug. I added a ticket to work on it later.
Thanks for your report.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Michał Sienicki <Michal(dot)Sienicki(at)instytut(dot)com(dot)pl> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: problem with empty arguments of trigger procedure |
| Date: | 2012-07-19 20:28:05 |
| Message-ID: | 1342729685.1989.126.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
On Wed, 2012-07-04 at 21:55 +0200, Guillaume Lelarge wrote:
> On Tue, 2012-07-03 at 10:05 +0200, Michał Sienicki wrote:
> > Bug report - pgAdmin 1.14.3, Windows
> >
> > Trigger definition is not shown properly when function contains "empty" arguments.
> >
> > Example
> >
> > Trigger definition:
> >
> > CREATE TRIGGER test_trigger
> > BEFORE INSERT
> > ON test_table
> > FOR EACH ROW
> > EXECUTE PROCEDURE test_function('arg1', '', 'arg3');
> >
> > is displayed in pgAdmin as:
> >
> > CREATE TRIGGER test_trigger
> > BEFORE INSERT
> > ON test_table
> > FOR EACH ROW
> > EXECUTE PROCEDURE test_function('arg1', 'arg3');
> >
>
> You're right, this is a bug. I added a ticket to work on it later.
> Thanks for your report.
>
It's fixed in 1.16.
Thank you.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com