From: | Michael Ansley <Michael(dot)Ansley(at)intec-telecom-systems(dot)com> |
---|---|
To: | sqllist <pgsql-sql(at)postgresql(dot)org>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Object syntax |
Date: | 2000-10-05 13:19:40 |
Message-ID: | 7F124BC48D56D411812500D0B7472514061460@fileserver002.intecsystems.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Given the following table definitions, and data inserts:
dev=# create address (addr varchar(50), postcode varchar(9));
dev=# create client (name varchar(30), addr address);
dev=# insert into client values ('Michael');
dev=# insert into address values ('11 Windsor Close', 'RH16 4QR');
INSERT 18935 1
dev=# update client set addr = 18935::address;
dev=# explain select client.addr.postcode from client;
NOTICE: QUERY PLAN:
Seq Scan on client (cost=0.00..1.01 rows=1 width=4)
EXPLAIN
dev=# select client.addr.postcode from client;
ERROR: init_fcache: Cache lookup failed for procedure 18935
What's happening here? Bug, or am I doing something wrong?
Cheers...
From | Date | Subject | |
---|---|---|---|
Next Message | Jono | 2000-10-05 13:23:06 | Oracle to POSTGRESQL |
Previous Message | Jan Wieck | 2000-10-05 12:38:46 | Re: VIEW problem |
From | Date | Subject | |
---|---|---|---|
Next Message | Didier Boudigue | 2000-10-05 13:47:41 | JDBC and BLOB in Postgres |
Previous Message | Craig May | 2000-10-05 06:07:56 | createuser |