Postgres crash during Stored procedure execution

Hi,

We are facing one database crash issue because of stored procedures.

When the stored procedure with a set of values is executed the first time,
it works fine.

If the same stored procedure is executed with same set of values once more,
the database crashes with the error

WARNING:  terminating connection because of crash of another server process

DETAIL:  The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.

HINT:  In a moment you should be able to reconnect to the database and
repeat your command.

This is what we have in the stored procedure:

SELECT * FROM TEST(1, 1)

Two values are being passed to the stored procedure.

First one is just a number and second value is an ID which has foreign key
constraint.

Because of the foreign key constraint, the foreign key violation error is
expected. But why should the server crash because of this violation?

Please let me know what we are missing.

Thanks and Regards

Jayashankar

Larsen & Toubro Limited

www.larsentoubro.com

This Email may contain confidential or privileged information for the
intended recipient (s). If you are not the intended recipient, please do not
use or disseminate the information, notify the sender and delete it from
your system.