From: Josh Berkus <josh@agliodbs.com>
To: Rich Seiersen <rich67dev@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: plpgsql question
Date: Sat, 8 Nov 2003 15:46:35 -0800
Message-ID: <200311081546.35377.josh@agliodbs.com> (raw)
In-Reply-To: <Law9-F5etvHGrvxtvOx00028551@hotmail.com>
References: <Law9-F5etvHGrvxtvOx00028551@hotmail.com>
Rich,
> I don't want to abuse you - so if this is the wrong forum for this, feel
> free to toss it back with direction :-)
No, but I do think that you should CC a mailing list becuase:
1) Someone else may have direct experience with your problem and answer more
quickly than me, and:
2) Other people will want to read your issue and share in the solution.
Therefore I've cc'd the SQL list. Hope that's OK. I've omitted the full text
of your procedure in case it contains proprietary info.
> I think I might be running up against an error with plpgsql in temrs of seg
> faults with null values in stored procs. Here is my stored proc, the
> error, and the datatype definintion:
> 1. I am using 7.3 btw
> 2. WARNING: Error occurred while executing PL/pgSQL function
> getcaseaccounttransactionlist
> WARNING: line 44 at return next
> ERROR: Wrong record type supplied in RETURN NEXT
Um, that's a regular error. How is it a Seg Fault?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, rich67dev@hotmail.com
Subject: Re: plpgsql question
In-Reply-To: <200311081546.35377.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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