What's the CURRENT schema ? - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject What's the CURRENT schema ?
Date
Msg-id 3CABCB51.4749D0B1@tpf.co.jp
Whole thread Raw
Responses Re: What's the CURRENT schema ?
List pgsql-hackers
Hi,

I'm playing with the new schema functionality.

I login to a database as a user yamada.
There I created 2 schemas yamada and inoue.
By accident I made 2 tables with the same name
vs1 in both public and yamada schemas.

I can see the content of yamada.vs1 by the command select * from vs1
but there seems to be no way to see the content of
public.vs1.
If I drop the table yamada.vs1, I can see the content
of public.vs1 by the command select * from vs1.
Well there seems to be no concept of the CURRENT schema.
Is it intended ?

regards,
Hiroshi Inoue


pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: timeout implementation issues
Next
From: Bruce Momjian
Date:
Subject: Re: timeout implementation issues