Re: [GENERAL] plpgsql function errors

2005-02-04 Thread Juan Casero (FL FLC)
-Original Message- From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 4:49 PM To: Juan Casero (FL FLC) Cc: Postgresql General Subject: Re: [GENERAL] plpgsql function errors On Fri, Feb 04, 2005 at 01:14:44PM -0600, Juan Casero (FL FLC) wrote: > Here is the output

Re: [GENERAL] plpgsql function errors

2005-02-04 Thread Juan Casero (FL FLC)
PM To: Juan Casero (FL FLC) Cc: Postgresql General Subject: Re: [GENERAL] plpgsql function errors On Fri, Feb 04, 2005 at 12:44:35PM -0600, Juan Casero (FL FLC) wrote: > Sorry about that. I did forget one parameter... > > customer_service=# select > trx_id('JUANCASERO3055128218&

Re: [GENERAL] plpgsql function errors

2005-02-04 Thread Juan Casero (FL FLC)
inal Message- From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 1:56 PM To: Juan Casero (FL FLC) Cc: Postgresql General Subject: Re: [GENERAL] plpgsql function errors On Fri, Feb 04, 2005 at 12:44:35PM -0600, Juan Casero (FL FLC) wrote: > Sorry about tha

Re: [GENERAL] Best Linux Distribution

2005-02-04 Thread Juan Casero (FL FLC)
Let me chime in here for a moment. My objective is not to bash any filesystem technology. I have been using XFS consistently now for a couple of years on all my Linux boxes. It works great. I love the spead and performance. A number of years ago when it was first being ported to Linux I tried

Re: [GENERAL] plpgsql function errors

2005-02-04 Thread Juan Casero (FL FLC)
wanted to start with the simplest case possible to improve my chances of success with the procedure and optimize it later. Any ideas on why the function call fails? Thanks, Juan -Original Message- From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 1:06 PM

[GENERAL] plpgsql function errors

2005-02-04 Thread Juan Casero (FL FLC)
Title: plpgsql function errors Hi Everyone - I am new to this list and although I have been using postgresql on and off for about a year now.  I am trying to develop a webapp using perl and cgi with postgresql 7.4.6 as a backend database.  One of the things I need is to create a transaction