Re: Dumb question about binary cursors and #ifdefHAVE_INT64_TIMESTAMP

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dumb question about binary cursors and #ifdefHAVE_INT64_TIMESTAMP
Date: 2007-12-11 21:18:34
Message-ID: D425483C2C5C9F49B5B7A41F8944154701000B1A@postal.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> -----Original Message-----
> From: Alvaro Herrera [mailto:alvherre(at)alvh(dot)no-ip(dot)org]
> Sent: Tuesday, December 11, 2007 1:11 PM
> To: Dann Corbit
> Cc: pgsql-hackers(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Dumb question about binary cursors and
> #ifdefHAVE_INT64_TIMESTAMP
>
> Dann Corbit wrote:
> > If I create a binary cursor on a recent version of PostgreSQL, how
can I
> > tell if the timestamp data internally is an 8 byte double or an 8
byte
> > integer?
> >
> > I see an #ifdef that changes the code path to compute timestamps as
one
> > type or the other, but I do not know how to recognize the internal
> > format of the type that will be returned in a binary cursor.
> >
> > How can I do that?
>
> SHOW integer_timestamp;
>
> (actually, IIRC, this is one of the params that the server will send
you
> at session start).

I guess that I am supposed to check for error on the statement? What
does it look like when the query works?

This is what I get against PostgreSQL 8.2.5 using PG Admin III query
tool:

ERROR: unrecognized configuration parameter "integer_timestamp"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Obe, Regina 2007-12-11 21:21:14 Re: Hijack!
Previous Message Tom Lane 2007-12-11 21:15:46 Re: Dumb question about binary cursors and #ifdef HAVE_INT64_TIMESTAMP

Browse pgsql-hackers by date

  From Date Subject
Next Message Dann Corbit 2007-12-11 21:23:26 Re: Dumb question about binary cursors and #ifdefHAVE_INT64_TIMESTAMP
Previous Message Tom Lane 2007-12-11 21:15:46 Re: Dumb question about binary cursors and #ifdef HAVE_INT64_TIMESTAMP