Community members:
A number of people have contacted the Core Team about taking action
regarding a Code of Conduct (CoC) for the project. After some
discussion, the plan we have come up with is below.
**Please do not reply-all to this email, as we do not wish to generate
additional list traffic r
Hi all,
I am test pglogical on PG 9.4.5, but I am not successfully even if I
install the latest version "postgresql94-pglogical-1.0.1-2".
Is there any one running pglogical on PG 9.4.5 successfully?
I describe my operation step, please help me to trouble shooting?
provider node: 1
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dane Foster
Sent: Tuesday, January 26, 2016 2:39 PM
To: pgsql-general
Subject: [GENERAL] Can PostgreSQL use multi-column index for FK constraint
validation?
Hello,
If I have a primary key index of
On 01/26/2016 12:47 PM, Dane Foster wrote:
> My example is modeling an order details table and the answer to the
> question of selectivity is it depends. For some of our clients it is
> highly selective because customers generally order a single item at a
> time. For others it's multi-modal because
Dane Foster writes:
> My example is modeling an order details table and the answer to the
> question of selectivity is it depends. For some of our clients it is highly
> selective because customers generally order a single item at a time. For
> others it's multi-modal because it starts out w/ thei
On Tue, Jan 26, 2016 at 3:15 PM, Josh Berkus wrote:
> On 01/26/2016 11:38 AM, Dane Foster wrote:
> > Hello,
> >
> > If I have a primary key index of the form:
> > (col1, col2, col3)
> > and a foreign key constraint of the form:
> > FOREIGN KEY (col1, col2) REFERENCES foo
> > ON DELETE CASCADE ON
Well done Joshua D. Drake and thank you for the hard work putting up with so
many comments.
Hope it is all worth it.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joshua D. Drake
Sent: 26 January 2016 19:01
To: Jan
On 01/26/2016 11:38 AM, Dane Foster wrote:
> Hello,
>
> If I have a primary key index of the form:
> (col1, col2, col3)
> and a foreign key constraint of the form:
> FOREIGN KEY (col1, col2) REFERENCES foo
> ON DELETE CASCADE ON UPDATE CASCADE
> should I create a separate index (col1, col2) or is
Zenaan,
> I simply wrote in first person with the intention to catalyse thought
> about what could and or should and or should not be in such a
> "covenant". In no way was the email any statement of authority and I
> had hoped to make that clear, evidently not.
It wasn't. And while longterm comm
Hello,
If I have a primary key index of the form:
(col1, col2, col3)
and a foreign key constraint of the form:
FOREIGN KEY (col1, col2) REFERENCES foo
ON DELETE CASCADE ON UPDATE CASCADE
should I create a separate index (col1, col2) or is PostgreSQL capable of
using the primary key's index?
Than
On 01/26/2016 09:03 AM, Jan Danielsson wrote:
On 24/01/16 18:30, Joshua D. Drake wrote:
Hello,
This thread is deprecated. The CoC Final Draft has been submitted to
-core for final modification, acceptance or decline.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. http
On Tue, 2016-01-26 at 11:06 +, Max wrote:
> Is there a collation for case and accent insensitive filter? I just
> found the use of operators like ILIKE ou CITEXT module but I can't
> use ILIKE in the queries and the CITEXT is a field-by-field solution
> for the case insensitive part of the prob
On 24/01/16 18:30, Joshua D. Drake wrote:
[---]
> This is something that I brought up in protest because I believe that it
> is crucial to the growth of this community.
Do you have any evidence to support this belief? (Without referring
to an anonymous invisible mass, a single case or unverifi
On 1/26/2016 7:21 AM, Edson F. Lidorio wrote:
How to compile the master version 9.6 Dev, for Linux?
do note, 9.6 is still a early beta, and is probably 6 months from
feature complete and a year+ from release.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mail
On Tue, Jan 26, 2016 at 4:21 PM, Edson F. Lidorio
wrote:
>
>
> On 25-01-2016 16:46, Igal @ Lucee.org wrote:
>
> Hi Everybody,
>
> I have posted a video tutorial on How to Compile PostgreSQL 9.5 for
> Windows 64bit
> https://www.youtube.com/watch?v=-BJmuZT5IPE
>
> It was quite difficult for me to
On 25-01-2016 16:46, Igal @ Lucee.org wrote:
Hi Everybody,
I have posted a video tutorial on How to Compile PostgreSQL 9.5 for
Windows 64bit
https://www.youtube.com/watch?v=-BJmuZT5IPE
It was quite difficult for me to figure it out, so hopefully it will
make life easier for
the next guy (
I was hoping to be able to use the prefix module with postgresql 9.5.
However, I'm not finding it in the redhat 7 repo:
https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/
It is available for 9.4:
https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-7-x86_64/
It is a
Hi Craig, how are you?
Just as an update, I figured it out...
First, here's my setup:
Node 1 and Node 2 running postgresql-bdr94-bdr and bdr enabled.
Node 3 with the same setup, ready to receive the snapshot clone.
These were my steps:
1) pg_start_backup
2) take snapshot from Node 1
3) pg_stop_b
Is there a collation for case and accent insensitive filter? I just found the
use of operators like ILIKE ou CITEXT module but I can't use ILIKE in the
queries and the CITEXT is a field-by-field solution for the case insensitive
part of the problem. I also found the unaccent text search dictiona
Wow. And I was annoyed with myself that _I'd_ wasted so much time by
being drawn into this nonsense.
It appears that the only way to deal with the covenant and its
proponents is just to say "lalalalalala can't hear you" because they
will not listen to reason or take on board that any of what they
I have recently installed Postgres 9.5 on CentOS 7.
I would like to connect this instance to an Hadoop cluster where data is
managed by Phoenix (over hBase).
My idea was to establish a link between Postgres and Phoenix thanks to
jdbc_fdw.
However, when I compiled the jdbc_fdw, it didn't put the th
21 matches
Mail list logo
