| From: | Boszormenyi Zoltan <zb(at)cybertec(dot)at> |
|---|---|
| To: | pgsql-hackers(at)postgreSQL(dot)org |
| Cc: | Hans-Juergen Schoenig <hs(at)cybertec(dot)at> |
| Subject: | TEXT vs PG_NODE_TREE in system columns (cross column and expression statistics patch) |
| Date: | 2011-04-28 14:03:56 |
| Message-ID: | 4DB973CC.7070204@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
attached is the WIP patch for cross-column statistics and
extra expression statistics.
My question is that why pg_node_tree is unusable as
syscache attribute? I attempted to alias it as text in the patch
but I get the following error if I try to use it by setting
USE_SYSCACHE_FOR_SEARCH to 1 in selfuncs.c.
Directly using the underlying pg_statistic3 doesn't cause an error.
zozo=# select * from t1 where i+1 = 5;
ERROR: could not determine which collation to use for string comparison
HINT: Use the COLLATE clause to set the collation explicitly.
The table looks like this:
create table t1 (id serial primary key, t text, i integer);
Best regards,
Zoltán Böszörményi
--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
http://www.postgresql.at/
| Attachment | Content-Type | Size |
|---|---|---|
| cross-column-v10.patch | text/plain | 90.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-04-28 14:04:26 | Re: Extension Packaging |
| Previous Message | Andrew Dunstan | 2011-04-28 14:03:36 | Re: unknown conversion %m |