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

2004-08-18 Thread Dann Corbit
EMAIL PROTECTED] > Subject: [GENERAL] Could not create a table named "USER" > under postgreSQL > > > Hello, > > I have a question about "date" & "timestamp" types in > PostgreSQL. I want > to setup the default value '-00-00&#

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

2004-08-18 Thread gnari
"Ying Lu" <[EMAIL PROTECTED]> wrote: > > I have a question about "date" & "timestamp" types in PostgreSQL. I want > to setup the default value '-00-00' and "-00-00 00:00:00" for > them. However, it seems that PostgreSQL does not support it. Could > someone helps me please? if you want

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

2004-08-18 Thread Ying Lu
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Mascari Sent: Wednesday, August 18, 2004 11:24 AM To: Ying Lu Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Could not create a table named "USER" under postgreSQL Ying Lu wrote: Hello, I have a table n

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

2004-08-18 Thread Dann Corbit
ECTED] On Behalf Of Mike Mascari > Sent: Wednesday, August 18, 2004 11:24 AM > To: Ying Lu > Cc: [EMAIL PROTECTED] > Subject: Re: [GENERAL] Could not create a table named "USER" > under postgreSQL > > > Ying Lu wrote: > > > Hello, > > > > I hav

[GENERAL] Could not create a table named "USER" under postgreSQL

2004-08-18 Thread Ying Lu
Hello, I have a question about "date" & "timestamp" types in PostgreSQL. I want to setup the default value '-00-00' and "-00-00 00:00:00" for them. However, it seems that PostgreSQL does not support it. Could someone helps me please? The example table: T1 (col1 varchar(7) not null,

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

2004-08-18 Thread gnari
"Ying Lu" <[EMAIL PROTECTED]> did write: > Hello, > > I have a table named "USER" under MySQL database. When I am trying to > move tables from MySQL to PostgreSQL, I found that I could not create a > table namely "USER". I guess "USER" is a key string used by PostgreSQL > system so that we co

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

2004-08-18 Thread Mike Mascari
Ying Lu wrote: Hello, I have a table named "USER" under MySQL database. When I am trying to move tables from MySQL to PostgreSQL, I found that I could not create a table namely "USER". I guess "USER" is a key string used by PostgreSQL system so that we could not create a table named "USER". Is t

[GENERAL] Could not create a table named "USER" under postgreSQL

2004-08-18 Thread Ying Lu
Hello, I have a table named "USER" under MySQL database. When I am trying to move tables from MySQL to PostgreSQL, I found that I could not create a table namely "USER". I guess "USER" is a key string used by PostgreSQL system so that we could not create a table named "USER". Is that true? Than