Re: [GENERAL] table partitioning and plpgsql functions in 8.2.3

2007-04-08 Thread paul rivers
Apologies, I should have read more cafeully - this is already documented: 5.9.5 Caveats Constraint exclusion only works when the query's WHERE clause contains constants. A parameterized query will not be optimized, since the planner cannot know what partitions the parameter value might select at

Re: [GENERAL] Documenting PGSQL database.

2007-04-08 Thread Björn Lundin
7 apr 2007 kl. 21.07 skrev RPK: I am using PGSQL 8.2.3 on Windows XP. I want to know whether there is any way of documenting the schema of PGSQL database so that I can get a printed copy of the same. Hmm, I did not get my own post , so I thought I'd reply on this one again Looking th

Re: [GENERAL] Documenting PGSQL database.

2007-04-08 Thread imageguy
On Apr 7, 4:07 pm, [EMAIL PROTECTED] (RPK) wrote: > I am using PGSQL 8.2.3 on Windows XP. I want to know whether there is any way > of documenting the schema of PGSQL database so that I can get a printed copy > of the same. > -- > View this message in > context:http://www.nabble.com/Documenting-PG