[GENERAL] Constraint exclusion not working - need different constraints?

ed, since the planner cannot know which partition the function     value might fall into at run time."     Will I likely need to replace the date_part functions with actual dates to make this work? Thanks, -- Doug Gorley | d...@gorley.ca -- Sent via pgsql-general mailing list (pgsql-general@p

Re: [GENERAL] Constraint exclusion not working - need different constraints?

On Wed, 27 May 2015 18:21:58 -0400, Tom Lane wrote: "=?utf-8?b?RG91ZyBHb3JsZXk=?=" writes: I'm attempting to implement table partitioning with constraint exclusions, but I'm not seeing the planner limit the plan to an appropriate set of child tables.  I'm wondering if the functions in my

[GENERAL] How to monitor recovery on Windows?

7;ve never done a recovery from WAL files before, but it sounds simple enough. One thing I'm unsure of though: how can I monitor the progress of the recovery? Will the WAL files themselves change or disappear? Will progress reports end up in the PostgreSQL logs? Something else entirely? T

[GENERAL] Generating GRANT/REVOKE on functions from catalog

this? Thanks, -- -------- *Doug Gorley* | doug.gor...@gmail.com <mailto:doug.gor...@gmail.com> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Generating GRANT/REVOKE on functions from catalog

That looks like exactly what I want. Is there an easy way to cast that to a string so that I can concatenate it into a GRANT statement? *Doug Gorley* | doug.gor...@gmail.com <mailto:doug.gor...@gmail.com> Tom Lane

Re: [GENERAL] Generating GRANT/REVOKE on functions from catalog

c inner join pg_namespace on pg_proc.pronamespace = pg_namespace.oid Thanks very much! -------- *Doug Gorley* | doug.gor...@gmail.com <mailto:doug.gor...@gmail.com> Tom Lane wrote: Doug Gorley writes: That looks lik

[GENERAL] Any justification for sequence table vs. native sequences?

multiuser updates for two.) Can anyone comment on this? Has anyone ever had to apply a pattern like this when native sequences weren't sufficient? If so, what was the justification? Thanks, -- ---- *Doug Gorley* | doug.gor

[GENERAL] Regexp confusion

pattern '\.\d+' occurs once. So why does (4) return false? between (3), (4), and (5), it appears as though the group is matching multiple times. Thanks, -- *Doug Gorley* | doug.gor...@gmail.com <mai

[GENERAL] Different sort order btwn Linux and Windows

I'm running the following SQL commands on a new PostgreSQL 9.0 database, one on Linux, one on Windows. create table i (j varchar(4)); insert into i (j) values ('A'), ('E'), ('

Re: [GENERAL] Different sort order btwn Linux and Windows

That does indeed appear to be the case -- the database on the Linux server has en_CA.UTF-8 collation, while the database on the Windows server has English_Canada.1252 collation. Thanks! Doug On Wed, Apr 27, 2011 at 1:04 PM, Thom Brown wrote: > On 27 April 2011 20:28, Doug Gorley wr

[GENERAL] Zero-length character breaking query?

l ~ '^SMITH'" returns "5". So, it's as if there is a zero-length character at the end of the value that is preventing a match. Is this possible? If so, how could this data have been created? Thanks, Doug Gorley dgor...@aihs.ca -- Sent via pgsql-general ma

Re: [GENERAL] Zero-length character breaking query?

Thanks Tom; this is at a client site, so I have limited access, but it looks like a REINDEX resolves the issue. Doug -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: March 16, 2012 6:33 AM To: Doug Gorley Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Zero