Createmultipleinsertcommand With Postgresql Scheme

Yii 1.1 General Discussion
1

Hi All,

After announcement I tried immediately to use CDbCommandBuilder::createMultipleInsertCommand form my project but it seems it was forgotten about recognizing postgresql scheme with "." as in other method works.

Could someone suggest from which method copy the line for this feature and where exactly place them in the new method?

thanks a lot

luca

2

In the third statement in the composeMultipleInsertCommand there is:




$tableName=$this->getDbConnection()->quoteTableName($table->name);

and in other methods $table->rawName is used, so it should be:




$tableName=$table->rawName;

I’ve filed an issue on github for this.

3

Thanks for your help but this doesn’t fix it

I did as you suggest but table was imu.versamenti and it takes it as imuversamenti

<h1>CDbException</h1>

<p>Table "imuversamenti" does not exist. (/home/adminsit/YII/yii-1.1.14.f0fee9/framework/db/schema/CDbCommandBuilder.php:859)</p><pre>#0 /home/adminsit/YII/yii-1.1.14.f0fee9/framework/db/schema/CDbCommandBuilder.php(290): CDbCommandBuilder->ensureTable(NULL)

#1 /home/adminsit/YII/yii-1.1.14.f0fee9/framework/db/schema/CDbCommandBuilder.php(264): CDbCommandBuilder->composeMultipleInsertCommand(‘imuversamenti’, Array)

4

UPDATE it work perfectly if I use double quote “imu.versamenti” instead of ‘imu.versamenti’

thanks a lot

luca