#6373: PostgreSQL Driver should not make assumptions about schema availibility
---------------------------------------+------------------------------------
Reporter: cookiecaper | Owner:
Type: Enhancement | Status: new
Priority: Medium | Milestone: 1.3.x.x
Component: PostgreSQL | Version:
Severity: Normal | Resolution:
Keywords: postgresql schema odbc | Php_version: n/a
Cake_version: |
---------------------------------------+------------------------------------
Comment (by sancho):
My problem was that the PostgreSQL search path is set to the configured
schema name, thus making it essentially useless (its like having a file
search path on the current directory only).
May I suggest, that the search path can be configured independently from
the schema?
The config-entry could look like
{{{
'schema_search_path' => 'schema1,schema2,public'
}}}
and in dbo_postgres.php change
{{{
$this->_execute("SET search_path TO " . $config['schema_search_path']);
}}}
to
{{{
$this->_execute("SET search_path TO " . ($config['schema_search_path'] ?
$config['schema_search_path'] : $config['schema']));
}}}
E voilà, improved functionally while retaining current behaviour
--
Ticket URL: <https://trac.cakephp.org/ticket/6373#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
-~----------~----~----~----~------~----~------~--~---
