| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Quick question |
| Date: | 2003-10-04 09:35:18 |
| Message-ID: | 3F7E9456.9060501@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Thanks - that's what I ended up doing. Hooray for CLUSTER indexes and
constraints in phpPgAdmin CVS now!
Chris
Tom Lane wrote:
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>
>>If someone could help me with this, it would be cool. How do I query
>>the catalogs to find the underlying index for a constraint? (Assuming
>>the constraint is primary or unique)
>
>
> A first approximation is that the constraint and the index have the same
> name, but I suppose someone could break that association by renaming the
> index. Look in pg_depend for an internal dependency entry from the
> index to the constraint if you want to be sure.
>
> regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-10-04 09:37:32 | Re: count(*) slow on large tables |
| Previous Message | Hannu Krosing | 2003-10-04 09:00:04 | Re: [HACKERS] Index/Function organized table layout (from Re: |