Search Results for: waiting for 9.3

Waiting for 9.3 – Support indexing of regular-expression searches in contrib/pg_trgm.

On 9th of April, Tom Lane committed patch: Support indexing of regular-expression searches in contrib/pg_trgm.   This works by extracting trigrams from the given regular expression, in generally the same spirit as the previously-existing support for LIKE searches, though of course the details are far more complicated.   Currently, only GIN indexes are supported. We … Continue reading “Waiting for 9.3 – Support indexing of regular-expression searches in contrib/pg_trgm.”

Waiting for 9.3 – Add new JSON processing functions and parser API.

On 29th of March, Andrew Dunstan committed patch: Add new JSON processing functions and parser API.   The JSON parser is converted into a recursive descent parser, and exposed for use by other modules such as extensions. The API provides hooks for all the significant parser event such as the beginning and end of objects … Continue reading “Waiting for 9.3 – Add new JSON processing functions and parser API.”

Waiting for 9.3 – Add parallel pg_dump option.

On 24th of March, Andrew Dunstan committed patch: Add parallel pg_dump option.   New infrastructure is added which creates a set number of workers (threads on Windows, forked processes on Unix). Jobs are then handed out to these workers by the master process as needed. pg_restore is adjusted to use this new infrastructure in place … Continue reading “Waiting for 9.3 – Add parallel pg_dump option.”

Waiting for 9.3 – Support writable foreign tables.

On 10th of March, Tom Lane committed patch: Support writable foreign tables.   This patch adds the core-system infrastructure needed to support updates on foreign tables, and extends contrib/postgres_fdw to allow updates against remote Postgres servers. There’s still a great deal of room for improvement in optimization of remote updates, but at least there’s basic … Continue reading “Waiting for 9.3 – Support writable foreign tables.”

Waiting for 9.3 – Report pg_hba line number and contents when users fail to log in

On 10th of March, Magnus Hagander committed patch: Report pg_hba line number and contents when users fail to log in   Instead of just reporting which user failed to log in, log both the line number in the active pg_hba.conf file (which may not match reality in case the file has been edited and not … Continue reading “Waiting for 9.3 – Report pg_hba line number and contents when users fail to log in”

Waiting for 9.3 – JSON generation improvements.

On 10th of March, Andrew Dunstan committed patch: JSON generation improvements.   This adds the following:   json_agg(anyrecord) -> json to_json(any) -> json hstore_to_json(hstore) -> json (also used as a cast) hstore_to_json_loose(hstore) -> json   The last provides heuristic treatment of numbers and booleans.   Also, in json generation, if any non-builtin type has a … Continue reading “Waiting for 9.3 – JSON generation improvements.”

Waiting for 9.3 – Provide database object names as separate fields in error messages.

Yet another missed thing for “Waiting for 9.3″. Sorry about that. On 29th of January, Tom Lane committed patch: Provide database object names as separate fields in error messages.   This patch addresses the problem that applications currently have to extract object names from possibly-localized textual error messages, if they want to know for example … Continue reading “Waiting for 9.3 – Provide database object names as separate fields in error messages.”

Waiting for 9.3 – Add a materialized view relations.

On 4th of March, Kevin Grittner committed patch: Add a materialized view relations.   A materialized view has a rule just like a view and a heap and other physical properties like a table. The rule is only used to populate the table, references in queries refer to the materialized data.   This is a … Continue reading “Waiting for 9.3 – Add a materialized view relations.”