SPI Interface to Call Procedure with Transaction Control Statements

Hi All, In PG-11, procedures were introduced. In the pg_partman tool, a procedure named run_maintenance_proc was developed to replace run_maintenance function. I was trying to call this procedure in pg_partman with SPI_execute() interface and this is the command being executed: CALL "partman".run_

Re: getting pg_basebackup to use remote destination

On Thu, Jan 3, 2019 at 3:46 PM Stephen Frost wrote: > Greetings Chuck, > > * Chuck Martin (clmar...@theombudsman.com) wrote: > > Using iperf, the transfer speed between the two servers (from the main to > > the standby) was 938 Mbits/sec. If I understand the units correctly, it > is > > close to

Re: Thoughts on row-level security for webapps?

Thank you for the responses. I did some research and now understand that in my query I'll need to do something like 'SET LOCAL user_id=5; SET ROLE app_user' and define a policy that references a 'user_id' variable. I think I have enough info now to get started. On Thu, Jan 3, 2019 at 12:49 PM Ste

Re: Thoughts on row-level security for webapps?

Greetings, * Siegfried Bilstein (sbilst...@gmail.com) wrote: > I'm evaluating using a tool called Postgraphile that generates a GraphSQL > server from a postgres setup. The recommended way of handling security is > to implement RLS within postgres and simply have the webserver take a > cookie or s

Re: getting pg_basebackup to use remote destination

Greetings Chuck, * Chuck Martin (clmar...@theombudsman.com) wrote: > Using iperf, the transfer speed between the two servers (from the main to > the standby) was 938 Mbits/sec. If I understand the units correctly, it is > close to what it can be. That does look like the rate it should be going at

Re: Memory exhaustion due to temporary tables?

[ please don't re-quote the entire thread when replying ] Thomas Carroll writes: > On Monday, December 10, 2018, 7:45:07 PM EST, Tom Lane > wrote: >> You said you'd been able to reproduce this problem outside production. >> Any chance you could boil that down to a sharable test case? > T

Re: query with regular expression

Thanks for the tip! On Thu, Jan 3, 2019 at 12:58 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thursday, January 3, 2019, Glenn Schultz wrote: > >> All, >> >> I am writing a query to select * from where ~ '[regx] an example of the >> sting that I am matching is below >> >> FHLG

Re: query with regular expression

On Thursday, January 3, 2019, Glenn Schultz wrote: > All, > > I am writing a query to select * from where ~ '[regx] an example of the > sting that I am matching is below > > FHLG16725 > > The first two alpha characters to match are FN, FH, GN any alpha > characters between those and the numeric

query with regular expression

All, I am writing a query to select * from where ~ '[regx] an example of the sting that I am matching is below FHLG16725 The first two alpha characters to match are FN, FH, GN any alpha characters between those and the numeric don't matter as the first two alpha + numeric will create a unique.

Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL

Hi Kevin, Thank you for the responce. I have tried to intall the RPMs with -relocate option,however it is not working as expected and throwing below error. [root@Server1dev:/root/PG11]# #-> rpm -ivh --relocate /usr/pgsql-11/=/u01/postgres/pg11_relocate/ postgresql11-server-11.1-1PGDG.rhel7.x86_6

Re: [unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,NativeErr = 209}

čt 3. 1. 2019 v 12:59 odesílatel Mihalidesová Jana < jana.mihalides...@cetin.cz> napsal: > It could be problem with odbc driver even when isql works? > > > > > > isql -v postgres > > +---+ > > | Connected!| > > |

Re: Memory exhaustion due to temporary tables?

On Monday, December 10, 2018, 7:45:07 PM EST, Tom Lane wrote: Thomas Carroll writes: >  On Monday, December 10, 2018, 5:50:22 PM EST, Tom Lane >wrote:  >> Also, as mentioned upthread, it'd be interesting to see if there's >> a memory context dump showing up in your server log. > T

RE: [unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,NativeErr = 209}

It could be problem with odbc driver even when isql works? isql -v postgres +---+ | Connected!| | | | sql-statement | | help [tablename] | | quit

Re: [unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,NativeErr = 209}

Hi čt 3. 1. 2019 v 12:00 odesílatel Mihalidesová Jana < jana.mihalides...@cetin.cz> napsal: > Hi, > > > > I try to connect from oracle 11.2.0.4 to postgres but I still got. Do you > have any idea what configuration should I check. What is wrong? > > > > ERROR at line 1: > > ORA-28500: connection

[unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,NativeErr = 209}

Hi, I try to connect from oracle 11.2.0.4 to postgres but I still got. Do you have any idea what configuration should I check. What is wrong? ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,N