heap_mark4update: (am)invalid tid

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: heap_mark4update: (am)invalid tid
Date: 2003-09-08 11:37:20
Message-ID: Pine.LNX.4.44.0309081655580.10122-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I am using 7.3.2 on redhat linux 7.3.

I am getting this error during update. My update sql is,

test_pg=# update po_header set emp_name = a.user_name from users a where
emp_code = a.user_code and emp_name != a.user_name and a.user_name is not
null;

I referred the link,
http://archives.postgresql.org/pgsql-bugs/2003-04/msg00076.php .

My answers are,

(a) yes, i have before triggers
(b) no, users table donot have multi entries

Should i require to upgrade? or, Is there any smart sql?

TIA.

regards,
bhuvaneswaran

Table definitions:
Table "public.po_header"
Column | Type | Modifiers
---------------------+--------------------------+--------------------------------
po_no | text |
seq_x | integer |
seq_y | integer |
comp_code | text |
generated_by | text |
supp_code | text |
emp_code | text |
....
emp_name | text |
...
Indexes: po_header_uniq_idx unique btree (po_no, comp_code, seq_x, seq_y),
...
Check constraints: "po_header_type" ((("type" = 'NEW'::text) OR ("type" = 'CHANGED'::text)) OR ("type" = 'CANCELLED'::text))
Triggers: RI_ConstraintTrigger_17175491,
...
tapproval_date,
tbuyer_supp_map,
texception,
tmtime_po_header,
tnames_po_header,
tpo_flags_insert,
tprocess_complete,
tref_supplier,
tstatus_count

Table "public.users"
Column | Type | Modifiers
-------------------+--------------------------+-----------------------------------------------
user_id | integer | not null default nextval('user_id_seq'::text)
login_id | text |
user_code | text |
comp_code | text |
user_name | text |
...
Indexes: users_pkey primary key btree (user_id),
...
Check constraints: "users_email_id" ((email_id ~ '@'::text) AND (email_id ~ '.'::text))
Triggers: RI_ConstraintTrigger_17175378,
...
tmtime_users

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Huxton 2003-09-08 12:09:16 Re: [GENERAL] plPGSQL bug in function creation
Previous Message Marek Lewczuk 2003-09-08 08:32:28 plPGSQL bug in function creation