agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Ed Rahn <edsrahn@gmail.com>
To: pgsql-sql@postgresql.org
Subject: foregin table insert error
Date: Sun, 14 Dec 2014 04:13:45 -0500
Message-ID: <548D54C9.3040005@gmail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

Hi,
I have a foreign table that I'm getting an insert error on:

horsedata=# insert into remote_cache (entry_id, name_id) values(2,1);
ERROR:  null value in column "id" violates not-null constraint
DETAIL:  Failing row contains (null, 1, 2, null).
CONTEXT:  Remote SQL command: INSERT INTO public.cache(id, name_id, 
entry_id, value) VALUES ($1, $2, $3, $4)


Here is the remote table client side:
horsedata=# \d remote_cache
      Foreign table "public.remote_cache"
   Column  |  Type   | Modifiers | FDW Options
----------+---------+-----------+-------------
  id       | integer |           |
  name_id  | integer |           |
  entry_id | integer |           |
  value    | integer |           |
Server: home
FDW Options: (table_name 'cache')


And here's cache server side:
horsedata=# \d cache;
                                Table "public.cache"
   Column  |       Type       | Modifiers
----------+------------------+----------------------------------------------------
  id       | integer          | not null default 
nextval('cache_id_seq'::regclass)
  name_id  | integer          |
  entry_id | integer          |
  value    | double precision |
Indexes:
     "cache_pkey" PRIMARY KEY, btree (id)
     "cache_name_id_entry_id_key" UNIQUE CONSTRAINT, btree (name_id, 
entry_id)
     "ix_cache_entry_id" btree (entry_id)
     "ix_cache_name_id" btree (name_id)


Any suggestions?

Thanks
Ed


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

view thread (5+ messages)  latest in thread

Message-ID: <548D54C9.3040005@gmail.com>
Permalink:  ../548D54C9.3040005@gmail.com/
Also on:    postgresql.org/message-id/548D54C9.3040005@gmail.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: edsrahn@gmail.com
  Subject: Re: foregin table insert error
  In-Reply-To: <548D54C9.3040005@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox