Unix Technical Forum

Function name string bug pgadmin 1.4.1

This is a discussion on Function name string bug pgadmin 1.4.1 within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> Hi all, I want to report a bug in pgAdmin v 1.4.1 When we try to change some propertie ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Support

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 08:17 PM
Luiz K. Matsumura
 
Posts: n/a
Default Function name string bug pgadmin 1.4.1

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 08:17 PM
Andreas Pflug
 
Posts: n/a
Default Re: Function name string bug pgadmin 1.4.1

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:12 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com