Re: [SQL] rename primary key

2010-01-15 Thread Seb
On Fri, 15 Jan 2010 07:35:17 +0100, Guillaume Lelarge wrote: [...] > Primary keys are constraints. They are enforced with an index, but > actually they are constraints. So we put them on the constraints > nodes. > There is the same behaviour for unique constraints. Thanks. Would there be any

[SQL] indexes

2010-01-15 Thread Seb
Hi, I have some views and queries that take a bit too long to return, so perhaps some judicious indexes might help, but I don't know much about how to use them. The PostgreSQL manual has a good section on indexes, but I can't find guidance on (unless I missed something): o How to decide what col