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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: [GENERAL] Error in Adding All Tables

  • From: "Joshua D. 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: [GENERAL] Error in Adding All Tables
  • Date: Sat, 01 Nov 2008 18:25:28 -0700
  • Message-id: <490D0188.5060301@commandprompt.com> <text/plain>
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
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group