I'm having trouble making UPDATE queries in PostgreSQL. I know that
there is a known issue about Postgres not supporting aliases in UPDATE
queries. Anyway, my problem is that when I try to create new Aro like
this:
$parent = $this->Acl->Aro->findByAlias('SuperUser');
$parentId = $parent['Aro']['id'];
$this->Acl->Aro->create();
$this->Acl->Aro->save(array(
'foreign_key' => null,
'parent_id' => $parentId,
'alias' => 'User:30'));
I get the following error:
Warning (2): pg_query() [function.pg-query]: Query failed: ERROR:
column "Aro" of relation "aros" does not exist
LINE 1: UPDATE "aros" AS "Aro" SET "Aro"."lft" = "Aro"."lft" + 2
W...
^ [CORE\cake\libs\model\datasources
\dbo\dbo_postgres.php, line 123]
$sql = "UPDATE "aros" AS "Aro" SET "Aro"."lft" = "Aro"."lft" + 2
WHERE "Aro"."lft" >= '2'"
I've already posted a bug to trac.cakephp.org... the reason for this
message is that I would like to ask everybody for help on creating
some quick solution or patch for this problem.
P.S. This problem with aliases isn't just a one time thing, it is and
will be happening until cakephp developers move the method
renderStatement from dbo_source.php to each dbo file. It should work
as it is, but it doesn't, they should all follow SQL standards but
they don't. So, my suggestion is to make renderStatement in every dbo.
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
