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.
>