Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On Monday, December 14, 2015, Jack Christensen wrote: > On 12/14/2015 11:55 AM, Benjamin Smith wrote: > >> Is there a way to set PG field-level read permissions so that a deny >> doesn't >> cause the query to bomb, but the fields for which permission is denied to >> be

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On Mon, 2015-12-14 at 09:55 -0800, Benjamin Smith wrote: > Is there a way to set PG field-level read permissions so that a deny > doesn't > cause the query to bomb, but the fields for which permission is > denied to be > nullified? > > In our web-based app, we have a request to implement

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On Monday, December 14, 2015 05:25:16 PM Adrian Klaver wrote: > > FOLLOWUP QUESTION: is there a way to ask the query planner what > > tables/fields were output in a database result? > > Just dawned on me, are you asking if EXPLAIN can output more detailed > information? Ha ha, in another post,

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

On 12/9/15 7:05 PM, Andreas Kretschmer wrote: I'm really newbie to PostgreSQL but the boss pushed me to handle it >and implement it in production f*&%*$%%$#%$#

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On 12/14/2015 04:22 PM, Benjamin Smith wrote: On Monday, December 14, 2015 01:02:00 PM you wrote: On 12/14/2015 09:55 AM, Benjamin Smith wrote: Is there a way to set PG field-level read permissions so that a deny doesn't cause the query to bomb, but the fields for which permission is denied to

Re: [GENERAL] Deletion Challenge

On Saturday, December 05, 2015 11:08:05 AM Berend Tober wrote: > WITH max_click AS ( >SELECT > cash_journal.fairian_id, > max(cash_journal.click) AS click > FROM cash_journal > GROUP BY cash_journal.fairian_id > ) >delete from cash_journal j > using max_click

Re: [GENERAL] Deletion Challenge

> test=> delete from cash_journal where ARRAY[click, cash_journal_id] NOT in > (select max(ARRAY[click,cash_journal_id]) from cash_journal group by > fairian_id); DELETE 7 For what it's worth, we've run into *severe* performance issues using in() if there are a large number of values in

Re: [GENERAL] Feature Request: Faceting for full text search

On 12/9/2015 9:30 AM, Mirek Svoboda wrote: Is it OK if I add feature request "faceting for FTS" to roadmap? I hope you can define precisely what you mean by this in concrete terms, as I look at it and scratch my head. -- john r pierce, recycling bits in santa cruz -- Sent via

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On 12/14/2015 11:55 AM, Benjamin Smith wrote: Is there a way to set PG field-level read permissions so that a deny doesn't cause the query to bomb, but the fields for which permission is denied to be nullified? In our web-based app, we have a request to implement granular permissions:

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On Monday, December 14, 2015 05:20:52 PM Adrian Klaver wrote: > > FOLLOWUP QUESTION: is there a way to ask the query planner what > > tables/fields were output in a database result? > > I am not following, that would be in the query output would it not? A > more detailed explanation of what you

Re: [GENERAL] Overhead changing varchar(2000) to text

On 12/9/15 5:43 PM, Edson Richter wrote: Actually, the biggest change is that I don't have to keep another constraint between app and database - if I want to increase the user perceived space, now I just have to change the application (of course, under the limits). For what it's worth, I

Re: [GENERAL] Feature Request: Faceting for full text search

On 12/9/15 11:30 AM, Mirek Svoboda wrote: Is it OK if I add feature request "faceting for FTS" to roadmap? If you're asking how to get a feature added to Postgres, you basically have 4 options: 1) Convince an existing contributor to work on adding the feature. 2) Convince a large enough

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On Monday, December 14, 2015, Benjamin Smith wrote: > On Monday, December 14, 2015 05:25:16 PM Adrian Klaver wrote: > > > FOLLOWUP QUESTION: is there a way to ask the query planner what > > > tables/fields were output in a database result? > > > > Just dawned on me, are

Re: [GENERAL] Deletion Challenge

On 12/9/15 7:59 PM, Berend Tober wrote: The issue is that I'd like the application (that is, the data base and its stored procedures) to be robust enough to be a "long-running" application, i.e. one that doesn't suffer gradual performance degradation as time and the accumulated data increase.

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On 12/14/2015 04:22 PM, Benjamin Smith wrote: Ccing list On Monday, December 14, 2015 01:02:00 PM you wrote: On 12/14/2015 09:55 AM, Benjamin Smith wrote: Is there a way to set PG field-level read permissions so that a deny doesn't cause the query to bomb, but the fields for which permission

[GENERAL] Multi-master replication

Hello All! As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need install BDR module?). I wants to play with multi-master, asynchronous replication on two servers PostgreSQL 9.5 beta 2. In official docs very small information about how to configure servers. Could anyone

[GENERAL] Practical Application

All, I'm looking for some real world documentation on the use of ora2pg to move from Oracle DB 11gR2 64-bit to PostgreSQL (i.e. What's the best pgsql version to use; Is it possible to use a exported copy of the Oracle DB to create a pgsql image of it; These kinds of questions). Does PGSQL

Re: [GENERAL] Practical Application

On Mon, Dec 14, 2015 at 03:52:41PM +, Gene Poole wrote: > I'm looking for some real world documentation on the use of ora2pg to move > from Oracle DB 11gR2 64-bit to PostgreSQL (i.e. What's the best pgsql version > to use; Is it possible to use a exported copy of the Oracle DB to create a >

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

> I hope I have been the most clear as my poor level of English could be.. It would be great if you could express that in java + sql as well, so the exact code can be added to JDBC driver test suite as a regression test. Vladimir -- Sent via pgsql-general mailing list

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

