From: Stephen Davies <scldad@sdc.com.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Sanjay Arora <sk@pobx.com>
Cc: pgsql-interfaces@postgresql.org
Cc: goga@tc-internet.com
Cc: arminder@tc-internet.com
Subject: Re: Null values where they should not be...HELP Please!!
Date: Fri, 04 May 2001 08:41:13 +0930
Message-ID: <200105032311.IAA07534@mustang.sdc.com.au> (raw)
In-Reply-To: <422.988918563@sss.pgh.pa.us>
This looks a bit like the problem that I raised a few weeks ago.
It seems that either ODBC or MSAccess or (more likely) VB knows a way to
insert records containing nothing but nulls.
I changed my DDL to make the unique (sequence-based) keys on the tables
involved "not null". This sees to have stopped the inserts but has not
caused any error messages.
The database is only acessed via VB and Access. There is no user use of
psql.
Cheers,
Stephen Davies
On Thu, 03 May 2001 15:36:03 -0400, Tom Lane said:
> Sanjay Arora <sk@pobx.com> writes:
> > Assuming even that the application is trying to store null where it should
> > not, PG should raise an error, instead of accepting the same.
>
> Indeed. No one has reported any such problem before, AFAIR. Are you
> sure the columns are marked NOT NULL?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
========================================================================
Stephen Davies Consulting scldad@sdc.com.au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: scldad@sdc.com.au, tgl@sss.pgh.pa.us, sk@pobx.com, goga@tc-internet.com, arminder@tc-internet.com
Subject: Re: Null values where they should not be...HELP Please!!
In-Reply-To: <200105032311.IAA07534@mustang.sdc.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox