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 9.2.13-1.el7_1
> @r
On Mon, Jun 8, 2015 at 10:29 AM, Jason Dusek 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 version
> of the
On Mon, May 18, 2015 at 11:24 AM, Geoff Montee 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
> connecti
On Mon, May 18, 2015 at 10:28 AM, Filip Rembiałkowski
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 (servername 'ms');
> CREATE SERV
Hi Filip,
On Mon, May 18, 2015 at 7:52 AM, Filip Rembiałkowski
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 the developer of td
On Wed, Sep 24, 2014 at 1:37 PM, Alberto Cabello Sánchez
wrote:
>
> On Wed, 24 Sep 2014 09:04:21 -0700
> Daniel Lenski 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
GROUP BY:
> >
> > Why do
On Mon, Jul 14, 2014 at 2:23 AM, sumita 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. See:
http
ication. There's a wiki page that suggests 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
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 wrote:
>
> SET statement_timeout=0;
>> SET work_mem=1024GB;
>>
>
> I just realized about the SET command.
>
> Isn't i
