Re: [GENERAL] Date data type

2008-11-03 Thread Craig Ringer
Mike Hall wrote: > I'm currently converting an MS Access database to PostgreSQL (version 8.1 as > it is the vesion that ships with CentOS 5). What version of Microsoft Access are you using? I haven't seen this issue with Access 2007, which I've been forced to use in a recent project. It actually

Re: [GENERAL] Date data type

2008-11-03 Thread Albe Laurenz
Mike Hall wrote: > I'm currently converting an MS Access database to PostgreSQL > (version 8.1 as it is the vesion that ships with CentOS 5). > > I'm having trouble with an INSERT statement attempting to > insert an empty value ('') into a field with data type DATE. > This produces the followin

Re: [GENERAL] Date data type

2008-11-02 Thread A. Kretschmer
am Mon, dem 03.11.2008, um 16:03:33 +0930 mailte Mike Hall folgendes: > Gday, > > I'm currently converting an MS Access database to PostgreSQL (version 8.1 as > it is the vesion that ships with CentOS 5). > > I'm having trouble with an INSERT statement attempting to insert an empty > value (''

Re: [GENERAL] Date data type

2008-11-02 Thread Klint Gore
Mike Hall wrote: Gday, I'm currently converting an MS Access database to PostgreSQL (version 8.1 as it is the vesion that ships with CentOS 5). I'm having trouble with an INSERT statement attempting to insert an empty value ('') into a field with data type DATE. This produces the following er

[GENERAL] Date data type

2008-11-02 Thread Mike Hall
Gday, I'm currently converting an MS Access database to PostgreSQL (version 8.1 as it is the vesion that ships with CentOS 5). I'm having trouble with an INSERT statement attempting to insert an empty value ('') into a field with data type DATE. This produces the following error message: ERRO