Re: [GENERAL] pg_upgrade failing from 9.3 to 9.4 because "template0" already exists

2015-05-14 Thread Bruce Momjian
On Mon, Mar 9, 2015 at 12:43:05PM -0400, Bruce Momjian wrote: > On Fri, Mar 6, 2015 at 06:10:15PM -0500, Stephen Frost wrote: > > Technically, there haven't been any complaints about either pg_dumpall's > > behavior in this regard, or pg_upgrade's, but pg_upgrade's post-upgrade > > scripts would

Re: [GENERAL] Documentation missing bigint?

2015-05-14 Thread Bruce Momjian
On Thu, Dec 11, 2014 at 12:03:56PM -0800, Paul Jungwirth wrote: > Hello, > > The table of which C types represent which SQL types seems to be missing > bigint: > > http://www.postgresql.org/docs/9.3/static/xfunc-c.html#XFUNC-C-TYPE-TABLE > > It looks like bigint should be listed and should corr

Re: [GENERAL] client_min_messages documentation typo

2015-05-14 Thread Bruce Momjian
On Fri, Dec 20, 2013 at 11:29:22AM -0500, George Woodring wrote: > > Currently the documentation looks like: > > client_min_messages (enum) > > Controls which message levels are sent to the client. Valid values are > DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING, ERROR,

[GENERAL] BDR table level replication questions

2015-05-14 Thread Dennis
Hello, I am trying to setup table level replication with BDR 0.9.0 but I am running into some errors. I believe I must be missing a step or two in the process. I currently have a two node group that I want to build. 1) On node1 I have a database built with the tables I want to replicate;

Re: [GENERAL] Grouping By Similarity (using pg_trgm)?

2015-05-14 Thread David G. Johnston
On Thu, May 14, 2015 at 1:09 PM, Cory Tucker wrote: > That produces pretty much the same results as the CROSS JOIN I was using > before. Because each "my_value" in the table are different, if I group on > just their value then I will always have the full result set and a bunch of > essentially d

Re: [GENERAL] Grouping By Similarity (using pg_trgm)?

2015-05-14 Thread Cory Tucker
That produces pretty much the same results as the CROSS JOIN I was using before. Because each "my_value" in the table are different, if I group on just their value then I will always have the full result set and a bunch of essentially duplicated results. Any other ideas/options? On Thu, May 14,

Re: [GENERAL] Grouping By Similarity (using pg_trgm)?

2015-05-14 Thread David G. Johnston
On Thu, May 14, 2015 at 11:58 AM, Cory Tucker wrote: > [pg version 9.3 or 9.4] > > Suppose I have a simple table: > > create table data ( > my_value TEXT NOT NULL > ); > CREATE INDEX idx_my_value ON data USING gin(my_value gin_trgm_ops); > > > Now I would like to essentially do group by to get

[GENERAL] Grouping By Similarity (using pg_trgm)?

2015-05-14 Thread Cory Tucker
[pg version 9.3 or 9.4] Suppose I have a simple table: create table data ( my_value TEXT NOT NULL ); CREATE INDEX idx_my_value ON data USING gin(my_value gin_trgm_ops); Now I would like to essentially do group by to get a count of all the values that are sufficiently similar. I can do it us

Re: [GENERAL] ECPG SET CONNECTION

2015-05-14 Thread Bruce Momjian
On Fri, May 31, 2013 at 02:26:08PM +0200, Leif Jensen wrote: >Hi guys. > >In the ECPG manual (including latest 9.1.9) about ECPG SQL SET CONNECTION > ; it is stated that "This is not thread-aware". > >When looking in the ecpg library code connect.c for ECPGsetconn( ... ), it > looks

Re: [GENERAL] to_number, to_char inconsistency.

2015-05-14 Thread Bruce Momjian
On Sun, Feb 10, 2013 at 06:27:02PM -0500, Tom Lane wrote: > Jeremy Lowery writes: > > I load and dump text files with currency values in it. The decimal in these > > input and output formats in implied. The V format character works great for > > outputing numeric data: > > > # select to_char(123.

Re: [GENERAL] Connection question

2015-05-14 Thread Adrian Klaver
On 05/14/2015 07:52 AM, S. Richler. wrote: Hi, I am wondering if anyone has successfully connected to a Progress database using ODBC. Yes. See below for more information: https://odbc.postgresql.org/ Thanks Stuart Richler Montreal -- Adrian Klaver adrian.kla...@aklaver.com -- Sent

Re: [GENERAL] Connection question

2015-05-14 Thread Igor Neyman
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of S. Richler. Sent: Thursday, May 14, 2015 10:53 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Connection question Hi, I am wondering if anyone has successfully connected to a Progress data

[GENERAL] Connection question

2015-05-14 Thread S. Richler.
Hi, I am wondering if anyone has successfully connected to a Progress database using ODBC. Thanks Stuart Richler Montreal