Casting money to numeric(10,2)

I'm using 7.0.2 I think, how can I remove the 8k row limit?

Is this removed in 7.1 ? If so, is it worth trying the beta of that? Or is
there another way to do it?

(I realise this question has probably been asked a hundred times, but I
can't find an answer in any of the online docs)

Cheers,
Mike

____________________________________________________________
Mike Cannon-Brookes - Technology Director, Asia Pacific
internet.com Corporation - The Internet Industry Portal
Ph: (612) 9290 1088 - Mob: 0416 106090

- The Media Network @ http://australia.internet.com
- Meet A Guru @ http://www.breakfastforums.com.au
- Subscribe Online @ http://www.enewsletters.com.au
____________________________________________________________

On Thu, Jan 11, 2001 at 04:25:07PM +1100, Mike Cannon-Brookes wrote:

I'm using 7.0.2 I think, how can I remove the 8k row limit?

You can recompile and up the page size to ~32K, use large objects,
or upgrade to 7.1

Is this removed in 7.1 ? If so, is it worth trying the beta of that? Or is
there another way to do it?

There are others ways (see above), but I'd suggest upgrading. I've
been running 7.1 from CVS for a while now (for development) without
any major problems.

(I realise this question has probably been asked a hundred times, but I
can't find an answer in any of the online docs)

The mailing list archives would probably have lots of answers to this.

HTH,

Neil

--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

You can use facts to prove anything that's even remotely true.
-- Homer J. Simpson

Ben Stringer <ben@magicrock.net> writes:

I'm trying to migrate several tables from a 6.5.2 DB to a
7.0.2 DB, and having trouble casting money (in the old DB)
to numeric(10,2) prior to doing a pg_dump.

Hm. It doesn't seem that there is a cast path from money to anything,
even in latest sources. You might have to resort to dumping the table
as-is, then editing the dump file to change the column type from money
to numeric in the CREATE TABLE (and edit out all the dollar signs and
commas in the data, too). Ugh.

regards, tom lane

Beta 3 of 7.1 has been released. You won't have to worry about the row
limit and you'll also help check for any possible bugs. :)

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Mike Cannon-Brookes" <mcannon@internet.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, January 11, 2001 12:25 AM
Subject: [GENERAL] Removing the row limit