#6147: Using console script to update a Postgres database fails with syntax
error
-----------------------------+----------------------------------------------
Reporter: chrisbdaemon | Owner: mark_story
Type: Bug | Status: assigned
Priority: Medium | Milestone: 1.2.x.x
Component: PostgreSQL | Version: 1.2 Final
Severity: Normal | Resolution:
Keywords: | Php_version: PHP 5
Cake_version: 1.2.1.8004 |
-----------------------------+----------------------------------------------
Comment (by chrisbdaemon):
Yes. I was looking at the Postgres docs and it says that serial is
equivolent to typing out "integer DEFAULT nextval('tablename_colname_seq')
NOT NULL" and creating the sequence. Which now that I think of it perhaps
should be done manually?
[[BR]][[BR]]
The problem with "NOT NULL" is that it looks like you have to use "ALTER
columnname SET NOT NULL" Its the same with default, the default value
appears to be set with "ALTER columnname SET DEFAULT somevalue" instead of
"ALTER columnname TYPE sometype DEFAULT somevalue"
--
Ticket URL: <https://trac.cakephp.org/ticket/6147#comment:3>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
