[ADMIN] ODBC on cygwin/NT Postgres 7.1

How does one set up ODBC on a cygwin/NT/Postgres 7.1 installation? I already had a psqlodbc.dll from the last install (7.0.3). Do I need to recompile a new one with VC++? Do I need to recompile postgres with --with-odbc? I'm using a precompiled 7.1 that came along with cygwin 1.1.8 and I don't kno

[ADMIN] New cygwin includes Postgresql 7.1-2!?

I just installed the latest cygwin 1.1.8 on my NT 4.0 and apparently it also installed some/all of 7.1--or am I imagining things? I downloaded to a directory and then installed (default everything) and apparently Postgres came along for the ride! Does anyone know exactly what's happening here (is

Re: [ADMIN] Can't do pg_dump(all)

Please ignore the syntax in my example. It doesn't work with any combination, right or wrong bangh <[EMAIL PROTECTED]> on 02/11/2001 12:30:21 PM To: Larry Bottorff/Harvey@Harvey cc: Subject: Re: [ADMIN] Can't do pg_dump(all) I think you should enter: pg_dump db_name > afile.out n

[ADMIN] Can't do pg_dump(all)

I've had this problem for a while now in different forms: Basically, I can't get any of the utilities to recognize anything. I just tried %pg_dump > afile.out and got this error message: psql: connectDBStart() -- connect() failed: No such file or directory Is the postmaster running at 'lo

[ADMIN] 7.1 out soon?

A while back someone said 7.1 would be out by now. Any new date(s)? I really can't go forward with the row size restriction of 7.0.3. LB ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] And the workaround is....?

Okay, I thought it would never happen to me, but I just exceeded the max tuple size (Tuple is too big...). Was there a workaround out there? I'm using 7.0.3 on cygwin/NT4.0. LB ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go

[ADMIN] Can foreign keyed field allow nulls?

I have a table with a field I'd like to do a REFERENCES to a lookup table on; however, this field is not manditory, i.e., can be NULL. Is it possible to do such a thing? LB ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

[ADMIN] Python, Postgres support?

I'm in an MS Windows environment and I'm running Postgres 7.0.3 through cygwin. I'm also using the ActiveState Python port to Windows. Is there a way to do Postgres with Python in this environment. I've followed this and that trail and not really found anything that looks definitive LB

[ADMIN] pg_hba.conf changes have no effect on cygwin/NT 4.0

So far I have only been able to get psql to start with these pg_hba.conf entries: localall trust host all 127.0.0.1 255.255.255.255 trust Then, I can use >psql -h localhost template1 and get a pro

[ADMIN] Default not triggering

I'd like to do a copy of a text file into a table. I follow the procedure and it works fine, except default values for empty fields are never enacted. I have a timestamp field which uses "DEFAULT CURRENT_TIMESTAMP". It never gets fired during a "copy from...", although it works fine for "insert in

[ADMIN] When is a constraint too big?

I'm building a rather large table with certain fields that have a set range of possible values. Some have a possible range of 100 or more values. Should I continue to list out the boolean gospel right there in a CONSTRAINT statement, or is this a job for a trigger, i.e., put the possible values in

[ADMIN] Admin tutorials?

I've looked at psql and found good stuff, but I still don't know how to get a listing of all my tables. I know in Oracle it's a SELECT statement, and I take it for granted a lot of admin is done with regular SQL commands, where can I learn such stuff as how to list my tables? LB

[ADMIN] Admin questions on NT

I have set up 7.0.3 on my NT machine (no hope for non-Microsoft at this time) at my place of employment. I set it up as user "larryb". The larryb account has Administrator privledges, something (as I understand) had to be in order to install a fully functional cygwin. Now, because I installed 7.0

[ADMIN] pg_shadow prob solved

I simply blew away .../data directory and redid initdb and I was back in. I hope this doesn't happen in the middle of serious work

[ADMIN] pg_shadow problem

I know this has been dealt with before, but I can't find the solution in the archives I'm trying to start up 7.0.3 on NT/cygwin. I have it properly installed and I type: $ipc-daemon & $postmaster -i & So far so good, then $psql -h localhost template1 But I get the error: FATAL 1: SetUserID

[ADMIN] ODBC on NT/cygwin Installation

Hello, I've finally gotten 7.0.3 installed and running on NT4.0 Workstation/cygwin combo. I'm now trying to get ODBC up and running. (I did "./configure --with-odbc") Unfortunately, the docs seem to not be geared towards getting ODBC running directly on the NT platform. How do I get things set up

[ADMIN] ODBC On Postgresql On NT/cygwin?

Hello, I've finally gotten 7.0.3 installed and running on NT4.0 Workstation/cygwin combo. I'm now trying to get ODBC up and running. (I did "./configure --with-odbc") Unfortunately, the docs seem to not be geared towards getting ODBC running directly on the NT platform. How do I get things set up

[ADMIN] Errors building Postgres on NT

Below is my first attempt at getting help. A nice person responded and offered the solution below. I followed it exactly and still was not able to get past these errors. (What's this business of trying to link ...dummy.s to tas.s!?) I'm running NT 4.0 WS/sp5 and am using cygwin DLL 1.1.14, trying