Re: [SQL] Timestamp output

Andreas,

I can't reproduce the problem you are seeing.  I created a table 'test'
with one column of type timestamp.  Inserted one row with the value from
now().  And then ran a simple jdbc program to select out that one row.
This all worked without errors.

Again I ask are you using the latest 7.2 driver?  I know there where
some bugs in earlier 7.2 drivers (I think in all of the betas actually)
that look similar to the problem you are reporting.

thanks,
--Barry


Andreas Joseph Krogh wrote:
> On Tuesday 05 February 2002 11:59, you wrote:
>
>>Andreas,
>>
>>Are you using the latest 7.2 driver?  I don't have any problems with
>>this using the latst 7.2 driver.  If you are using the latest driver,
>>can you send in a test case that reproduces this problem?
>>
>
> I have the following table:
> CREATE TABLE FORUMARTICLE(
>     ARTICLEID SERIAL NOT NULL PRIMARY KEY,
>     FORUMID INTEGER NOT NULL REFERENCES FORUM(FORUMID),
>     CATEGORYID INTEGER NOT NULL REFERENCES CATEGORY(CATEGORYID),
>     SUBJECT VARCHAR(512) NOT NULL,
>     LEADTEXT VARCHAR(4000),
>     BODY VARCHAR(4000) NOT NULL,
>     USERNAME VARCHAR(64) NOT NULL,
>     CREATED TIMESTAMP DEFAULT 'now' NOT NULL,
>     LASTPOSTING TIMESTAMP,
>     LASTPOSTINGBY VARCHAR(64),
>     ISAPPROVED INTEGER DEFAULT 0 NOT NULL,
>     APPROVEDBY INTEGER DEFAULT 0 NOT NULL
> );
>
> I have the following trigger on FORUMARTICLE:
> CREATE FUNCTION stamp_article () RETURNS OPAQUE AS '
>     BEGIN
>         -- Check that lastpostingby is given
>         IF NEW.LASTPOSTINGBY ISNULL THEN
>             RAISE EXCEPTION ''LASTPOSTINGBY cannot be NULL value'';
>         END IF;
>
>         -- Remember when LASTPOSTINGBY changed
>         NEW.LASTPOSTING := ''now'';
>         RETURN NEW;
>     END;
> ' LANGUAGE 'plpgsql';
>
> CREATE TRIGGER stamp_article BEFORE UPDATE ON FORUMARTICLE
> FOR EACH ROW EXECUTE PROCEDURE stamp_article();
>
> This causes the follogin entry in FORUMARTICLE:
>
>          lastposting
> ------------------------------
>  2002-02-26 18:32:54.83294+01
>
> which throws the Exception in the JDBC driver as follows:
>
> Bad Timestamp Format at 23 in 2002-02-26 18:32:54.83294+01
>
> I have the postgresql.jar from 7.2 in my classpath:
>
> diff ~/postgresql-7.2/src/interfaces/jdbc/jars/postgresql.jar
> ~/catalina/common/lib/postgresql.jar
>
> echo $?
> 0
>
>
>