Re: [GENERAL] Off Topic: Anybody reading this via news.gmane.org?

No problem reading (and hopefully posting) via Gmane here. -- Ian Pilcher arequip...@gmail.com "I grew up before Mark Zuckerberg invented frien

[GENERAL] Range for user-defined SQLSTATE codes

sed 'W' and 'Z' as my tests.) Is there anything like a standard range -- formal or otherwise -- for such codes? A best practice? A general consensus? A half-painted bike shed? Thanks! -- ==========

[GENERAL] Cast double precision to integer & check for overflow

T_MAX, Integer.MAX_VALUE, etc. Do I have to hard-code this value? Thanks! (And yes, I do feel stupid having to ask this question here.) -- ==== Ian Pilcher arequip...@gmail.com Sometimes th

Re: [GENERAL] Cast double precision to integer & check for overflow

rd-code these values, but I'd like to use a more expressive syntax, if it is available. -- ============ Ian Pilcher arequip...@gmail.com Sometimes there's nothing left to do but crash a

[GENERAL] Trust intermediate CA for client certificates

fundamental to the PKI trust model.) Thanks! -- ============ Ian Pilcher arequip...@gmail.com Sometimes there's nothing left to do but crash and

Re: [GENERAL] Trust intermediate CA for client certificates

d to validate it's own certificate? -- ============ Ian Pilcher arequip...@gmail.com Sometimes there's nothing left to do but crash and burn...or die trying. =

Re: [GENERAL] Trust intermediate CA for client certificates

validates certificates, I do not believe that there is any way of achieving the desired behavior with the current codebase. Adding pgsql-hackers to see if there is any interest in a patch to add this functionality. -- Ian Pil

Re: [GENERAL] [HACKERS] Trust intermediate CA for client certificates

enSSL discover it that way, but it looks like > OpenSSL won't use certs it's seen in server.crt when verifying client > cert trust paths. Nope. It's pretty obvious from be-secure.c that only the certificates in root.crt will be used. --

Re: [GENERAL] [HACKERS] Trust intermediate CA for client certificates

is configuration, the test client is able to connect with the "good" client certificate, but it is also able to connect with the "bad" client certificate when it presents a certificate chain that includes the server CA certificate. -- ========

Re: [GENERAL] JDBC Connection Errors

g_hba.conf is set to trust 0.0.0.0/0 (IPv4 only) Does it work with -Djava.net.preferIPv4Stack=true is specified on the client command line (or if the property is otherwise set)? If so, the problem is that many JVMs default to using IPv6 if available. -- ====

Re: [GENERAL] Can't start PostgreSQL on Fedora Core3

-R -v /var/lib/pgsql'. If it suggests changes that appear to make sense, run 'restorecon -R -v /var/lib/pgsql'. HTH -- ======== Ian Pilcher

Re: [GENERAL] Can't start PostgreSQL on Fedora Core3

dated. -- ==== Ian Pilcher[EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubs

[GENERAL] Loopback IDENT authentication broken in FC4

Just a friendly warning that FC4's targeted SELinux policy breaks PostgreSQL IDENT authentication across the loopback interface. Details at: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=161383 -- ==== Ian Pi

Re: [GENERAL] UTF-8 -> ISO8859-1 conversion problem

inly veiled racism of their constituents. Ian Pilcher ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match