Re: "fun with multipart primary keys" hobby kit

Поиск
Список
Период
Сортировка
От Chris Trawick
Тема Re: "fun with multipart primary keys" hobby kit
Дата
Msg-id 1073110034.733.42.camel@unity.basin.cultured.net
обсуждение исходный текст
Ответ на Re: "fun with multipart primary keys" hobby kit  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Actually, it would appear that I was born yesterday.  I had no idea.
Added the cast and it fell right in.  Thanks!

chris  <--  feeling pretty dumb right now


On Sat, 2004-01-03 at 00:57, Tom Lane wrote:
> Chris Trawick <ctrawick@cultured.net> writes:
> >  contactid      | bigint  | not null
>                     ^^^^^^
>
> > Am I reading this right?  Is it only using half of the fully-qualified
> > pk index?  How do I diagnose this?  Has anyone seen this before?
>
> Surely you've been around here long enough to remember the
> must-cast-bigint-constants problem.
>
>             regards, tom lane


В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "fun with multipart primary keys" hobby kit
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: deferred foreign keys