Re: [GENERAL] Error in Adding All Tables - Mailing list pgsql-odbc

salman Sheikh wrote:
>
>
> Hi freinds,
> i wanted to add my all tables once in MFC application,
>
> i have a databank,which has 11 tables and i want to add them all togather.
>
>  After Adding all tables, it shows me always this errors by debugging.
>
>
> ERROR: column reference "ctid" is ambiguous;
> Error while executing the query

This means you did this:

SELECT ctid,ctid from table1, table2

But it doesn't know which ctid belongs to which table. You need to use
aliases or dotted notation.

Joshua D. Drake