Re: [SQL] Problem with timestamp and primary key. - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: [SQL] Problem with timestamp and primary key.
Date
Msg-id 199907131657.MAA25778@candle.pha.pa.us
Whole thread Raw
In response to Problem with timestamp and primary key.  ("Esteban Chiner Sanz" <echiner@tissat.es>)
List pgsql-sql
> Does anybody know what could be the problem. What should I do?
> The problem is that I could subtitute TIMESTAMP with DATE or DATETIME
> but that's not compatible with Oracle's DATE and, when I try to access
> the table with JDBC in Oracle works fine but in Postgres it needs to be
> Timestamp.
> Please help,

This is a known problem because our jdbc does not know DATETIME, and our
TIMESTAMP can't do indexes.

People, any solutions?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] Postgres ERROR
Next
From: "Hub.Org News Admin"
Date:
Subject: ...