Re: Insert into sintax - Mailing list pgsql-general

From Josué Maldonado
Subject Re: Insert into sintax
Date
Msg-id 4113A3B5.5030400@lamundial.hn
Whole thread Raw
In response to Re: Insert into sintax  (Duane Lee - EGOVX <DLee@mail.maricopa.gov>)
List pgsql-general
Duane,

El 05/08/2004 5:29 PM, Duane Lee - EGOVX en su mensaje escribio:
> What table is lnpedpk in - ped_cam?  What table is ped_pk in - ped_pro and
> ped_cam?

lnPedPk is parameter pased to the function and it could be a fixed value
on the sql console too, ped_pk is common in both tables, I changed the
code to this and still get the same error

INSERT INTO ped_cam
      (SELECT * from ped_pro where ped_pro.ped_pk=81178)
      WHERE NOT EXISTS
    (SELECT 1 FROM ped_cam WHERE ped_cam.ped_pk=81178);

Thanks,


--
Sinceramente,
Josué Maldonado.
"Deja que los perros ladren, Sancho, es señal que caminamos." -- Miguel
de Cervantes Saavedra.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 7.4.2 allows foreign key violation
Next
From: Ron St-Pierre
Date:
Subject: Re: New to Postgres