Re: [ADMIN] Missing Schema
James Neville wrote: > Does anyone have a clue as to how this may have happened, and an > approach to remedying the problem with a reinstall? Well, perhaps you have simply dropped them? You can just recreate them. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Missing Schema
Peter Eisentraut wrote: Well, perhaps you have simply dropped them? You can just recreate them. Well, thats a relief, but what tables do I need to recreate, and what are their schemas? I'm also rather curious as to how/why someone would have dropped a system table. Thanks, James. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] Missing Schema
James Neville wrote: > Peter Eisentraut wrote: > >Well, perhaps you have simply dropped them? You can just recreate > > them. > > Well, thats a relief, but what tables do I need to recreate, and what > are their schemas? You don't need to create any tables, just schemas. > I'm also rather curious as to how/why someone would have dropped a > system table. You didn't drop any system table (or you'd have far worse problems), you (possibly) just dropped the schema "public". ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] Missing Schema
James Neville <[EMAIL PROTECTED]> writes: > Only recently, we have noticed the abscence of any schemas. It's not possible that the database contains *no* schemas. You are being way too imprecise in describing the problem. > The product issues queries like: > SELECT * FROM dbname.public.users; > Obviously, the JDBC Driver making the SQL query fails on 'public'. What's obvious about it? And what exactly is the error message? I suspect you are completely misinterpreting what you are seeing. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]