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
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 |