Hello to all.
I have an application that uses postgresql-8.1, but the tables are in
different schemes.
The tables that in the scheme public, work perfectly, but the other
does not work.
>From a console of postgresql I can accede with the following annotation
select * from [schema_name].[table_name]
select * from [table_name] (when the table belongs to the scheme
'public')
I have proven different solutions but nonprofit that works, for
example:
In the postgresql:
CREATE TABLE instituciones.iininstitucion
(
id_iininstitucion int4 NOT NULL DEFAULT
nextval('iininstitucion_id_iininstitucion_seq'::regclass),
id_iindireccion int4,
id_itisubsubtipoinstitucion int4,
...
In the model:
class IinInstitucion extends AppModel {
var $name = 'iininstitucion';
var $useTable = 'instituciones.iininstitucion';
var $primaryKey = 'id_iininstitucion';
var $displayField = "descripcion";
}
it throws the following error:
Missing Database Table
No Database table for model iininstitucion (expected
"instituciones.iininstitucion"), create it first.
Also it adds the following configuration in the server of database with
the same error:
ALTER DATABASE desarrollo SET search_path=pg_catalog, instituciones;
This is still bug or the functionality for schemas in postgresql not
this supported?
thanks
--
Ariel Santana
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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/cake-php
-~----------~----~----~----~------~----~------~--~---
