Error in Adding All Tables

This is a multi-part message in MIME format.

--=-------------12255837403649455119
Content-Type: text/plain; charset=iso-8859-15
Content-Transfer-Encoding: 7bit

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

i need help from u ppl. I am using Visual C++ 2005 and postgresql 8.3.

thanks
Sheikh

Psssst! Schon vom neuen WEB.DE MultiMessenger geh&oum l;rt?
Der kann`s mit allen: *http://www.produkte.web.de/messenger/?did=3123* [http://www.produkte.web.de/messenger/?did=3123]

Run, Fatboy, Run" sowie "Rails & Ties" kostenlos anschauen!
Blockbuster-Gutscheine sichern unter *http://www.blockbuster.web.de* [http://www.blockbuster.web.de]

--=-------------12255837403649455119
Content-Type: text/html; charset=iso-8859-15
Content-Transfer-Encoding: 7bit

<html><body bgcolor='#ffffff' style='margin-left:0px; font-size:9pt; margin:0px; font-family:Verdana; margin-left:0px; margin-right:0px; margin-top:0px; margin-bottom:0px; font-family: Verdana' ><BR><BR><TABLE id=alt style="PADDING-LEFT: 10px; FONT-SIZE: 9pt; MARGIN-LEFT: 20px; BORDER-LEFT: blue 2px solid; FONT-FAMILY: Verdana"><TBODY><TR><TD><P>Hi freinds, <BR>i wanted to add my all tables once in MFC application,</P><P>i have a databank,which has 11 tables and i want to add them all togather.</P><P> After Adding all tables, it shows me always this errors by debugging.</P><P><BR>ERROR: column reference "ctid" is ambiguous; <BR>Error while executing the query <BR></P><P>i need help from u ppl. I am using Visual C++ 2005 and postgresql 8.3.<BR></P><P>thanks <BR>Sheikh </P><BR><BR>
<TABLE cellSpacing=0 cellPadding=0 border=0><TBODY><TR><TD bgColor=#000000><IMG height=1 alt="" src="https://img.web.de/p.gif" width=1 border=0></TD></TR><TR><TD style="FONT-SIZE: 12px; LINE
-HEIGHT: 17px; 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"><B>http://www.produkte.web.de/messenger/?did=3123</B></A> </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><BR><br><br><table cellpadding="0" cellspacing="0" border="0"><tr><td bgcolor="#000000"><img src="https://img.web.de/p.gif" width="1" height="1" border="0" alt="" /></td></tr><tr><td style="font-family:verdana; font-size:12px; line-height:17px;">Run, Fatboy, Run" sowie "Rails & Ties" kostenlos anschauen! <br>Blockbuster-Gutscheine sichern unter <A HREF="http://www.blockbuster.web.de"><B>http://www.blockbuster.web.de</B></A> </td></tr></table></
body></html>

--=-------------12255837403649455119--

salman Sheikh [ So, 02 November 2008 00:55 ] [ ID #1975653 ]

Re: [GENERAL] Error in Adding All Tables

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content=3D"text/html;charset=3DISO-8859-15"
http-equiv=3D"Content-Type">
</head>
<body bgcolor=3D"#ffffff" text=3D"#000000">
salman Sheikh wrote:
<blockquote cite=3D"mid:1388732484 [at] web.de" type=3D"cite"><br>
<br>
<table id=3D"alt"
style=3D"border-left: 2px solid blue; padding-left: 10px; font-size: 9pt=
; margin-left: 20px; font-family: Verdana;">
<tbody>
<tr>
<td>
<p>Hi freinds, <br>
i wanted to add my all tables once in MFC application,</p>
<p>i have a databank,which has 11 tables and i want to add=A0them
all togather.</p>
<p>=A0After Adding all tables, it shows me always this errors by
debugging.</p>
<p><br>
ERROR: column reference "ctid" is ambiguous; <br>
Error while executing the query <br>
</p>
<p>i need help from u ppl. I am using Visual C++ 2005 and
postgresql 8.3.<br>
</p>
<p>thanks <br>
Sheikh </p>
<br>
<br>
<table border=3D"0" cellpadding=3D"0" cellspacing=3D"0">
<tbody>
<tr>
<td bgcolor=3D"#000000"><img moz-do-not-send=3D"true" alt=3D=
""
src=3D"https://img.web.de/p.gif" border=3D"0" height=3D"1" width=3D"1"><=
/td>
</tr>
<tr>
<td style=3D"font-size: 12px; font-family: verdana;">Psssst=
!
Schon vom neuen WEB.DE MultiMessenger geh&oum l;rt? =A0=A0=A0<br>
Der kann`s mit allen: <a moz-do-not-send=3D"true"
href=3D"http://www.produkte.web.de/messenger/?did=3D3123"><b>http://www.=
produkte.web.de/messenger/?did=3D3123</b></a>=A0=A0</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 a command.<br>
<br>
<br>
</body>
</html>

Justin [ So, 02 November 2008 02:22 ] [ ID #1975654 ]

Re: [GENERAL] Error in Adding All Tables

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Joshua Drake [ So, 02 November 2008 02:25 ] [ ID #1975655 ]