Re: "fun with multipart primary keys" hobby kit - Mailing list pgsql-performance

From Chris Trawick
Subject Re: "fun with multipart primary keys" hobby kit
Date
Msg-id 1073110034.733.42.camel@unity.basin.cultured.net
Whole thread Raw
In response to Re: "fun with multipart primary keys" hobby kit  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: "fun with multipart primary keys" hobby kit
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: deferred foreign keys