Re: [GENERAL] Bugs with like_option in CREATE TABLE

2015-09-10 Thread hubert depesz lubaczewski
On Wed, Sep 09, 2015 at 07:51:48PM -0400, Melvin Davidson wrote: > *O/S = Windows 10PostgreSQL 9.2.10, compiled by Visual C++ build 1600, > 32-bit* > http://www.postgresql.org/docs/9.1/interactive/sql-createtable.html > > and like_option is: > { INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS |

Re: [GENERAL] Bugs with like_option in CREATE TABLE

2015-09-10 Thread Melvin Davidson
My apologies. I made a test case but this time it worked. I must have had a brain fart while I was working on this yesterday. Well, at least I am getting used to the taste of eating crow. :) On Thu, Sep 10, 2015 at 5:56 AM, hubert depesz lubaczewski < dep...@depesz.com> wrote: > On Wed, Sep 09,

[GENERAL] Can I integrate PostgreSQL into MS Visual Studio EXPRESS ?

2015-09-10 Thread Denis Yanov
You can try to use this latest PostgreSQL ODBC driver with VS Express. Here is the driver https://www.devart.com/odbc/postgresql/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] clone_schema function

2015-09-10 Thread Igor Neyman
From: Melvin Davidson [mailto:melvin6...@gmail.com] Sent: Wednesday, September 09, 2015 4:48 PM To: Igor Neyman Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] clone_schema function Thanks Igor, hmm, apparently the "INCLUDING CONSTRAINTS' option of "CREATE

Re: [GENERAL] clone_schema function

2015-09-10 Thread Melvin Davidson
Yes, however, the documentation would be a lot clearer if it said "copies all constraints except foreign keys". I've made this known. At any rate, I've attached a new version of the function that now does copy the foreign keys. Let me know if I missed anything else. On Thu, Sep 10, 2015 at 9:09

[GENERAL] Error when installing the bdr extension

2015-09-10 Thread Ioana Danes
Hi, I am trying to install the UDR from 2ndquadrant and I am getting the following error when I try to create the bdr extension: # create extension bdr; ERROR: could not find function "bdr_internal_sequence_reset_cache" in file "/usr/lib/postgresql94/lib64/bdr.so" I could not find a mailing

BDR mailing list (was: [GENERAL] Error when installing the bdr extension)

2015-09-10 Thread Martín Marqués
El 10/09/15 a las 13:17, Ioana Danes escribió: > > I could not find a mailing list for BDR/UDR so I thought to post my > issue here with my hope that somebody can help me. It seems people are now looking for a specific mailing list for bdr/udr extensions and as I recall from earlier mails, there

Re: [GENERAL] BDR mailing list

2015-09-10 Thread Joshua D. Drake
On 09/10/2015 10:11 AM, Martín Marqués wrote: El 10/09/15 a las 13:17, Ioana Danes escribió: I could not find a mailing list for BDR/UDR so I thought to post my issue here with my hope that somebody can help me. It seems people are now looking for a specific mailing list for bdr/udr

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Joe Conway
On 09/10/2015 03:03 PM, Andrew Sullivan wrote: > On Thu, Sep 10, 2015 at 02:54:31PM -0700, Ken Tanzer wrote: >> Thanks, but I guess I should have been clearer. Thanks to y'all wonderful >> mailing list folks, I get it now as to why the two sorts are not the same. >> I'm hoping for practical

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Ken Tanzer
On Thu, Sep 10, 2015 at 2:02 PM, Alvaro Herrera wrote: > Ken Tanzer wrote: > > > Are there any other potential solutions, pitfalls or considerations that > > come to mind? Any thoughts welcome. And as I said, if there's not a > good > > way to do this I'll probably

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Andrew Sullivan
On Thu, Sep 10, 2015 at 02:54:31PM -0700, Ken Tanzer wrote: > Thanks, but I guess I should have been clearer. Thanks to y'all wonderful > mailing list folks, I get it now as to why the two sorts are not the same. > I'm hoping for practical suggestions or advice about how to get C locale > sorting

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Ken Tanzer
On Thu, Sep 10, 2015 at 3:03 PM, Andrew Sullivan wrote: > On Thu, Sep 10, 2015 at 02:54:31PM -0700, Ken Tanzer wrote: > > Thanks, but I guess I should have been clearer. Thanks to y'all > wonderful > > mailing list folks, I get it now as to why the two sorts are not the >

Re: [GENERAL] avoid lock conflict between SELECT and TRUNCATE

2015-09-10 Thread Venkata Balaji N
On Thu, Sep 10, 2015 at 3:54 AM, Florin Andrei wrote: > Once in a while, I have a report running a complex query such as this: > > BEGIN;declare "SQL_CUR04919850" cursor with hold for SELECT > "auths_with_trans"."user_id" AS "user_id (auths_with_trans)", >

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Steve Crawford
Any null values in first name?? -Steve On Thu, Sep 10, 2015 at 12:35 PM, Ken Tanzer wrote: > Hi. In a table that includes these columns: > > my_db=> \d tbl_client > ... > name_last | character varying(40) | not null > name_first

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Tom Lane
Peter Geoghegan writes: > On Thu, Sep 10, 2015 at 12:35 PM, Ken Tanzer wrote: >> Any thoughts about what's going on, what to do about it, or what obvious >> point I missing? Thanks in advance! > This is the expected behavior. If you don't

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Peter Geoghegan
On Thu, Sep 10, 2015 at 12:51 PM, Ken Tanzer wrote: > OK, can one of you help me out in understanding this? I would have thought > that given "CLARK," and "CLARKE" that the comma would get compared against > the E and come first. End of story, before we even get to

[GENERAL] Very puzzling sort behavior

2015-09-10 Thread Ken Tanzer
Hi. In a table that includes these columns: my_db=> \d tbl_client ... name_last | character varying(40) | not null name_first | character varying(30) | not null ... I am extremely puzzled by the sorting of the "CLARKE"s in this list:

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Peter Geoghegan
On Thu, Sep 10, 2015 at 12:35 PM, Ken Tanzer wrote: > Any thoughts about what's going on, what to do about it, or what obvious > point I missing? Thanks in advance! This is the expected behavior. Locale rules will weigh the punctuation character and space you added after

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Ken Tanzer
Alright never mind, I guess I see what's going on. Thanks! Ken On Thu, Sep 10, 2015 at 12:51 PM, Ken Tanzer wrote: > > > On Thu, Sep 10, 2015 at 12:47 PM, Tom Lane wrote: > >> Peter Geoghegan writes: >> > On Thu, Sep 10,

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Ken Tanzer
On Thu, Sep 10, 2015 at 12:47 PM, Tom Lane wrote: > Peter Geoghegan writes: > > On Thu, Sep 10, 2015 at 12:35 PM, Ken Tanzer > wrote: > >> Any thoughts about what's going on, what to do about it, or what > obvious point I

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Alvaro Herrera
Ken Tanzer wrote: > Are there any other potential solutions, pitfalls or considerations that > come to mind? Any thoughts welcome. And as I said, if there's not a good > way to do this I'll probably leave it alone. In part, it boils down to what you use the in ORDER BY clause. If you

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Ken Tanzer
On Thu, Sep 10, 2015 at 12:56 PM, Peter Geoghegan < peter.geoghega...@gmail.com> wrote: > On Thu, Sep 10, 2015 at 12:51 PM, Ken Tanzer wrote: > > OK, can one of you help me out in understanding this? I would have > thought that given "CLARK," and "CLARKE" that the comma