Re: "fun with multipart primary keys" hobby kit

From: Chris Trawick <ctrawick(at)cultured(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: "fun with multipart primary keys" hobby kit
Date: 2004-01-03 06:07:14
Message-ID: 1073110034.733.42.camel@unity.basin.cultured.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cultured(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message D. Dante Lorenso 2004-01-04 01:18:34 Indexing a Boolean or Null column?
Previous Message Tom Lane 2004-01-03 05:57:54 Re: "fun with multipart primary keys" hobby kit