Re: [HACKERS] non-ipv6 vs hostnames

2011-08-17 Thread Charles.McDevitt
 On tis, 2011-08-16 at 16:17 +0200, Magnus Hagander wrote:
  Well, I got this on a win64 build. It's *supposed* to have ipv6. I
  wonder if it breaks on windows just because there is no ipv6 address
  on the machine...
 
 It would mean that getaddrinfo() of ::1 failed.  That seems weird.
 

A system admin can set registry keys to disable IPv6, either partially 
(allowing ::1), or totally (all IPv6 addresses fail).

If the system has IPv6 enabled, it's not possible for there to be no ipv6 
address.  There is always the link-local address of each LAN adapter.


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Debian readline/libedit breakage

2011-02-17 Thread Charles.McDevitt
 On 02/17/2011 12:34 PM, Bruce Momjian wrote:
  Andrew Dunstan wrote:
 
  On 02/17/2011 12:13 PM, Bruce Momjian wrote:
  FWIW, the only interactively usable version of psql for windows I know
  of is the one that runs under Cygwin. It can be build with readline and
  works as expected.
  Uh, don't we have a psql built via MSVC?  Doesn't it work interactively?
 
  Not if you want readline. And in my book that's a requirement of a psql
  that's usable interactively. It's pretty horrible to use without it.
  Well, as horrible as other Windows apps.  I will leave others to decide
  if that is usable.  ;-)  I am unclear if we would ship readline support
  on Windows even if we didn't have a license issue (no OS readline
  version on Windows).
 
 
 Windows developers almost universally work from GUIs and not using
 console apps (and that's true of many Unix developers also, particularly
 those who can't recall a time when X-Windows wasn't almost universally
 available). Microsoft has de-emphasized console apps for 15 years. So
 the only people who are likely to be interested in using an enhanced
 psql on Windows are old Unix-heads like you and me. It's not worth a lot
 of effort, IMNSHO.
 
 cheers
 
 andrew
 

I think this is wrong...  There are plenty of people who use the command line 
in Windows, and Microsoft has been adding better support for this, including 
PowerShell and interfaces to every administrative operation from command line 
scripts.

Psql on Windows is ugly... Readline does (supposedly) run on Windows, but no 
one has done the work to get it to happen.
One of the problems with libedit is that it does not support Windows, as far as 
I know.

I don't know of a good solution, given the license for readline.  But it would 
sure be nice.


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Debian readline/libedit breakage

2011-02-12 Thread Charles.McDevitt
 charles.mcdev...@emc.com wrote:
  The GNU people will never be 100% satisfied by anything you do to psql, 
  other
 than making it GPL.
  Readline is specifically licensed in a way to try to force this (but many 
  disagree
 with their ability to force this).
 
 
 The GNU people are perfectly content with the license of PostgreSQL.
 They are unhappy with the license terms of OpenSSL, which is fair
 because they are ridiculous.  Eric Young and the rest of the
 contributors produced a useful piece of software, and made it considerly
 less valuable to the world due to the ego trip terms:
 http://www.openssl.org/source/license.html -- the worst specific problem
 is the requirement to acknowledge OpenSSL use in advertising of projects
 that use it.
 
 The PostgreSQL community has had similar issues with popular software
 commonly used on top of PostgreSQL, that happened to use a non-standard
 license with unique terms.  It would be both hypocritical and incorrect
 to now blame the GNU projects for taking a similar stand on this one.

You are correct... I overreacted, after having run into problems in the past 
with GPL (vs LGPL) issues.
My apologies to all for adding stupid distracting comments to this thread.

It would be wonderful if the OpenSSL people would compromise on this, but I 
suppose that isn't possible.

I'd love to see libedit get better, and would like to see that solution, 
because OpenSSL's FIPS compliance really helps with Federal customers, but I 
realize that involves a lot of effort.
I hope if the PostgreSQL project goes down the path of switching to GnuTLS, 
OpenSSL remains an option (for the server side). 



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Debian readline/libedit breakage

2011-02-11 Thread Charles.McDevitt
Don't forget that OpenSSL has a FIPS-140 compliant version, and FIPS-140 
compliance is essential to many Federal users.

GnuTLS doesn't qualify.



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Debian readline/libedit breakage

2011-02-11 Thread Charles.McDevitt
If psql uses libreadline and libgnutls, does that mean psql will be distributed 
under the GPL in the future?  Or Dual-licensed?

If I read the readline license right, applications that link to it must be GPL.

That's why we (EMC/Greenplum) switch to libedit, even though readline is 
nicer... We didn't want to ship part of our product as GPL


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Debian readline/libedit breakage

2011-02-11 Thread Charles.McDevitt
 -Original Message-
 From: gsst...@gmail.com [mailto:gsst...@gmail.com] On Behalf Of Greg Stark
 Sent: Friday, February 11, 2011 4:03 PM
 On Fri, Feb 11, 2011 at 11:06 PM,  charles.mcdev...@emc.com wrote:
  The GNU people will never be 100% satisfied by anything you do to psql, 
  other
 than making it GPL.
  Readline is specifically licensed in a way to try to force this (but many 
  disagree
 with their ability to force this).
 
 This is just libelous FUD. There's absolutely no reason postgres would
 have to be GPL'd to satisfy any library license. 

Ok, but be aware that readline is GPL v3, not GPL v2, and has those additional 
requirements.

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Debian readline/libedit breakage

2011-02-11 Thread Charles.McDevitt
 -Original Message-
 From: gsst...@gmail.com [mailto:gsst...@gmail.com] On Behalf Of Greg Stark
 Sent: Friday, February 11, 2011 4:14 PM
 To: McDevitt, Charles
 Cc: sfr...@snowman.net; alvhe...@commandprompt.com;
 g...@2ndquadrant.com; mba...@debian.org; t...@sss.pgh.pa.us;
 and...@dunslane.net; j...@commandprompt.com; pgsql-
 hack...@postgresql.org
 Subject: Re: Debian readline/libedit breakage
 
 On Sat, Feb 12, 2011 at 12:07 AM,  charles.mcdev...@emc.com wrote:
  This is just libelous FUD. There's absolutely no reason postgres would
  have to be GPL'd to satisfy any library license.
 
  Ok, but be aware that readline is GPL v3, not GPL v2, and has those 
  additional
 requirements.
 
 No

What?  From the GNU Readline home page:  Readline is free software, 
distributed under the terms of the GNU General Public License, version 3.

I know it used to be GPLv2, but that isn't true these days.

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Why don't we accept exponential format for integers?

2010-12-17 Thread Charles.McDevitt
  And so does:
  SELECT 1.23e+01::Integer
 
 
   which I find just as dangerous as
   SELECT '1.234e+01'::Integer;
 
  Add quotes to either of the other two, and then they don't work either.
 
 Well, that's stupidly arbitrary.  If we're not going to accept
 '1.234e+01'::Integer, then we shouldn't accept 1.234e+01::Integer either.
 

Isn't this a case of an explicit cast?  Shouldn't our answer to 
1.234e+1::Integer be the same as CAST(1234e+1 AS Integer)?
Which is legal ISO SQL, as far as I can see.

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers