[GENERAL] advice on holding mail
Dear All, I'll be away for a few weeks... can anyone tell me how to switch my mail from this mailing list off for the duration, and how to switch it to digest mode on my return? Thanks much Rob
Re: [GENERAL] GTK or TCL/TK ... what do you prefer ? (beginner)
Dear Marcel, I do not know Postgres very well. However, our team has built a number of applications using TCL/TK. At present we are using Postgres for our local database, because we are stuck with Unix until the department as a whole can upgrade to Windows NT. Unix don't have certain concepts like ODBC that we take for granted in a Windows networking environment. Many Unix programmers simply use flat files for local storage, because database access is so slow, and there is the additional administrational overhead what a bother. For some this is job security though, writing code that is tightly coupled to everybody elses code, and nobody else can understand. As a consequence, data access is coupled tightly to production applications, making them expensive to build and difficult to maintain. We survive by decoupling the data access from the applications completely... by writing a bunch of TCL procedures with well-known names, and putting them into an incrTCL class. I call it DataServices. It holds all of the SQL, all of the calls into the Postgress library. The incrTCL class has a constructor and destructor that connect to and disconnect from, a database. The advantage of using TCL is that it is a very powerful processor of lists and strings. A procedure, if it returns a list, or even better a keyed list (containing the headers and the data, such as "person.name {Rob}", "person.address {One Buckingham Place}", will simply return a list, an emplty list if no data matches, or raise an exception which you can handle with an error dialog, if the database is dead. This way, when we find a database that gives us better performance and does not require major hacking, we will only have to rewrite a single class, not every application that we support. It would be great to be able to access an Access database from Unix, across a network. Maybe this Spring I'll have time for a project like this. I prefer to concentrate on what I WHAT to build, instead of wasting a lot of time worrying about how to do it! Hacking makes you lose sight of the big picture. My advice is to stop worrying about documentation, start experimenting, and decide for yourself, what you like to use. I highly recommend the Scriptics distribution of TCL/TK called TCLPro, found at http://www.scriptics.com. Cheers Rob
[GENERAL] How do I set digest?
Help, I'm drowining in eMail... anybody know how to set digest mode? Thanks Rob
[GENERAL] set digest
set digest
Re: [GENERAL] how to use pg-connect ?
Dear Cecile, You can do this with a connection string: pg_connect -conninfo $string ...or directly, dos/unix style, as in pg_connect $database -host $host -port $portNumber Cheers Rob C écile DESNOYERS <[EMAIL PROTECTED]> on 01/26/2000 12:48:14 PM To: [EMAIL PROTECTED] cc:(bcc: Robert Wagner/SIAC) Subject: [GENERAL] how to use pg-connect ? Hello, I'd like to know if there is a way to use pg_connect() with a different host than « localhost ». I tried to put an IP address or a server name but it didn't work. Has anybody ever used pg_connect with something else than localhost ? Thank you Cecile
[GENERAL] How do I change port for the postmaster?
I'm attempting to run two different postmasters on two different HP-UX servers, servicing two different apps. The only commonality is that I'm on one terminal. The first starts up OK. When I attempt to start the postmaster on the other server, I get the error, FATAL: StreamServerPort: bind() failed: errno=226 Is another postmaster already running on that port? If not, remove socket node (/tmp/.s.PGSQL.5432) and retry./usr/local/pgsql/bin/postmaster: cannot create UNIX stream port Tried deleting the file, /tmp/.s.PGSQL.5432 but this had no effect. Do I need to use a different port number, to run postmaster on two different servers? If so, does anybody know how I can change the port number? Is there something else, that I'm doing wrong? I'm looking through the docs but can't find anything. I'd like to keep postgres in the organization and avoid switching to (and learning) some big commercial product like oracle! Thanks! Rob Wagner Lowly Consultant, SIAC
[GENERAL] hard limit on result handles reached
Hello all, Ran into this while regression testing my app. Does anybody know if this is a physical limitation of postgress, or is this a parameter to the database that I can change? Kinda limits the database's usefulness in the real world... On the 128th query, this is the error I get... up until query 127 things are fine. Cheers Rob