[COMMITTERS] pgsql: Fix nested PlaceHolderVar expressions that appear only in target

2011-08-08 Thread Tom Lane
Fix nested PlaceHolderVar expressions that appear only in targetlists. A PlaceHolderVar's expression might contain another, lower-level PlaceHolderVar. If the outer PlaceHolderVar is used, the inner one certainly will be also, and so we have to make sure that both of them get into the placeholder

[COMMITTERS] pgsql: Fix nested PlaceHolderVar expressions that appear only in target

2011-08-08 Thread Tom Lane
Fix nested PlaceHolderVar expressions that appear only in targetlists. A PlaceHolderVar's expression might contain another, lower-level PlaceHolderVar. If the outer PlaceHolderVar is used, the inner one certainly will be also, and so we have to make sure that both of them get into the placeholder

[COMMITTERS] pgsql: Fix nested PlaceHolderVar expressions that appear only in target

2011-08-08 Thread Tom Lane
Fix nested PlaceHolderVar expressions that appear only in targetlists. A PlaceHolderVar's expression might contain another, lower-level PlaceHolderVar. If the outer PlaceHolderVar is used, the inner one certainly will be also, and so we have to make sure that both of them get into the placeholder

[COMMITTERS] pgsql: Fix nested PlaceHolderVar expressions that appear only in target

2011-08-08 Thread Tom Lane
Fix nested PlaceHolderVar expressions that appear only in targetlists. A PlaceHolderVar's expression might contain another, lower-level PlaceHolderVar. If the outer PlaceHolderVar is used, the inner one certainly will be also, and so we have to make sure that both of them get into the placeholder

[COMMITTERS] pgsql: Teach psql to display the comments on SQL/MED objects in verbose

2011-08-08 Thread Robert Haas
Teach psql to display the comments on SQL/MED objects in verbose mode. The relevant backslash commands already exist, so we're just adding an additional column. With this commit, all objects that have psql backslash commands and accept comments should now display those comments at least in verbos

[COMMITTERS] pgsql: Teach psql to display the comments on conversions and domains.

2011-08-08 Thread Robert Haas
Teach psql to display the comments on conversions and domains. \dc and \dD now accept a "+" option, which will cause the comments to be displayed. Along the way, correct a few oversights in the previous commit in this area, 3b17efdfdd846c9bfad1637686e6f18198ea3df5 - namely, (1) when \dL+ is used,

[COMMITTERS] pgsql: Teach vacuumlo to limit number of removals, via new -l option.

2011-08-08 Thread Robert Haas
Teach vacuumlo to limit number of removals, via new -l option. Also, handle failure better: don't just blindly keep trying to delete stuff after the transaction has already failed. Tim Lewis, reviewed by Josh Kupershmidt, with further hacking by me. Branch -- master Details --- http://g

[COMMITTERS] pgsql: Correct the lie in pg_config.h.win32 about having inttypes.h.

2011-08-08 Thread Andrew Dunstan
Correct the lie in pg_config.h.win32 about having inttypes.h. This lie has been harmless until now, but has been exposed by the change to include postgres.h before the python headers, which in some versions include inttypes.h if HAVE_INTTYPES_H is set. Branch -- master Details --- http:/