Re: Proglems with 7.2.1

Thanks to everyone who replied, but I think I figured out the problem. We
had triggers on each table that would start a function written in C. This, I
believe, is where the problem occured, and would explain the sigsev.

Thanks again!

-James

-----Original Message-----
From: Aurangzeb M. Agha [mailto:aagha@bigfoot.com]
Sent: Thursday, August 08, 2002 3:00 PM
To: James Kelty
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Proglems with 7.2.1


James, I'm a novice myself, so please excuse my ignorance.

What is the type o your 'employeeid' column?  I would guess that its
probably numeric, but you seem to be trying to insert a char value ('X')
into it.

Still, this should not terminate your server.

What platform are your running on?

Is this insert done via psql or pgadmin?

Is postmaster actually dead after you get the error below?

    Rgs,
    Aurangzeb

On Thu, 8 Aug 2002, James Kelty wrote:

:Hello.
:
:We recently moved to PostgreSQL 7.2.1 and are now having a problem with
just
:normal inserts. The following query
:INSERT INTO employee ("employeeid","sales_y_n","dataentry_y_n",
:"firstname","lastname","systemname","password") values
:('X','True','True','TEST','TEST','','X');
:
:Produces the following debug information. Can anyone help me with this? The
:signal 11 looks pretty bad.
:
:
:DEBUG:  server process (pid 23307) was terminated by signal 11
:DEBUG:  terminating any other active server processes
:DEBUG:  all server processes terminated; reinitializing shared memory and
:semaphores
:DEBUG:  database system was interrupted at 2002-08-08 16:15:48 PDT
:DEBUG:  checkpoint record is at 2/C30A416C
:DEBUG:  redo record is at 2/C30A416C; undo record is at 0/0; shutdown TRUE
:DEBUG:  next transaction id: 38682; next oid: 69992620
:DEBUG:  database system was not properly shut down; automatic recovery in
:progress
:FATAL 1:  The database system is starting up
:DEBUG:  redo starts at 2/C30A41AC
:DEBUG:  ReadRecord: record with zero length at 2/C30AC3CC
:DEBUG:  redo done at 2/C30AA374
:DEBUG:  database system is ready
:
:
:Thanks!
:
:-James
:
:James Kelty
:Director of Operations
:Everbase Systems, LLC
:624 A Street
:Ashland, OR 97520
:jamesk@everbase.net
:541.488.0801
:
:
:---------------------------(end of broadcast)---------------------------
:TIP 3: if posting/reading through Usenet, please send an appropriate
:subscribe-nomail command to majordomo@postgresql.org so that your
:message can get through to the mailing list cleanly
:

--
Aurangzeb M. Agha    | Email : aagha@bigfoot.com
                     | Home  : +3 010 8959.558
34 Nafsika St.       | Direct: +3 010 8995.875
Voula 16673          | Mobile: TBD
Greece               | Voice : 415 412 4234 (US Only)
                     | e-Fax : 978 246.0770
PGP ID: 0x68B3A763   |

"Those who would give up essential liberty to purchase a little
 temporary safety deserve neither liberty nor safety."

                    - Benjamin Franklin