Обсуждение: 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