Re: Problems with your patch (Sorry).

I now no longer get the badNode error message but the query does not work:

testing=> create table test (
testing-> number int2,
testing-> in_words text
testing-> );
CREATE
testing=> insert into test values (1,'one');
INSERT 147786 1
testing=> insert into test values (2,'two');
INSERT 147787 1
testing=> insert into test values (3,'three');
INSERT 147788 1
testing=> insert into test values (4,'four');
INSERT 147789 1
testing=> select * from test;
number|in_words
------+--------
1|one
2|two
3|three
4|four
(4 rows)

testing=> create view on_test as select *,number * number as "Number
Squared" >from test;
CREATE
testing=> select * from on_test;
number|in_words|Number Squared
------+--------+--------------
| |
(1 row)

testing=> select *,number * number as "Number Squared" from pants;

This user already runs a patched 6.3.2 for the AS fix above.

number|in_words|Number Squared
------+--------+--------------
1|one | 1
2|two | 4
3|three | 9
4|four | 16
(4 rows)

Is this a patch thing (i.e. I applied incorrectly) or did the patch not
work for me?

Best regards,

I think you did it right. Looks like we have a problem with views:

test=> create view xxyz as select usesysid * usesysid from pg_shadow;
CREATE
test=> select * from xxyz;
?column?
--------

(1 row)

I will add to TODO list. The view/rewrite system is being overhauled by
Jan, hopefully for 6.4.

-- 
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)