Postgres planner bug in 7.3.x and 7.4.1 ?
От | Laurent Perez |
---|---|
Тема | Postgres planner bug in 7.3.x and 7.4.1 ? |
Дата | |
Msg-id | 6.0.0.22.2.20040109104428.03eac7a8@pop3.free.fr обсуждение исходный текст |
Ответы |
Re: Postgres planner bug in 7.3.x and 7.4.1 ?
|
Список | pgsql-general |
Hello We're experiencing weird behaviours with both Postgres 7.3.x and 7.4.1 versions, relating to views based on views including fields based upon plpgsql functions. Attached is a .sql file showing our problems, from a co-worker who doesn't have immediate access to this mailing list. Here's the psql output on a 7.4.1 version (t1, t2 already created), showing the function being called : postgres@msi:/$ psql -p5433 -d t2g_3 -f /tmp/t1.sql You are now connected as new user postgres. psql:/tmp/t1.sql:32: ERROR: function "plpgsql_call_handler" already exists with same argument types psql:/tmp/t1.sql:35: ERROR: language "plpgsql" already exists CREATE FUNCTION CREATE VIEW CREATE VIEW CREATE VIEW CREATE VIEW psql:/tmp/t1.sql:284: NOTICE: f1 >>>>>>>> 8980 psql:/tmp/t1.sql:284: NOTICE: f1 >>>>>>>> 8981 psql:/tmp/t1.sql:284: NOTICE: f1 >>>>>>>> 8982 num_adr | num_person | firstname | name ---------+------------+-----------+------ 6231 | 8982 | Chico | Marx (1 row) num_adr | num_person | firstname | name ---------+------------+-----------+------ 6231 | 8982 | Chico | Marx (1 row) Thanks for any support laurent --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.545 / Virus Database: 339 - Release Date: 27/11/2003
Вложения
В списке pgsql-general по дате отправления: