#6373: PostgreSQL Driver should not make assumptions about schema availibility
---------------------------------------+------------------------------------
Reporter: cookiecaper | Type: Enhancement
Status: new | Priority: Medium
Milestone: 1.2.x.x | Component: General
Version: 1.2 Final | Severity: Normal
Keywords: postgresql schema odbc | Php_version: n/a
Cake_version: |
---------------------------------------+------------------------------------
The current code for the PostgreSQL driver both resets search_path and
includes WHERE conditions restricting results to the specified schema.
This should not happen; schemas in PostgreSQL are a purely organizational
structure, intended for humans more than machines, and Cake should not
assume that data within the specified schema is the only data it should
access.
Ideally, you should not reset search_path on the opening of the session.
This is a role-level configuration variable on the database side, and it
should be respected.
For instance, PostGIS imports 670-some stored functions, and some people
want these accessible but don't want to traverse 670 + custom functions
every time; it's easier to break that out into a schema.
Find attached a short diff against latest stable that half-corrects this
issue by allowing the user to specify multiple schemas within his config
files and have that setting respected.
--
Ticket URL: <https://trac.cakephp.org/ticket/6373>
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
tickets-cakephp+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
