Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfU5m-0000jL-A1 for pgsql-general@arkaria.postgresql.org; Thu, 23 May 2013 11:53:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UfU5l-0000ZH-HY for pgsql-general@arkaria.postgresql.org; Thu, 23 May 2013 11:53:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfU5k-0000YY-0w for pgsql-general@postgresql.org; Thu, 23 May 2013 11:53:56 +0000 Received: from nm26.bullet.mail.bf1.yahoo.com ([98.139.212.185]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UfU5a-0006E5-Vg for pgsql-general@postgresql.org; Thu, 23 May 2013 11:53:55 +0000 Received: from [98.139.212.146] by nm26.bullet.mail.bf1.yahoo.com with NNFMP; 23 May 2013 11:53:44 -0000 Received: from [98.139.212.238] by tm3.bullet.mail.bf1.yahoo.com with NNFMP; 23 May 2013 11:53:44 -0000 Received: from [127.0.0.1] by omp1047.mail.bf1.yahoo.com with NNFMP; 23 May 2013 11:53:44 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 822441.65379.bm@omp1047.mail.bf1.yahoo.com Received: (qmail 9556 invoked by uid 60001); 23 May 2013 11:53:44 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1369310024; bh=66qvfzPguWK20xPRgBlVI59pDoDV9I1aFRVIHxcxaJY=; 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=yW9OPQgeEH6nDP3+CQKJslv93abxX77834fHsveGKRY9Wh2lPrbVagz8bH/8oxFIOZhh8eewFN+LEx+4onUYVFekesn8iJuMNNfki13o8kESd/G5EtgL6VNnb0ucpdzNu+mGIDetj2q2a4IBRSgOw7OyGGNYk9TfoYirPE8rlSA= 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=yPFYSqgFNOQvHhJQ3g6zuzjbu3QPw6tV67/i/0pz/Q4T1hKTtY2dVSEHkKLtYG+Ommabf9mBFhFrNbGudzhSDkBvqvidNWpvJjgd7if4CHU1aqTNNoNd8zVcQ+/ECdRGFO09iP7kXb7bHG5OOFaD+jKtX7ozjl7kQjv8OLGwvyM=; X-YMail-OSG: YcHx2HgVM1kcRjms_fOqwRVpn1urXbpoz0N8Q4cfqMAetDl gIIfxIJBR52M.ca.WEokWtKiIwmbihZLM8CfoPS7tCyaiw9puJAaDGcVqH7M zIsV633RMsCkxVGwabCKA70U8_pB4vh46PzZmFm2k5szHsPavayoO_vH3Eoq K2BPrzOhnsSyFgP5USeCmXMqtUmtLTUVUnqMASfQXEg7h5jh1oYbZLv_ui6. jPzSdwsigRNrGEm9gq3cgYcdUifg4a.KxDCERXxMOId8i3aK7mPZNkhgJl7j P4E1a2xGrIccZLL0VKeQ_AjVQINimXyDr7mdPwDix_pEKI7OWwEsZ0kD22tv 0MYv6u3_n5kAhADlsMSmQsPKjY3savfmdzqsZAHfldxSWOHbNnHQ0niKkOMd 91ZjMFp2YcNxBEC_ugobWmO0YZ0K80Q5tPEWDVQb_0qqHLWBVYfhMZVRdR2E bgMBdR5ozzH0UCaa_jjBvy27N2P2CN3fmF_NoyvSUN0P0L_MHwUfPocPaVNi bOZYLiXkhE1Iv0MKN1FJmqDBm2w-- Received: from [69.125.89.202] by web164904.mail.bf1.yahoo.com via HTTP; Thu, 23 May 2013 04:53:44 PDT X-Rocket-MIMEInfo: 002.001, MS4gSSBhbSBoYXZpbmcgdHJvdWJsZSB3cml0aW5nIGxvbmcgdmFsdWVzIHZpYSBjIGludGVyZmFjZSAudGVzdGxpYnFwLWR0LmMgwqBpcyBhdHRhY2hlZC4KLiAyIGlzIGJlaW5nIGluc2VydGVkIGFzIDg1ODk5MzQ1OTIuCgoKcXNmPT4gc2VsZWN0ICogZnJvbSB0MTsKwqAgwqBjdXJkYXRlIMKgIHwgwqBzdHJmIMKgfCDCoCDCoCDCoCDCoGludGYgwqAgwqAgwqAgwqB8IMKgIMKgIMKgIMKgIHRtX25ldyDCoCDCoCDCoCDCoCB8IHR4bmlkwqAKLS0tLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0BMAEBAQE- X-Mailer: YahooMailWebService/0.8.144.546 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> <1369266903.47851.YahooMailNeo@web164904.mail.bf1.yahoo.com> Message-ID: <1369310024.8114.YahooMailNeo@web164904.mail.bf1.yahoo.com> Date: Thu, 23 May 2013 04:53:44 -0700 (PDT) From: Neeraj Rai Reply-To: Neeraj Rai Subject: - pgaql long value corrupted using htons To: "pgsql-general@postgresql.org" In-Reply-To: <1369266903.47851.YahooMailNeo@web164904.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="-1611076590-1463430666-1369310024=:8114" X-Pg-Spam-Score: -3.1 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org ---1611076590-1463430666-1369310024=:8114 Content-Type: multipart/alternative; boundary="-1611076590-1348199353-1369310024=:8114" ---1611076590-1348199353-1369310024=:8114 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable 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 am using string for data and timestamp and it seems to work. I found functions like TimestampTzGetDatum,time_t_to_timestamptz in the cod= e=A0 But it seems they are not exposed to interface. I have the date time in unix format (via time and gettimeofday). I would pr= efer to pass those values in binary, rather than string format. Is there any option to do this ? Or i= s it easily addable? thanks Neeraj ---1611076590-1348199353-1369310024=:8114 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
1. I am having trouble writing long values via c interface .tes= tlibqp-dt.c  is attached.
. 2 is being= inserted as 8589934592.


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

I trie= d htobe64 but that didn't help either.
Any advi= se would be appreciated.

2. I am using string for data and timestamp and it seem= s to work.

I found functions like Ti= mestampTzGetDatum,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 tim= e and gettimeofday). I would prefer to pass those values
in binary, rather than string format. Is there any option to do t= his ? Or is it easily addable?

thanks
Neeraj
= ---1611076590-1348199353-1369310024=:8114-- ---1611076590-1463430666-1369310024=:8114 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-1463430666-1369310024=:8114 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general ---1611076590-1463430666-1369310024=:8114--