Thread: Error in Adding All Tables

salman Sheikh wrote: <blockquote cite="mid:1388732484@web.de" type="cite"><br /><br /><table id="alt"
style="border-left:2px solid blue; padding-left: 10px; font-size: 9pt; margin-left: 20px; font-family:
Verdana;"><tbody><tr><td><p>Hifreinds, <br /> i wanted to add my all tables once in MFC application,<p>i have a
databank,whichhas 11 tables and i want to add them all togather.<p> After Adding all tables, it shows me always this
errorsby debugging.<p><br /> ERROR: column reference "ctid" is ambiguous; <br /> Error while executing the query <br
/><p>ineed help from u ppl. I am using Visual C++ 2005 and postgresql 8.3.<br /><p>thanks <br /> Sheikh <br /><br
/><tableborder="0" cellpadding="0" cellspacing="0"><tbody><tr><td bgcolor="#000000"><img alt="" border="0" height="1"
moz-do-not-send="true"src="https://img.web.de/p.gif" width="1" /></td></tr><tr><td style="font-size: 12px; font-family:
verdana;">Psssst!Schon vom neuen WEB.DE MultiMessenger geh&oum l;rt?    <br /> Der kann`s mit allen: <a
href="http://www.produkte.web.de/messenger/?did=3123"
moz-do-not-send="true"><b>http://www.produkte.web.de/messenger/?did=3123</b></a>  </td></tr></tbody></table></td></tr></tbody></table><br
/></blockquote><br/> Without looking at the sql statement you are using its kinda hard to know what the problem is<br
/><br/> but ambiguous column means the Postgresql can't figure out what you want to do as the column shows up twice in
acommand.<br /><br /><br /> 

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