Hai.. I introduce myself, my name : Agus, from Indonesia. Im develop application using POwerbuilder 7 and postgresql 7.3.
I have serveral error, and cannot solve yet. Anybody help me?
Hi Agus, I'll do my best.
This is the error : 1. When I connecct postgresql using powerbuilder , there is message like this ... Catalog tables could not be created and are not available for use Why ?
Don't know. This doesn't sound like a PostgreSQL error - is it something from PowerBuilder? You'll have to turn statement logging on in the postgresql.conf file and see what sql is being sent unless powerbuilder can tell you more. Details on setting statement logging are in the manuals.
2. When I login to my application , sometimes raise error like this... SQLSTATE = 28000 FATAL : Sorry, too many clients already
Why? What is the solution
It sounds like you have too many connections. How many do you have, and is this larger than the limit set in postgresql.conf? Details in the manuals.
[snip]2. There are 5000 rows, then there are report call query like this SELECT so_hd.*
when running aplication call this report, application become hang. Why ? there is solution?
Don't know. Is the database doing anything? What do ps and top show? Are there any errors recorded in postgresql's logs?
4. There are some report become hang . The transaction is few but design report using sub report. Is it cause hang? is there the solustion ?
What do the logs show? What hangs? What transactions would you be using to create a report?
3. There is error like this... Sybase Inc. Product File has encountered a problem and needs to close
I'm not sure what relevance a "Sybase Inc. Product File" has to postgresql - it's presumably something to do with Sybase.
When I using report window for query and access thousand record transcaction. Why ? Any suggestion
Sorry - I don't understand what you mean here. What I'd suggest is:
1. Pick one problem (to start with) 2. Turn statement-logging on in the postgresql.conf file 3. Restart the database 4. Reproduce the problem 5. Post details here, along with any errors/warnings in the logs.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
