On Fri, Oct 28, 2005 at 02:57:03PM -0400, Rod Taylor wrote: > The basic idea is that most of us break out schemas by creating fake > primary keys for the purpose of obtaining performance because using the > proper primary key (single or multiple columns) is often very slow. > > The automatic and transparent creation of a surrogate key by PostgreSQL > would allow us to dramatically clean up the presentation of our schema > to the users using the database without the performance hit we currently > get. > > > It puts surrogate keys (fake primary keys) back to the level of table > spaces, indexes and other performance enhancements where they belong.
Ahh. Yes, that would definately be great to have. Although it would probably take me months if not years to get used to not seeing a bunch of _id fields laying all over the place... Is SURROGATE part of any of the ANSI specs? -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
