![]() ![]()
Wednesday, December 14. 2011GeoInformatics article and new book in the worksPrinter FriendlyRecommended Books: PostGIS in action and other PostgreSQL books
Trackbacks
Trackback specific URI for this entry
No Trackbacks
Recommended Books: PostGIS in action and other PostgreSQL books
Comments
Display comments as
(Linear | Threaded)
Hi,I have some different issue. I have ceteard a Database, DB1 which has more than 1 schema, viz, Common , User and ofcourse public . I have ceteard a LoginRole also, meUser .1. Created DB1, Common, User and tables under Common/User with owner=meUser 2. Given Privileges for all tables inside Common/User to public as well as meUser. 3. Given Priv. and Grants for Schema Common/User to meUser 4. Given Priv. and Grants for DB1 to meUserBut now when I use pgAdmin3 to exe select * from Common.myTable I get the following error.ERROR: schema Common does not exist********** Error **********ERROR: schema Common does not exist SQL state: 3F000I know I have not done something correct in Priv./Grants section because of which this error is coming. But I am not able to figure this out.Can you help me, in suggesting what might have gone wrong and how can I get this working? Atul
|
QuicksearchCalendarCategoriesArchivesBlog AdministrationEntry's LinksShow tagged entriesRemote RSS/OPML-Blogroll FeedNo RSS/OPML feed selected
|