Re: [GENERAL] attempting to install tds_fw-master on redhat

2015-11-11 Thread Geoff Montee
Hi Joanne, On Wed, Nov 11, 2015 at 4:53 AM, Mammarelli, Joanne T wrote: > Installed postgresql-devel .. getting closer .. > > Installed Packages > postgresql.x86_64 9.2.13-1.el7_1 > @rhel7-x86_64-2015-07 > postgresql-devel.x86_64

Re: [GENERAL] Joins between foreign tables

2015-06-08 Thread Geoff Montee
On Mon, Jun 8, 2015 at 10:29 AM, Jason Dusek jason.du...@gmail.com wrote: The databases involved are all Postgres 9.4 or 9.3. The FDW is the Postgres FDW. The join node (the one from which queries are issued) is Postgres 9.4 installed yesterday from the Postgres Apt repository. It's using the

Re: [GENERAL] SQL Server access from PostgreSQL

2015-06-06 Thread Geoff Montee
On Mon, May 18, 2015 at 11:24 AM, Geoff Montee geoff.mon...@gmail.com wrote: The NOTICE right before the error might provide useful information: NOTICE: DB-Library notice: Msg #: 40508, Msg state: 1, Msg: USE statement is not supported to switch between databases. Use a new connection

Re: [GENERAL] SQL Server access from PostgreSQL

2015-05-18 Thread Geoff Montee
Hi Filip, On Mon, May 18, 2015 at 7:52 AM, Filip Rembiałkowski filip.rembialkow...@gmail.com wrote: Hi. I will be happy to hear your opinion which one is better - odbc_fdw or tds_fdw? In terms of performance / stability / convenience. (Pg on OpenSuse, MS SQL on Win2008 ) Thanks! I'm

Re: [GENERAL] SQL Server access from PostgreSQL

2015-05-18 Thread Geoff Montee
On Mon, May 18, 2015 at 10:28 AM, Filip Rembiałkowski filip.rembialkow...@gmail.com wrote: Thank you Geoff. Actually I have a problem - maybe you can point me in the right direction? CREATE EXTENSION tds_fdw; CREATE EXTENSION CREATE SERVER ms FOREIGN DATA WRAPPER tds_fdw OPTIONS

Re: [GENERAL] Why can't I select un-grouped columns when grouping by a (non-primary) unique key?

2014-09-24 Thread Geoff Montee
On Wed, Sep 24, 2014 at 1:37 PM, Alberto Cabello Sánchez albe...@unex.es wrote: On Wed, 24 Sep 2014 09:04:21 -0700 Daniel Lenski dlen...@gmail.com wrote: If I include the primary key of a table in my GROUP BY clause, PG 9.3 allows me to refer to other columns of that table without explicit

Re: [GENERAL] security labels or sensitivity markings

2014-07-14 Thread Geoff Montee
On Mon, Jul 14, 2014 at 2:23 AM, sumita su...@avaya.com wrote: Does postgresql support the use of security labels or sensitivity markings? If what you want is some kind of row-level security, you have to roll your own when using PostgreSQL. Security_barrier views are a good option for this.

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-07 Thread Geoff Montee
PostgreSQL support was in development at one time. I'm not sure how far they got, or if they are still working on it. http://www.continuent.com/solutions/replication https://wiki.postgresql.org/wiki/Tungsten Geoff Montee

Re: [GENERAL] Security Issues: Allowing Clients to Execute SQL in the Backend.

2014-04-30 Thread Geoff Montee
They don't apply server-wide. They apply to that user's session: http://www.postgresql.org/docs/8.4/interactive/sql-set.html Geoff On Wed, Apr 30, 2014 at 6:19 AM, Hello World worldani...@gmail.com wrote: SET statement_timeout=0; SET work_mem=1024GB; I just realized about the SET