From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
---|---|
To: | Mark Wilson <mark(at)mediasculpt(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: accessing schemas |
Date: | 2002-10-16 20:10:35 |
Message-ID: | 3DADC7BB.3090106@paradise.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Mark,
You need 7.3 for schema support (7.3 is currently in Beta2 I think)
Best wishes
Mark
Mark Wilson wrote:
> Hi all,
>
> I am using postgresql 7.2.1.
>
> I'm trying to create two separate objects with the same name, a table
> and a view on the table. It seems like the best way to do this is to
> create two schemas and have the view reference the table in the other
> schema. But I have a problem. TO start with, it seems like psql is
> creating another database instead of another schema (e.g. CREATE
> SCHEMA TEST1; returns CREATE DATABASE). This is not the biggest
> problem in the world, although I had thought that schemas would be
> subordinate to databases (just like users :~)
>
> Secondly, when I run "\c test2 testuser" to *connect* to the schema I
> want the view created in, where
> running create view try1 as select * from test1.try1;
> returns ERROR: parser: parse error at or near "."
> How can I get the view in the test2 schema to reference the table in
> schema test1?
>
> Thanks in advance,
> Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Marie G. Tuite | 2002-10-16 20:16:33 | Re: Pg_dumpall problem |
Previous Message | Mark Wilson | 2002-10-16 20:08:25 | accessing schemas |