Postgres Pro
Downloads
Home   >   mailing lists

Re: My honours project - databases using dynamically attached entity-properties - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: My honours project - databases using dynamically attached entity-properties
Date
Msg-id 87ejnuosn5.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: My honours project - databases using dynamically attached entity-properties  (Richard Huxton <dev@archonet.com>)
Responses Re: My honours project - databases using dynamically attached entity-properties  (Josh Berkus <josh@agliodbs.com>)
Re: My honours project - databases using dynamically attached entity-properties  (Richard Huxton <dev@archonet.com>)
List pgsql-hackers
Tree view 
"Richard Huxton" <dev@archonet.com> writes:

> Well the cost depends on where/how complex the extra fields are. If you're just
> talking about adding columns usercol01..NN with different types and possibly a
> lookup to a single client_attributes table, it's not difficult.

And then what? dynamically construct all your SQL queries? 
Sure, sounds like a simple solution to me...

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: possible de-optimization of multi-column index plans in 8.3
Next
From: Gregory Stark
Date:
Subject: Re: [COMMITTERS] pgsql: Make configuration parameters fall back to their default values