[GENERAL] nodeRead ERROR.

My guess is that the view is overflowing the 8k limit. 6.4 should allow
for larger block sizes.

Dear all,

I have a very long table (i.e. has a lot of columns). I created a couple
of views on this table. They created fine. \d <view_name> yields the
expected results.

However, if I actually perform a select I get:

select * from test;

ERROR: nodeRead: Bad type 0

Furthermore, if I try to drop the views, I get the same error message (and
the views aren't deleted).

Anybody experienced this problem (I have 6.3.2 under IRIX 5.3) or knows of
a way to get rid of these views?

please cc to me as I'm not always up-to-date in my news-reading!

Many thanks,

Stuart.

+-------------------------+--------------------------------------+
| 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@ludwig.ucl.ac.uk | UNITED KINGDOM.                      |
+-------------------------+--------------------------------------+

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

NO! Trying to drop the view yields the same message! v. strange.

[See new posting [GENERAL] more nodeError problems and general view failures!]

S.

You can't even drop the view?

Dear Bruce,

Thanks for that info. Do you know how I can 'over-rule' the error in order
to drop the problematic views?

Thanks also for your work on this mailing list.

Regards,

Stuart.

ERROR: nodeRead: Bad type 0

Furthermore, if I try to drop the views, I get the same error message

(and

the views aren't deleted).

+-------------------------+--------------------------------------+
| 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@ludwig.ucl.ac.uk | UNITED KINGDOM.                      |
+-------------------------+--------------------------------------+

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
+  If your life is a hard drive,     |  (610) 353-9879(w)
+  Christ can be your backup.        |  (610) 853-3000(h)

+-------------------------+--------------------------------------+
| Stuart Rison            | Ludwig Institute for Cancer Research |
+-------------------------+ University College London            |
| Tel. (0171) 878 4041    | 91 Riding House Street               |
| Fax. (0171) 878 4040    | London, W1P 8BT, UNITED KINGDOM.     |
+-------------------------+--------------------------------------+
| stuart@NOJUNK_ludwig.ucl.ac.uk [Remove NOJUNK_ for it to work] |
+----------------------------------------------------------------+