使用codeigniter将数据插入postgresql数据库


inserting data into postgresql database with codeigniter

当我试图在postgresql中的用户表中插入一行时,我遇到了一个问题,例如

我有一个带有活动记录的正常插入,$this->db->insert($table,$data),我得到一个类似这样的错误:

错误:关系«user_accounts»第1行:插入"user_account"("user_aaccounts"。"uacc_group_fk"

我认为问题可能是我将插入的字段中的表名("user_accounts"。"uacc_group_fk"),.

你知道我该怎么避免吗?我只想把字段的名称没有表名。

提前谢谢

是否检查了"user_accounts"列。"uacc_group_fk"是否存在(带引号)?

这是的insert_user函数中使用的数据数组https://github.com/haseydesign/flexi-auth/blob/master/library_files/application/models/flexi_auth_model.php:

$sql_insert = array(
        $this->auth->tbl_col_user_account['group_id'] => $group_id,
        $this->auth->tbl_col_user_account['email'] => $email,
        $this->auth->tbl_col_user_account['username'] => ($username) ? $username : '',
        $this->auth->tbl_col_user_account['password'] => $hash_password,
        $this->auth->tbl_col_user_account['ip_address'] => $ip_address,
        $this->auth->tbl_col_user_account['last_login_date'] => $this->database_date_time(),
        $this->auth->tbl_col_user_account['date_added'] => $this->database_date_time(),
        $this->auth->tbl_col_user_account['activation_token'] => $activation_token,
        $this->auth->tbl_col_user_account['active'] => 0,       
        $this->auth->tbl_col_user_account['suspend'] => $suspend_account        
    );