Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Martijn van Oosterhout
On Wed, Sep 12, 2001 at 04:55:35PM +, Thomas Lockhart wrote: > > BTW, i don't know who thought of it but -dd-mm is a terrible format and > > should be shot. > > Where does -dd-mm appear in PostgreSQL? What is the issue here? >From the original post: > vendirza=# SHOW DATESTYLE; > NO

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Graham Leggett
Barry Lind wrote: > I am guessing from the error that you are using JDBC as your client. > This looks like a known issue with the 7.0 jdbc driver. Have your tried > the 7.1 jdbc driver? (as long as you don't use the DatabaseMetadata > object too much, the 7.1 driver should work fine against a 7

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Barry Lind
Graham, I am guessing from the error that you are using JDBC as your client. This looks like a known issue with the 7.0 jdbc driver. Have your tried the 7.1 jdbc driver? (as long as you don't use the DatabaseMetadata object too much, the 7.1 driver should work fine against a 7.0 database).

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Thomas Lockhart
> BTW, i don't know who thought of it but -dd-mm is a terrible format and > should be shot. Where does -dd-mm appear in PostgreSQL? What is the issue here? - Thomas ---(end of broadcast)--- TIP 2: you can get off all

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Graham Leggett
Martijn van Oosterhout wrote: > > vendirza=# SHOW DATESTYLE; > > NOTICE: DateStyle is ISO with US (NonEuropean) conventions > > > > vendirza=# SHOW DATESTYLE; > > NOTICE: DateStyle is ISO with US (NonEuropean) conventions > > Looks the same machine to me. That's because both machines are conf

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Martijn van Oosterhout
On Wed, Sep 12, 2001 at 05:16:29PM +0200, Graham Leggett wrote: > According to the FAQ and docs, this is caused by the date format being > wrong, but the date format is the same on both installations: > > vendirza=# SHOW DATESTYLE; > NOTICE: DateStyle is ISO with US (NonEuropean) conventions >