From: Robert Edwards <bob@cs.anu.edu.au>
To: Penchalaiah P. <penchalaiahp@infics.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: hi i am gettin error when i am deleting a function from
Date: Tue, 12 Sep 2006 10:46:56 +1000
Message-ID: <45060380.9060004@cs.anu.edu.au> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C90716603D@venus.infics.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C90716603D@venus.infics.com>
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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bob@cs.anu.edu.au, penchalaiahp@infics.com
Subject: Re: hi i am gettin error when i am deleting a function from
In-Reply-To: <45060380.9060004@cs.anu.edu.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox