Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfIsC-0002OJ-Cb for pgsql-interfaces@arkaria.postgresql.org; Wed, 22 May 2013 23:55:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UfIsB-0001Cn-TC for pgsql-interfaces@arkaria.postgresql.org; Wed, 22 May 2013 23:55:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfIsB-0001C9-5v for pgsql-interfaces@postgresql.org; Wed, 22 May 2013 23:55:11 +0000 Received: from nm14-vm0.bullet.mail.bf1.yahoo.com ([98.139.213.164]) by magus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UfIs5-0001bY-DD for pgsql-interfaces@postgresql.org; Wed, 22 May 2013 23:55:10 +0000 Received: from [98.139.212.144] by nm14.bullet.mail.bf1.yahoo.com with NNFMP; 22 May 2013 23:55:03 -0000 Received: from [98.139.215.252] by tm1.bullet.mail.bf1.yahoo.com with NNFMP; 22 May 2013 23:55:03 -0000 Received: from [127.0.0.1] by omp1065.mail.bf1.yahoo.com with NNFMP; 22 May 2013 23:55:03 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 830898.74649.bm@omp1065.mail.bf1.yahoo.com Received: (qmail 48194 invoked by uid 60001); 22 May 2013 23:55:03 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1369266903; bh=lYKXb5YwV87IAp4w8k3WUEmGRKWtiUvl7mUwwBtx9jg=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=JpMSXPlQXsZHHY+6ZY3muFoyADPuKmxq2cMbKzuJHltl+hQF2rBfbcYX3l2pf8c8fqfXLVilfM4DOYhaWKj4NkYYqtvK/l0QRpYTBoFX8eQWUhQwb/L+fLMmNmzh/uc2IGNorSr/2qJHcwGcPlWYCxAlUiKJV2r1zyZNHX2LrkQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=wjqTWAMkzaGKV1w2EWrw8Ev61uGmnE3TyzSGS3lWTcTPdHZ59AwkAF6bLYJpCKkkcLYk7rPE5ayqPA8+G0oYnKt2RTpkYbTbBppm9uzputq3KxAYFNZTTJgV/nvtMBD83tU4hJKlNY5ZZSO+V0ErrZycioUujSxQ3lxuu2eqS2I=; X-YMail-OSG: LDUqmmgVM1nTqYFYuQ78yhWpLBS3AmkYqN3NcdR7ytyWEuL GT0A_JzGVHRg.iaA9J8vRx7FtEHs56dwpS3kAap17cFArap3y0EHqfex5swg TSFODRE7kP9z6UADU.fHSXzm5d6ZHFE0ULqn4qZTa6uSY683vxAih.FPCSB2 .z05Hb8Gspa9k5WvjZZAnZ0G7cpMMsD_uOmnFaE.LgMYjpHfRGhBlKaxvmCW n6w9kUr0UndAMDhtSM1ioeBwC51cDMSC4YCOnHrack9joTypbq486IK.ZPue j6wfNGzFilNtbeC3nWfSs55bU1is89FXPHDqrL4S_MDKWCZ1iwKnCs3wECs5 KDJBcIUBkjSFkx.pD1vQxtEJsDeQ7Neco2yYAnHjkrj.pEaNro3kwAcy592b XjqA71Y0jRSppLdOX6NUZbAIAipzGrtznKSakKP38_ezE5YPxEx45Lf5DTl2 lYtTBkS4x0W8vYHmoNAj0UcoXXc0mPohfwTJjdx2rhklzkEe8KOOSUsu1r9J LPohM0UnDw4W_ISweTuQmeaLT Received: from [69.125.89.202] by web164904.mail.bf1.yahoo.com via HTTP; Wed, 22 May 2013 16:55:03 PDT X-Rocket-MIMEInfo: 002.001, CgrCoHRlc3RsaWJxcC1kdC5jIMKgaXMgYXR0YWNoZWQKCgoKCj5fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwo.IEZyb206IE5lZXJhaiBSYWkgPHJuZWVyYWpAeWFob28uY29tPgo.VG86ICJwZ3NxbC1pbnRlcmZhY2VzQHBvc3RncmVzcWwub3JnIiA8cGdzcWwtaW50ZXJmYWNlc0Bwb3N0Z3Jlc3FsLm9yZz4gCj5TZW50OiBXZWRuZXNkYXksIE1heSAyMiwgMjAxMyA3OjUyIFBNCj5TdWJqZWN0OiBbSU5URVJGQUNFU10tIHBnYXFsIGxvbmcgdmFsdWUgY29ycnVwdGVkIHVzaW5nIGh0b25zCj4gCj4BMAEBAQE- X-Mailer: YahooMailWebService/0.8.142.542 References: <1369185968.87888.YahooMailNeo@web164906.mail.bf1.yahoo.com> <1369241530.69063.YahooMailAndroidMobile@web164901.mail.bf1.yahoo.com> <1369266733.72536.YahooMailNeo@web164902.mail.bf1.yahoo.com> Message-ID: <1369266903.47851.YahooMailNeo@web164904.mail.bf1.yahoo.com> Date: Wed, 22 May 2013 16:55:03 -0700 (PDT) From: Neeraj Rai Reply-To: Neeraj Rai Subject: Re: - pgaql long value corrupted using htons To: "pgsql-interfaces@postgresql.org" In-Reply-To: <1369266733.72536.YahooMailNeo@web164902.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="-1611076590-1221816962-1369266903=:47851" X-Pg-Spam-Score: -3.1 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-interfaces Precedence: bulk Sender: pgsql-interfaces-owner@postgresql.org ---1611076590-1221816962-1369266903=:47851 Content-Type: multipart/alternative; boundary="-1611076590-1264966024-1369266903=:47851" ---1611076590-1264966024-1369266903=:47851 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable =A0testlibqp-dt.c =A0is attached >________________________________ > From: Neeraj Rai >To: "pgsql-interfaces@postgresql.org" =20 >Sent: Wednesday, May 22, 2013 7:52 PM >Subject: [INTERFACES]- pgaql long value corrupted using htons >=20 > > >Hi, > > >1. I am having trouble writing long values via c interface .testlibqp-dt.c= =A0is attached. >. 2 is being inserted as 8589934592. > > > > >qsf=3D> select * from t1; >=A0 =A0curdate =A0 | =A0strf =A0| =A0 =A0 =A0 =A0intf =A0 =A0 =A0 =A0| =A0= =A0 =A0 =A0 tm_new =A0 =A0 =A0 =A0 | txnid=A0 >------------+--------+--------------------+------------------------+------- >1999-01-10 | hello2 |8589934592 | 1999-01-08 04:05:06-05 | =A0 =A0 3 > > >I tried htobe64 but that didn't help either. >Any advise would be appreciated. > > > >2.=A0I have switched to using string for data and timestamp and it seems t= o work. > > >I found functions like TimestampTzGetDatum,time_t_to_timestamptz in the co= de=A0 >But it seems they are not exposed to interface. >I have the date time in unix format (via time and gettimeofday). I would p= refer to pass those values >in binary, rather than string format. Is there any option to do this ? Or = is it easily addable? > > >thanks >Neeraj > > > >= ---1611076590-1264966024-1369266903=:47851 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

 te= stlibqp-dt.c  is attached


From: Neeraj Rai <rneeraj@yahoo.com>
<= b>To: "pgsql-interfaces@postg= resql.org" <pgsql-interfaces@postgresql.org>
Sent: Wednesday, May 22, 2013 7:52 PM
Subject: [INTERFACES]- pgaql long value = corrupted using htons
Hi,

1. I am having trouble writing lon= g values via c interface .testlibqp-dt.c  is attached.
. 2 is being inserted as 8589934592.
<= div style=3D"color: rgb(69, 69, 69); font-family: 'Helvetica Neue', Helveti= ca, Arial, sans-serif; font-size: 12px; ">

qs= f=3D> select * from t1;
=
   curdate   |  strf  |       =  intf        |         tm_new =         | txnid 
------------+--------+-= -------------------+------------------------+-------
1999-01-10 |= hello2 |8589934592 | 1999-01-08 04:05:06-05 |     3

I tried htobe64 but that didn't help either.
A= ny advise would be appreciated.

2. I hav= e switched to using string for data and timestamp and it seems to work.

I found functio= ns like TimestampTzGetDatum,time_t_to_timestamptz in the code 
But it seems they are not exposed = to interface.
I have the date time = in unix format (via time and gettimeofday). I would prefer to pass those va= lues
in binary, rather than= string format. Is there any option to do this ? Or is it easily addable?

