Zeoslib Portal

I figured out the solution, and am posting it in case anyone else has this problem. I need to "set standard_conforming_strings=off". I can run this statement in an SQLProcessor object. This statement will cause an error if it is run on a PostgreSQL server earlier than version 9. If you use...

I checked the version of libpq.dll. It is the correct version. I assume this is because it is installed as part of the PostgreSQL 9.3 installation. I tried adding the property bytea_output=escape to the connection object, and it did not cause an error, but it did not help. I am pretty sure the probl...

I am using a 7.1 alpha version that seems to be working quite well for me. Recently we have tried to upgrade to PostgreSQL 9.3. Everything works well, except for the jpg that my software stores in a bytea field. It can be stored without an error message, but I get jpg error 53 when I try to view it....

A couple of months ago I downloaded an alfa to fix a bug with posting data with a single quote in it. I think it is 7.1.0.2161. Since I installed this, the single quote thing works great, but I have been having occasional memory leaks that I have been trying to get rid of. They seem to happen when t...

OK, I have tested the fix some more, and it seems to work very well with no additional bugs introduced. Thank you very much for all your assistance!! A little clarification. When I said "Obviously, this property is a stringlist, so it could also be done in code." I did not mean you (the ze...

Actually, I went and looked at the change log, and it looks like 2169 is the revision that you did. As before, it took me a few minutes to figure out exactly what I was supposed to do to follow your instructions. For someone else reading this (or me in 3 weeks, I already had to go back and look at m...

By the time I went to get the files, they were already at rev. 2169. Is it OK to use that one, or should I ask my SVN guru to show me how to get exactly 2168?

Right now my project is dead in the water because I don't have a bug-free version of Zeos that I can run it with. I hope what you are discussing will not take a long time! I believe you are saying that it is somewhat strange to have varchar fields without a limit. I agree. I did not mean to do this....

I assume this means that the length of the data in the field would be limited to 255 bytes if the length is not specified?

Unfortunately, when I went to use the patch with my software, something in it is now broken and does not work. I have several databases that the software needs to use, and so in each database I have a version table with a 'kind' field. The kind field in each is varchar and contains a string indicati...

Yay, it works! I did not test it extensively, but I was able to post a single quote with no problems, where it gave me a problem before. Is this particular version I downloaded (2161) stable enough so that I can continue using it? I am getting ready to test my software prior to a release. What is yo...

OK, I hate to be a needy person, but... I think I have found the correct repository at http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-7.1/src/ Is the only file I need at http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-7.1/src/plain/ZPlainPostgreSqlDriver.pas or do I need to get mo...

Is it possible to give the full URL of the repository? I have not used it before, so I don't know where it is. (Luckily, we have just started using SVN at work, so I know how to use it. I know I saw a link for it somewhere, so I will also go try to find it.)

I just tried the breakpoint you suggested, and the EscapeString function is not assigned, as you theorized.

Is there a patch I can try to get it assigned?

I would really like to keep using PostgreSQL 8.1 for a few more months.

Somebody gave me a code snippet to display the PostgreSQL version, so here is what is displayed on my Help - About screen: PostgreSQL 8.1.11 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) I think you are probably on to something here. I realize 8.1 is outdated and no longer ...