[COMMITTERS] pgsql: Allow CREATE TABLE (LIKE ...) from composite type

2012-03-03 Thread Peter Eisentraut
Allow CREATE TABLE (LIKE ...) from composite type The only reason this didn't work before was that parserOpenTable() rejects composite types. So use relation_openrv() directly and manually do the errposition() setup that parserOpenTable() does. Branch -- master Details --- http://git.po

[COMMITTERS] pgsql: Provide environment overrides for psql file locations.

2012-03-03 Thread Andrew Dunstan
Provide environment overrides for psql file locations. PSQL_HISTORY provides an alternative for the command history file, and PSQLRC provides an alternative location for the .psqlrc file. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/34c978442c55dd13a3a8c6b90fd4380

Re: [COMMITTERS] pgsql: Provide environment overrides for psql file locations.

2012-03-03 Thread Andrew Dunstan
On 03/03/2012 04:43 PM, Andrew Dunstan wrote: Provide environment overrides for psql file locations. PSQL_HISTORY provides an alternative for the command history file, and PSQLRC provides an alternative location for the .psqlrc file. Forgot to mention this was reviewed by David Wheeler. Apo

[COMMITTERS] pgsql: Collect and use element-frequency statistics for arrays.

2012-03-03 Thread Tom Lane
Collect and use element-frequency statistics for arrays. This patch improves selectivity estimation for the array <@, &&, and @> (containment and overlaps) operators. It enables collection of statistics about individual array element values by ANALYZE, and introduces operator-specific estimators