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
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
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
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
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
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
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,
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
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;
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
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
> > >
> > >
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
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
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
>
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
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
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?
пн, 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,
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
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
> >
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
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) <
22 matches
Mail list logo