Re: hi i am gettin error when i am deleting a function from

From: Robert Edwards <bob(at)cs(dot)anu(dot)edu(dot)au>
To: "Penchalaiah P(dot)" <penchalaiahp(at)infics(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: hi i am gettin error when i am deleting a function from
Date: 2006-09-12 00:46:56
Message-ID: 45060380.9060004@cs.anu.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)in(at)infics(dot)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(dot)in(at)infics(dot)com and delete this email from
> your records.
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mezei Zoltán 2006-09-12 10:23:58 Two optimization questions
Previous Message Robert Edwards 2006-09-12 00:43:44 Re: on connect/on disconnect