[GENERAL] 9.5 CentOS 7 setting PGDATA for systemctl

2016-05-21 Thread Tory M Blue
Evening, morning, or afternoon, So I'm trying to go back to a stock rpm package (vs my full custom, builds). This is a learning curve, not only because it's all "whacked pathing (in my eyes:)) but rhel7 is a #$%$# with all the things they changed. Sooo I've got servers built and I've got the co

Re: [GENERAL] How to know if SPI or some other API triggered an ERROR.

2016-05-21 Thread dandl
Thanks. Yes, I have seen those around and kind of wondered. It looks like it can only be used in a "C" context. Should do what I need, if I can find the right place to put it. Regards David M Bennett FACS Andl - A New Database Language - andl.org > -Original Message- > From: Tom Lane

Re: [GENERAL] PostgreSql Doubt

2016-05-21 Thread John R Pierce
On 5/21/2016 2:22 PM, aluka raju wrote: I have a data source for example in file format(xml,csv ..etc) , i want to use postgresql engine to query select,update,insert using foreign data wrappers(fdw). updating/inserting into a CSV, XML, or whatever flat file will be very painful, it will re

Re: [GENERAL] PostgreSql Doubt

2016-05-21 Thread Adrian Klaver
On 05/21/2016 02:22 PM, aluka raju wrote: Hello, I have a data source for example in file format(xml,csv ..etc) , i want to use postgresql engine to query select,update,insert using foreign data wrappers(fdw). question1 --- > is it possible to prepare our own fdw ?. http://www.postgresql.org/

[GENERAL] Enhancement proposal for psql: add a column to "\di+" to show index type

2016-05-21 Thread Ivan Voras
Hi, As it says in the subject: if any developer is interested in doing so, I think it is useful to see the index type in "\di+" output. The new column could be named "using" to reflect the SQL statement. It would contain entries such as "btree", "BRIN", "GIN", etc.

[GENERAL] PostgreSql Doubt

2016-05-21 Thread aluka raju
Hello, I have a data source for example in file format(xml,csv ..etc) , i want to use postgresql engine to query select,update,insert using foreign data wrappers(fdw). question1 --- > is it possible to prepare our own fdw ?. question2 -> is it possible to seperate postgresql engine and use it

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

2016-05-21 Thread Tom Lane
Venkata Balaji N writes: > On Sat, May 21, 2016 at 1:04 AM, Tom Lane wrote: >> http://www.unix.com/man-page/opensolaris/3c/atomic_cas/ >> http://docs.oracle.com/cd/E23824_01/html/821-1465/atomic-cas-3c.html >> >> I see that the first of those mentions it's for SunOS 5.11 whereas your >> machine

Re: [GENERAL] .bash_profile replaced on software updates

2016-05-21 Thread Devrim Gündüz
Hi John, Can you please create a ticket at redmine.postgresql.org , under pgrpms project? I will look at this soon. Thanks! Regards, Devrim On May 21, 2016 5:09:13 PM GMT+03:00, John DeSoi wrote: >I'm using CentOS and updating Postgres with yum. Whenever Postgres is >updated (even minor updat

Re: [GENERAL] .bash_profile replaced on software updates

2016-05-21 Thread David G. Johnston
On Sat, May 21, 2016 at 10:09 AM, John DeSoi wrote: > I'm using CentOS and updating Postgres with yum. Whenever Postgres is > updated (even minor updates) the .bash_profile is replaced with the lines > below. I was happy to see the idea of the .psql_profile added fairly > recently, but I don't un

[GENERAL] .bash_profile replaced on software updates

2016-05-21 Thread John DeSoi
I'm using CentOS and updating Postgres with yum. Whenever Postgres is updated (even minor updates) the .bash_profile is replaced with the lines below. I was happy to see the idea of the .psql_profile added fairly recently, but I don't understand why the last line is commented out. I still have t

Re: [GENERAL] How to know if SPI or some other API triggered an ERROR.

2016-05-21 Thread Tom Lane
"dandl" writes: > The question is whether there is any way to know that some Postgres API call > such as SPI (or others) did not return but instead triggered an elog(ERROR). I think what you're looking for is to set up a PG_TRY/PG_CATCH block to intercept the error as the stack is being unwound.

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-21 Thread Chris Travers
On Sat, May 21, 2016 at 12:49 PM, Szymon Lipiński wrote: > > > Strangely I have never had a problem testing stored procedures. You have >> to create a data set for the tests of course and that is the hardest part, >> but there are some really nice things: >> >> 1. If your test scripts always ro

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-21 Thread Szymon Lipiński
On 21 May 2016 at 11:28, Chris Travers wrote: > > > On Fri, May 20, 2016 at 10:43 PM, Guyren Howe wrote: > >> On May 20, 2016, at 13:38 , Pierre Chevalier Géologue < >> pierrechevalierg...@free.fr> wrote: >> > >> > Le 04/05/2016 18:29, Szymon Lipiński a écrit : >> >> On the other hand, when I wa

[GENERAL] How to know if SPI or some other API triggered an ERROR.

2016-05-21 Thread dandl
The question is whether there is any way to know that some Postgres API call such as SPI (or others) did not return but instead triggered an elog(ERROR). The context is the implementation of a language handler (plandl for Andl) with the possibility of re-entrant calls to functions. I would li

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-21 Thread Chris Travers
On Fri, May 20, 2016 at 10:43 PM, Guyren Howe wrote: > On May 20, 2016, at 13:38 , Pierre Chevalier Géologue < > pierrechevalierg...@free.fr> wrote: > > > > Le 04/05/2016 18:29, Szymon Lipiński a écrit : > >> On the other hand, when I was trying to store all my logic in a > >> database, there was

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-21 Thread Szymon Lipiński
On 20 May 2016 at 22:43, Guyren Howe wrote: > On May 20, 2016, at 13:38 , Pierre Chevalier Géologue < > pierrechevalierg...@free.fr> wrote: > > > > Le 04/05/2016 18:29, Szymon Lipiński a écrit : > >> On the other hand, when I was trying to store all my logic in a > >> database, there was just one

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-21 Thread Szymon Lipiński
On 21 May 2016 at 00:08, Steve Atkins wrote: > > > On May 20, 2016, at 1:43 PM, Guyren Howe wrote: > > > > On May 20, 2016, at 13:38 , Pierre Chevalier Géologue < > pierrechevalierg...@free.fr> wrote: > >> > >> Le 04/05/2016 18:29, Szymon Lipiński a écrit : > >>> On the other hand, when I was tr