RewriteDefine.c : Rule size
От | Olivier Ertz |
---|---|
Тема | RewriteDefine.c : Rule size |
Дата | |
Msg-id | 3784CE8B.9E412BB3@illite.u-strasbg.fr обсуждение исходный текст |
Ответы |
Re: [SQL] RewriteDefine.c : Rule size
|
Список | pgsql-sql |
Hello, I'm using Postgres 6.4.2. I want to create a view, but a message appear :ERROR: DefineQueryRewrite: rule plan string too big. What could be the solution to avoid the problem? In fact, I have 31 columns in a table, and i want to make a view on this table (with a line restrict = WHERE clause). I watched the RewriteDefine.c code and saw : #define RULE_PLAN_SIZE BLCKSZ I thought changing the value of this size, but I don't find the place to modify the BLCKSZ value. But, before doing the modification and recompile, I would like to have your opinion on the problem...perhaps is there an easier way to resolve the problem. Thank you for answering -- ERTZ Olivier - ertz@illite.u-strasbg.fr - Tel 03 88 35 85 87 ------------------------------------------------------------ Etudiant DESS Informatique | Stagiaire EOST/ULP-CGS UniversiteLouis Pasteur | Ecole et Observatoire des STRASBOURG - France | Sciences de la Terre ------------------------------------------------------------ World Wide Web : http://dess-info.u-strasbg.fr/~ertz ------------------------------------------------------------
В списке pgsql-sql по дате отправления: