BUG #4402: Column expansion: date comes wthout a cast
| От | Joachim Unger |
|---|---|
| Тема | BUG #4402: Column expansion: date comes wthout a cast |
| Дата | |
| Msg-id | 200809050537.m855bdSv058698@wwwmaster.postgresql.org обсуждение |
| Ответы |
Re: BUG #4402: Column expansion: date comes wthout a cast
|
| Список | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4402
Logged by: Joachim Unger
Email address: jo.unger@arcor.de
PostgreSQL version: 8.3
Operating system: Windwos XP Professional 32 Bit
Description: Column expansion: date comes wthout a cast
Details:
The column expansion lists date types without a date cast.
Here is an example where I'm using NEW inside a trigger:
[...]
ins_sql := 'INSERT INTO ' || quote_ident(new_child_table) || '('
||col_names(new_child_table) || ') VALUES ' || NEW;
RAISE NOTICE 'INSERT: %',ins_sql;
EXECUTE ins_sql;
[...]
Execution of the generated SQL throws an error:
ERROR: column "adate" is of type date but expression is of type integer
LINE 1: INSERT INTO table_2008_1(id,adate) VALUES (1,2008-01-30)
HINT: You will need to rewrite or cast the expression.
That hint describes exactly what is missing:(1,DATE '2008-01-30')
В списке pgsql-bugs по дате отправления: