pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Dropping Functions
3+ messages / 2 participants
[nested] [flat]

* Dropping Functions
@ 2008-03-27 00:05 Shawn <postgres@xmtservices.net>
  2008-03-27 00:13 ` Re: Dropping Functions Adrian Klaver <aklaver@comcast.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Shawn @ 2008-03-27 00:05 UTC (permalink / raw)
  To: pgsql-sql

Hi Guys,

Just a quick question.  Is there a known problem with dropping function in 
8.2.6?  I can make them but they can't be deleted.

Shawn





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Dropping Functions
  2008-03-27 00:05 Dropping Functions Shawn <postgres@xmtservices.net>
@ 2008-03-27 00:13 ` Adrian Klaver <aklaver@comcast.net>
  2008-03-27 00:25   ` Re: Dropping Functions Shawn <postgres@xmtservices.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Adrian Klaver @ 2008-03-27 00:13 UTC (permalink / raw)
  To: pgsql-sql; +Cc: Shawn <postgres@xmtservices.net>

On Wednesday 26 March 2008 5:05 pm, Shawn wrote:
> Hi Guys,
>
> Just a quick question.  Is there a known problem with dropping function in
> 8.2.6?  I can make them but they can't be deleted.
>
> Shawn

They will not deleted if something else depends on them i.e. a trigger.
Can you show the error message if any?
-- 
Adrian Klaver
aklaver@comcast.net



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Dropping Functions
  2008-03-27 00:05 Dropping Functions Shawn <postgres@xmtservices.net>
  2008-03-27 00:13 ` Re: Dropping Functions Adrian Klaver <aklaver@comcast.net>
@ 2008-03-27 00:25   ` Shawn <postgres@xmtservices.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Shawn @ 2008-03-27 00:25 UTC (permalink / raw)
  To: pgsql-sql

On Thursday 27 March 2008 00:13:26 Adrian Klaver wrote:
> On Wednesday 26 March 2008 5:05 pm, Shawn wrote:
> > Hi Guys,
> >
> > Just a quick question.  Is there a known problem with dropping function
> > in 8.2.6?  I can make them but they can't be deleted.
> >
> > Shawn
>
> They will not deleted if something else depends on them i.e. a trigger.
> Can you show the error message if any?
> --
> Adrian Klaver
> aklaver@comcast.net

Thanks Adrian,

Sorry to bother you, I found it.  I had 2 _ characters in the name and I was 
trying to delete with only 1.  Talk about bonehead....

Shawn




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2008-03-27 00:25 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-27 00:05 Dropping Functions Shawn <postgres@xmtservices.net>
2008-03-27 00:13 ` Adrian Klaver <aklaver@comcast.net>
2008-03-27 00:25   ` Shawn <postgres@xmtservices.net>

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