Re: Resp.: Automatic insert statement generator? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Resp.: Automatic insert statement generator?
Date
Msg-id 493AA57A.30600@iol.ie
Whole thread Raw
In response to Re: Resp.: Automatic insert statement generator?  (Sebastian Tennant <sebyte@smolny.plus.com>)
List pgsql-general
On 06/12/2008 16:02, Sebastian Tennant wrote:
> Here's it working:
>
>  itidb=> select list_fields('joblist');

<snip>

> Here's me trying to drop it, only to be told it doesn't exist:
>
>  itidb=> drop function list_fields();
>  ERROR:  function list_fields() does not exist

You need to specify the argument types as well, so this -

  drop function list_fields(varchar); -- or whatever it is

- ought to work.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Sebastian Tennant
Date:
Subject: Re: Unique constaint violated without being violated
Next
From: Sebastian Tennant
Date:
Subject: Re: Resp.: Automatic insert statement generator?