Unable to insert into PostgreSQL using laravel eloquent ORM

Question

I did my research a lot before posting this.

I am getting the following error when trying to insert a record into PostgreSQL using Laravel eloquent ORM.

This is the error:

Illuminate \ Database \ QueryException

SQLSTATE[42703]: Undefined column: 
7 ERROR: column "id" does not exist LINE 1: ...ed_at", "created_at") 
values ($1, $2, $3, $4) 
returning "id" ^ (SQL: insert into "fb_post_like_counts" ("post_id", "count", "updated_at", "created_at") values (293843523498_10152007721598499, 0, 2014-03-12 16:56:24, 2014-03-12 16:56:24) returning "id")

This is the database table create schema:

Schema::create('fb_post_shares_counts', function($table)
{
    //
    $table->string('post_id');
    $table->string('count')->default(0);

    //  created_at updated_at deleted_at
    $table->timestamps();
    $table->softDeletes();

    // set composite keys   
    $table->primary(array('post_id', 'updated_at'));
});

and this is the code i am trying to execute:

// SAVE POST SHARES
$post_share_count   =   new FbPostShareCount;
$post_share_count->post_id   =  $response['id'];
$post_share_count->count    =   $fql_post['share_count'];       
$post_share_count->save();

and I created a model class FbPostShareCount extends Eloquent.

I know that laravel does not support complex keys but this problem did not occur when I was using MySQL

Awaiting feedback. Is it solved?

Seiji Manoan
– Seiji Manoan

2015-06-02 11:34:41 +00:00
Commented Jun 2, 2015 at 11:34 — Seiji Manoan
– Seiji Manoan, Commented Jun 2, 2015 at 11:34

Antonio Carlos Ribeiro · Accepted Answer · 2014-03-12 20:00:38Z

14

Set the primary key in your FbPostShareCount model as

class FbPostShareCount extends Eloquent {

    protected $primaryKey = 'post_id';

    ...
}

answered Mar 12, 2014 at 20:00

Antonio Carlos Ribeiro

87.9k22 gold badges220 silver badges205 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mo Fetch Over a year ago

same error. Just for the record I am using composite keys in the database I attached the schema.

greatwitenorth Over a year ago

as far as I'm aware eloquent does not currently support composite keys.

Seiji Manoan Over a year ago

@MoFetch The Antonio Carlos Ribeiro is right. But, as arcsum also has said, it should be INTEGER as ID for PK.

Chando · Accepted Answer · 2019-07-28 16:23:22Z

4

Laravel eloquent ORM have auto increment, So set up primaryKey = null and increment = false.

protected $primaryKey = null;

public $incrementing = false;

answered Jul 28, 2019 at 16:23

Chando

4444 silver badges16 bronze badges

Comments

arcsum · Accepted Answer · 2014-05-19 07:15:56Z

1

have you tried using the correct data type for post id?

$table->integer('post_id');

answered May 19, 2014 at 7:15

arcsum

1568 bronze badges

Collectives™ on Stack Overflow

Unable to insert into PostgreSQL using laravel eloquent ORM

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related