| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.5.0b4 |
| Bug #7731 | PostgreSQL - alterTable | ||
|---|---|---|---|
| Submitted: | 2006-05-26 10:12 UTC | ||
| From: | decombe at unisolution dot de | Assigned: | lsmith |
| Status: | Closed | Package: | MDB2_Driver_pgsql (version 2.0.3) |
| PHP Version: | 4.3.10 | OS: | Suse 9.3 |
| Roadmaps: | (Not assigned) | ||
[2006-05-26 10:12 UTC] decombe at unisolution dot de
(Chris)
Description:
------------
I wanted to use MDB2 to modify a Columnsize in my Database PostgreSQL. I use the function alterTable. PostgreSQL give back a error because the Query is false.
MDB2 2.0.3 stable
MDB2_Driver_mysql 1.0.3 stable
MDB2_Driver_pgsql 1.0.3 stable
MDB2_Schema 0.5.0 beta
Test script:
---------------
$table = 'data_users';
$change = Array ( [change] => Array ( [user_version] => Array ( [type] => text [definition] => Array ( [type] => text [length] => 10 ) ) ) ) ;
$this->manager->alterTable($table, $change, false);
Actual result:
--------------
_doQuery: Could not execute statement[Native message: ERROR: parser: parse error at or near "TYPE" at character 43 ] mdb2_error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -2
Query - ALTER TABLE data_users ALTER user_version TYPE VARCHAR(10)
Comments
[2006-05-26 10:25 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-05-26 10:34 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-05-26 10:41 UTC] decombe at unisolution dot de
Ok. what do you mean exactly ? Will you modify the function for the code to work with my version of PostgreSQL or do you only write a meaningful error ?
For which dedicated version of Pgsql are you developping the functions ?
[2006-05-26 10:44 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-05-31 14:40 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!