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 |
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,
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
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
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
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
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
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
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
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
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
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
>
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)",
>
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
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
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
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:
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
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,
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
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
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
22 matches
Mail list logo