| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Vincent de Phily <vincent(dot)dephily(at)mobile-devices(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
| Subject: | Re: does reindex need exclusive table access? |
| Date: | 2011-11-02 14:11:54 |
| Message-ID: | 29331.1320243114@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Vincent de Phily <vincent(dot)dephily(at)mobile-devices(dot)fr> writes:
> The technique kinda works (with some changes) using unique indexes however. Is
> there a functional difference between a unique index and a primary key index
> (knowing that my column is not null) ? Or is it just for documentation and ORM
> purposes ?
The only functional difference is that a foreign key declaration
referring to the table ("REFERENCES tabname") will default to the pkey
column list. If you haven't got a declared pkey then you have to spell
out the column list.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-11-02 14:26:50 | Re: Performance Problem with postgresql 9.03, 8GB RAM, Quadcore Processor Server--Need help!!!!!!! |
| Previous Message | Vincent de Phily | 2011-11-02 13:59:38 | Re: does reindex need exclusive table access? |