[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? Thanks a

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 that

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 could not create

[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 Dann Corbit
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 named USER under MySQL database. When I am trying to move

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

2004-08-18 Thread Ying Lu
-Original 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 named

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 to store

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

2004-08-18 Thread Dann Corbit
: [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' and -00-00 00:00:00 for them. However, it seems that PostgreSQL does not support it. Could someone