Re: max relations in a single database
От | Ralph Graulich |
---|---|
Тема | Re: max relations in a single database |
Дата | |
Msg-id | Pine.LNX.4.21.0207221645170.15547-100000@shauny.shauny.de обсуждение исходный текст |
Ответ на | Re: max relations in a single database (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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 ...
В списке pgsql-general по дате отправления: