From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | d(dot)a(dot)ignatyev(at)yandex(dot)ru |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #16474: Foreign key issue |
Date: | 2020-06-01 17:05:24 |
Message-ID: | 387001.1591031124@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> A few lines of SQL to clarify the situation:
This isn't clarifying much. If I guess at your table definitions,
it works for me:
regression=# create table r_source (source text primary key);
CREATE TABLE
regression=# create table ppdm_rule_remark(source text references r_source);
CREATE TABLE
regression=# insert into r_source values ('PPDM39RNEX');
INSERT 0 1
regression=# select source from r_source where source = 'PPDM39RNEX' \gset
regression=# \echo :source
PPDM39RNEX
regression=# INSERT INTO ppdm_rule_remark("source") values (:'source');
INSERT 0 1
Please provide a *self contained* example if you want us to
investigate more closely.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | d.a.ignatyev | 2020-06-01 19:36:11 | RE: BUG #16474: Foreign key issue |
Previous Message | Tom Lane | 2020-06-01 16:18:11 | Re: BUG #16472: Bug in to_timestamp ? |