Search results

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 ...

On 4th of April, Tom Lane committed patch: Add \watch [SEC] command to psql. This allows convenient re-execution of commands. Will Leinweber, reviewed by Peter Eisentraut, Daniel Farina, and Tom Lane

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 ...

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 ...

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 ...

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 ...

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) ...

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 ...

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 ...

On 1st of February, Peter Eisentraut committed patch: Add CREATE RECURSIVE VIEW syntax This is specified in the SQL standard. The CREATE RECURSIVE VIEW specification is transformed into a normal CREATE VIEW statement with a WITH RECURSIVE clause. reviewed by Abhijit Menon-Sen and Stephen ...