[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] Updating Query of 1 table from data in another
From:       "Scott Marlowe" <scott.marlowe () gmail ! com>
Date:       2008-10-15 14:26:11
Message-ID: dcc563d10810150726l74a5c086xd378a58027d9d3d4 () mail ! gmail ! com
[Download RAW message or body]

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.

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
[prev in list] [next in list] [prev in thread] [next in thread]