Re: [HACKERS] Declarative partitioning

f.com/2010/09/25/exclusion-constraints-are-general ized-sql-unique/ If partitioning could be based on EC, it would bring these additional benefits: - The choice of operator as long as it is boolean. commutative and Indexable - The use of Expression/Function and not just bare columns Jean-Pierre

Re: [HACKERS] Declarative partitioning

f.com/2010/09/25/exclusion-constraints-are-general ized-sql-unique/ If partitioning could be based on EC, it would bring these additional benefits: - The choice of operator as long as it is boolean. commutative and Indexable - The use of Expression/Function and not just bare columns Jean-Pierre

Re: [HACKERS] ALTER TABLE INHERIT vs collations

One use case for this might be with constraint exclusion where there would be one partition per collation (language) with queries against the parent table always being for exactly one language. Not sure what the collation should be in the parent table then. -- Sent via pgsql-hackers mailing lis

[HACKERS] Number of parentheses in check constraints affected by operator_precedence_warning

((new.col1 IS DISTINCT FROM old.col1) OR (new.col2 IS DISTINCT FROM old.col2)) OR ((new.col3 IS NOT NULL) AND (new.col3 IS DISTINCT FROM old.col3))) OR ((new.col3 IS NULL) AND (new.col3 IS DISTINCT FROM old.col3 EXECUTE PROCEDURE f1(); We got these results on Windows x64. Thanks, Jean-Pierre

[HACKERS] Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?

;) @@ to_tsvector('simple', 'blue'); Is this expected ? Thanks, Jean-Pierre Pelletier -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?

'rat cat bat fat') @@ to_tsquery('simple', 'cat <-> rat'); returns "false" select to_tsvector('simple', 'cat rat bat fat') @@ to_tsquery('simple', 'cat <-> rat'); returns "true" Jean-Pierre Pelletier

[HACKERS] The link to download PostgreSQL 9.6 Beta 2 for Windows X64 is broken (The link downloads Beta 1)

The link to download PostgreSQL 9.6 Beta 2 for Windows X64 is not working. The link does download something, but it's Beta 1. http://www.enterprisedb.com/products-services-training/pgdownload#windows Thanks, Jean-Pierre Pelletier

[HACKERS] pg_restore & search_path, COPY failed for table "mytable": ERROR: function myinnerfunction(integer) does not exist

or constraints ? That's with version 9.5.3 & 9.6 beta 3. Thanks, Jean-Pierre Pelletier -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] temporal variants of generate_series()

UNCTION generate_series ( start_ts date, end_ts date, step interval ) RETURNS SETOF date STRICT LANGUAGE sql AS $$ SELECT ('epoch'::date + s.i * '1 second'::interval)::date AS "generate_series" FROM generate_series( extract('epoch' FROM $1)::

Re: [HACKERS] temporal variants of generate_series()

UNCTION generate_series ( start_ts date, end_ts date, step interval ) RETURNS SETOF date STRICT LANGUAGE sql AS $$ SELECT ('epoch'::date + s.i * '1 second'::interval)::date AS "generate_series" FROM generate_series( extract('epoch' FROM $1)::

Re: [HACKERS] [JDBC] server process (PID 1188) exited with exit code

ate(08006) From: Oliver Jowett <[EMAIL PROTECTED]> To: Tom Lane <[EMAIL PROTECTED]> CC: Dave Cramer <[EMAIL PROTECTED]>, JEAN-PIERRE PELLETIER <[EMAIL PROTECTED]>, List , PostgreSQL-development Subject: Re: [HACKERS] [JDBC] server process (PID 1188) exited with

Re: [HACKERS] [JDBC] server process (PID 1188) exited with exit code

Yes, the problem is gone in 8.2 beta2. Thanks all for an outstanding product and support, Jean-Pierre Pelletier From: Tom Lane <[EMAIL PROTECTED]> To: "JEAN-PIERRE PELLETIER" <[EMAIL PROTECTED]> CC: pgsql-hackers@postgresql.org, [EMAIL PROTECTED], [EMAIL PROTECTED]

[HACKERS] Index ignored with "is not distinct from", 8.2 beta2

ctual time=0.237..0.241 rows=1 loops=1) Index Cond: (col = 123) Total runtime: 0.366 ms (4 rows) Time: 0.000 ms I am on Windows XP Service pack 2 with PostgreSQL 8.2 beta2 Thanks, Jean-Pierre Pelletier e-djuster ---(end of broadcast)--- TIP

Re: [HACKERS] Index ignored with "is not distinct from", 8.2 beta2

. I'll wait before using IS NOT DISTINCT FROM and stick with the equivalent longer forms which use indexes. 8.2 is better than 8.1 which was not picking up indexes even with the longer forms. Jean-Pierre Pelletier From: "Jim C. Nasby" <[EMAIL PROTECTED]> To: JEAN-PIERR

Re: [HACKERS] Index ignored with "is not distinct from", 8.2 beta2

istinct from 123" and the equivalent longer form has no problem picking up the index I could restate the problem as: Why can't the planner handle "col is not distinct from 123" as well as "col is not null and 123 is not null and col = 123 or col is null and 123 is null" Jean

[HACKERS] log_min_error_statement and parameters value

ly interested in the statements displayed with log_min_error_statement. Is it possible to set log_min_error_statement to display the parameters value? Thanks, Jean-Pierre Pelletier e-djuster ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster