Re: [GENERAL] Resp.: Automatic insert statement generator?

2008-12-06 Thread Sebastian Tennant 
Hi Osvaldo,

Your list_fields function looked interesting to me so I tried it out and
it only worked for one of the five or so tables in the database I was
connected to at the time.

More concerning is the fact that I can't seem to drop it.  I'm told it
doesn't exist, and then I use it to prove (to myself) that it does.


Here's it not working:

 itidb= select list_fields('joblistings');
 -[ RECORD 1 ]-
 list_fields | 

Here's it working:

 itidb= select list_fields('joblist');
 -[ RECORD 1 ]--
 list_fields | full_name,username,password,recruiter,subscribed,...

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

And here's it working again!

 itidb= select list_fields('joblist');
 -[ RECORD 1 ]--
 list_fields | full_name,username,password,recruiter,subscribed,...


I'm noticing some very strange behaviour this evening (see thread
'Unique constaint violated without being violated').

Is my database corrupted or are there some vital database maintenance
tasks I've neglected to do?

I'm starting to get worried now.

Sebastian


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Resp.: Automatic insert statement generator?

2008-12-06 Thread Raymond O'Donnell 
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
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Resp.: Automatic insert statement generator?

2008-12-06 Thread Sebastian Tennant 
Quoth Raymond O'Donnell [EMAIL PROTECTED]:
 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.

Man, am I'm feeling geriatric tonight!  Thanks for clearing that up for
me Ray.

I guess this is what comes of working under pressure on a Saturday night
when I should be out having a quiet drink with a few friends.

Sebastian


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general