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

On Sun, May 22, 2016 at 1:59 AM, Tom Lane wrote: > 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

[GENERAL] Fatal error "stack empty" on ROLLBACK

SPI call to execute "ROLLBACK" triggers FATAL ERROR "stack empty". What does it mean? Nothing in the docs I can see. In the particular case there were no update commands issued between BEGIN and ROLLBACK. Is that what it means? Or am I missing something? Regards David M Bennett FACS Andl - A New

Re: [GENERAL] 9.5 CentOS 7 setting PGDATA for systemctl

On 05/21/2016 10:27 PM, Tory M Blue wrote: 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. So

Re: [GENERAL] 9.5 CentOS 7 setting PGDATA for systemctl

> On May 22, 2016, at 07:50, Adrian Klaver wrote: > >> On 05/21/2016 10:27 PM, Tory M Blue wrote: >> 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 (

Re: [GENERAL] 9.5 CentOS 7 setting PGDATA for systemctl

On 05/22/2016 09:06 AM, Tory M Blue wrote: On May 22, 2016, at 07:50, Adrian Klaver wrote: So where did you get the 'stock' RPM's from, CentOS or the Postgres repos? Postgres yum repos (I like this btw) I do not use CentOS myself, so I will point you at this: http://people.planetp

Re: [GENERAL] 9.5 CentOS 7 setting PGDATA for systemctl

On Sun, May 22, 2016 at 9:10 AM, Adrian Klaver wrote: > On 05/22/2016 09:06 AM, Tory M Blue wrote: >> >> >> >> >>> On May 22, 2016, at 07:50, Adrian Klaver >>> wrote: >>> > >>> >>> So where did you get the 'stock' RPM's from, CentOS or the Postgres >>> repos? >> >> >> Postgres yum repos (I like t

[GENERAL] Postgresql-MongoDb foreigndata wrapper

Hello, I want use my data source as mongodb and connect through postgresql fdw. Is their any restrictions that the data present in mongodb to be structured or unstructured data? Thanks aluka Sent with MailTrack

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

Hi Asif, Sorry, i should have responded first. Thanks for inputs and my replies are inline - > Any help would be appreciated. Do i need to give any particular CFLAGS ? >> >> >> Below is the *configure *command - >> >> >> ./configure --prefix=/opt/postgres/9.5.3 CC=/opt/SUNWspro/bin/cc >> 'CFLAGS

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

On Sun, May 22, 2016 at 6:38 PM, Venkata Balaji N wrote: > > On Sun, May 22, 2016 at 1:59 AM, Tom Lane wrote: > >> 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

Re: [GENERAL] Postgresql-MongoDb foreigndata wrapper

On Mon, 23 May 2016, 1:03 p.m. aluka raju, wrote: > Hello, > > I want use my data source as mongodb and connect through postgresql fdw. > Is their any restrictions that the data present in mongodb to be structured > or unstructured data? > For connecting to mongoDB you would need mongodb_fdw an

Re: [GENERAL] Postgresql-MongoDb foreigndata wrapper

Cc pg-list Pls avoiding reaching out to members via list. I may not know something which someone else in the list may know. On Mon, 23 May 2016, 1:22 p.m. aluka raju, wrote: > Hello, > > I have data storage in flat files (structured and unstructured) . I want > to run sql queries on that , so i

[GENERAL] Postgresql-fdw

I have data storage in flat files (structured and unstructured) . I want to run sql queries on that , so i am looking in to postgresql how to use fdw on the data that i have. I want to prepare an api for running sql queries for the data in files,so i am trying to have separate postgresql engine and

Re: [GENERAL] Postgresql-fdw

You can build a multicorn fdw http://multicorn.org/ Regards On May 23, 2016 7:54 AM, "aluka raju" wrote: > > I have data storage in flat files (structured and unstructured) . I want to run sql queries on that , so i am looking in to postgresql how to use fdw on the data that i have. I want to pr

Re: [GENERAL] Postgresql-fdw

On 5/22/2016 10:52 PM, aluka raju wrote: I have data storage in flat files (structured and unstructured) . I want to run sql queries on that , so i am looking in to postgresql how to use fdw on the data that i have. I want to prepare an api for running sql queries for the data in files,so i am