Thread: Not Null Field
Hi, I created the phonebook table with NOT NULL fileds: create table phonebook ( first varchar(20) NOT NULL, last varchar(20) NOT NULL, uniqname char(8) NOT NULL PRIMARY KEY, phone varchar(30), status char(7) NOT NULL, room varchar(40) ); If I try to insert NULL values into those fields from psql I got an error message - that is right. But when I insert records from my C-program (with embedded SQL) I dot no errors and such records are added to the table. I even can insert empty record. Why this happens? Do I need to write some code to check NULL values? Thank you, -Margarita ------------------------------- Margarita Barvinok System Administrator II University of Michigan Department of Biology -------------------------------
On Mon, Sep 20, 1999 at 11:34:42AM -0400, Margarita Barvinok wrote: > But when I insert records from my C-program (with embedded SQL) I dot no How do you do that? > errors and such records are added to the table. I even can insert empty > record. Why this happens? Do I need to write some code to check NULL > values? You shouldn't. Would you please send us a piece of source code? Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!
On Mon, Sep 20, 1999 at 11:34:42AM -0400, Margarita Barvinok wrote: > > Hi, > > I created the phonebook table with NOT NULL fileds: > > create table phonebook ( > first varchar(20) NOT NULL, > last varchar(20) NOT NULL, > uniqname char(8) NOT NULL PRIMARY KEY, > phone varchar(30), > status char(7) NOT NULL, > room varchar(40) ); > > If I try to insert NULL values into those fields from psql I got an error > message - that is right. > But when I insert records from my C-program (with embedded SQL) I dot no > errors and such records are added to the table. I even can insert empty > record. Why this happens? Do I need to write some code to check NULL > values? > > Thank you, > -Margarita How are you doing it? Can you send your source? I guess you are not entering NULL but empty string values. Ivo.
Ivo, I think you are right. I inserted empty strings. Thank you for reply. -Margarita On Mon, 20 Sep 1999, Ivo Simicevic wrote: > On Mon, Sep 20, 1999 at 11:34:42AM -0400, Margarita Barvinok wrote: > > If I try to insert NULL values into those fields from psql I got an error > > message - that is right. > > But when I insert records from my C-program (with embedded SQL) I dot no > > errors and such records are added to the table. I even can insert empty > > record. Why this happens? Do I need to write some code to check NULL > > values? > > > > Thank you, > > -Margarita > > How are you doing it? Can you send your source? > I guess you are not entering NULL but empty string values. > > Ivo. >