pgsql-committers@postgresql.org discussions

1	pgsql: Improve regression test for #8410.

Improve regression test for #8410. The previous version of the query disregarded the result of the MergeAppend instead of checking its results. Andres Freund Branch ------ REL9_3_STABLE Details ...

Tom Lane
Aug 31, 2013 at 1:41 am
Aug 31, 2013 at 1:41 am

1	pgsql: Add test case for bug #8410.

Add test case for bug #8410. Per Andres Freund. Branch ------ REL9_3_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/ce58aad2ba13885e2c5fa50e31ee5945e883096b Modified Files ...

Tom Lane
Aug 30, 2013 at 11:28 pm
Aug 30, 2013 at 11:28 pm

1	pgsql: Reset the binary heap in MergeAppend rescans.

Reset the binary heap in MergeAppend rescans. Failing to do so can cause queries to return wrong data, error out or crash. This requires adding a new binaryheap_reset() method to binaryheap.c, but ...

Tom Lane
Aug 30, 2013 at 11:16 pm
Aug 30, 2013 at 11:16 pm

1	pgsql: Make error wording more consistent

Make error wording more consistent Branch ------ REL9_3_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/dfed97b744a4706d7c7b410667c0c5bc92d0eb8d Modified Files -------------- ...

Alvaro Herrera
Aug 29, 2013 at 5:12 pm
Aug 29, 2013 at 5:12 pm

0	pgsql: Use a non-locking initial test in TAS_SPIN on x86_64.

Use a non-locking initial test in TAS_SPIN on x86_64. Testing done in 2011 by Tom Lane concluded that this is a win on Intel Xeons and AMD Opterons, but it was not changed back then, because of an ...

Heikki Linnakangas
Aug 29, 2013 at 11:06 am
Aug 29, 2013 at 11:06 am

0	pgsql: Allow discovery of whether a dynamic background worker is runnin

Allow discovery of whether a dynamic background worker is running. Using the infrastructure provided by this patch, it's possible either to wait for the startup of a dynamically-registered background ...

Robert Haas
Aug 28, 2013 at 6:14 pm
Aug 28, 2013 at 6:14 pm

0	pgsql: Partially restore comments discussing enum renumbering hazards.

Partially restore comments discussing enum renumbering hazards. As noted by Tom Lane, commit 813fb0315587d32e3b77af1051a0ef517d187763 was overly optimistic about how safe it is to concurrently change ...

Robert Haas
Aug 28, 2013 at 5:24 pm
Aug 28, 2013 at 5:24 pm

0	pgsql: Accept multiple -I, -P, -T and -n options in pg_restore.

Accept multiple -I, -P, -T and -n options in pg_restore. We already did this for -t (--table) in 9.3, but missed the other similar options. For consistency, allow all of them to be specified multiple ...

Heikki Linnakangas
Aug 28, 2013 at 7:00 am
Aug 28, 2013 at 7:00 am

0	pgsql: Initialize cached OID to Invalid in new hash entries

Initialize cached OID to Invalid in new hash entries Andres Freund; bug detected by valgrind Branch ------ master Details ------- ...

Alvaro Herrera
Aug 27, 2013 at 6:56 pm
Aug 27, 2013 at 6:56 pm

0	pgsql: Fix some "translator:" comments mangled by pgindent

Fix some "translator:" comments mangled by pgindent Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/673b527534893a4a8adb3cdef52fc645c13598ce Modified Files -------------- ...

Alvaro Herrera
Aug 27, 2013 at 5:34 pm
Aug 27, 2013 at 5:34 pm

0	pgsql: doc: Explain that ereport doesn't return for ERROR or higher lev

doc: Explain that ereport doesn't return for ERROR or higher levels. Christophe Pettus Branch ------ master Details ------- ...

Robert Haas
Aug 26, 2013 at 6:28 pm
Aug 26, 2013 at 6:28 pm

2	pgsql: Account better for planning cost when choosing whether to use cu

Account better for planning cost when choosing whether to use custom plans. The previous coding in plancache.c essentially used 10% of the estimated runtime as its cost estimate for planning. This ...

Tom Lane
Aug 24, 2013 at 7:14 pm
Aug 24, 2013 at 7:14 pm

2	pgsql: Don't crash when pg_xlog is empty and pg_basebackup -x is used

Don't crash when pg_xlog is empty and pg_basebackup -x is used The backup will not work (without a logarchive, and that's the whole point of -x) in this case, this patch just changes it to throw an ...

Magnus Hagander
Aug 24, 2013 at 3:16 pm
Aug 24, 2013 at 3:16 pm

