Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tisqy-0007RT-Ff for pgsql-performance@arkaria.postgresql.org; Wed, 12 Dec 2012 20:24:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tisqx-0002hP-DF for pgsql-performance@arkaria.postgresql.org; Wed, 12 Dec 2012 20:24:27 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tisqw-0002hK-9U for pgsql-performance@postgresql.org; Wed, 12 Dec 2012 20:24:26 +0000 Received: from nm16.bullet.mail.ird.yahoo.com ([77.238.189.69]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tisqt-0002ET-UA for pgsql-performance@postgresql.org; Wed, 12 Dec 2012 20:24:25 +0000 Received: from [77.238.189.52] by nm16.bullet.mail.ird.yahoo.com with NNFMP; 12 Dec 2012 20:24:22 -0000 Received: from [212.82.108.253] by tm5.bullet.mail.ird.yahoo.com with NNFMP; 12 Dec 2012 20:24:22 -0000 Received: from [127.0.0.1] by omp1018.mail.ird.yahoo.com with NNFMP; 12 Dec 2012 20:24:21 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 996669.94683.bm@omp1018.mail.ird.yahoo.com Received: (qmail 28044 invoked by uid 60001); 12 Dec 2012 20:24:21 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.es; s=s1024; t=1355343861; bh=1B2ZJaTyP1+eJiA1tHdU0FGRssAb5iOu0kQAU9pCg/k=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=HxsKBbdyjLkYoug1E6b9CpbBCmw7Q+js7ejB7zaqNx5lv1ucmyFT7WdnRGNj+rmDgSXiZ5Fb3LLCCij9kFzrBVfVuRH2qEJzUosEsy1oACWOM8J04nItDMhw6ffdyvDONFhZ9FPt93TY085bk5VBbgYq1zbe8uzp0dqzUUGKMgA= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.es; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=Z/8J9KNuQkPVJHJfU0vAqpF823NcTWO8RdOQ6m0XhHcxJZJgCPACyG05GgphZxCOnggCQrJcTktt6dIZSWBwGd2kMjzRHi1xry6nuHHLCGkkOVD/nVzD1wyRf7OYbhYnFyGLovKbuJdGGA6nDpaDQl6sAoOt/r9IW4ADBFlWwsc=; X-YMail-OSG: chXdsJwVM1lqfk9RyKryGpyw7gGnuDhH6F.RwzeqU2NoMtn 3cRqAGMjUpTGNU6ed1nmeeAH81E71sjOBNmHgSlO6bLzbzCyuzt8Gk8sm6Sf osvf.aGrUoi6jnT5ggUWudN.4BPv53E6J6.0u5DGwWFHzzBt7xM7AkQt5mEx 484buE.kvbsWBVbMMkmrgdGrwQJAmY6Blh1cckqPwsaDpY8SRCC_IFGfBSkL W25K8DeClb1JPuBpiaalR6WR20IGuRqYg_TC6n7Ve0wpBhwVnUmBXFFTbRSM Je0Z5qv1zN5j3_KoA4GoYnEEY2UwuAVh2cr98yNE2I9CZS2y_hWIHNAwEEU3 wFQE.btjdh01KrwuK8Xvgp3JFZFO83IfWqbjY7jFNXy3jcEwmoRcgZi4MjF_ bncFrr1DLSwucHSWG._nwEVqqXiWvV1WhDjb_3ywch6u4PsCoRN1unN_d35a u4KRYUmAYJAefZHlbszTTBCmzDIx6a1UgmqNhKvQobBwiJ2FEK4PThaiRwqU 8MtR21g2Ev7MJOmelQlUp.nDEUVzLvux55hejIdobEXYHeDsf9Tb4ajpM95p Ct2rfnzBADRfUwsa4hjeRU18j8yzGK_ul_Jl5agRBWaJlIetSp.HoRo_fn3e FHWX5 Received: from [87.248.115.98] by web172202.mail.ir2.yahoo.com via HTTP; Wed, 12 Dec 2012 20:24:21 GMT X-Rocket-MIMEInfo: 001.001, SGksCgpBbnlib2R5IGtub3dzIGhvdyB0byBjcmVhdGUgYSB0YWJsZSB1c2luZyBhIHRhYmxlIGZpbGU_IEl0IGlzbid0IGEgZmR3LCBpcyBhIGZpbGUgdGhhdCBjb21wb3NlIHRoZSB0YWJsZSBpbiBwb3N0Z3Jlc3FsIGFuZCBnZXQgd2l0aCB0aGUgcGdfcmVsYXRpb25fZmlsZXBhdGggZnVuY3Rpb24uIEV4OgoKc2VsZWN0IHBnX3JlbGF0aW9uX2ZpbGVwYXRoKCdwZ19wcm9jJyk7CgpBbnlib2R5IGtub3dzIGEgSkRCQyBvciBhIG11bHRpcGxhdGZvcm0gY29kZSB0aGF0IGxldCByZWFkIHRoZSBkZWxldGUgcm8BMAEBAQE- X-Mailer: YahooMailWebService/0.8.128.478 References: <1355329606.81067.YahooMailNeo@web172204.mail.ir2.yahoo.com> Message-ID: <1355343861.27682.YahooMailNeo@web172202.mail.ir2.yahoo.com> Date: Wed, 12 Dec 2012 20:24:21 +0000 (GMT) From: Alejandro Carrillo Reply-To: Alejandro Carrillo Subject: Re: Read rows deleted To: "pgsql-performance@postgresql.org" Cc: Sergey Konoplev In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1007433603-905384605-1355343861=:27682" X-Pg-Spam-Score: 1.8 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org ---1007433603-905384605-1355343861=:27682 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0A=0AAnybody knows how to create a table using a table file? It isn't a= fdw, is a file that compose the table in postgresql and get with the pg_re= lation_filepath function. Ex:=0A=0Aselect pg_relation_filepath('pg_proc');= =0A=0AAnybody knows a JDBC or a multiplatform code that let read the delete= rows of a table without writing of a table file?=0A=0AThanks=0A=0A=0A=0A= =0A>________________________________=0A> De: Sergey Konoplev =0A>Para: Alejandro Carrillo =0A>CC: "pgsql-perfo= rmance@postgresql.org" =0A>Enviado: Mi= =E9rcoles 12 de diciembre de 2012 15:13=0A>Asunto: Re: [PERFORM] Read rows = deleted=0A> =0A>Hi,=0A>=0A>On Wed, Dec 12, 2012 at 8:26 AM, Alejandro Carri= llo wrote:=0A>> Anybody knows a JDBC or a multiplatfor= m code that let read the delete rows=0A>> of a table without writing of a t= able file?=0A>> Anybody knows how to create a table using a table file?=0A>= =0A>I am not sure what you mean but may be one of this links will help you:= =0A>=0A>- http://www.postgresql.org/docs/9.2/static/file-fdw.html=0A>- http= ://pgxn.org/dist/odbc_fdw/.=0A>=0A>>=0A>> thanks=0A>=0A>=0A>=0A>--=0A>Serge= y Konoplev=0A>Database and Software Architect=0A>http://www.linkedin.com/in= /grayhemp=0A>=0A>Phones:=0A>USA +1 415 867 9984=0A>Russia, Moscow +7 901 90= 3 0499=0A>Russia, Krasnodar +7 988 888 1979=0A>=0A>Skype: gray-hemp=0A>Jabb= er: gray.ru@gmail.com=0A>=0A>=0A> ---1007433603-905384605-1355343861=:27682 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi,

Anybody knows how to create a table using a table file? It isn'= t a fdw, is a file that compose the table in postgresql and get with the pg= _relation_filepath function. Ex:

select pg_relation_filepath('pg_proc');

Anybody knows a JDBC or a multipla= tform code that let read the delete rows of a table without writing of a ta= ble file?

Thanks

=

De: Sergey Konople= v <gray.ru@gmail.com>
Para:= Alejandro Carrillo <fasterzip@yahoo.es>
CC: "pgsql-performance@postgresql.org" = <pgsql-performance@postgresql.org>
Enviado: Mi=E9rcoles 12 de diciembre de 2012 15:13
= Asunto: Re: [PERFORM] Read= rows deleted

Hi,

On Wed, Dec 12, 2012 at 8:2= 6 AM, Alejandro Carrillo <fasterzip@yahoo.es> wrote:
&g= t; Anybody knows a JDBC or a multiplatform code that let read the delete ro= ws
> of a table without writing of a table file?
> Anybody know= s how to create a table using a table file?

I am not sure what you m= ean but may be one of this links will help you:

- http://= www.postgresql.org/docs/9.2/static/file-fdw.html
- http://pgxn.org/dist/odbc_fdw/<= /a>.

>
> thanks



--
Sergey Konoplev
Dat= abase and Software Architect
http://www.linkedin.com/in/grayhemp

Phone= s:
USA +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Kras= nodar +7 988 888 1979

Skype: gray-hemp
Jabber: gra= y.ru@gmail.com


---1007433603-905384605-1355343861=:27682--