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 >> nullified? >> >> In our

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 you asking if EXPLAIN can

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: table/fiel

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 pgsql-g

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 gro

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 usuall

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*&%*$%%$#%$#&# (forgive me) >They don't hire a database expert, I don't know why. You can learn that. PostgreSQL is really, really great. Btw.: i kno

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 conjunct

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 b

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, I

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 w

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] 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 is

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 granul

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. I

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: table/fiel

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 file

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; pgsq

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 Klav

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 ha

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

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 refcur

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 request to implement granular

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 73B

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? >> >> Thanks for the question, but n

[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 cu

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 heard, PostgreSQL 9.5 has bu

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 hear that? Was that word o

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

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 1

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: http://bdr-project.org/docs/stable/install-require

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 (fir

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 >

[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 func

[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

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 memor

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] [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 lis

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 (pgsql-general@postgresql.