0	pgsql: Tag refs/tags/REL9_3_RC1 was created

Tag refs/tags/REL9_3_RC1 was created.

Pgsql
Aug 24, 2013 at 1:17 am
Aug 24, 2013 at 1:17 am

5	pgsql: In locate_grouping_columns(), don't expect an exact match of Var

In locate_grouping_columns(), don't expect an exact match of Var typmods. It's possible that inlining of SQL functions (or perhaps other changes?) has exposed typmod information not known at parse ...

Tom Lane
Aug 23, 2013 at 9:31 pm
Aug 23, 2013 at 9:31 pm

2	pgsql: Disable -faggressive-loop-optimizations in gcc 4.8+ for pre-9.2

Disable -faggressive-loop-optimizations in gcc 4.8+ for pre-9.2 branches. With this optimization flag enabled, recent versions of gcc can generate incorrect code that assumes variable-length arrays ...

Tom Lane
Aug 21, 2013 at 10:32 pm
Aug 21, 2013 at 10:32 pm

1	pgsql: Fix hash table size estimation error in choose_hashed_distinct()

Fix hash table size estimation error in choose_hashed_distinct(). We should account for the per-group hashtable entry overhead when considering whether to use a hash aggregate to implement DISTINCT ...

Tom Lane
Aug 21, 2013 at 5:38 pm
Aug 21, 2013 at 5:39 pm

0	pgsql: docs: Remove second 'trim' index reference

docs: Remove second 'trim' index reference Per suggestion from Vik Fearing Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/5dcc48c2c76cf4b2b17c8e14fe3e588ae0c8eff3 ...

Bruce Momjian
Aug 21, 2013 at 11:33 am
Aug 21, 2013 at 11:33 am

3	pgsql: Unconditionally use the WSA equivalents of Socket error constant

Unconditionally use the WSA equivalents of Socket error constants. This change will only apply to mingw compilers, and has been found necessary by late versions of the mingw-w64 compiler. It's the ...

Andrew Dunstan
Aug 20, 2013 at 6:19 pm
Aug 26, 2013 at 6:59 pm

1	pgsql: release notes: update link to 9.3 PL/pgSQL constraint error info

release notes: update link to 9.3 PL/pgSQL constraint error info Backpatch to 9.3. Pavel Stehule Branch ------ REL9_3_STABLE Details ------- ...

Bruce Momjian
Aug 20, 2013 at 1:39 pm
Aug 20, 2013 at 1:39 pm

0	pgsql: Stamp 9.3rc1.

Stamp 9.3rc1. Branch ------ REL9_3_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/ce52c6fe243665e0f4d84414f9341b9719415551 Modified Files -------------- configure | 18 ...

Tom Lane
Aug 19, 2013 at 11:45 pm
Aug 19, 2013 at 11:45 pm

1	pgsql: Be more wary of unwanted whitespace in pgstat_reset_remove_files

Be more wary of unwanted whitespace in pgstat_reset_remove_files(). sscanf isn't the easiest thing to use for exact pattern checks ... also, don't use strncmp where strcmp will do. Branch ------ ...

Tom Lane
Aug 19, 2013 at 11:36 pm
Aug 19, 2013 at 11:36 pm

1	pgsql: Fix removal of files in pgstats directories

Fix removal of files in pgstats directories Instead of deleting all files in stats_temp_directory and the permanent directory on a crash, only remove those files that match the pattern of files we ...

Alvaro Herrera
Aug 19, 2013 at 9:56 pm
Aug 19, 2013 at 9:56 pm

1	pgsql: Rename the "fast_promote" file to just "promote".

Rename the "fast_promote" file to just "promote". This keeps the usual trigger file name unchanged from 9.2, avoiding nasty issues if you use a pre-9.3 pg_ctl binary with a 9.3 server or vice versa ...

Heikki Linnakangas
Aug 19, 2013 at 6:07 pm
Aug 19, 2013 at 6:07 pm

1	pgsql: Fix qual-clause-misplacement issues with pulled-up LATERAL subqu

Fix qual-clause-misplacement issues with pulled-up LATERAL subqueries. In an example such as SELECT * FROM i LEFT JOIN LATERAL (SELECT * FROM j WHERE i.n = j.n) j ON true; it is safe to pull up the ...

Tom Lane
Aug 19, 2013 at 5:20 pm
Aug 19, 2013 at 5:20 pm

1	pgsql: Fix pg_upgrade failure from servers older than 9.3

