Re: Postgres CTE issues
| От | Shekar Tippur |
|---|---|
| Тема | Re: Postgres CTE issues |
| Дата | |
| Msg-id | CAHmfATowaL7LdZkQ9c81tCiGLtOBRbmvzFP1JgntTe7Ak22vHg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Postgres CTE issues (Marc Mamin <M.Mamin@intershop.de>) |
| Ответы |
Re: Postgres CTE issues
|
| Список | pgsql-sql |
<div dir="ltr"><div class="gmail_extra">Marc,</div><div class="gmail_extra"><br /></div><div class="gmail_extra">I have
changedthe table C:</div><div class="gmail_extra"><br /></div><div class="gmail_extra"><p class=""><span
class="">createtable C ( </span><p class=""><span class=""> "id" SERIAL PRIMARY
KEY,</span><pclass=""><span class=""> name varchar(40)</span><p class=""><span class=""> , b_id integer references
B(id)DEFERRABLE INITIALLY DEFERRED NOT NULL);</span><p class=""><span class=""><br /></span><p class=""><span
class="">Istill get the same error:</span><p class=""><span class="">insert into A (var1, var2) values ('Hello1',
'World1');</span><pclass=""><span class="">ERROR: null value in column "b_id" violates not-null constraint</span><p
class=""><spanclass="">DETAIL: Failing row contains (2, World1, null).</span><p class=""><span class="">CONTEXT: SQL
statement"INSERT INTO C (name, b_id) VALUES (NEW.var2, b_id)"</span><p class=""><p class=""><span class="">PL/pgSQL
functionfn_test() line 17 at SQL statement</span></div></div>
В списке pgsql-sql по дате отправления: