Zeoslib Portal

Trupka, thank you for answering my question. A2. Yes - ZConnection.Properties.Add('codepage=WIN1250'); A2 sounds good but unfortunately it didn't work for me (with the same encoding or with 1253 for Greek). Connect method executes well, but when I try to open a ZQuery the back end reports this error...

Hi, I'm back again and am happy about that. :) I have to develop an application which should store data in Postgres. The front end should also accept Greek language data. Could you suggest me something clever how to do it? My questions so far: Q1. Can I store Greek characters in ASCII encoded databa...

Yes, I can add new note to an open issue. The problem must be that the issue was resolved. Thx.

h.

Ok, nice of you. I tested rev305 as you mentioned in the Mantis note but I saw a rev306 too. Should I also try that? Other thing: As far as I can remember, earlier I was able to edit notes directly in the Mantis and also I received notification mails about the monitored or self-created bug reports. ...

Dear Mark,
I have just realized that a bug fix was sent to the Mantis (0000059). It seems to fix the problem and so far I cannot see any problems.

Thank you very much.

Hudgi

It seems your information is more up to date then mine. Thank you for the quote, i missed this sentence in the doc. It's a good news, isn't it? So Mark was right at the first... But what makes it sure that the user executed this ALTER SEQUENCE .. OWNED BY statement? It is quite a good stuff, but it ...

Mark, You are right if you use this approach. Sorry, but I think this is that "bad programming practice" you mentioned earlier. (note the risk of other users simultaneous inserts) In my opinion it would be a much more solid solution to obtain the next_value Before executing the insert stat...

Mark, Ben, now came into my mind that the default expression is quite a good approach (thx for Ben) because that whole data stored in information_schema.columns.column_default is the complete expression which must be executed before every insert. (I mean that we do not need to extract the sequence n...

Ben, AFAIC, in postgres the dependency links a sequence to a table field and there are no explicit markers. I think your solution is not really solid because you can't decide if a sequence is referenced in column_default or not. Certainly you can judge by searching for character sequences like "...

Mark, if you create a column with type Serial , an explicit sequence will be created automatically. In PGAdmin3 you can see on the properties page a sequence field which gives you the name of the associated sequence for the selected field object. ("[FIELDNAME]_seq" by default) Because this...

Mark,
thank you for your summary. You are absolutely right.
Does this append feature also work with Postgres tables? Does it handle sequences as well?

-- h.

Puunnnk, "SELECT max(id) as id FROM codigo" it won't work on a network environment. What will you do if some other users also insert new records in parallel with you? You will see the id inserted last time by anybody, not only you... I do not know if there is a Mysql object "sequence&...

OK, I've got it. I monitored the execution by ProcessExplorer and found that no lib*.dll was loaded. I had simply add an entry to the system PATH pointing to the exe directory (this directory contains the libpq.dll). I thougth that it is not necessary to add the execution directory itself to the PAT...

Hi, I managed to set up the program on Win98. Do not ask me how.. :) I installed the Delphi7 IDE to debug the code right there - and magically it got repared... Now I have to set up another VM to try out againg without the IDE. But: On NT4 I have a more usable error message: SQL Error: could not sen...

I've done it. You can download the sample project as well.

Thank you very much,
-- Csaba