Thread: Schemas seem to disapear!
PgAdminIII v1.1.0 Devel(Jun 4 2004) on Windows XP I can't get into my database. Schemas' number is 0!! But with previous Devel it's ok with 5 Schemas. Regards, Carme.
carmect@tv3mail.com wrote: >PgAdminIII v1.1.0 Devel(Jun 4 2004) on Windows XP > >I can't get into my database. Schemas' number is 0!! But with previous >Devel it's ok with 5 Schemas. > > > Please switch on logging and check what's going on, or send us the output. Regards, Andreas
carmect@tv3mail.com wrote: >>carmect@tv3mail.com wrote: >> >> >> >>>PgAdminIII v1.1.0 Devel(Jun 4 2004) on Windows XP >>> >>>I can't get into my database. Schemas' number is 0!! But with previous >>>Devel it's ok with 5 Schemas. >>> >>> >>> >>> >>> >>Please switch on logging and check what's going on, or send us the >>output. >> >>Regards, >>Andreas >> >> > > >There are no errors about this problem on pgadmin.log! >When I open pgadmin3, at the databases' tree on the left appears this: > >* MyDatabaseName >** Casts (0) >** Languages (0) >** Schemas (0) > >instead of: > >* MyDatabaseName >** Casts (175) >** Languages (1) >** Schemas (5) > >so I can't open any schema! But data exist 'cause I can execute any sql >query. > >I really don't undestand it!! > > > Please activate sql logging; you then will see the queries sent to the server and can examine why you don't see anything. Please do not mail private addresses, but use the mailing list, thank you. Regards, Andreas >Carme. > > > > > >
> carmect@tv3mail.com wrote: > >>>carmect@tv3mail.com wrote: >>> >>> >>> >>>>PgAdminIII v1.1.0 Devel(Jun 4 2004) on Windows XP >>>> >>>>I can't get into my database. Schemas' number is 0!! But with >>>> previous Devel it's ok with 5 Schemas. >>>> >>>> >>>> >>>> >>>> >>>Please switch on logging and check what's going on, or send us the >>> output. >>> >>>Regards, >>>Andreas >>> >>> >> >> >>There are no errors about this problem on pgadmin.log! >>When I open pgadmin3, at the databases' tree on the left appears this: >> >>* MyDatabaseName >>** Casts (0) >>** Languages (0) >>** Schemas (0) >> >>instead of: >> >>* MyDatabaseName >>** Casts (175) >>** Languages (1) >>** Schemas (5) >> >>so I can't open any schema! But data exist 'cause I can execute any sql >> query. >> >>I really don't undestand it!! >> >> >> > Please activate sql logging; you then will see the queries sent to the > server and can examine why you don't see anything. > > Please do not mail private addresses, but use the mailing list, thank > you. > > Ok. Sorry! I'm sending you the log file. Carme.
Attachment
carmect@tv3mail.com wrote: >> >> >Ok. Sorry! I'm sending you the log file. > > > I can't see anything in this. Apparently, you haven't selected any database or one of its subnodes, so no schema is accessed. You'll have to click somewhere in the object tree. Regards, Andreas
Andreas Pflug wrote: > carmect@tv3mail.com wrote: > >>> >> >> Ok. Sorry! I'm sending you the log file. >> >> >> > I can't see anything in this. I finally could reproduce this, it occurred if the selected database is the initial one. Fixed in cvs, win32 snapshot will follow. Regards, Andreas
> Andreas Pflug wrote: > >> carmect@tv3mail.com wrote: >> >>>> >>> >>> Ok. Sorry! I'm sending you the log file. >>> >>> >>> >> I can't see anything in this. > > > I finally could reproduce this, it occurred if the selected database is > the initial one. > Fixed in cvs, win32 snapshot will follow. > > Regards, > Andreas Yes! The problem is solved now. Thanks! Carme.