Phinx - database migrations for php app - postgreSQL schema does not work

Question

I'm using Phinx for databse migrations.

It's not workig with PostgreSQL schemas in my case (example test.table).

// create the table
$table = $this->table('test.table');
$table->addColumn('test', 'integer')
      ->create();

When i hit phinx migrate it causes an arror. Is there any solutions for that?

My error is:

--> IMAGE ERROR

The error is: Syntax error or within "."

Does Phinx supports dot notation in the tablemethod?

Did you specify the pgsql adapter per the documentation? http://docs.phinx.org/en/latest/configuration.html#supported-adapters — Jeremy Harris, Aug 05 '16 at 14:24
@JeremyHarris, Yes i did. It works with public schema, with others not. — Piotr, Aug 05 '16 at 14:26

Piotr · Answer 1 · 2016-10-06T12:42:31.280

3

I found alternative solution. Before changes in the table, I manualy selected PostgreSQL schema.

// changing schema
$this->getAdapter()->setOptions(array_replace($this->getAdapter()->getOptions(), ['schema' => 'your_schema']));

// create the table
$table = $this->table('test_table');
$table->addColumn('test', 'integer')
            ->create();

edited Oct 06 '16 at 12:42

answered Sep 12 '16 at 10:19

Piotr

1,777
17
24

score 0 · Answer 2 · edited Aug 05 '16 at 14:29

0

Are you sure you can use dot notation in the table name like that?

// create the table
$table = $this->table('test_table');
$table->addColumn('test', 'integer')
    ->create();

test.table would follow the pattern databasename.tablename

edited Aug 05 '16 at 14:29

Jeremy Harris

24,318
13
79
133

answered Aug 05 '16 at 14:27

Carl Casbolt

102
6

1

In postgreSQL dot notation follows: `schema.tablename` – Piotr Aug 05 '16 at 14:31

Phinx - database migrations for php app - postgreSQL schema does not work

2 Answers2