Re: [GENERAL] IEEE 754-2008 decimal numbers

2010-10-10 Thread Darren Duncan
Craig Ringer wrote: On 10/11/2010 04:46 AM, Thomas Munro wrote: Has anyone done any work on IEEE 754-2008 decimal types for PostgreSQL? I haven't seen any discussion. Perhaps you should ask on pgsql-hackers@ as well, as some folks who might've tried it read that list but not this one. I c

Re: [GENERAL] IEEE 754-2008 decimal numbers

2010-10-10 Thread Craig Ringer
On 10/11/2010 04:46 AM, Thomas Munro wrote: Has anyone done any work on IEEE 754-2008 decimal types for PostgreSQL? I haven't seen any discussion. Perhaps you should ask on pgsql-hackers@ as well, as some folks who might've tried it read that list but not this one. I couldn't find anythin

[GENERAL] IEEE 754-2008 decimal numbers

2010-10-10 Thread Thomas Munro
Hi Has anyone done any work on IEEE 754-2008 decimal types for PostgreSQL? I couldn't find anything, so I was thinking it might be a fun exercise for learning about extending PostgreSQL with user defined types. My first goal is to be able to store decimal numbers with a smaller disk footprint th

Re: [GENERAL] rotate psql output

2010-10-10 Thread Ben Carbery
For the record, I did find a way to do with another application.. mathematica makes it fairly trivial: Say a query such as: data = SQLSelect[someconnection,"sometable"] Printing it: TableForm[data] Then simply: Transpose[TableForm[data]]

Re: [GENERAL] Postgres won't start after setting ssl=on

2010-10-10 Thread Scott Marlowe
Postgres cannot run as root. On Sun, Oct 10, 2010 at 9:40 AM, Rob Sargent wrote: > Does postgres run as root or as the postgres user. I suspect you want > postgres to own that file. > > Mike Christensen wrote: >> >> Hi, I'm trying to require SSL for Postgres connections from certain >> IPs..  Thi

Re: [GENERAL] Postgres won't start after setting ssl=on

2010-10-10 Thread Rob Sargent
Does postgres run as root or as the postgres user. I suspect you want postgres to own that file. Mike Christensen wrote: Hi, I'm trying to require SSL for Postgres connections from certain IPs.. This is on Postgres 9.0. First, I've followed the directions at: http://www.postgresql.org/docs/9

AAi.}c\1Re: [GENERAL] Postgres won't start after setting ssl=on

2010-10-10 Thread issinyeung
coh乡w Mike Christensen 编写: >While I do appreciate the vote of confidence, rest assured you will >never see a post from me that starts with "So I've been hacking the pg >code and..." > >On Sat, Oct 9, 2010 at 11:54 PM, Scott Marlowe wrote: >> On Sat, Oct 9, 2010 at 10:04 PM, Darren Duncan >> wr

Re: [GENERAL] Postgres won't start after setting ssl=on

2010-10-10 Thread Mike Christensen
While I do appreciate the vote of confidence, rest assured you will never see a post from me that starts with "So I've been hacking the pg code and..." On Sat, Oct 9, 2010 at 11:54 PM, Scott Marlowe wrote: > On Sat, Oct 9, 2010 at 10:04 PM, Darren Duncan > wrote: >> The owner of these new files