View Issue Details

IDProjectCategoryView StatusLast Update
0006809VALENTINA STUDIODatabasepublic2014-03-29 17:19
ReportervikramAssigned ToSergey Pashkov 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformOSMac OS xOS Version10.8.5
Product Version5.5.4 
Target Version5.5.5Fixed in Version5.5.5 
Summary0006809: Valentina Studio doesn't show default databases and schemas on PostgreSQL server
DescriptionHello


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 Reproduce1)Create connection to database
2)Note that valentina studio is not listing any database
TagsNo tags attached.
Working with DB:postgreSQL Server
Version of your DB8.4.18

Activities

vikram

vikram

2014-03-29 07:04

reporter  

pgadmin.png (68,606 bytes)
vikram

vikram

2014-03-29 07:04

reporter  

ValentinaStudio.png (88,311 bytes)
Sergey Pashkov

Sergey Pashkov

2014-03-29 08:54

developer   ~0007752

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.
vikram

vikram

2014-03-29 09:13

reporter   ~0007753

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 ?
Sergey Pashkov

Sergey Pashkov

2014-03-29 10:15

developer   ~0007754

It is not possible in the current version.
vikram

vikram

2014-03-29 12:52

reporter   ~0007755

Thanks for the reply.
Sergey Pashkov

Sergey Pashkov

2014-03-29 17:19

developer   ~0007756

Added two options in Valentina Studio preferences for PostgreSQL plugin:
- Show System Databases;
- Show System Schemas.

Issue History

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