Kumar, Lakshmi (Cognizant) wrote: > Hi , > I have two users in my database x & y. > I tried to create a table abc in y which is there in x with the same > name.Ofcourse i logged in as user y and tried. > Even then am not allowed to create throwing error that "object already > exist". > Can anybody xplain this comparing Oracle-schema with the user in postgres > as am in the process of porting oracle schemas to postgres`.
We don't have schemas but hope to have them in 7.3. Right now, you can create temp tables with duplicate names but they go away on session exit. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
