| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | Postgre General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Linking |
| Date: | 2005-11-02 00:22:29 |
| Message-ID: | 20051102002229.GB88679@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Nov 01, 2005 at 02:22:07PM -0800, Bob Pawley wrote:
> On data entry I want the serial number generated in process.fluid_id
> to be transferred to column specification.fluid_id.
This sounds like the same thing you asked last week. Was the example
in the following message not helpful? Did I misunderstand what you're
trying to do?
http://archives.postgresql.org/pgsql-general/2005-10/msg01695.php
> A simple insert/select command will transfer the serial number but
> entering a second row then employing an insert/select command violates
> the p_k unique rule.
Could you provide an example of what you're doing to get this error?
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew D. Fuller | 2005-11-02 01:01:41 | Re: SQL injection |
| Previous Message | Nels Lindquist | 2005-11-02 00:18:33 | Re: Copying data from one column to another |