From: | "Alexander Zhiltsov" <ayz(at)ems(dot)ru> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Bug in PostrgeSQL 8.0beta |
Date: | 2004-10-01 08:46:33 |
Message-ID: | 003801c4a793$275b6a30$2742a8c0@office.ems.chel.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello,
I downloaded and install postgresql-8.0.0beta3.tar.gz
I create the following table:
CREATE OR REPLACE FUNCTION "ayz"."my_lower" (text) RETURNS text AS'
BEGIN
return lower($1);
END;
'LANGUAGE 'plpgsql' IMMUTABLE RETURNS NULL ON NULL INPUT SECURITY INVOKER;
CREATE TABLE public.art
(
art_id int4 NOT NULL,
art_name "varchar"(60),
art_costin "numeric"(15,2),
art_costout "numeric"(15,2),
rem "varchar"(60),
art_country_name "varchar"(25),
art_firm_name "varchar"(35),
art_price_name "varchar"(100) DEFAULT 'wwww'::character varying,
CONSTRAINT art_pkey PRIMARY KEY (art_id)
)
WITH OIDS;
CREATE INDEX art_art_name_idx
ON public.art
USING btree
(my_lower(art_name::text));
ALTER TABLE public.art CLUSTER ON art_art_name_idx;
Executing the following query return an error 'ERROR: unrecognized node type: 656'.
SELECT pg_get_expr(i.indexprs, i.indrelid) AS expr
FROM pg_index i
INNER JOIN pg_class c ON i.indrelid = c.oid
WHERE c.relname = 'art'
Expression tree is
({FUNCEXPR :funcid 4061872 :funcresulttype 25 :funcretset false :funcformat 0 :args ({RELABELTYPE :arg {VAR :varno 1 :varattno 2 :vartype 1043 :vartypmod 64 :varlevelsup 0 :varnoold 1 :varoattno 2} :resulttype 25 :resulttypmod -1 :relabelformat 1})})
Thanks,
Alexander
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan | 2004-10-01 14:13:35 | pg_dumpall fails |
Previous Message | Michael Fuhr | 2004-10-01 06:23:25 | Re: BUG #1274: Trigger sequence incorrect |