Re: [GENERAL] pg_dirtyread doesnt work

2012-12-28 Thread Alejandro Carrillo
So I going to say, Alvaro. The table structure should not create a table with TOAST > > De: Alvaro Herrera >Para: Phil Sorber >CC: Alejandro Carrillo ; "pgsql-general@postgresql.org" > >Enviado: Viernes 28 de diciembre de 2012 15:10 >Asunto: Re: [GENERAL] pg_

Re: [GENERAL] pg_dirtyread doesnt work

2012-12-28 Thread Alvaro Herrera
Phil Sorber escribió: > Most likely it's because of TOAST'd records. The module is pretty > naive and needs to be updated to handle such cases. It doesn't look like a column with this definition would be toasted, though: > On Fri, Dec 28, 2012 at 10:53 AM, Alejandro Carrillo > wrote: > > Creat

Re: [GENERAL] OneCNC XR5 3D Mill Expert v30.43 Crack

2012-12-28 Thread Martin Gainty
28 December 2012 Dear Sir Before we proceed I need to know the address of your operation in ChinaWhat is the lat and long coordinates of your operation in china I will also need all details on your H1BVisa..most notably which organisation in the US is sponsoring youand what is their contact num

Re: [GENERAL] pg_dirtyread doesnt work

2012-12-28 Thread Phil Sorber
Most likely it's because of TOAST'd records. The module is pretty naive and needs to be updated to handle such cases. On Fri, Dec 28, 2012 at 10:53 AM, Alejandro Carrillo wrote: > > Anybody knows why could be happening: ERROR: invalid memory alloc request > size 1850015748 > > Thanks > > ___

Re: [GENERAL] UNION and pg_restore

2012-12-28 Thread Bryan Lee Nuse
Thanks, Tom, for your helpful explanation and suggestions. > Now you're doubtless wondering why Postgres doesn't dodge this ambiguity > for you. This is exactly what I was wondering, of course. And I follow the reasoning behind why it cannot, at present. If Postgres can't ensure that the view

Re: [GENERAL] pg_dirtyread doesnt work

2012-12-28 Thread Alejandro Carrillo
Anybody knows why could be happening: ERROR:  invalid memory alloc request size 1850015748 Thanks > > De: Alejandro Carrillo >Para: "pgsql-general@postgresql.org" >Enviado: Jueves 27 de diciembre de 2012 16:17 >Asunto: [GENERAL] pg_dirtyread doesnt work > >

Re: [GENERAL] Tool to create database diagrams in postgreSQL

2012-12-28 Thread David Goodenough
On Friday 28 Dec 2012, nevillekb wrote: > Hi, > > Can anyone tell me which free GUI based tools are available for creating > database diagrams for my database in postgresql. > > Thanks, > > Neville. > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/Tool-to-c

Re: [GENERAL] Tool to create database diagrams in postgreSQL

2012-12-28 Thread Ognjen Blagojevic
Neville, On 28.12.2012 7:52, nevillekb wrote: Can anyone tell me which free GUI based tools are available for creating database diagrams for my database in postgresql. This was asked many times before, search the archives. E.g: http://archives.postgresql.org/pgsql-general/2011-08/msg01023.php

Re: [GENERAL] Cursor fetch Problem.

2012-12-28 Thread Harry
Hi, Kindly see the below attached statements related to Cursor Fetch Issue it's still residing as a process. 500 20222 31036 79 Dec27 ?16:22:31 postgres: user1 sampledb 192.168.0.40[36022] FETCH 500 20829 31036 81 Dec27 ?16:18:48 postgres: user1 sampledb 192.168.0.40[5759

[GENERAL] Tool to create database diagrams in postgreSQL

2012-12-28 Thread nevillekb
Hi, Can anyone tell me which free GUI based tools are available for creating database diagrams for my database in postgresql. Thanks, Neville. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Tool-to-create-database-diagrams-in-postgreSQL-tp5738103.html Sent from the

Re: [GENERAL] Cursor fetch Problem.

2012-12-28 Thread Harry
No any statements as u mentioned. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Cursor-fetch-Problem-tp5737915p5738120.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] update from a csv file?

2012-12-28 Thread Christian Hammers
Am Fri, 28 Dec 2012 00:47:35 -0500 schrieb François Beausoleil : > > Le 2012-12-27 à 09:54, Kirk Wythers a écrit : > > > I have been using COPY FROM to do a mass import of records from CSV > > files into a new database. I have discover however, a small number > > of records ( a few thousand) in

[GENERAL] Fwd: Re: [SQL] sql basic question

2012-12-28 Thread Andreas Kretschmer
sorry, first answer not to the list ... -- Ursprüngliche Nachricht -- Von: Andreas Kretschmer An: Antonio Parrotta Datum: 28. Dezember 2012 um 13:00 Betreff: Re: [SQL] sql basic question > > so the result should be: > LABELID Distance SIDE > "

Re: [GENERAL] Cursor fetch Problem.

2012-12-28 Thread Amit Kapila
On Thursday, December 27, 2012 2:44 PM Harry wrote: > Below is the Linux ps -ef | grep postgres output :- > > 501 12163 5473 0 Dec19 ?00:00:00 postgres: enterprisedb > sampledb 192.168.0.231[53991] ?EDB-SPL Procedure successfully completed > 501 12167 5473 0 Dec19 ?00