From: | "ing(dot) Ovidiu Tanasiciuc" <tanasiciuc(at)yahoo(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3886: pgsql NEW dinamic columns change |
Date: | 2008-01-18 19:22:12 |
Message-ID: | 200801181922.m0IJMCgn050079@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3886
Logged by: ing. Ovidiu Tanasiciuc
Email address: tanasiciuc(at)yahoo(dot)com
PostgreSQL version: 8.25
Operating system: Windows Xp
Description: pgsql NEW dinamic columns change
Details:
Hi. I want to make a trigger for more tables that then i try to make a
update to make a new insert. i find a solution in next syntax
INSERT INTO TG_RELNAME SELECT NEW.*;
RETURN OLD;
the problem is that the primary key is violated because NEW.id_client
already exists.
i try to find a solution for change
NEW.<variable>=new_sequence .I can make this but the problem is how to
concatenate NEW with the variable???
I have solutions for put in the char or text <variable> the corect primary
key.
Please send me a solution or make a update at pgsql because a lot of people
need to change dynamic NEW or OLD columns(see in google : dynamic access
RECORD columns)
thanks...
PS: when it will be finsih slony2 syncronus master-master. I use very well
until now master with 10 slaves via VPN,but i will need master-master
solution for free.
From | Date | Subject | |
---|---|---|---|
Next Message | 苏睿 | 2008-01-19 08:23:11 | Error happen when Compile C program |
Previous Message | Tom Lane | 2008-01-18 17:47:46 | Re: BUG #3881: lo_open leaks memory |