Skip site navigation (1) Skip section navigation (2)

Re: Error in Adding All Tables

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: salman Sheikh <salman_sheikh(at)web(dot)de>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Error in Adding All Tables
Date: 2008-11-02 01:25:28
Message-ID: 490D0188.5060301@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

In response to

Responses

pgsql-odbc by date

Next:From: Andreas KretschmerDate: 2008-11-02 07:30:47
Subject: Re: Error in Adding All Tables
Previous:From: justinDate: 2008-11-02 01:22:44
Subject: Re: Error in Adding All Tables

pgsql-general by date

Next:From: justinDate: 2008-11-02 01:52:30
Subject: Re: Error in Adding All Tables
Previous:From: justinDate: 2008-11-02 01:22:44
Subject: Re: Error in Adding All Tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group