Re: Reviewed: max. no of relations in a database

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ralph Graulich <maillist(at)shauny(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: Reviewed: max. no of relations in a database
Date: 2002-08-05 09:22:59
Message-ID: 200208051022.59067.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday 03 Aug 2002 12:52 am, Ralph Graulich wrote:

> The problem only occures with loads of data (just inserting dummy data to
> the tables didn't show the problem!). Second, the problem only occures if
> there are lots of long relation names. As I changed all the relation names
> to shorter and less descriptive ones, the problem magically disappeared.

Missed the discussion a couple of days ago, but you weren't exceeding the
31-char length for table-names etc?

Might be worth a quick check. If you need to change this there's a constant in
a header file that needs to be changed and a recompile - see archive for
details.

- Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christian Imbeault 2002-08-05 09:48:16 multi-column primary key insert error ('duplicate' complaint)
Previous Message Jeff Davis 2002-08-05 09:20:50 Re: O'Reilly Open Source Convention Report