I assume in that case you'll need to create a model for your join
table (which is otherwise created for you)...
and specify which schema (db) it uses.
Otherwise, if you can, move them all to the same schema.
On Nov 25, 7:55 am, Antônio Marco <[EMAIL PROTECTED]> wrote:
> Thanks, teknoid!
>
> But now I'm having a new problem... My applications uses tables
> separated in different schemas. These tables are related one each
> other as shown above.
>
> I'm trying the HBTM association between "geo.plots" and
> "dme.addresses" tables. I created the "geo.addresses_plots" table but
> when I run my application I receives the message bellow:
>
> Warning (2): pg_query() [function.pg-query]: Query failed: ERRO:
> relation "addresses_plots" do not exists [CORE.rc2/libs/model/
> datasources/dbo/dbo_postgres.php, line 152]
>
> Can you help me once more?
>
> I hope so.
>
> On 24 nov, 18:50, teknoid <[EMAIL PROTECTED]> wrote:
>
> > This is a basic HABTM (hasAndBelongsToMany) relationship.
> > Read up on it in the manual... you should also rename the join table
> > (if you'd like to keep consistent with conventions).
>
> > On Nov 24, 2:40 pm, Antônio Marco <[EMAIL PROTECTED]> wrote:
>
> > > Hi folks!
>
> > > I created 3 tables as shown bellow:
>
> > > CREATE TABLE geo.plots
> > > (
> > > id serial NOT NULL,
> > > created timestamp,
> > > modified timestamp,
>
> > > the_geom varchar(255),
>
> > > inscricao_imobiliaria varchar(14) NOT NULL,
>
> > > quadra varchar(10),
> > > lote smallint,
>
> > > numero_residencial_previo smallint,
>
> > > PRIMARY KEY (id)
> > > )
> > > WITH OIDS;
>
> > > CREATE TABLE geo.plot_addresses
> > > (
> > > id serial NOT NULL,
> > > created timestamp,
> > > modified timestamp,
>
> > > plot_id int NOT NULL,
> > > address_id int NOT NULL,
>
> > > endereco_principal bool NOT NULL DEFAULT true,
>
> > > PRIMARY KEY (id),
> > > FOREIGN KEY (plot_id) REFERENCES geo.plots (id),
> > > FOREIGN KEY (address_id) REFERENCES dme.addresses (id)
> > > )
> > > WITH OIDS;
>
> > > CREATE TABLE dme.addresses
> > > (
> > > id serial NOT NULL,
> > > created timestamp,
> > > modified timestamp,
>
> > > habilitado bool NOT NULL DEFAULT true,
>
> > > street_postal_code_id int NOT NULL,
> > > parent_id int,
>
> > > complemento bool NOT NULL DEFAULT false,
>
> > > numero smallint,
>
> > > bloco varchar(10),
> > > andar smallint,
> > > unidade smallint,
>
> > > posicao smallint,
>
> > > caixa_postal smallint,
>
> > > complemento_livre varchar(255),
>
> > > PRIMARY KEY (id),
>
> > > FOREIGN KEY (street_postal_code_id) REFERENCES
> > > dme.street_postal_codes (id),
> > > FOREIGN KEY (parent_id) REFERENCES dme.addresses (id)
> > > )
> > > WITH OIDS;
>
> > > They are associated as shown bellow:
>
> > > //
> > > class Plot extends AppModel {
> > > var $name = 'Plot';
>
> > > var $useDbConfig = 'geo';
>
> > > var $hasMany = array(
> > > 'PlotAddresses' => array(
> > > 'className' => 'PlotAddress',
> > > 'foreignKey' => 'plot_id'
> > > )
> > > );
>
> > > }
>
> > > //
> > > class PlotAddress extends AppModel {
> > > var $name = 'PlotAddress';
>
> > > var $useDbConfig = 'geo';
>
> > > var $belongsTo = array(
> > > 'Plot' => array(
> > > 'className' => 'Plot',
> > > 'foreignKey' => 'plot_id'
> > > ),
>
> > > 'Address' => array(
> > > 'className' => 'Address',
> > > 'foreignKey' => 'address_id'
> > > )
> > > );
>
> > > }
>
> > > //
> > > class Address extends AppModel {
> > > var $name = 'Address';
>
> > > var $useDbConfig = 'dme';
>
> > > var $hasOne = array(
> > > 'PlotAddress' => array(
> > > 'className' => 'PlotAddress',
> > > 'foreignKey' => 'address_id'
> > > )
> > > );
>
> > > }
>
> > > I have used Scaffolding in this application but when I run the index
> > > of PlotAddresses, I receive the message bellow:
>
> > > Notice (8): Undefined index: Address [CORE.rc2/libs/view/scaffolds/
> > > index.ctp, line 81]
>
> > > Verifing the line, I saw that the problem is related to "belongTo"
> > > association.
>
> > > Can anybody help me to solve this problem? Is my association
> > > incorrect?
>
> > > Thanks a lot.
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"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/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