Fix pg_upgrade failure from servers older than 9.3 When upgrading from servers of versions 9.2 and older, and MultiXactIds have been used in the old server beyond the first page (that is, 2048 multis ...

Alvaro Herrera
Aug 19, 2013 at 4:57 pm
Aug 19, 2013 at 4:57 pm

1	pgsql: release notes: remove username from 9.3 major item

release notes: remove username from 9.3 major item Etsuro Fujita Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/1bc5935b67c77f27bf653089e757476cfb4245e1 Modified Files ...

Bruce Momjian
Aug 19, 2013 at 4:26 pm
Aug 19, 2013 at 4:26 pm

1	pgsql: Translation updates

Translation updates Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/a2f2e902b8e1b391c1f33ea7ac2b925355448ef3 Modified Files -------------- src/backend/po/de.po | 3313 ...

Peter Eisentraut
Aug 19, 2013 at 3:41 am
Aug 19, 2013 at 3:41 am

1	pgsql: Remove relcache entry invalidation in REFRESH MATERIALIZED VIEW.

Remove relcache entry invalidation in REFRESH MATERIALIZED VIEW. This was added as part of the attempt to support unlogged matviews along with a populated status. It got missed when unlogged support ...

Kevin Grittner
Aug 18, 2013 at 9:26 pm
Aug 18, 2013 at 9:26 pm

4	pgsql: libpq: Report strerror on pthread_mutex_lock() failure

libpq: Report strerror on pthread_mutex_lock() failure Branch ------ REL9_2_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/b94c6c691e86a1d9c2a98e935f661c95924d8f37 Modified Files ...

Peter Eisentraut
Aug 18, 2013 at 2:01 am
Aug 18, 2013 at 2:01 am

1	pgsql: Fix thinko in comment.

Fix thinko in comment. Branch ------ REL9_3_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/8820b502367de2669a8d3ed02a1cc485dd84fc4b Modified Files -------------- ...

Tom Lane
Aug 18, 2013 at 12:36 am
Aug 18, 2013 at 12:36 am

1	pgsql: Fix planner problems with LATERAL references in PlaceHolderVars.

Fix planner problems with LATERAL references in PlaceHolderVars. The planner largely failed to consider the possibility that a PlaceHolderVar's expression might contain a lateral reference to a Var ...

Tom Lane
Aug 18, 2013 at 12:22 am
Aug 18, 2013 at 12:23 am

1	pgsql: release notes: update 9.3 major feature list

release notes: update 9.3 major feature list Backpatch to 9.3. Branch ------ REL9_3_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/2505aaed7be290018f999f6e9250c24b26db97d0 Modified ...

Bruce Momjian
Aug 16, 2013 at 10:01 pm
Aug 16, 2013 at 10:01 pm

1	pgsql: release notes: Update to 9.3 git current

release notes: Update to 9.3 git current Backpatch to 9.3, of course. Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/e91f2bb3ee8bb1f4be5bbfe0e43815e47b49aa3f Modified ...

Bruce Momjian
Aug 16, 2013 at 8:55 pm
Aug 16, 2013 at 8:55 pm

0	pgsql: Move more bgworker code to bgworker.c; also, some renaming.

Move more bgworker code to bgworker.c; also, some renaming. Per discussion on pgsql-hackers. Michael Paquier, slightly modified by me. Original suggestion from Amit Kapila. Branch ------ master ...

Robert Haas
Aug 16, 2013 at 7:32 pm
Aug 16, 2013 at 7:32 pm

0	pgsql: Rename some bgworker functions as we've done in master.

Rename some bgworker functions as we've done in master. Commit 2dee7998f93062e2ae7fcc9048ff170e528d1724 renames these functions in master, for consistency; per discussion, backport just the renaming ...

Robert Haas
Aug 16, 2013 at 7:32 pm
Aug 16, 2013 at 7:32 pm

2	pgsql: pg_upgrade: shut down server after auth failure

pg_upgrade: shut down server after auth failure Register atexit() server shutdown if pg_ctl successfully started the server, but we can't connect to it. Backpatch to 9.3. Pavel Raiskup Branch ------ ...

Bruce Momjian
Aug 16, 2013 at 3:09 pm
Aug 16, 2013 at 3:40 pm

1	pgsql: Don't allow ALTER MATERIALIZED VIEW ADD UNIQUE.

Don't allow ALTER MATERIALIZED VIEW ADD UNIQUE. Was accidentally allowed, but not documented and lacked support for rename or drop once created. Per report from Noah Misch. Branch ------ master ...

Kevin Grittner
Aug 15, 2013 at 6:19 pm
Aug 15, 2013 at 6:19 pm

1	pgsql: Add tab completion for \dx in psql

Add tab completion for \dx in psql Branch ------ REL9_3_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/d2fa20acdd67db00b48fcc4b9a13b998c1c8bb54 Modified Files -------------- ...

Magnus Hagander
Aug 15, 2013 at 4:45 pm
Aug 15, 2013 at 4:45 pm

1	pgsql: Improve error message when view is not updatable

Improve error message when view is not updatable Avoid using the term "updatable" in confusing ways. Suggest a trigger first, before a rule. Branch ------ master Details ------- ...

Peter Eisentraut
Aug 15, 2013 at 3:29 am
Aug 15, 2013 at 3:29 am

1	pgsql: Treat timeline IDs as unsigned in replication parser

Treat timeline IDs as unsigned in replication parser Timeline IDs are unsigned ints everywhere, except the replication parser treated them as signed ints. Branch ------ REL9_3_STABLE Details ------- ...

Peter Eisentraut
Aug 15, 2013 at 3:29 am
Aug 15, 2013 at 3:29 am

1	pgsql: Remove ph_may_need from PlaceHolderInfo, with attendant simplifi

Remove ph_may_need from PlaceHolderInfo, with attendant simplifications. The planner logic that attempted to make a preliminary estimate of the ph_needed levels for PlaceHolderVars seems to be ...

Tom Lane
Aug 14, 2013 at 10:39 pm
Aug 14, 2013 at 10:39 pm

0	pgsql: docs: document TRIM "comma" syntax

docs: document TRIM "comma" syntax This syntax is supported by the parser, but is non-standard. _Not_ backpatched to 9.3 in case we change our minds. Branch ------ master Details ------- ...

Bruce Momjian
Aug 14, 2013 at 9:26 pm
Aug 14, 2013 at 9:26 pm

1	pgsql: Remove Assert that matview is not in system schema from REFRESH.

Remove Assert that matview is not in system schema from REFRESH. We don't want to prevent an extension which creates a matview from being installed in pg_catalog. Issue was raised by Hitoshi Harada ...

Kevin Grittner
Aug 14, 2013 at 5:45 pm
Aug 14, 2013 at 5:45 pm

0	pgsql: Update Emacs configuration

Update Emacs configuration Update emacs.samples with new configuration snippets that match pgindent et al. formatting more accurately and follow Emacs Lisp best practices better. Add .dir-locals.el ...

Peter Eisentraut
Aug 14, 2013 at 12:20 am
Aug 14, 2013 at 12:20 am

1	pgsql: Emit a log message if output is about to be redirected away from

Emit a log message if output is about to be redirected away from stderr. We've seen multiple cases of people looking at the postmaster's original stderr output to try to diagnose problems, not ...

Tom Lane
Aug 13, 2013 at 7:25 pm
Aug 13, 2013 at 7:25 pm

1	pgsql: 9.3 release notes: move foreign table item

9.3 release notes: move foreign table item Move item about foreign data wrappers supporting inserts/updates/deletes to object manipulation. From Etsuro Fujita Branch ------ master Details ------- ...

Bruce Momjian
Aug 13, 2013 at 4:49 pm
Aug 13, 2013 at 4:51 pm

0	pgsql: pg_dump: avoid schema qualification for ALTER ... OWNER

pg_dump: avoid schema qualification for ALTER ... OWNER We already use search_path to specify the schema, so there is no need for pg_dump to schema-qualify the name. Also remove dead code. Branch ...

Bruce Momjian
Aug 13, 2013 at 3:46 pm
Aug 13, 2013 at 3:46 pm

0	My commit messages and blank lines

Unfortunately, since May, my commit script has been removing blank lines from my commit messages. I have now fixed this. Sorry. Fortunately I have had only 34 commits since then. -- Bruce Momjian ...

Bruce Momjian
Aug 13, 2013 at 3:12 pm
Aug 13, 2013 at 3:12 pm

1	pgsql: PL/Python: Adjust the regression tests for Python 3.3

PL/Python: Adjust the regression tests for Python 3.3 Similar to 2cfb1c6f77734db81b6e74bcae630f93b94f69be, the order in which dictionary elements are printed is not reliable. This reappeared in the ...

Peter Eisentraut
Aug 11, 2013 at 1:24 pm
Aug 11, 2013 at 1:24 pm

group	pgsql-committers @
categories	postgresql
discussions	37,212
posts	52,654
users	448
website	postgresql.org...
irc	#postgresql

summaries	on	Hotkey: s
users list	on	Hotkey: d
user style	avatars	Hotkey: a

PostgreSQL > pgsql-committers

Search Discussions

37,212 discussions - 52,654 posts

Top users

Content

People

Support

Translate