On Mon, 15 Sep 2003, S.P.Vimala wrote:
> Hi,
>
> I have a table in postgresql db with the following description.
>
> - Table: vyapar_user
> CREATE TABLE vyapar_user (
> loginid varchar(150) NOT NULL,
> name varchar(150) NOT NULL,
> "password" varchar(32) NOT NULL,
> "type" varchar(10) NOT NULL,
> address varchar(100) NOT NULL,
> phone varchar(15),
> email varchar(20),
> creationdate date DEFAULT date('now'::text),
> expriydate date DEFAULT (date('now'::text) + 360),
> CONSTRAINT vyapar_user_pk PRIMARY KEY (loginid)
> ) WITH OIDS;
>
>
> If i try inserting NULL values from backend, then it gives me an
> error. But thru php, its adds null values without any errors. Any idea
> how to solve this issue.....
I'll need to see some sample code. In my experience, PHP cannot insert
NULLS into not null fields.
Are you sure you're not inserting '' and thinking of it as NULL? They're
not the same.
