History | Log In     View a printable version of the current page.  
We are currently focused especially on Moodle 2.0, Moodle 1.9.x bugs and Moodle 1.9.x testing.    Confused? Lost? Please read this introduction to the Tracker.
Issue Details (XML | Word | Printable)

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

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
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
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..

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

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?

Petr Škoda - 16/May/08 02:42 PM
bound params avoided in ddl