Error in Adding All Tables

am 02.11.2008 00:55:39 von salman Sheikh

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

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:

body>

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

Re: [GENERAL] Error in Adding All Tables

am 02.11.2008 02:22:44 von Justin

http-equiv=3D"Content-Type">

salman Sheikh wrote:

style=3D"border-left: 2px solid blue; padding-left: 10px; font-size: 9pt=
; margin-left: 20px; font-family: Verdana;">

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=A0them
all togather.

=A0After 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

""
src=3D"https://img.web.de/p.gif" border=3D"0" height=3D"1" width=3D"1"><=
/td>

Psssst=
!
Schon vom neuen WEB.DE MultiMessenger geh&oum l;rt? =A0

Der kann`s mit allen: href=3D"http://www.produkte.web.de/messenger/?did=3D3123">http://www.=
produkte.web.de/messenger/?did=3D3123

Without looking at the sql statement you are using its kinda hard to
know what the problem is

but ambiguous column means the Postgresql can't figure out what you
want to do as the column shows up twice in a command.

Re: [GENERAL] Error in Adding All Tables

am 02.11.2008 02:25:28 von Joshua Drake

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc