Re: Updating Query of 1 table from data in another - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: Updating Query of 1 table from data in another
Date
Msg-id dcc563d10810150726l74a5c086xd378a58027d9d3d4@mail.gmail.com
Whole thread Raw
In response to Re: Updating Query of 1 table from data in another  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-sql
On Wed, Oct 15, 2008 at 8:16 AM, Chris Preston
<chris@thetrafalgartravel.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.


pgsql-sql by date:

Previous
From: "Stefano Buliani"
Date:
Subject: Re: effectiveness tool
Next
From: "Jamie Tufnell"
Date:
Subject: Most efficient way to achieve this ts_query