Hi Zlatko, it has nothing to do with the amount of records, but with the amount of fields. The size for one record.
You're program will need a lot of memory. The table batches_microbs containts a few varchar's without any limitation of the length. Thus the maximum length is used. You should probably change them to varchar(20) orso... The fix was made late yesterday evening, so I think that it'll be in the snapshot of tomorrow. Joost On Mon, 3 Jul 2006, [UTF-8] Zlatko Mati?? wrote: > OK. thanks for information. > Which revision of fpc is included in Lazarus-0.9.17-20060630-win32.exe? > I narrowed resultset of the query by adding where clause: "select * from > batches_microbs where batches_microbs.plant='ZUBNE PASTE' and > batches_microbs.sampling_type='OTISCI POVR??INA';" and now it has only 9 > rows. But, the problem remains! How do you explain that? > > Regards, > > Zlatko > > ----- Original Message ----- > From: "Joost van der Sluis" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Monday, July 03, 2006 1:10 AM > Subject: Re: [lazarus] problems with SQLdb components and Postgres > > > fixed in fpc revision 4086 > > On Sun, 2006-07-02 at 16:18 +0200, Zlatko Mati?? wrote: > > Yes, the same happens when using simple sql query such as "select * from > > sometable;". > > > > ----- Original Message ----- > > From: "johnf" <[EMAIL PROTECTED]> > > To: <[email protected]> > > Sent: Sunday, July 02, 2006 3:16 PM > > Subject: Re: [lazarus] problems with SQLdb components and Postgres > > > > > > On Saturday 01 July 2006 23:32, Zlatko Mati?? wrote: > > > Hi! > > > > > > Well, I agree it is a complex query:) But the same happens with very > > > simple > > > query such as "select * from batches_microbs;"... > > > I have only default logging on Postgres enabled. Please, tell me which > > > options in postgresql.conf should I enable in order to see detailed log > > > information. > > > Thanks, > > > > > > Zlatko > > > > > > P.S. Have you seen screenshots that I sent you directly on your e-mail? > > > > > > > > > ----- Original Message ----- > > > From: "johnf" <[EMAIL PROTECTED]> > > > To: <[email protected]> > > > Sent: Saturday, July 01, 2006 11:59 PM > > > Subject: Re: [lazarus] problems with SQLdb components and Postgres > > > > > > On Saturday 01 July 2006 11:05, Zlatko Mati?? wrote: > > > > ((results_microbs join batches_microbs on' > > > > ' (((results_microbs.batch) =' > > > > ' (batches_microbs.batch)))) join' > > > > ' (departments join plants on' > > > > ' ((departments.department =' > > > > ' plants.department))) on' > > > > ' (((batches_microbs.plant) =' > > > > ' (plants.plant)))) > > > > > > Fairly complex joins! Did you turn on the logging in Postgres? What > > > does > > > the > > > log report say? Have you attempted to simplify the SQL expression to > > > determine where the break down occurs? Although, I have a few complex > > > SQL > > > expressions in my code I don't attempt to create joins within joins. > > > > > > Also I generally use sqlquery.add for the expression. I did not check > > > the > > > rest of the code because you suggested that you were returning the wrong > > > data > > > types (which means that the program sent a legal sql statement). You > > > also > > > suggested that your sql statement worked from pgAdminIII. So again I > > > wonder what FPC is sending to Postgres? Check the log and see if what > > > is > > > being sent > > > from FPC matches what pgAdminIII is sending. If they do match then I > > > suggest > > > we have a bug in FPC. The funny thing is I think the first thing that > > > happens when a sql select is made is the table information (such as > > > field > > > type) is returned. > > > > > > John > > > > In postgres.conf I have turned on the following: > > log_statement = true > > log_timestamp = true > > > > No I have not seen your screenshots. I have my mail filtered. I'll > > check. > > > > Are you getting the same issues with a simple select statement such as > > "Select > > * from SomeTable" ? > > > > John > > > > _________________________________________________________________ > > To unsubscribe: mail [EMAIL PROTECTED] with > > "unsubscribe" as the Subject > > archives at http://www.lazarus.freepascal.org/mailarchives > > > > _________________________________________________________________ > > To unsubscribe: mail [EMAIL PROTECTED] with > > "unsubscribe" as the Subject > > archives at http://www.lazarus.freepascal.org/mailarchives > > > -- > Met vriendelijke groeten, > > Joost van der Sluis > CNOC Informatiesystemen en Netwerken > http://www.cnoc.nl > > _________________________________________________________________ > To unsubscribe: mail [EMAIL PROTECTED] with > "unsubscribe" as the Subject > archives at http://www.lazarus.freepascal.org/mailarchives > > _________________________________________________________________ > To unsubscribe: mail [EMAIL PROTECTED] with > "unsubscribe" as the Subject > archives at http://www.lazarus.freepascal.org/mailarchives > > _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
