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

Re:

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "S(dot)P(dot)Vimala" <vimala(at)ncb(dot)ernet(dot)in>
Cc: <pgsql-php(at)postgresql(dot)org>
Subject: Re:
Date: 2003-09-15 17:05:25
Message-ID: Pine.LNX.4.33.0309151104470.2494-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-php
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.


In response to

  • at 2003-09-15 10:00:23 from S.P.Vimala

Responses

  • Re: at 2003-09-16 04:27:20 from S.P.Vimala

pgsql-php by date

Next:From: S.P.VimalaDate: 2003-09-16 04:27:20
Subject: Re:
Previous:From: James WardDate: 2003-09-15 12:21:06
Subject: Re: pg_connect(): ...Too many open links (0)

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