Re: hi i am gettin error when i am deleting a function from - Mailing list pgsql-sql

From Robert Edwards
Subject Re: hi i am gettin error when i am deleting a function from
Date
Msg-id 45060380.9060004@cs.anu.edu.au
Whole thread Raw
In response to hi i am gettin error when i am deleting a function from my pgadmin  ("Penchalaiah P." <penchalaiahp@infics.com>)
List pgsql-sql
Can you give us the actual delete command you are issuing?

You need to specify the types of the function arguments when deleting
functions, for example:

DELETE FUNCTION my_sum (int, int);

etc.

Cheers,

Bob Edwards.

Penchalaiah P. wrote:
> Hi good morning to all….
> 
> I created some functions in my pgadmin… when I am deleting those 
> functions from that pgadmin its giving error…i.e
> 
>  
> 
> An ERROR  has occurred;;;;
> 
>  
> 
> ERROR:function function_name1(character varying, character varying, 
> character varying, date, character varying) does not exist…
> 
> May I know the reason y its not deleting….
> 
>  
> 
> *Thanks  &  Regards*
> 
> *Penchal reddy **|** Software Engineer           *
> 
> *Infinite Computer Solutions **|** Exciting Times…Infinite 
> Possibilities... *
> 
> *SEI-CMMI level 5 **| **ISO 9001:2000*
> 
> *IT SERVICES **|** 
> BPO
                                                       
 
> *
> 
> *Telecom **|** **Finance **|** **Healthcare **| **Manufacturing **|** 
> **Energy & Utilities **|** **Retail & Distribution **|** 
> **Government                                                        *
> 
> *Tel +91-80-5193-0000(Ext:503)**|** Fax  +91-80-51930009 **|** Cell No  
> +91-9980012376**|**www.infics.com**          *
> 
> *Information transmitted by this e-mail is proprietary to Infinite 
> Computer Solutions and/ or its Customers and is intended for use only by 
> the individual or entity to which it is addressed, and may contain 
> information that is privileged, confidential or exempt from disclosure 
> under applicable law. If you are not the intended recipient or it 
> appears that this mail has been forwarded to you without proper 
> authority, you are notified that any use or dissemination of this 
> information in any manner is strictly prohibited. In such cases, please 
> notify us immediately at** **_info.in@infics.com _**and delete this mail 
> from your records.*
> 
>  
> 
> Information transmitted by this e-mail is proprietary to Infinite 
> Computer Solutions and / or its Customers and is intended for use only 
> by the individual or the entity to which it is addressed, and may 
> contain information that is privileged, confidential or exempt from 
> disclosure under applicable law. If you are not the intended recipient 
> or it appears that this mail has been forwarded to you without proper 
> authority, you are notified that any use or dissemination of this 
> information in any manner is strictly prohibited. In such cases, please 
> notify us immediately at info.in@infics.com and delete this email from 
> your records.
> 



pgsql-sql by date:

Previous
From: Robert Edwards
Date:
Subject: Re: on connect/on disconnect
Next
From: Mezei Zoltán
Date:
Subject: Two optimization questions