Thanks for the initial results. Can you check that you are not using super
permissions and are enabling row security when running the test? Super
ignores row security.
Also yes, I forgot to add the policy names, sorry about that.
On Sun, Sep 30, 2018 at 1:34 AM Charles Clavadetscher (SwissPUG) <
c
Thank you for the detailed report Charles. I think you may be missing the
“returning id” clause in the insert. Can you verify it works when you use
“returning id”? Thanks!
On Sun, Sep 30, 2018 at 7:57 PM Charles Clavadetscher (SwissPUG) <
clavadetsc...@swisspug.org> wrote:
> Hello
>
> On 30.09.201
On Fri, Sep 28, 2018 at 10:43 PM Adrian Klaver
wrote:
> On 9/28/18 8:41 AM, Durgamahesh Manne wrote:
> > Hi
> >
> > This is regarding bdr extension issue. I got below error at the time i
> > have tried to create the bdr extention
> >
> >
> > ERROR: could not open extension control file
> > "opt/P
Hi,
admitting that windows is quite alien to me...
I have installed a postgresql server on linux and now want to allow windows
clients access through a tcl gui.
Activestate tcl is installed, and when I try to
package require tdbc::postgresql
I get a complaint about libpq.dll.5 missing. The post
пн, 1 окт. 2018 г. в 11:15, :
>
>
> Hi,
>
> admitting that windows is quite alien to me...
> I have installed a postgresql server on linux and now want to allow windows
> clients access through a tcl gui.
> Activestate tcl is installed, and when I try to
> package require tdbc::postgresql
> I get
Hi,
if I understand it correctly, backend_xmin in pg_stat_replication is the
xmin that's reported back by hot_standby_feedback. Given there are no
long-running transactions on the replica, I presume that value should be
pretty close to the xmin field of any recent snapshots on the master. This
is
The real issue here is to do with the visibility of the data inserted
by the trigger function from within the same command. In general, data
inserted by a command is not visible from within that same command.
The easiest way to see what's going on is with a simple example.
Consider the following (
On 10/1/18 1:14 AM, haman...@t-online.de wrote:
Hi,
admitting that windows is quite alien to me...
I have installed a postgresql server on linux and now want to allow windows
clients access through a tcl gui.
Activestate tcl is installed, and when I try to
What version of Activestate tcl?
On 9/30/18 9:26 PM, Arup Rakshit wrote:
Hello Adrian,
The one I said in gist is different query, and the previous mail I
posted another query because I was testing with different types of
queries. So 1.5, 1.7 is not for this current one. My main point now I am
trying to understand why it is n
On 10/1/18 6:36 AM, wolfg...@alle-noten.de wrote:
Please reply to list also.
Ccing list.
I am getting ready to head out the door which is why I am returning this
to list for other eyes to see.
On 10/1/18 1:14 AM, haman...@t-online.de wrote:
Hi,
admitting that windows is quite alien to me.
On 10/1/18 1:08 AM, Durgamahesh Manne wrote:
On Fri, Sep 28, 2018 at 10:43 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 9/28/18 8:41 AM, Durgamahesh Manne wrote:
> Hi
>
> This is regarding bdr extension issue. I got below error at the
time i
> hav
Hi,
On 2018-10-01 12:20:26 +0200, Torsten Förtsch wrote:
> if I understand it correctly, backend_xmin in pg_stat_replication is the
> xmin that's reported back by hot_standby_feedback. Given there are no
> long-running transactions on the replica, I presume that value should be
> pretty close to t
I understand the PostgreSQL 9.x installed on a RHEL distribution can be
configured and supports FIPS 140-2 when using and properly configuring OpenSSL
FIPS. My question is can the same be accomplished with a Windows installation,
as easily or similar to the RHEL installation/configuration proced
On Mon, Oct 1, 2018 at 7:34 PM Adrian Klaver
wrote:
> On 10/1/18 1:08 AM, Durgamahesh Manne wrote:
> >
> >
> > On Fri, Sep 28, 2018 at 10:43 PM Adrian Klaver
> > mailto:adrian.kla...@aklaver.com>> wrote:
> >
> > On 9/28/18 8:41 AM, Durgamahesh Manne wrote:
> > > Hi
> > >
> > >
Bradley May writes:
> I understand the PostgreSQL 9.x installed on a RHEL distribution can be
> configured and supports FIPS 140-2 when using and properly configuring
> OpenSSL FIPS. My question is can the same be accomplished with a Windows
> installation, as easily or similar to the RHEL inst
Thanks a lot! So, the correct calculation is like this:
select application_name,
txid_snapshot_xmin(txid_current_snapshot()),
backend_xmin::TEXT::BIGINT,
(txid_snapshot_xmin(txid_current_snapshot())-backend_xmin::TEXT::BIGINT)%(2^32)::BIGINT
from pg_stat_replication;
applicati
On 10/01/2018 11:44 AM, Bradley May wrote:
> I understand the PostgreSQL 9.x installed on a RHEL distribution can
> be configured and supports FIPS 140-2 when using and properly
> configuring OpenSSL FIPS. My question is can the same be accomplished
> with a Windows installation, as easily or simil
Hello team,
My name is Ari and I work for SoftwareOne, an international software consulting
and reseller company.
We have an end user interested in:
* 1 2ndQPostgres Platinium
For their work environment in Mexico.
Do you work with resellers?
Can we get a price quote?
Best regards,
Hello,
I am trying to populate/create a database with CREATE TABLE AS SELECT
like so:
CREATE TABLE test_table AS
SELECT row_number() over() as gid, cells.geom
FROM test_geom_function(1,2,3) AS cells;
This works on one database instance, but not on another. On the database
it doesn't
Am 01.10.2018 um 20:02 schrieb Pichardo, Ari:
Hello team,
My name is Ari and I work for SoftwareOne, an international software
consulting and reseller company.
We have an end user interested in:
·1 2ndQPostgres Platinium
For their work environment in Mexico.
Do you work with resellers?
derek writes:
> I am trying to populate/create a database with CREATE TABLE AS SELECT
> like so:
> CREATE TABLE test_table AS
> SELECT row_number() over() as gid, cells.geom
> FROM test_geom_function(1,2,3) AS cells;
> This works on one database instance, but not on another. On the
Hello List,
I have a question regarding the new stored procedures in Postgres 11 (I tested
beta4):
I'd like to know if it is somehow possible to get a (or possibly more) result
set from selects within the SP, as it is possible in MariaDB, MySQL, or SQL
Server.
What I found until now is to us
Jan Kohnert writes:
> I have a question regarding the new stored procedures in Postgres 11 (I
> tested
> beta4):
> I'd like to know if it is somehow possible to get a (or possibly more) result
> set from selects within the SP, as it is possible in MariaDB, MySQL, or SQL
> Server.
Not there a
Hi,
I am interested in trying the hash partitioning method now available in 11
(trying the beta 4). However, I have the data already hashed at the
application level across multiple postgres instances. If possible, I would
like to keep these two hashing methods same. This would enable me to move
a
24 matches
Mail list logo
