Обсуждение: pgsql odbc
Hello, After I altered a table in my database I am not able to connect the Database with the postgresql-odbc-driver (v.6.40.00.09) What I get is: ODBC--call failed. The Access-Table only shows col-names but nothing else. It is a RH6.1Linux with PostgreSQL 6.5.2 Because I am new to SQL it is a very simple db music1 with 2 tables (artist, volumes). artist has 2 col. (name1, name2) volumes has 3 col. (vname1, vname2, vname3) What I did was ALTER TABLE artist ADD (refno1 INTERGER) ; ALTER TABLE artist RENAME refno1 TO aref1 ; Is there something else to do with the db? Any hints? TIA C.
Carsten Huettl schrieb: > > Hello, > > After I altered a table in my database I am not able to connect the > Database with the postgresql-odbc-driver (v.6.40.00.09) > What I get is: > ODBC--call failed. > The Access-Table only shows col-names but nothing else. > > It is a RH6.1Linux with PostgreSQL 6.5.2 ... It seems the postmaster runs out of memory. I checked the postmaster with top while I tried to connect via odbc an it grabs more and more memory. The system has only 32megs and 96megs swap. When postmaster grabs 110megs the odbc-call fails and postmaster releases the memory. How do I correct this behaviour? TIA