Postgres Pro
Downloads
Home   >   mailing lists

Thread: Function name string bug pgadmin 1.4.1

Function name string bug pgadmin 1.4.1

From
"Luiz K. Matsumura"
Date:
Hi all,
 
I want to report a bug in pgAdmin v 1.4.1
When we try to change some propertie in trigger function in the tree
 
Databases
 |- <DBname>
   |- Schemas
     |- <schemaname>
       |- Tables
         |- <tablename>
           |- Triggers
             |- <Trigger_name>
               |- <Function_name>
 
 
in the properties window they generate a wrong <schema>.<Function name> string like :
 
CREATE OR REPLACE FUNCTION <trigger_name>.<function_name>() ....
 
When i use the properties window trough
 
Databases
 |- <DBname>
   |- Schemas
     |- <schemaname>
       |- Trigger Functions
         |- <Function_name>
 
It works write generating:
 
CREATE OR REPLACE FUNCTION <schemaname>.<function_name>() ....
 
 
Thanks in Advance.
 
PS.
Thanks by create this wonderful tool, it´s really a good job.
Sorry by the poor english.
 
Luiz Matsumura

Re: Function name string bug pgadmin 1.4.1

From
Andreas Pflug
Date:
Luiz K. Matsumura wrote:
> Hi all,
>  
> I want to report a bug in pgAdmin v 1.4.1
> When we try to change some propertie in trigger function in the tree
>  
> Databases
>  |- <DBname>
>    |- Schemas
>      |- <schemaname>
>        |- Tables
>          |- <tablename>
>            |- Triggers
>              |- <Trigger_name>
>                |- <Function_name>
>  
>  
> in the properties window they generate a wrong <schema>.<Function name> 
> string like :
>  
> CREATE OR REPLACE FUNCTION <trigger_name>.<function_name>() ....
>  
> When i use the properties window trough
>  
> Databases
>  |- <DBname>
>    |- Schemas
>      |- <schemaname>
>        |- Trigger Functions
>          |- <Function_name>
>  
> It works write generating:
>  
> CREATE OR REPLACE FUNCTION <schemaname>.<function_name>() ....

Can't reproduce this. Please provide a sample.

Regards,
Andreas