View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006809 | VALENTINA STUDIO | Database | public | 2014-03-29 07:04 | 2014-03-29 17:19 |
Reporter | vikram | Assigned To | Sergey Pashkov | ||
Priority | high | Severity | major | Reproducibility | always |
Status | resolved | Resolution | fixed | ||
OS | Mac OS x | OS Version | 10.8.5 | ||
Product Version | 5.5.4 | ||||
Target Version | 5.5.5 | Fixed in Version | 5.5.5 | ||
Summary | 0006809: Valentina Studio doesn't show default databases and schemas on PostgreSQL server | ||||
Description | Hello I am using Valentina 5.3.4 and postgresql 8.4.18. I have postgres installed on my virtual machine with user postgres (with no password ) and database postgres, Database is having multiple schema's but when I connect with Valentina it is not showing any database to me. But if fire a query on database in SQL editor I see the result. Also when I connect with PGAdmin I see the database and schemas under it. Please check attached screenshot of pgAdmin and Valentina Studio | ||||
Steps To Reproduce | 1)Create connection to database 2)Note that valentina studio is not listing any database | ||||
Tags | No tags attached. | ||||
Working with DB: | postgreSQL Server | ||||
Version of your DB: | 8.4.18 | ||||
pgadmin.png (68,606 bytes) |
|
ValentinaStudio.png (88,311 bytes) |
|
Database "postgres" is a default administrative connection database. Documentation says, that it can be used for initial connection purposes: 'So to create the first "ordinary" database you can connect to postgres.' We'll add an option into preferences to show these databases. |
|
I don't need new database to be created currently I have all schemas under 'postgres' database. How do I browse them? OR this is not possible in current version ? | |
It is not possible in the current version. | |
Thanks for the reply. | |
Added two options in Valentina Studio preferences for PostgreSQL plugin: - Show System Databases; - Show System Schemas. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2014-03-29 07:04 | vikram | New Issue | |
2014-03-29 07:04 | vikram | File Added: pgadmin.png | |
2014-03-29 07:04 | vikram | File Added: ValentinaStudio.png | |
2014-03-29 08:54 | Sergey Pashkov | Note Added: 0007752 | |
2014-03-29 08:56 | Sergey Pashkov | Assigned To | => Sergey Pashkov |
2014-03-29 08:56 | Sergey Pashkov | Status | new => assigned |
2014-03-29 08:56 | Sergey Pashkov | Target Version | => 5.5.5 |
2014-03-29 08:56 | Sergey Pashkov | Summary | Valentina Studio is no listing database and schemas => Valentina Studio doesn't show default databases and schemas on PostgreSQL server |
2014-03-29 09:13 | vikram | Note Added: 0007753 | |
2014-03-29 10:15 | Sergey Pashkov | Note Added: 0007754 | |
2014-03-29 12:52 | vikram | Note Added: 0007755 | |
2014-03-29 17:19 | Sergey Pashkov | Note Added: 0007756 | |
2014-03-29 17:19 | Sergey Pashkov | Status | assigned => resolved |
2014-03-29 17:19 | Sergey Pashkov | Fixed in Version | => 5.5.5 |
2014-03-29 17:19 | Sergey Pashkov | Resolution | open => fixed |