Re: referential integrity violation

In article <Pine.LNX.4.21.0210211547390.3016-100000@ponder.fairway2k.co.uk>,
nandrews@investsystems.co.uk ("Nigel J. Andrews") writes:

> On Mon, 21 Oct 2002 mk@fashaf.co.za wrote:
>> I have tried '' , undef , 'NULL' , 'null' non of them seem to work?
>>
>> any idea how to submit a NULL value with perl?
>>

> Okay, let's take a step back to view the slightly larger picture rather than
> the little detail...

> With a design such as:

> create table t1 (
>  i int primary key
> );

> create table t2 (
>  i int primary key,
>  t text,
>  a int references t1 (a)
> );

> your perl code should be submitting a string such as, note the lack of quotes
> around the null:

> insert into mytable values ( 23, 'my text', NULL )

> i.e.

> use Pg;

> # connect to server etc.

> $conn->exec("insert into mytable values ( 23, 'my text', NULL )");

> # error check etc.

You could also let Perl do the quoting for you:

use DBI;

> # connect to server etc.

$conn->do (q{
  INSERT INTO mytable VALUES (?, ?, ?)
}, undef, 23, "my text", undef);