| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | <mk(at)fashaf(dot)co(dot)za> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: referential integrity violation |
| Date: | 2002-10-18 15:12:59 |
| Message-ID: | 20021018081143.X23987-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 18 Oct 2002 mk(at)fashaf(dot)co(dot)za wrote:
> Hi guys
>
> I have created a Pg DB, Ive included 2 of the tables.
> When inserting non NULL values everything works just fine,
> but when i want to leave a table empty i get the following error:
>
> EXEC: ERROR: referential integrity violation - key referenced from pc not found in slip_printer
>
> Im recieving the information from a Perl CGI form that is filled in and then INSERT it using perl DBI
>
> If any more information is needed please let me know. As far as i know i should be allowed to have null.
What is the actual insert statement giving the error (if you need
to you can turn on query logging to see)? NULLs should work fine
but I'd need a test statement to check.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simpson, Mike W | 2002-10-18 15:40:03 | Re: [JDBC] Performance problem iterating a resultset |
| Previous Message | Darren Ferguson | 2002-10-18 14:51:24 | Re: referential integrity violation |