Re: [HACKERS] GSoC 2017: Foreign Key Arrays

2017-07-08 Thread Alexander Korotkov
On Sun, Jul 9, 2017 at 2:35 AM, Mark Rofail wrote: > * What I am working on* > >- since we want to create an index on the referencing column, I am >working on firing a 'CREATE INDEX' query programatically right after >the 'CREATE TABLE' query >- The

Re: [HACKERS] COPY vs. transition tables

2017-07-08 Thread David Fetter
On Sun, Jul 09, 2017 at 11:46:03AM +1200, Thomas Munro wrote: > On Sat, Jul 8, 2017 at 8:42 PM, David Fetter wrote: > > Using the script attached, I'm getting this very odd result set below. > > > > Audit records from COPY to the "foo bar" table aren't getting > > recorded, but

Re: [HACKERS] COPY vs. transition tables

2017-07-08 Thread Thomas Munro
On Sat, Jul 8, 2017 at 8:42 PM, David Fetter wrote: > Using the script attached, I'm getting this very odd result set below. > > Audit records from COPY to the "foo bar" table aren't getting > recorded, but audit records from COPY to the baz table are. Thanks for the bug

Re: [HACKERS] GSoC 2017: Foreign Key Arrays

2017-07-08 Thread Mark Rofail
* What I am working on* - since we want to create an index on the referencing column, I am working on firing a 'CREATE INDEX' query programatically right after the 'CREATE TABLE' query - The problem I ran into is how to specify my Strategy ( GinContainsElemStrategy) within the

Re: [HACKERS] pg_receivewal and messages printed in non-verbose mode

2017-07-08 Thread Magnus Hagander
On Wednesday, June 14, 2017, Michael Paquier wrote: > On Tue, Jun 13, 2017 at 4:50 PM, Craig Ringer > wrote: > > On 13 June 2017 at 14:33, Michael Paquier > wrote: > >> Those come from

[HACKERS] PDF content lemma subdivision

2017-07-08 Thread Erik Rijkers
The PDF-version of the documentation has content-'frame' displayed on the left-hand side (I'm viewing with okular; I assmume it will be similar in most viewers). That content displays a treeview down to the main entries/lemmata, like 'CREATE TABLE'. It doesn't go any deeper anymore. There

Re: [HACKERS] hash index on unlogged tables doesn't behave as expected

2017-07-08 Thread Amit Kapila
On Sat, Jul 8, 2017 at 9:06 AM, Amit Kapila wrote: > On Sat, Jul 8, 2017 at 8:52 AM, Robert Haas wrote: >> On Thu, Jul 6, 2017 at 5:54 AM, Kyotaro HORIGUCHI >> wrote: >>> Check for INIT_FORKNUM appears both

Re: [HACKERS] SCRAM auth and Pgpool-II

2017-07-08 Thread Tatsuo Ishii
Hi Alvaro, > Hi Tatsuo. > > There's definitely an important concern here that should be addressed: > how poolers/proxies/middleware/etc can deal with SCRAM, specifically > in the context of channel binding. > > If there is to be a single connection from client to PostgreSQL

[HACKERS] COPY vs. transition tables

2017-07-08 Thread David Fetter
Folks, Using the script attached, I'm getting this very odd result set below. Audit records from COPY to the "foo bar" table aren't getting recorded, but audit records from COPY to the baz table are. Best, David. \i copy_oddity.sql CREATE TABLE COMMENT CREATE FUNCTION CREATE FUNCTION CREATE