How to set the default schema of postgres?
Looks like the Phalcon always defines the public schema:
'database' => array(
'adapter' => 'Postgres',
'host' => 'localhost',
'username' => 'user',
'password' => 'password',
'dbname' => 'mydb',
'schema' => 'mySchema', // doesn't work <--- ERROR HERE
),That option is the way to go:
https://github.com/phalcon/cphalcon/blob/master/unit-tests/config.db.php#L16
But my schema is not "public"
My problem is how to set postgres in a different schema "public"
That option is the way to go:
https://github.com/phalcon/cphalcon/blob/master/unit-tests/config.db.php#L16
See this problem: https://stackoverflow.com/questions/23553375/database-adapter-not-setting-schemas-in-phalcon
If 'schema' is defined, it changes the current schema in the connection to that value: https://github.com/phalcon/cphalcon/blob/1.3.3/ext/db/adapter/pdo/postgresql.c#L144-L148
If 'schema' is defined, it changes the current schema in the connection to that value: https://github.com/phalcon/cphalcon/blob/1.3.3/ext/db/adapter/pdo/postgresql.c#L144-L148
but not working
not working!!!
Same here not working
Temporary solution. Define in all models
public function initialize(){
$this->getModelsManager()->setModelSchema($this, 'YourSchemaName');
/*...*/}