Re: Updating Query of 1 table from data in another

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Chris Preston" <chris(at)thetrafalgartravel(dot)com>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Updating Query of 1 table from data in another
Date: 2008-10-15 14:26:11
Message-ID: dcc563d10810150726l74a5c086xd378a58027d9d3d4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Oct 15, 2008 at 8:16 AM, Chris Preston
<chris(at)thetrafalgartravel(dot)com> wrote:
>
> Thanks scott
> Does this work with 8.1 (that's what I'm using)
> When I try to create the b table I get a message

Yep. Post a self-contained example of what's not working.

> ERROR: there is no unique constraint matching given keys for referenced
> table "testa"
> SQL state: 42830
>
> I named the a table testa and the b table testb

Like it says, there's no matching keys.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jamie Tufnell 2008-10-16 01:00:49 Most efficient way to achieve this ts_query
Previous Message Stefano Buliani 2008-10-15 07:40:44 Re: effectiveness tool