nothing show-stopping, but something I found by accident:
test=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.3.1 on i386-unknown-freebsd4.7, compiled by GCC 2.95.4
(1 row)
test=# create table foo (bar int);
CREATE TABLE
test=# update foo set foo=1 where foo=1;
ERROR: exprType: Do not know how to get type for 711 node
Only occurs when the column name used in the WHERE clause
is the same as the table name but does not exist in the table.
I would have expected a message more like this:
test=# update foo set foo=1 ;
ERROR: Relation "foo" has no column "foo"
Ian Barwick
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
