Re: [GENERAL] 10 beta 4 foreign table partition check constraint broken?

On Thu, Sep 21, 2017 at 02:59:21PM +0900, Michael Paquier wrote: /tmp/mutt-mayon-1000-26043-945be079d938129298 > On Fri, Sep 15, 2017 at 10:43 PM, Paul Jones <p...@cmicdo.com> wrote: > > Is this a bug in Postgres 10b4? Looks like neither partition ranges > > nor check co

[GENERAL] 10 beta 4 foreign table partition check constraint broken?

Is this a bug in Postgres 10b4? Looks like neither partition ranges nor check constraints are honored in 10b4 when inserting into partitions that are foreign tables. Here is a nearly shovel-ready example. Just replace with your servers/passwords. -- -- -- Server 1 --

[GENERAL] Redacting JSONB

Is there some way to redact JSONB fields? This is essentially implementing "row-level" security on JSONB fields. Could possibly be done with a view or a function. MongoDB and MarkLogic both do this. PJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Question about jsonb and data structures

On Wed, Jun 21, 2017 at 09:37:20AM -0700, Emilie Laffray wrote: > Date: Wed, 21 Jun 2017 09:37:20 -0700 > From: Emilie Laffray > To: Achilleas Mantzios > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Question about jsonb and

[GENERAL] Upgrade method from 9.2 to 10 ?

Would it be possible to upgrade from 9.2 to 10 by doing a pg_basebackup to the new server, followed by pg_upgrade -k, then streaming replication from the 9.2 server to the 10 server until we're ready to cut over to 10? The idea is to minimize downtime. PJ -- Sent via pgsql-general mailing

[GENERAL] Stats update difference between VACUUM ANALYZE and ANALYZE in 9.2?

tomatic analyze for that table. If that table is rarely inserted into or updated, the inheritance statistics will not be up to date unless you run ANALYZE manually." Can anyone explain what's going on here? Thanks, Paul Jones -- Sent via pgsql-general mailing list (pgsql-ge

[GENERAL] Question about shared_buffer cache behavior

In Postgres 9.5.1 with a shared_buffer cache of 7Gb, a SELECT from a single table that uses an index appears to read the table into the shared_buffer cache. Then, as many times as the exact same SELECT is repeated in the same session, it runs blazingly fast and doesn't even touch the disk. All

[GENERAL] MongoDB 3.2 beating Postgres 9.5.1?

I have been running the EDB benchmark that compares Postgres and MongoDB. I believe EDB ran it against PG 9.4 and Mongo 2.6. I am running it against PG 9.5.1 and Mongo 3.2 with WiredTiger storage using 10,000,000 JSON records generated by the benchmark. It looks like Mongo is winning, and

[GENERAL] Anyone compare PG 9.5 and MongoDB 3.2?

MongoDB has released 3.2 with their WiredTiger storage. Has anyone benchmarked 9.5 against it, and for JSONB elements several MB in size? PJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] 9.4 -> 9.5 upgrade problem when both python2 and python3 present

On Mon, Jan 11, 2016 at 06:23:06PM -0500, Tom Lane wrote: > Date: Mon, 11 Jan 2016 18:23:06 -0500 > From: Tom Lane <t...@sss.pgh.pa.us> > To: Paul Jones <p...@cmicdo.com> > cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] 9.4 -> 9.5 upgrade problem when both

Re: [GENERAL] 9.4 -> 9.5 upgrade problem when both python2 and python3 present

On Mon, Jan 11, 2016 at 10:04:16AM -0500, Tom Lane wrote: /tmp/mutt-mayon-1000-19386-284b6a00794950f414 > Paul Jones <p...@cmicdo.com> writes: > > pg_upgrade complains about not being able to find $libdir/plpython3 > > when upgrading a 9.4 cluster that has both pyt

[GENERAL] 9.4 -> 9.5 upgrade problem when both python2 and python3 present

pg_upgrade complains about not being able to find $libdir/plpython3 when upgrading a 9.4 cluster that has both python2 and python3 used. Both the 9.4 and 9.5 PGs have been built from source with python2/3 in the recommended way and the plpython3.so is present in /usr/local/pgsql/lib. I dropped

