Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Today's Activity

Use the typcache to cache constraints for domain types
Tom Lane: Previously, we cached domain constraints for the life of a query, or really for the life of the FmgrInfo struct that was used to invoke domain_in() or domain_check().

Other Activity This Week

Add note about how to make the SRF detoasted arguments live accross calls
Fujii Masao

Add hasRowSecurity to copyfuncs/outfuncs
Stephen Frost: The RLS patch added a hasRowSecurity field to PlannerGlobal and PlannedStmt but didn't update nodes/copyfuncs.c and nodes/outfuncs.c to reflect those additional fields.

Add locking clause for SB views for update/delete
Stephen Frost: In expand_security_qual(), we were handling locking correctly when a PlanRowMark existed, but not when we were working with the target relation (which doesn't have any PlanRowMarks, but the subquery created for the security barrier quals still needs to lock the rows under it). Noted by Etsuro Fujita when working with the Postgres FDW, which wasn't properly issuing a SELECT ...

Improve parser's one-extra-token lookahead mechanism
Tom Lane: There are a couple of places in our grammar that fail to be strict LALR(1), by requiring more than a single token of lookahead to decide what to do.

Support more commands in event triggers
Alvaro Herrera: COMMENT, SECURITY LABEL, and GRANT/REVOKE now also fire ddl_command_start and ddl_command_end event triggers, when they operate on database-local objects.

Refactor unit conversions code in guc.c
Heikki Linnakangas: Replace the if-switch-case constructs with two conversion tables, containing all the supported conversions between human-readable unit strings and the base units used in GUC variables.

Add GUC to control the time to wait before retrieving WAL after failed attempt
Fujii Masao: Previously when the standby server failed to retrieve WAL files from any sources (i.e., streaming replication, local pg_xlog directory or WAL archive), it always waited for five seconds (hard-coded) before the next attempt.

Most Popular In The Past Month

to_char(): prevent accesses beyond the allocated buffer
Bruce Momjian: Previously very long field masks for floats could access memory beyond the existing buffer allocated to hold the result.

Be more careful to not lose sync in the FE/BE protocol
Heikki Linnakangas: If any error occurred while we were in the middle of reading a protocol message from the client, we could lose sync, and incorrectly try to interpret a part of another message as a new protocol message.

Add new function BackgroundWorkerInitializeConnectionByOid
Robert Haas: Sometimes it's useful for a background worker to be able to initialize its database connection by OID rather than by name, so provide a way to do that.

Simplify the way OpenSSL renegotiation is initiated in server
Heikki Linnakangas: At least in all modern versions of OpenSSL, it is enough to call SSL_renegotiate() once, and then forget about it.

Introduce and use infrastructure for interrupt processing during client reads
Andres Freund: Up to now large swathes of backend code ran inside signal handlers while reading commands from the client, to allow for speedy reaction to asynchronous events.

Avoid returning undefined bytes in chkpass_in().
Tom Lane: We can't really fix the problem that the result is defined to depend on random(), so it is still going to fail the "unstable input conversion" test in parse_type.c.

Support more commands in event triggers
Alvaro Herrera: COMMENT, SECURITY LABEL, and GRANT/REVOKE now also fire ddl_command_start and ddl_command_end event triggers, when they operate on database-local objects.

Add GUC to control the time to wait before retrieving WAL after failed attempt
Fujii Masao: Previously when the standby server failed to retrieve WAL files from any sources (i.e., streaming replication, local pg_xlog directory or WAL archive), it always waited for five seconds (hard-coded) before the next attempt.

Refactor unit conversions code in guc.c
Heikki Linnakangas: Replace the if-switch-case constructs with two conversion tables, containing all the supported conversions between human-readable unit strings and the base units used in GUC variables.

Add note about how to make the SRF detoasted arguments live accross calls
Fujii Masao

Legal Disclaimer & Disclosure | Contact Us
Copyright © 2010 - 2015 by Phoronix Media. All rights reserved.
All trademarks and copyrights used are properties of their respective owners.
Powered by the Phoronix Content Management System (PHXCMS-8).