thanks
Neeraj


= ---1611076590-1264966024-1369266903=:47851-- ---1611076590-1221816962-1369266903=:47851 Content-Type: text/x-csrc; name="testlibpq-dt.c" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="testlibpq-dt.c" LyoKQ1JFQVRFIHRhYmxlIHQxCigKY3VyZGF0ZSAgICAgICAgICAgICAgICAg ZGF0ZSwKc3RyZiAgICAgICAgICAgICAgICAgICAgdmFyY2hhcigxMCksCmlu dGYgICAgICAgICAgICAgICAgICAgIGJpZ2ludCwKdG1fbmV3ICAgICAgICAg ICAgICAgICAgdGltZXN0YW1wdHosCnR4bmlkICAgICAgICAgICAgICAgICAg IHNtYWxsaW50Cik7CiAqLwoKI2luY2x1ZGUgPHN0ZGlvLmg+CiNpbmNsdWRl IDxzdGRsaWIuaD4KI2luY2x1ZGUgPHN0cmluZy5oPgojaW5jbHVkZSA8dGlt ZS5oPgojaW5jbHVkZSA8YXJwYS9pbmV0Lmg+CgojaW5jbHVkZSAibGlicHEt ZmUuaCIKCnN0YXRpYyB2b2lkCmV4aXRfbmljZWx5KFBHY29ubiAqY29ubikK ewoJUFFmaW5pc2goY29ubik7CglleGl0KDEpOwp9Cgp0eXBlZGVmIHN0cnVj dAp7CiAgaW50IAkJY3VyZGF0ZTsKICBjaGFyCQlzdHJmWzhdOwogIGxvbmcJ CWludGY7CiAgaW50CQl0bV9uZXc7CiAgc2hvcnQJCXR4bmlkOwp9IHQxZGF0 YTsKCmludAptYWluKGludCBhcmdjLCBjaGFyICoqYXJndikKewogIGNoYXIJ CSp1c2VyOwogIGNoYXIJCSpwYXNzOwogIGNoYXIJCSpkYm5hbWU7CiAgY2hh cgkJKmhvc3QgPSBOVUxMOwogIGNoYXIJCSpwb3J0ID0gTlVMTDsKICBQR2Nv bm4JKmNvbm47CiAgUEdyZXN1bHQJKnJlczsKCiAgY2hhcgkJCWluc2VydFN0 bXRbNTEyXTsKICBpbnQJCQlyZXN1bHQ7CiAgY29uc3QgY2hhciogCXN0bXRO YW1lID0gInQxaW5zZXJ0IjsKICBjb25zdCBjaGFyKglwYXJhbVZhbHVlWzVd OwogIGludAkJCXBhcmFtTGVuZ3RoWzVdOwogIGludAkJCXBhcmFtRm9ybWF0 WzVdOwoKICB0MWRhdGEgbXlkYXRhOwogIGNoYXIJZGF0ZVsxNl07CiAgY2hh ciAgdG1fbmV3WzMyXTsKICBpbnQgaWk9MDsKCiAgaWYgKGFyZ2MgPCAzKQoJ ewoJICBmcHJpbnRmKHN0ZGVyciwgInVzYWdlOiBkYm5hbWUgdXNlciBwYXNz IFtob3N0XVtwb3J0XSBcbiIpOwoJICBleGl0KDEpOwoJfQogIGRibmFtZSAg ICA9IGFyZ3ZbMV07CiAgdXNlcgkgICAgPSBhcmd2WzJdOwogIHBhc3MJICAg ID0gYXJndlszXTsKICBpZiAoYXJnYyA+IDMpCWhvc3QgPSBhcmd2WzRdOwog IGlmIChhcmdjID4gNCkJcG9ydCA9IGFyZ3ZbNV07CgogIC8qIE1ha2UgYSBj b25uZWN0aW9uIHRvIHRoZSBkYXRhYmFzZSAqLwogIGNvbm4gPSBQUXNldGRi TG9naW4oaG9zdCwgcG9ydCwgTlVMTCwgTlVMTCwgZGJuYW1lLCB1c2VyLCBw YXNzKTsKCiAgLyogQ2hlY2sgdG8gc2VlIHRoYXQgdGhlIGJhY2tlbmQgY29u bmVjdGlvbiB3YXMgc3VjY2Vzc2Z1bGx5IG1hZGUgKi8KICBpZiAoUFFzdGF0 dXMoY29ubikgIT0gQ09OTkVDVElPTl9PSykKCXsKCSAgZnByaW50ZihzdGRl cnIsICJDb25uZWN0aW9uIHRvIGRhdGFiYXNlIGZhaWxlZDogJXMiLCBQUWVy cm9yTWVzc2FnZShjb25uKSk7CgkgIGV4aXRfbmljZWx5KGNvbm4pOwoJfQog IGZwcmludGYoc3Rkb3V0LCAiQ29ubmVjdGVkIHRvIGRhdGFiYXNlIDogJXMg JXNcbiIsIHVzZXIsIGRibmFtZSk7CgogIC8vIHByZXBhcmUgaW5zZXJ0IHN0 YXRlbWVudCB3aXRoIHVuaXF1ZSBrZXkKICBzdHJjcHkoaW5zZXJ0U3RtdCwg IklOU0VSVCBJTlRPIHQxIHZhbHVlcyAoJDEsICQyLCAkMywgJDQsICQ1KTsi KTsKCiAgLy8gbGV0IHRoZSBiYWNrZW5kIHByZXBhcmUgc3RhdGVtZW50IChp dCBpcyBwYXJzZWQvcGxhbm5lZCBvbmx5IG9uY2UpCiAgcmVzID0gUFFwcmVw YXJlIChjb25uLCBzdG10TmFtZSwgaW5zZXJ0U3RtdCwgMSwgTlVMTCk7CiAg cmVzdWx0ID0gUFFyZXN1bHRTdGF0dXMocmVzKTsKICBpZiAocmVzdWx0ICE9 IFBHUkVTX0NPTU1BTkRfT0spCgl7CgkgIGZwcmludGYoc3RkZXJyLCAiUFFw cmVwYXJlIGZhaWxlZDogJXMgOiAoJWQpICVzXG4iLCBpbnNlcnRTdG10LCBy ZXN1bHQsUFFlcnJvck1lc3NhZ2UoY29ubikpOwoJICBQUWNsZWFyKHJlcyk7 CgkgIGV4aXRfbmljZWx5KGNvbm4pOwoJfQogIGZwcmludGYoc3Rkb3V0LCAi UFFwcmVwYXJlIGRvbmUgOiAlcz0lc1xuIiwgc3RtdE5hbWUsIGluc2VydFN0 bXQpOwogIFBRY2xlYXIocmVzKTsKCiAgLy8gbWF5YmUgbXVsdGlwbGUgY2Fs bHMgdG8gaW5zZXJ0IGRhdGEKICBzdHJjcHkoZGF0ZSwgIjE5OTkwMTEwIik7 CiAgc3RyY3B5KG15ZGF0YS5zdHJmLCAiaGVsbG8yIik7CiAgbXlkYXRhLmlu dGYgPSBodG9ubCgodWludDMyX3QpMik7CiAgc3RyY3B5KHRtX25ldywgIjE5 OTktMDEtMDggMDQ6MDU6MDYgRVNUIik7CiAgbXlkYXRhLnR4bmlkID0gaHRv bnMoMyk7CgogIC8vIHNldCB2YWx1ZXMKICBwYXJhbVZhbHVlWzBdID0gZGF0 ZTsKICBwYXJhbVZhbHVlWzFdID0gbXlkYXRhLnN0cmY7CiAgcGFyYW1WYWx1 ZVsyXSA9IChjaGFyKikmbXlkYXRhLmludGY7CiAgcGFyYW1WYWx1ZVszXSA9 IHRtX25ldzsKICBwYXJhbVZhbHVlWzRdID0gKGNoYXIqKSZteWRhdGEudHhu aWQ7CgogIC8vIHNldCBsZW5ndGhzCiAgcGFyYW1MZW5ndGhbMF0gPSA4Owog IHBhcmFtTGVuZ3RoWzFdID0gNjsKICBwYXJhbUxlbmd0aFsyXSA9IHNpemVv ZihteWRhdGEuaW50Zik7CiAgcGFyYW1MZW5ndGhbM10gPSBzdHJsZW4odG1f bmV3KTsKICBwYXJhbUxlbmd0aFs0XSA9IHNpemVvZihteWRhdGEudHhuaWQp OwoKICAvLyBzZXQgZm9ybWF0CiAgcGFyYW1Gb3JtYXRbMF0gPSAwOwogIHBh cmFtRm9ybWF0WzFdID0gMDsKICBwYXJhbUZvcm1hdFsyXSA9IDE7CiAgcGFy YW1Gb3JtYXRbM10gPSAwOwogIHBhcmFtRm9ybWF0WzRdID0gMTsKCiAgcmVz ID0gUFFleGVjUHJlcGFyZWQoY29ubiwgc3RtdE5hbWUsIDUsIHBhcmFtVmFs dWUsIHBhcmFtTGVuZ3RoLCBwYXJhbUZvcm1hdCwgMCk7CiAgcmVzdWx0ID0g UFFyZXN1bHRTdGF0dXMocmVzKTsKICBpZiAocmVzdWx0ICE9IFBHUkVTX0NP TU1BTkRfT0spCgl7CgkgIGZwcmludGYoc3RkZXJyLCAiZXhlYyBmYWlsZWQ6 ICVzIDogKCVkKSAlc1xuIiwgaW5zZXJ0U3RtdCwgcmVzdWx0LFBRZXJyb3JN ZXNzYWdlKGNvbm4pKTsKCSAgUFFjbGVhcihyZXMpOwoJICBleGl0X25pY2Vs eShjb25uKTsKCX0KICBmcHJpbnRmKHN0ZG91dCwgImV4ZWMgZG9uZSA6ICVz LCAkMT0oJWQpXG4iLCBzdG10TmFtZSwgaWkpOwoKICBQUWNsZWFyKHJlcyk7 CgogIC8qIGNsb3NlIHRoZSBjb25uZWN0aW9uIHRvIHRoZSBkYXRhYmFzZSBh bmQgY2xlYW51cCAqLwogIFBRZmluaXNoKGNvbm4pOwoKICByZXR1cm4gMDsK fQo= ---1611076590-1221816962-1369266903=:47851 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-interfaces mailing list (pgsql-interfaces@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces ---1611076590-1221816962-1369266903=:47851--