[CakePHP : The Rapid Development Framework for PHP] #5867: Postgres schema execution incorrectly handles primary key

[CakePHP : The Rapid Development Framework for PHP]

#5867: Postgres schema execution incorrectly handles primary key
--------------------------------------------+-------------------------------
    Reporter:  chrisbdaemon                 |          Type:  Bug       
      Status:  new                          |      Priority:  Medium    
   Milestone:  1.2.x.x                      |     Component:  PostgreSQL
     Version:  RC3                          |      Severity:  Normal    
    Keywords:  postgres schema primary key  |   Php_version:  PHP 5     
Cake_version:  1.2.0.7692 RC3               |  
--------------------------------------------+-------------------------------
 Using console script with "schema run create" incorrectly handles primary
 key and renders this query:


 {{{
 CREATE TABLE "test" (
         "testcase" serial NOT NULL,
         PRIMARY KEY  ()
 );
 }}}

 Which causes PostgreSQL to choke on a syntax error. It should create a
 query similar to this:


 {{{
 CREATE TABLE "test" (
         "testcase" serial NOT NULL PRIMARY KEY
 );
 }}}

 or this:


 {{{
 CREATE TABLE "test" (
         "testcase" serial NOT NULL,
         PRIMARY KEY  (testcase)
 );
 }}}

 Attached is generated schema and sql query used to create test case for
 reproducing the problem.

-- 
Ticket URL: <https://trac.cakephp.org/ticket/5867>
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 tickets-cakephp@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---