Bug or Feature?
От | Olivier PRENANT |
---|---|
Тема | Bug or Feature? |
Дата | |
Msg-id | Pine.UW2.4.21.0203041016300.9349-100000@server.pyrenet.fr обсуждение исходный текст |
Ответы |
Re: Bug or Feature?
|
Список | pgsql-hackers |
Hi all, I'm in the process of switching frrom 7.1.3 to 7.2. The only problem I have so far is the definition of an index. The table contains a timestamp column. In 7.1.3 an index is defined as such: CREATE INDEX deb ON xxxx USING btree (date(timestamp coll) date_ops); on 7.2 I have an error message saying that functrional indexes must but made ISCACHABLE. Now should date() be made iscachable, do I have an other way to create trhis index? CAST did'nt wok. TIA Regards, -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)
В списке pgsql-hackers по дате отправления: