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

Issue Details (XML | Word | Printable)

Key:	MDL-14786
Type:	Sub-task
Status:	Resolved
Resolution:	Fixed
Priority:	Major
Assignee:	Petr Skoda
Reporter:	Petr Skoda
Votes:	0
Watchers:	0

Operations

Add/Edit UI Mockup to this issue

If you were logged in you would be able to see more operations.

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

Return to search

Component/s:

Database SQL/XMLDB

Affects Version/s:

2.0

Fix Version/s:

2.0

Participants:	Eloy Lafuente (stronk7) and Petr Skoda
Security Level:	None
Resolved date:	16/May/08
Affected Branches:	MOODLE_20_STABLE
Fixed Branches:	MOODLE_20_STABLE

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:

[ Permalink | « Hide ]

Petr Skoda added a comment - 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..

[ Permalink | « Hide ]

Petr Skoda added a comment - 13/May/08 07:10 AM

workaround in patch

[ Permalink | « Hide ]

Eloy Lafuente (stronk7) added a comment - 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?

[ Permalink | « Hide ]

Petr Skoda added a comment - 16/May/08 02:42 PM

bound params avoided in ddl

All content on this web site is made available under the GNU General Public License, unless otherwise stated.