Re: Updating Query of 1 table from data in another

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Updating Query of 1 table from data in another
Дата
Msg-id dcc563d10810150726l74a5c086xd378a58027d9d3d4@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Updating Query of 1 table from data in another  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Stefano Buliani"
Дата:
Сообщение: Re: effectiveness tool
Следующее
От: "Jamie Tufnell"
Дата:
Сообщение: Most efficient way to achieve this ts_query