Skip to content

PostgreSQL: Initial setup of database leads to an error #311

@frlan

Description

@frlan
$ bin/doctrine2-cli.php orm:schema-tool:create

 !                                                                                               
 ! [CAUTION] This operation should not be executed in a production environment!                  
 !                                                                                               

 Creating database schema...


In ToolsException.php line 35:
                                                                                                
  Schema-Tool failed with Error 'An exception occurred while executing 'CREATE TABLE dbversion  
   (id INT NOT NULL, version INT NOT NULL, name VARCHAR(255) NOT NULL, applied_on TIMESTAMP(0)  
   WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))':                                               
                                                                                                
  SQLSTATE[42P07]: Duplicate table: 7 FEHLER:  Relation »dbversion« existiert bereits' while e  
  xecuting DDL: CREATE TABLE dbversion (id INT NOT NULL, version INT NOT NULL, name VARCHAR(25  
  5) NOT NULL, applied_on TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))             
                                                                                                

In AbstractPostgreSQLDriver.php line 85:
                                                                                                
  An exception occurred while executing 'CREATE TABLE dbversion (id INT NOT NULL, version INT   
  NOT NULL, name VARCHAR(255) NOT NULL, applied_on TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PR  
  IMARY KEY(id))':                                                                              
                                                                                                
  SQLSTATE[42P07]: Duplicate table: 7 FEHLER:  Relation »dbversion« existiert bereits  

(Relation »dbversion« existiert bereits = Relation already exists)

Source from composer

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions