From: | Stuart Rison <stuart(at)ludwig(dot)ucl(dot)ac(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | [GENERAL] ERROR: DefineQueryRewrite. |
Date: | 1998-07-06 12:36:23 |
Message-ID: | l03110706b1c6734cbc90@[128.40.242.190] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear all,
I'm having trouble with a very long (i.e. a lot of columns) table.
I am trying to create a view on this tablke that will select approximately
30 columns and alias them (alias as in select rep_mal_insitu_ductal as
"ductal").
The column names are very long (hence the need to alias). When I try and
create the view I get:
ERROR: DefineQueryRewrite: rule plan string too big.
However, if I cut off some of the columns in the 'create view' statement,
it works fine (i.e. it's not a syntax problem).
I've tried getting around this by writting an sql script and running it
using \i but I get the same problem. I'm running 6.3.2 under IRIX 5.3.
Is there a way around or am I going to have to redesign my tables.
Thanks for any help you may provide.
Cheers,
Stuart.
PS. Please cc a copy of your answer to me.
+-------------------------+--------------------------------------+
| Stuart Rison | Ludwig Institute for Cancer Research |
| Tel. (0171) 878 4041 | Courtauld Building |
| Fax. (0171) 878 4040 | 91 Riding House Street |
+-------------------------+ London, W1P 8BT |
| stuart(at)ludwig(dot)ucl(dot)ac(dot)uk | UNITED KINGDOM. |
+-------------------------+--------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Corell | 1998-07-06 12:55:33 | |
Previous Message | Stuart Rison | 1998-07-06 12:27:49 | [GENERAL] nodeRead ERROR. |