Re: [GENERAL] typical schema for a forum?

nd its inverse, but is generally implemented with a "thread ID" field for efficiency) There is also the alternate "same thread as" relationship, post1.subject=post2.subject. The e-mail and newsgroup RFCs would also be a good source for architectural ideas. -- David Le

Re: [GENERAL] Indirect access to data, given table name as a string

On Sat, 2007-04-21 at 18:31 -0700, Arthaey Angosii wrote: > I want to allow "notes" on any row in any table in my database. A > table row may have multiple notes. Say my tables are "foo," "bar," and > "qux." I want to avoid having a lookup table for each of them > ("foo_notes," "bar_notes," and "qu

Re: [GENERAL] Questions about horizontal partitioning

Ron Johnson wrote: On 01/08/07 20:39, Tom Lane wrote: John Sales <[EMAIL PROTECTED]> writes: By doing this, I'm hoping that the query optimizer is smart enough to see that if a query comes in and requests only the six columns (that are in the narrower ta

Re: [GENERAL] GUID/UUID Support

tifier project on GBorg seems like it has what you want: a user-defined type, and a generator. I think the main thing it needs is some code cleanup/robustness and a lot of production testing. -- David Lee Lambert (recent WSU grad) <[EMAIL PROTECTED]> Cell phone: +1