[HACKERS] Timestamp format question
Hello: A user of the PgSqlClient ADO.NET provider is having problems when with timestamp and time values, he has a postgres 7.4.1 postgres install in a Suse machine. The provider works implements v3.0 of the postgres protocol handling timestamp andtime in binary format, the problem seems to be that the server is sending the timestamp value encoded as an Int64, but when running the same test against the postgresql snapshot for win32 the value seems to be encoded as a double :-\ (i have run the same test postgres 7.4.2 on Fedora Core 1 and seem s to be sending it encoded as a double) What is the supposed format that should be expected for time and timestamp values in binary format ?? There are any way to retrieve the value encoded always in the same way ?? or i'm making something really bad ?? :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] Timestamp format question
Hello: Depends whether you built the server with --enable-integer-timestamps or not. Thanks :) Sure: don't use binary I/O. hehe ... :-\ i will do ... thanks again :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] Transaction Rollback problen (3.0 Protocol)
Hello: I'm having a little problem with my .net data provider for postgresql 7.4. I'm executing a little sample that does: 1. Connect to the server. 2. Start transaction. 3. Execution of an invalid SQL command. 4. Catch exception and rollback transaction. After send the rollbact transaction command i'm not receiving any response from the server, instead, if the SQL command is a valid SQL command all runs fine, any idea about what can be the problem ?? Thanks in advance. -- Best regards Carlos Guzmán Álvarez Vigo-Spain ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Transaction Rollback problen (3.0 Protocol)
Hello: Are you using the extended query protocol? If so you probably have forgotten the need for a Sync message. You are right, thanks very much, it's working well now. -- Best regards Carlos Guzmán Álvarez Vigo-España ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] Question about read interval type in binary format
Hello: In src/backend/utils/adt/timestamp.c, interval_send looks like what you are looking for. Thanks :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]