Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Well, these make it clear that you've got some pretty big chunks of
nonstandard code in the backend, so my first thought is that there's a
memory-clobber bug somewhere in that.
I'm not sure what you mean by 'nonstandard code
Geoffrey <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Well, these make it clear that you've got some pretty big chunks of
>> nonstandard code in the backend, so my first thought is that there's a
>> memory-clobber bug somewhere in that.
> I'm not sure what you mean by 'nonstandard code,' could
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
Problem is, we seem to be having a problem with this reset issue and I
don't see a correlation in the backtraces. Most of them are in fact
related to inserts, but there are at least three different tables
involved. There are also some wher
Geoffrey <[EMAIL PROTECTED]> writes:
> Problem is, we seem to be having a problem with this reset issue and I
> don't see a correlation in the backtraces. Most of them are in fact
> related to inserts, but there are at least three different tables
> involved. There are also some where an INSER
Tom Lane wrote:
It seems you've got a corrupt "compiled statements" data structure for
a plpgsql trigger function. Offhand this does not look like any of the
known post-7.4.7 bug fixes. Can you show us the source code for that
trigger?
Problem is, we seem to be having a problem with this res
Geoffrey <[EMAIL PROTECTED]> writes:
> Program terminated with signal 11, Segmentation fault.
> #0 exec_stmt (estate=0xfeff8a90, stmt=0x0) at pl_exec.c:928
> in pl_exec.c
> #0 exec_stmt (estate=0xfeff8a90, stmt=0x0) at pl_exec.c:928
> #1 0x0083f005 in exec_stmts (estate=0xfeff8a90, stmt
Maybe I'm restating the obvious, but it looks to me like the procedural
trigger from the SQL query "INSERT INTO logs
(seq,level,event_code,event_date,event_time,city,province,user_id,est_ds
p_date,est_dsp_time,country,edilate,carr_code,notes,trac_notes,order_num
)
VALUES ('2','6','TAS','09/14/06','
