Experiencing problems with stored procedures - Mailing list pgsql-general

From sathish
Subject Experiencing problems with stored procedures
Date
Msg-id 20050616110638.M6260@mail.ceedees.com
Whole thread Raw
List pgsql-general
Dear group,
   We are using postgresql 7.4.7 on Fedora Core 3. We are currently
experiencing problems with running stored procedures on a database that
contains about 1200 tables. We have a table named adm_inst_mas with the
following structure

       Table "public.adm_inst_mas"
  Column   |         Type          | Modifiers
-----------+-----------------------+-----------
 inst_code | integer               | not null
 inst_name | text                  | not null
 inst_abbr | character(3)          | not null
 address   | text                  |
 city      | smallint              |
 district  | smallint              |
 pincode   | character varying(10) |
Indexes:
    "adm_inst_mas_pkey" primary key, btree (inst_code)
    "inst_name_ukey" unique, btree (inst_name)
    "adm_inst_un" unique, btree (inst_abbr)
Triggers:
    inst_order_trg AFTER INSERT ON adm_inst_mas FOR EACH ROW EXECUTE PROCEDURE
inst_order_fun()

We refer to the inst_code field as foreign key in almost 500 tables. At times
when we set a foreign key constraint that refers the inst_code in adm_inst_mas
the database detects deadlock. If we create the same constraint using alter table the
constraint is set. Whenever such error occurs we have difficulties in getting
stored procedures to run.  Now no procedures are getting executed in the database.
But table in which insert statement does not execute has no reference to the table
adm_inst_mas. How shall we debug and correct this problem.  We appreciate your early reply.

Thanking You in advance
Sathish Kumar.S

--
Open WebMail Project (http://openwebmail.org)


pgsql-general by date:

Previous
From: rod@cgvec.ie
Date:
Subject: Re: pg_dumpall
Next
From: stig erikson
Date:
Subject: encoding problems and float