From: | "Toff" <kristoff(dot)six(at)telenet(dot)be> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Ambiguous error on view |
Date: | 2005-09-19 10:18:31 |
Message-ID: | XfwXe.197826$L_7.10628197@phobos.telenet-ops.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello!
I want to create a view of a table that is in several schema's.
The table is
CREATE TABLE "operator"
(
"operatorid" INTEGER PRIMARY KEY,
"accountid" INTEGER REFERENCES "account"("accountid"),
"name" VARCHAR (40),
"active" BOOLEAN,
);
The schema's are "acc1", "acc2", ......
The view........
CREATE VIEW allops AS
SELECT operatorid, accountid, name
FROM acc1.operator, acc2.operator
WHERE active = true;
But I get the "ERROR: column reference "operatorid" is ambiguous"
If I remove "operatorid", or "accountid" in the view, the errortype is the
same.
What is the ambiguous thing about this? And how to solve it?
On the internet I found some posts with the same issue, but no direct
answers.
Thanks,
Kristoff
From | Date | Subject | |
---|---|---|---|
Next Message | Toff | 2005-09-19 20:58:28 | Re: Ambiguous error on view |
Previous Message | Ennio-Sr | 2005-09-18 16:23:29 | Re: pg_dump: relation "..." already exists warning |