Skip site navigation (1) Skip section navigation (2)

Re: Null values where they should not be...HELP Please!!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Davies <scldad(at)sdc(dot)com(dot)au>
Cc: Sanjay Arora <sk(at)pobx(dot)com>, pgsql-interfaces(at)postgresql(dot)org, goga(at)tc-internet(dot)com, arminder(at)tc-internet(dot)com
Subject: Re: Null values where they should not be...HELP Please!!
Date: 2001-05-03 23:14:37
Message-ID: 14597.988931677@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
Stephen Davies <scldad(at)sdc(dot)com(dot)au> writes:
> 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.

Are you looking for error messages in the postmaster log, or are you
just believing what Microsoft software tells you?

Running the postmaster with query logging enabled (-d2 postmaster
switch) would be even more helpful, since then we could see what these
mysterious queries are ...

			regards, tom lane

In response to

pgsql-interfaces by date

Next:From: Jarungwit J.Date: 2001-05-04 02:15:55
Subject: ODBC converts '\n' to '\r\n'.
Previous:From: Stephen DaviesDate: 2001-05-03 23:11:13
Subject: Re: Null values where they should not be...HELP Please!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group