SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 06:35 PM
| ||||
| ||||
 Re: default index for primary key of a table Vinita.Bansal@trilogy.com writes: > Postgres automatically creates index for Primary key of a table. I want to > turn this off, so that the default index is not created for primary key. > How can I do this?? Postgres does not support UNIQUE constraints (and PRIMARY KEY implies a UNIQUE constraint) without an index. In Postgres the index is necessary to implement the constraint. In practice this doesn't usually cause any problem. Why do you want to do this? -- greg ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
Linear Mode