>As I understand, it's all what you need, isn't you Ideally I would like to see a pull request at https://github.com/pgjdbc/pgjdbc/pulls, however your code seems to be good enough so somebody else can pick it up, simplify a bit, and file a PR. Vladimir -- Sent via pgsql-general mailing

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

>Ok. I understand, to put there a pull request, I must to register into this >webpage ?? Exactly. Vladimir -- 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] Memory Leak executing small queries without closing the connection - FreeBSD

On 12/13/2015 01:23 PM, Gerhard Wiesinger wrote: On 13.12.2015 21:14, Bill Moran wrote: Wait ... this is a combined HTTP/Postgres server? You didn't mention that earlier, and it's kind of important. What evidence do you have that Postgres is actually the part of this system running out of

Re: [GENERAL] Practical Application

Yeah guys from http://2ndquadrant.com/ are good, especially if you have a large dataset and your business depends heavily on it. But I assume if their management wants to cut costs, they expect that their employees will be able to handle completely new technology with not much prior experience

Re: [GENERAL] Multi-master replication

Hi, I have understood that at 9.5 BDR is not implemented yet , but you have to download and install it from 2ndQuadrant , ie , a modified version of postgresql Mario Soto -Mensaje original- De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] En nombre de

Re: [GENERAL] Multi-master replication

Just word of month, Thank you Simon for detailed explanation current status of BDR and PostgreSQL. BR, Dmitry On 12/14/2015 09:31 PM, Simon Riggs wrote: On 14 December 2015 at 15:55, Dmitry Mordovin > wrote: Hello All! As I

Re: [GENERAL] Multi-master replication

On Mon, Dec 14, 2015 at 9:55 AM, Dmitry Mordovin wrote: > Hello All! > > As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need > install BDR module?). Huh -- that may be so. But if it is, it contradicts the BDR documentation:

Re: [GENERAL] Multi-master replication

On 14 December 2015 at 15:55, Dmitry Mordovin wrote: > Hello All! > > As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need > install BDR module?). > PostgreSQL 9.5 does not yet have the full code required for Bi-Directional replication. How did you

Re: [GENERAL] Multi-master replication

Thank you Merlin, I see this doc too. But I confused, in 9.5 BDR placed to native code and becomes built in feature. So, need I install external BDR or try to config built in version ? Or I didn't understood clearly. BR, Dmitry On 12/14/2015 08:38 PM, Merlin Moncure wrote: On Mon, Dec

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On Mon, Dec 14, 2015 at 10:55 AM, Benjamin Smith wrote: > Is there a way to set PG field-level read permissions so that a deny > doesn't > cause the query to bomb, but the fields for which permission is denied to > be > nullified? > > In our web-based app, we have a

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

Yes, I was thinking to post my solution in this list for any who need to know how to receive more than one cursors from a function stored in a PostgreSQL database, but, living and working in Argentina, made an impossible work last week ( abnormal tasks to do are normal here ) , but now I

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

Well Vladimir, i copy here only the part used in the java program to connect, set the parameters and execute the call to the stored function ( I show how I manage both oracle and postgresql, but advises to better programming are welcome ) : 1) connecting, setting the parameters and execute

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

Ok. I understand, to put there a pull request, I must to register into this webpage ?? -Mensaje original- De: Vladimir Sitnikov [mailto:sitnikov.vladi...@gmail.com] Enviado el: lunes, 14 de diciembre de 2015 10:53 a.m. Para: Corradini, Carlos CC: Kevin Grittner; Adrian Klaver; List;

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

I forgot one more thing ... The return I made in the stored function is : RETURNS RECORD AS ' Excuse me for the forget ... -Mensaje original- De: Kevin Grittner [mailto:kgri...@gmail.com] Enviado el: viernes, 11 de diciembre de 2015 06:54 p.m. Para: Corradini, Carlos CC: Adrian

Re: [GENERAL] Postgresql INET select and default route ?

Fabuous ! Thank you ! On 14 December 2015 at 07:52, Albe Laurenz wrote: > Tim Smith wrote: >> Re: I am surprised that you don't expect "0.0.0.0/0" to be returned by the >> first >> query if you expect it to be returned by the second. >> Is that an oversicht? >> >>

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On Mon, Dec 14, 2015 at 09:55:02AM -0800, Benjamin Smith wrote: > Is that there is a way to let the query succeed, but nullify any fields where > read permissions fail? What about real field values begin NULL ? Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

Dear Mr. Adrian Well, I must be honest, with your and Mr. Kevin explanations, the Java program have worked fine and have printed the data obtained from a two cursors inside a PostgreSQL Database Stored Function. Then, I can confirm that this version of DB ( 9.4 ) use the OUT parameter with

[GENERAL] Permissions, "soft read failure" - wishful thinking?

Is there a way to set PG field-level read permissions so that a deny doesn't cause the query to bomb, but the fields for which permission is denied to be nullified? In our web-based app, we have a request to implement granular permissions: table/field level permissions. EG: userX can't read

Re: [GENERAL] postgresql 9.3 failover time

On 12/12/15 2:08 PM, Shay Cohavi wrote: > *I have postgresql 9.3 setup with 2 nodes (active/standby with streaming > replication & continuos archiving).* > *I have created 2 failover & failback script in order to perform a > switchover between the DB servers:* > *1. failover - create a trigger

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On 12/14/2015 09:55 AM, Benjamin Smith wrote: Is there a way to set PG field-level read permissions so that a deny doesn't cause the query to bomb, but the fields for which permission is denied to be nullified? In our web-based app, we have a request to implement granular permissions: