From: | Ralph Graulich <maillist(at)shauny(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: max relations in a single database |
Date: | 2002-07-22 14:52:14 |
Message-ID: | Pine.LNX.4.21.0207221645170.15547-100000@shauny.shauny.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Tom,
> Have you tried running the regression tests on your installation?
Meanhwilst I did a fresh compile with the changes involved and ran a
regression test with no unusual errors showing up. Imported the dumpfile
again gives me the same errors as before.
As the dumpfile is plain ASCII text, I used vi to edit the names of the
views by hand. I changed their names to be a good amount below the margin
of 30 or whatever characters, just using abbreviations.
Then I reimported without any problems.
So far I tracked down it must have something to do with the following
things in combination:
- long view names using complete ave space for their names
- names of the views only differing in the last char
(e.g. ...year_2000, ...year_2001, ...year_2002)
- and only if you're using views on views
(e.g. view_all as union of the single years' views)
- only if a fair amount of relations is already defined
(maybe 254 was just by accident)
Currently trying to tear the database apart and trying to build a test
suite for it.
Kind regards & thanks for your help so far
... Ralph ...
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2002-07-22 14:56:00 | Re: Windows - why not? |
Previous Message | Devrim GUNDUZ | 2002-07-22 14:43:05 | Re: Windows - why not? |