pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhi i am gettin error when i am deleting a function from my pgadmin
4+ messages / 4 participants
[nested] [flat]
* hi i am gettin error when i am deleting a function from my pgadmin
@ 2006-09-11 07:46 Penchalaiah P. <penchalaiahp@infics.com>
2006-09-11 14:46 ` Re: hi i am gettin error when i am deleting a function from my pgadmin Aaron Bono <aaron.bono@aranya.com>
2006-09-12 00:46 ` Re: hi i am gettin error when i am deleting a function from Robert Edwards <bob@cs.anu.edu.au>
0 siblings, 2 replies; 4+ messages in thread
From: Penchalaiah P. @ 2006-09-11 07:46 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: hi i am gettin error when i am deleting a function from my pgadmin
2006-09-11 07:46 hi i am gettin error when i am deleting a function from my pgadmin Penchalaiah P. <penchalaiahp@infics.com>
@ 2006-09-11 14:46 ` Aaron Bono <aaron.bono@aranya.com>
2006-09-11 14:47 ` Fwd: hi i am gettin error when i am deleting a function from my pgadmin Aaron Bono <postgresql@aranya.com>
1 sibling, 1 reply; 4+ messages in thread
From: Aaron Bono @ 2006-09-11 14:46 UTC (permalink / raw)
To: Penchalaiah P. <penchalaiahp@infics.com>; +Cc: pgsql-sql
On 9/11/06, Penchalaiah P. <penchalaiahp@infics.com> 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….
>
What schema is the function in? Perhaps you need to specify the schema name
in your drop statement.
It helps if you supply the exact command you are typing in.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
^ permalink raw reply [nested|flat] 4+ messages in thread
* Fwd: hi i am gettin error when i am deleting a function from my pgadmin
2006-09-11 07:46 hi i am gettin error when i am deleting a function from my pgadmin Penchalaiah P. <penchalaiahp@infics.com>
2006-09-11 14:46 ` Re: hi i am gettin error when i am deleting a function from my pgadmin Aaron Bono <aaron.bono@aranya.com>
@ 2006-09-11 14:47 ` Aaron Bono <postgresql@aranya.com>
0 siblings, 0 replies; 4+ messages in thread
From: Aaron Bono @ 2006-09-11 14:47 UTC (permalink / raw)
To: pgsql-sql
On 9/11/06, Penchalaiah P. <penchalaiahp@infics.com> 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….
>
What schema is the function in? Perhaps you need to specify the schema name
in your drop statement.
It helps if you supply the exact command you are typing in.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: hi i am gettin error when i am deleting a function from
2006-09-11 07:46 hi i am gettin error when i am deleting a function from my pgadmin Penchalaiah P. <penchalaiahp@infics.com>
@ 2006-09-12 00:46 ` Robert Edwards <bob@cs.anu.edu.au>
1 sibling, 0 replies; 4+ messages in thread
From: Robert Edwards @ 2006-09-12 00:46 UTC (permalink / raw)
To: Penchalaiah P. <penchalaiahp@infics.com>; +Cc: 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.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-09-12 00:46 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-11 07:46 hi i am gettin error when i am deleting a function from my pgadmin Penchalaiah P. <penchalaiahp@infics.com>
2006-09-11 14:46 ` Aaron Bono <aaron.bono@aranya.com>
2006-09-11 14:47 ` Aaron Bono <postgresql@aranya.com>
2006-09-12 00:46 ` Re: hi i am gettin error when i am deleting a function from Robert Edwards <bob@cs.anu.edu.au>
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