[GENERAL] ERROR: could not read block 3 in file "base/12511/12270"

I have been having disk errors that have corrupted something in my postgres database. Other databases work ok: Running on Ubuntu 10.04. paul@kitanglad:~$ psql -U postgres psql (9.4.5) Type "help" for help. postgres=# SELECT pg_catalog.pg_is_in_recovery(); ERROR: could not read block 3 in file

Re: [GENERAL] Code for user-defined type

On Wed, May 28, 2014 at 10:51:43AM +0200, Pavel Stehule wrote: Hello 2014-05-27 20:30 GMT+02:00 Paul Jones p...@cmicdo.com: I have written a user-defined type that allows direct import and printing of DB2 timestamps.It does correctly import and export DB2 timestamps, butI'm

Re: [GENERAL] Code for user-defined type

- Original Message - From: Tom Lane t...@sss.pgh.pa.us To: Paul Jones p...@cmicdo.com Cc: pavel.steh...@gmail.com pavel.steh...@gmail.com; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Thursday, May 29, 2014 11:32 AM Subject: Re: [GENERAL] Code for user-defined

[GENERAL] Code for user-defined type

I have written a user-defined type that allows direct import and printing of DB2 timestamps.It does correctly import and export DB2 timestamps, butI'm wondering ifsomeone could tell me if I made anymistakes in the C code, particularly w.r.t. memory leaks or non-portableconstructs.  I'm doing

[GENERAL] User defined operator fails to work in EXCLUDE constraint

    OPERATOR 15 === (circle, circle); CREATE TABLE punky (     acirc   CIRCLE,     EXCLUDE USING GIST (acirc circle_ops WITH ===) );  INSERT INTO punky VALUES ('(0,0),3)'); INSERT INTO punky VALUES ('(7,0),3)'); Paul Jones -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] User defined operator fails to work in EXCLUDE constraint

- Original Message - From: Tom Lane t...@sss.pgh.pa.us To: Paul Jones p...@cmicdo.com Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Sunday, April 13, 2014 4:25 PM Subject: Re: [GENERAL] User defined operator fails to work in EXCLUDE constraint Paul Jones

[GENERAL] Debugging extension with gdb?

Can someone point me to information on how to debug a Postgres extension with gdb? I have been able to attach to one but getting breakpoints to work right and getting the addresses to properly relocate (since the extension could be loaded anywhere) has been the problem for me. I have not found

Re: [GENERAL] Debugging extension with gdb?

From: Tom Lane t...@sss.pgh.pa.us To: Paul Jones p...@cmicdo.com Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Wednesday, November 20, 2013 9:13 AM Subject: Re: [GENERAL] Debugging extension with gdb? Paul Jones p...@cmicdo.com writes

Re: [GENERAL] Can LC_TIME affect timestamp input?

- Original Message - From: Jasen Betts ja...@xnet.co.nz To: pgsql-general@postgresql.org Cc: Sent: Saturday, January 26, 2013 9:00 PM Subject: Re: [GENERAL] Can LC_TIME affect timestamp input? On 2013-01-25, Paul Jones p...@cmicdo.com wrote: Is it possible for LC_TIME locale

[GENERAL] Can LC_TIME affect timestamp input?

affect anything, in or out with Postgres.  I know the locale works because date(1) displays the DB2 format correctly. Postgres version:   9.2.2 (Built from source) OS: Centos 6.3 Paul Jones -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Fine-grained replication?

. XReader certainly shows a lot of promise, but it's not quite here yet. Specific answers to respondents below... From: Sergey Konoplev sergey.konop...@postgresql-consulting.com Date: Tue, 19 Jun 2012 13:00:49 +0400 On Tue, Jun 19, 2012 at 1:49 AM, Paul Jones p...@cmicdo.com wrote: Is anyone

[GENERAL] Fine-grained replication?

Is anyone aware of other non-trigger-based, fine-grained replication tools for PostgreSQL along the lines of the XReader http://wiki.postgresql.org/wiki/XReader or pgreplay http://pgreplay.projects.postgresql.org/? Thanks, Paul Jones -- Sent via pgsql-general mailing list (pgsql-general