Re: Could not create a table named "USER" under postgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Could not create a table named "USER" under postgreSQL
Date: 2004-08-18 19:07:33
Message-ID: 2979.1092856053@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca> writes:
> at the beginning of the data population, we do not know the value of
> "col3"; values for "col3" are input throught GUI. Therefore, when I use
> MySQL, the default values I gave is "0000-00-00".

Use NULL. That's what it's for.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Glen Parker 2004-08-18 19:11:03 Re: pg_dump feature request: Exclude tables?
Previous Message Arthur van Dorp 2004-08-18 19:03:55 Re: Web application: Programming language/Framework: Summary