[#MDL-14786] pgsql does not support bound queries in field default values

Moodle

MDL-14679

pgsql does not support bound queries in field default values

Created: 12/May/08 01:14 AM Updated: 16/May/08 02:42 PM

Component/s:

Database SQL/XMLDB

Affects Version/s:

2.0

Fix Version/s:

2.0

Participants:	Eloy Lafuente (stronk7) and Petr Škoda
Security Level:	None

Description

« Hide

nice one! pg does not support $1 when defining field defaults
solution:
* do not allow [$:?] in field defaults (and enums maybe too) - there is only one in timezone table "00:00"
* report and wait
* emulate bound query params - grrrr

All

Comments

Change History

Version Control

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Petr Škoda - 12/May/08 04:53 AM

I might have better solution, going to hack pg $DB->execute() so that it detects table modifications and emulates bound queries..

[ Permlink | « Hide ]

Petr Škoda - 13/May/08 07:10 AM

workaround in patch

[ Permlink | « Hide ]

Eloy Lafuente (stronk7) - 16/May/08 07:07 AM

I guess this was fixed by avoiding bounds in DDL stuff correct? As we discussed in chat (long execute.... named function). Or not?

[ Permlink | « Hide ]

Petr Škoda - 16/May/08 02:42 PM

bound params avoided in ddl