Re: [GENERAL] PostgreSQL 8.3.4 Solaris x86 compilation issues

2008-11-01 Thread Zdenek Kotala
Hi, It is really strange. Is there any reason why you don't use integrated SSL? 64bit version is located in /usr/sfw/lib/64 Try ./configure --prefix=/opt/usr/local --with-libs=/usr/sfw/lib/64:/opt/usr/local/lib --without-readline --with-openssl CFLAGS= -m64 -xmodel=medium Or you canuse

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

2008-11-01 Thread Gregory Stark
Ivan Sergio Borgonovo [EMAIL PROTECTED] writes: But sorry I still can't get WHY compression as a whole and data integrity are mutually exclusive. ... Now on *average* the write operations should be faster so the risk you'll be hit by an asteroid during the time a fsync has been requested

Re: [GENERAL] PostgreSQL 8.3.4 Solaris x86 compilation issues

2008-11-01 Thread postgres Emanuel CALVO FRANCO
do you just read FAQ_Solaris in the docs. I don't remember at all, but is explain some steps to run with SSL. 2008/11/1, Zdenek Kotala [EMAIL PROTECTED]: Hi, It is really strange. Is there any reason why you don't use integrated SSL? 64bit version is located in /usr/sfw/lib/64 Try

Re: [GENERAL] PostgreSQL 8.3.4 Solaris x86 compilation issues

2008-11-01 Thread Zdenek Kotala
I know solaris FAQ well. There is mention OpenSSL problem with Solaris 8. Solaris 9 and newer are OK. They ship OpenSSL version which really work. Zdenek postgres Emanuel CALVO FRANCO napsal(a): do you just read FAQ_Solaris in the docs. I don't remember at all, but is explain

Re: [GENERAL] Decreasing WAL size effects

2008-11-01 Thread Bruce Momjian
Tom Lane wrote: Greg Smith [EMAIL PROTECTED] writes: That pushes the problem of writing a little chunk of code that reads only the right amount of data and doesn't bother compressing the rest onto the person writing the archive command. Seems to me that leads back towards wanting to

[GENERAL] Error in Adding All Tables

2008-11-01 Thread salman Sheikh
Hi freinds, i wanted to add my all tables once in MFC application, i have a databank,which has 11 tables and i want to add them all togather. After Adding all tables, it shows me always this errors by debugging. ERROR: column reference ctid is ambiguous; Error while executing the query

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread justin
salman Sheikh wrote: Hi freinds, i wanted to add my all tables once in MFC application, i have a databank,which has 11 tables and i want to add them all togather.  After Adding all tables, it shows me always this errors by debugging.

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread justin
I have no idea what you are trying to do??   please send the SQL commands you are using.  For me to help you Need to know what you are trying to accomplish and need to see the code! salman Sheikh wrote:  hi Do u have any suggestion regarding this problem? can u add all tables once

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread justin
you mean you are trying some kind of table joining correct??? example Select * from mytable, othertable where ctid = ctid ??? Please post the SQL statement you are using to communicate with the database.  The select insert update commands.   If i could see what you are doing i would have

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread Joshua D. Drake
salman Sheikh wrote: Hi freinds, i wanted to add my all tables once in MFC application, i have a databank,which has 11 tables and i want to add them all togather. After Adding all tables, it shows me always this errors by debugging. ERROR: column reference ctid is ambiguous; Error while

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread justin
Yes, i'm working with VS 2008 with QT framework working on a application with i don't know couple hundred thousand lines of code. Been using VS sense 1997  how about you??? One of your big problems is your using the Automatic Class builder.  Its sucks and is what is causing your problem as

Re: [GENERAL] speed up restore from dump

2008-11-01 Thread Robert Treat
On Friday 31 October 2008 08:07:08 Sam Mason wrote: On Thu, Oct 30, 2008 at 02:28:38PM -0700, Alan Hodgson wrote: On Thursday 30 October 2008, Joao Ferreira [EMAIL PROTECTED] wrote: well. see for yourself... (360 RAM , 524 SWAP) that's what it is... it supposed to be somewhat an

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread justin
Exactly NO not a clue. Do a crtl+F which brings up the Search box in Visual Studio search for Select. it will be in one of automatically created .cpp files. Class builder is suppose to create fully qualified queries but in some cases it does not mshelpfile