Re: [HACKERS] plpgsql problem..

Ok guys, brand new problem!

Now the backend segfaults.




query: begin transaction
ProcessUtility: begin transaction
CommitTransactionCommand
StartTransactionCommand
query: insert into
agencys(agency_id,created,createdby,updated,updatedby,loginallow,memberdate,
agencycode,agencyowner,agencyname,address1,address2,city,state,postal,countr
y,fed_taxid,naps_member,email,url,fee_sched,refund_policy,membership_type,up
s_type,invoice_hard_copy,zerodate,balance) values
(487,'now',291,'now',291,0,'02-01-2000','TEST-123','Mitch Vincent','Test
INC','knkln','lknlkn','lknlkn','ky','41101','US','','f','mitch@lala.com','ww
w.mitch.com','','jnblj','trac','f','f','12-01-1999',0)
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: update agencys set specialization='dfdf' where agency_id=487
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: update agencys set background='fdf' where agency_id=487
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: delete from agencys_phones where agency_id=487
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: insert into agencys_logins (agency_id,month,maxallowed) values
(487,'02-01-2000',0)
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: insert into accounting(agency_id,month,totaljobs,totalapps) values
(487,'02-01-2000',0,0)
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: insert into invoice
(invoice_number,agencycode,invoice_date,fee_membership,fee_logins,fee_conven
tion,fee_prints_jobs,fee_prints_apps,fee_hotlines,fee_postage,fee_ups,fee_la
te,fee_other1,other_desc1,fee_other2,other_desc2,fee_other3,other_desc3,fee_
pastdue,amount_paid,paid,total)
values(1,'TEST-123','02-01-2000',193.33333333333,0,0,0,0,0,0,0,0,0,'',0,'',0
,'',0,0,'f',0)
ProcessQuery
query: SELECT $1 + $2 + $3 + $4 + $5 + $6 + $7 + $8 + $9 + $10 + $11 + $12 +
$13 - $14
CommitTransactionCommand
StartTransactionCommand
query: select * from invoice where invoice_number=1
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 75928 exited with status 0


I get that in the log file.... Can anyone see anything that might point to
the reason behind the segfault?


You guys have no idea how much I appreciate your help.. Thanks one and all.

-Mitch




----- Original Message -----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mitch Vincent <mitch@venux.net>
Sent: Tuesday, February 01, 2000 11:49 AM
Subject: Re: [HACKERS] plpgsql problem..


> "Mitch Vincent" <mitch@venux.net> writes:
> > plpgsql_call_handler|    1002|     13|f       |t           |f
|
> > 0|f        |         0|0 0 0 0 0 0 0 0|        100|             0|
> > 0|           100|-     |/usr/local/pgsql/lib/plpgsql.so
> > (1 row)
>
> That looks like it should work now...
>
> > Hmm, get this, now I have another error after droping and re-creating
the
> > language and function.
>
> > ERROR: fmgr_info: Cache lookup for language failed 4427969
>
> It sounds like your language entry is still pointing at the old
> function.  (There's no interlock to keep you from dropping a function
> that things still depend on ... probably there should be ...)
>
> Try recreating the language entry now that you've remade the function.
>
> regards, tom lane
>