Re: [GENERAL] createdb argument question

2007-10-27 Thread Seneca Cunningham
On Sat, Oct 27, 2007 at 12:56:37PM -0500, Perry Smith wrote: > On my Mac systems, this work. On my AIX system it does not. I get: > > createdb dog -E utf8 > createdb: too many command-line arguments (first is "utf8") > Try "createdb --help" for more information. > > Has anyone else bumped in to

Re: [GENERAL] Q re installing Pg on OS X?

2007-04-15 Thread Seneca Cunningham
On Sun, Apr 15, 2007 at 06:18:18PM -0400, Kynn Jones wrote: > OK, I found the answer to my question about the "roles" error. > Still, it would be nice to have more up-to-date instructions on how to > install PostgreSQL on OS X. Any pointers would be much appreciated! Try the main documentation at

Re: [GENERAL] OS X Tiger, and PostgreSQL 8.2 don't mix?

2007-01-02 Thread Seneca Cunningham
On Tue, Jan 02, 2007 at 10:12:56AM -0700, Scott Ribe wrote: > > /etc/rc is what causes the values from /etc/sysctl.conf to be read in > > and used. Some values, such as the shm-related values are specified in > > the default /etc/rc after /etc/sysctl.conf is parsed up by /etc/rc and > > applied, b

Re: [GENERAL] OS X Tiger, and PostgreSQL 8.2 don't mix?

2006-12-30 Thread Seneca Cunningham
On Thu, Dec 28, 2006 at 09:11:24AM -0700, Scott Ribe wrote: > > and > > added the appropriate items to /etc/sysctl.conf > > 1) The location may be out of date. Don't add to /etc/sysctl.conf; edit the > values already in /etc/rc. Where you set these values has shifted around > somewhat in OS X rele

Re: [GENERAL] strange sum behaviour

2006-08-29 Thread Seneca Cunningham
Your double sum looks to be a normal error for floats in that situation. Take a look at <http://www2.hursley.ibm.com/decimal/decifaq.html> for some information about why you should be using numeric for your amount column. -- Seneca Cunningham [EMAIL PROTECTED] ---

Re: [GENERAL] More AIX 5.3 fun - out of memory ?

2006-03-29 Thread Seneca Cunningham
Gavin Hamill wrote: Seneca Cunningham wrote: You're using a 32-bit build with the default memory model, it would seem. You're limited to less than 256MB for the heap in that model. Try stopping the postmaster and starting it back up with the environment variable LDR_CNTRL set t

Re: [GENERAL] More AIX 5.3 fun - out of memory ?

2006-03-28 Thread Seneca Cunningham
edbook "Developing and Porting C and C++ Applications on AIX"[2] goes into all the gory details of what's happening. [1] http://publib.boulder.ibm.com/infocenter/pseries/topic/com.ibm.aix.doc/aixprggd/genprogc/lrg_prg_support.htm [2] http://www.redbooks.ibm.com/abstracts/sg245674

Re: [GENERAL] pg 8.1.3 on AIX

2006-03-22 Thread Seneca Cunningham
ature of this matter could have been better expressed in the FAQ by using something other than unadorned numbers to label the options. They're options, not steps) -- Seneca Cunningham [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Encoding errors when upgrading from 7.4 to 8.1

2006-01-26 Thread Seneca Cunningham
gt; > Does anybody have any ideas why this is failing in 8.1.2? 8.1 changed UTF-8 handling to be more strict about invalid sequences. You may want to read the 8.1.0 release notes. <http://www.postgresql.org/docs/8.1/interactive/release-8-1.html> -- Seneca Cunningham [EMAIL PROTECTED] -

Re: [GENERAL] out of memory during query execution

2005-12-21 Thread Seneca Cunningham
27;s from, "Developing and Porting C and C++ Applications on AIX": <http://www.redbooks.ibm.com/redbooks/SG245674/> -- Seneca Cunningham [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] out of memory during query execution

2005-12-20 Thread Seneca Cunningham
s compiler to test with. I would be interested in seeing the errors output by the 64-bit gcc build if another build is attempted. -- Seneca Cunningham [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please se

Re: [GENERAL] out of memory during query execution

2005-12-19 Thread Seneca Cunningham
x64" LDFLAGS="-Wl,-bbigtoc" ./configure You'll also want to export OBJECT_MODE=64 before the ./configure line. -- Seneca Cunningham [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org