Giter Site home page Giter Site logo

pgadmin-org / pgadmin4 Goto Github PK

View Code? Open in Web Editor NEW
2.1K 48.0 595.0 284.76 MB

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

Home Page: https://www.pgadmin.org

License: Other

Batchfile 0.16% Makefile 0.04% Shell 0.64% Python 63.00% JavaScript 32.48% HTML 0.26% CSS 0.26% PLpgSQL 2.58% Mako 0.01% Dockerfile 0.07% TypeScript 0.50%
administration database dba management postgres postgresql postgresql-database

pgadmin4's People

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

pgadmin4's Issues

If we create user with expiry date in PPAS server then user is not being created to due to *datestyle settings* (RM #1134)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1134
Originally created by Karen Blatchley at 2016-05-17 15:38:37 UTC.

Please note that this issue is not reproducible with PG-9.5 server because we support this datestyle('04/30/2016'). However i also checked this behavior on pgAdmin3 and we can crate users with expiry date option on both PG and PPAS server.

Steps:

  1. Launch pgAdmin4 on PPAS-9.5 server
  2. Click on Login node
  3. Right Click and provide user name qmg
  4. select date from Account Expires and Click on Save button

Expected result:

User should create in PPAS server through right click with expiry date option

Created by Fahar Abbas 2016-04-21

FTS Dictionary fixes (RM #1126)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1126
Originally created by Karen Blatchley at 2016-05-17 14:43:05 UTC.

  1. The template is not shown in properties views if it is not in a system schema (because of the way you are dealing with schema names etc). Please also check how the existing code will behave, if there is a template in the public schema with the same name as one in pg_catalog.

  2. Please strip the quotes from the options before displaying them.

Created by Dave Page 2016-04-14

Unable to drop Login if name contains double quotes (RM #1135)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1135
Originally created by Karen Blatchley at 2016-05-17 15:39:20 UTC.

Following error message displayed If contains spaces in name:

ERROR: Couldn't drop the user! ERROR: syntax error at or near "haider" LINE 1: DROP ROLE rayyan haider; ^

Steps:

Launch pgAdmin4 on connect to server
Click on Login node
Right Click and provide user name rayyan haider
Right Click and select Drop button
5.click ok to Drop this object
Expected result:

User should drop successfully if name contain spaces

Created by Fahar Abbas 2016-04-21

Pluggable architecture (RM #797)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/797
Originally created by Dave Page at 2014-08-26 17:27:05 UTC.

Whilst not a feature in itself, I'm recording this as one so it doesn't get lost. pgAdmin 4 should be based around a pluggable architecture to allow easy enhancement and extension.

  • Modules should be able to register menu options and even top-level menus upon initialisation, and provide the appropriate methods to execute the function and enable/disable menu options.
  • Modules should be able to register additional treeview node classes to be attached to existing node classes when the treeview is rendered.

Error message displayed in properties section of system level pgAgent job scheduler>sequences (RM #1121)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1121
Originally created by Karen Blatchley at 2016-05-17 14:35:00 UTC.

If user expand ppas-9.5 server and select system level catalog node, Select pgAgent job scheduler and select the properties of sequences, then "error fetching the properties not found" displayed. Please note that properties section is not displayed in pgAdmin3 and we should also hide this option on pgAdmin4

  1. Install pgadmin4 setup on Ubuntu 14.04 Linux 64
  2. Install PPAS-9.5 GA installer(server must be installed)
  3. Launch pgAdmin4
  4. Connect to PPAS-9.5 server
  5. Expand database edb
  6. Expand catalogs.
  7. Select pgAgent job scheduler
  8. Expand this and Click on sequences node
  9. Right Click and select properties

Expected result:

Properties section should not visible on System level catalogs or error message should not displayed.

Created by Fahar Abbas 2016-04-08

If User Click on Continue/start button second time and Cancel the Button then Debugger "Set arguments error" message displayed. In case of pgAdmin 4 this kind of error is not displayed and behavior is also different. (RM #1127)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1127
Originally created by Karen Blatchley at 2016-05-17 14:44:07 UTC.

1.Launch pgAdmin4:
2. Perform pre-req verification for debugger
3. create function:

CREATE OR REPLACE FUNCTION public.test()
RETURNS character AS
$BODY$
begin
return 1;
end;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;

  1. Expand PG-9.5 server
  2. Click on Function
  3. Right Click and Select debugging> Debug
  4. Click on Continue/start button
  5. Message Execution completed.
  6. Again Click on Continue/start button
  7. Debugger option open that include parameter
  8. And Click on Cancel Button

Created by Fahar Abbas 2016-04-15

Not able to scroll in browser tree (RM #1129)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1129
Originally created by Karen Blatchley at 2016-05-17 15:09:57 UTC.

With latest pull I am not able to scroll in browser tree, Just expand catalog(information schema) node and try scrolling.

murtuza@Laptop217:~/Desktop/pgadmin4$ git log --oneline | head -5
34ba5be Improvised the data clean up, in some cases, it was calling validation due to internal 'set' function call from the internal 'reset' function.
6e42e48 Fix the properties toolbar at the top of the panel so it's always visible.
de0864a Fix SQL Help on older browsers without string.endsWith().
7ca939d Fix dialogue close issue.
4d7d3bd Icon and toolbar cleanup/consistency.

Created by Murtuza Zabuawala 2016-04-15

creating duplicate user defined cast should throw proper error message (RM #1114)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1114
Originally created by Karen Blatchley at 2016-05-17 14:26:17 UTC.

open psql prompt and fire following query:
-- create cast (color as light) with inout as
assignment;

  • Launch pgAdmin4
  • Right Click and Create new cast
  • Select Color in source type and Select light in target type
  • Click on Save Button.
  • It's displayed a message enum data types are not binary- compatible

expected: it should throw proper error message:
cast from "xxx" type to "yyy" type already exist

Created by Priyanka Shendge 2016-03-29

User can not uncomment the sequences through Right Click option (RM #1118)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1118
Originally created by Karen Blatchley at 2016-05-17 14:31:36 UTC.

Steps.

  1. Launch pgAdmin4
  2. Connect to PG server
  3. sequences
  4. query created successfully.
  5. Right Click on select the properties
  6. provide abc in comments option
  7. Comments added successfully.
  8. remove the comments under comments section
  9. Click on SQL
  10. on SQL displayed in SQL tab
  11. Click on Save button

Created by Fahar Abbas 2016-04-05

Saving new connection doesn't close server dialog (RM #1106)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1106
Originally created by Karen Blatchley at 2016-05-17 14:05:17 UTC.

When adding a new server, clicking Save on the dialog doesn't close it and update the tree view as expected.

Created by Dave Page 2016-02-19

[2016-02-25 Dave Page] This bug has been fixed already.
[2016-03-04 Dave Page] Nope - still there. Perhaps only occurs when there are no servers already defined as I just say it with a brand new config DB.

Main UI (RM #789)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/789
Originally created by Dave Page at 2014-08-22 13:15:56 UTC.

Layout the main UI in HTML/CSS making use of Bootstrap:

  • A top menu bar should be included. At the left, menus to access functions/tools should be added. At the right, user options (such as logout, and a gravatar) should be shown when running in multi-user mode.

  • The page should be split into two sections using jQuery layout frames.

  • The left section should display the treeview.

  • The right section should display a tabset, with tabs for the object definition, statistics etc.

If Minimum value is 0 and maximum value is 1 for sequence, then Min value is not displayed in SQL pane (RM #1119)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1119
Originally created by Karen Blatchley at 2016-05-17 14:33:00 UTC.

Please note that this issue is not reproducible in pgAdmin3.

  1. Launch pgAdmin4
  2. Click on Sequence node
  3. provide user name isb
  4. in defination section select Min value 0 and Max value is 1
  5. Click on Save button
  6. Sequence created successfully
  7. Check the SQL pane
  8. No Min value displayed

Created by Fahar Abbas 2016-04-05

If User create Servers group with same name Servers then Internal server error displayed (RM #1136)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1136
Originally created by Karen Blatchley at 2016-05-17 15:45:23 UTC.

Steps:

  1. Launch pgAdmin 4 on Ubuntu 14.04 Linux 64
  2. click on Servers main node
  3. and create new server group
  4. provide name as Servers
  5. Click on save button

Expected result:

If server group is already created then pop up message displayed and it should notified about existing server group is already in use.

Created by Fahar Abbas 2015-04-22

Error saving database password (RM #1098)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1098
Originally created by Karen Blatchley at 2016-05-17 13:56:11 UTC.

Whenever user save password to server connection; it throws INTERNAL SERVER ERROR (UTF-8 codec can’t be decoded…..) (as per discussion with Khushboo issue in following file: .../pgadmin/browser/server_groups/servers/__init_py) (not sure about exact steps but it occurs if user has save password)

Added by Priyanka Shendge 2016-02-22

user defined (custom) roles not listed under owner drop-down of any new creation database objects (e.g. database, schema, FDW etc...) (RM #1115)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1115
Originally created by Karen Blatchley at 2016-05-17 14:27:32 UTC.

  1. create any role (e.g test user)
  2. assign necessary role privileges/password
  3. save
  4. make sure role is created and listed under Login/Group Roles tree node
  5. now, try to create database, tablespace or any other database objects
  6. expand owner drop-down

observation:
test user is not displayed under owner's drop-down

expected:
it should be listed

Created by Priyanka Shndge 2016-03-29

New Node: Does not honour the parent node object (RM #1103)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1103
Originally created by Karen Blatchley at 2016-05-17 14:01:51 UTC.

When Create/Update Any Node, if the selected Schema is other than the current one, the node will not be listed properly in the tree.

For example,
If my current schema is pem and I am creating Domain for pemdata then, it will not added properly in the browser tree.
Edit related cards
Assign to

Created by Khushboo Vashi 2016-02-24

While restating pgadmin server it is calculating "lastsysoid" wrong (RM #1128)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1128
Originally created by Karen Blatchley at 2016-05-17 15:08:58 UTC.

Very rare issue and happens when you restart pgAdmin4 server.

This is causing issue in database listing, In my case it's not showing postgres database.

Please find attach screenshot.

One screenshot shot of Mozilla & another was from Chrome both taken at same time from same pgAdmin4 server but from different browser.

One is displaying both database properly while other exclude postgres.

Created by Murtuza Zabuawala 2016-04-15

Unable to authenticate the valid credentials with new server group (RM #1137)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1137
Originally created by Karen Blatchley at 2016-05-17 15:46:58 UTC.

If User create new server group and on this server group and try create server, server added but if give valid password to this server following message displayed:

could not translate host name "postgres" to address: Name or service not known

Steps:

  1. Launch pgAdmin 4 on Ubuntu 14.04 Linux 64
  2. click on Servers main node
  3. and create new server group
  4. provide name as far
  5. Server group created
  6. create new server on this particular group and provide all valid credentials of Server after creation
  7. and provide valid password

Created by Fahar Abbas 2016-04-22

Login contain keyword, should also be dropped through right click (RM #1130)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1130
Originally created by Karen Blatchley at 2016-05-17 15:10:57 UTC.

IF Login contain keyword, it should be dropped through right click and please note that this issue is not reproducible on pgAdmin3

Steps.

  1. Launch pgAdmin4
  2. create login with name select or as keyword with right click option
  3. Login created successfully
  4. Click on this particular login
  5. Right Click and Select Delete/Drop

It's displayed following message:

ERROR: Couldn't drop the user! ERROR: syntax error at or near "select" LINE 1: DROP ROLE select; ^

Created by Fahar Abbas 2016-04-19

System configuration settings class (RM #788)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/788
Originally created by Dave Page at 2014-08-22 12:57:37 UTC.

A class should be created to allow the retrieval of system-wide configuration settings.

  • Each setting should be specified by a simple key.

  • A function to retrieve a setting value should be provided, taking an option parameter specifying a default value to be returned if the setting is not in the config file.

  • The settings file format should be easily human readable.

Note that this class must not allow editing of the configuration file - in fact, the file should be stored read-only for the web hosted installations to ensure that users cannot turn off (for example) authentication.

Tablespace: Input validation is missing. (RM #1110)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1110
Originally created by Karen Blatchley at 2016-05-17 14:12:08 UTC.

While creating the tablespace node, we are getting the error on the browser console.
Follow the below steps.

  • Create the new tablespace. Give the name of the table space
  • Go to "Variables" tab and press "Add" button. Do not enter the value.
  • Click on the SQL tab.
  • After above step, browser console will give error.

Same errors will be displayed when we do not enter the value for "Privileges" and "Security Labels" and click on SQL tab.

Created by Neel Patel 2016-03-11

[2016-03-11 Neel Patel] We are getting below error at python side when we do not add variable value. Below error will come when we do not enter the security label and variables.

Only create new procedure option is available in procedure node (RM #1123)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1123
Originally created by Karen Blatchley at 2016-05-17 14:40:15 UTC.

In case of procedure, only create option is available and rest of other options(drop, properties and refresh) are not displayed.

  1. Install pgadmin4 setup on Ubuntu 14.04 Linux 64
  2. Install PPAS-9.5 GA installer(server must be installed)
  3. Launch pgAdmin4
  4. Connect to PPAS-9.5 server
  5. Expand database edb
  6. Expand procedure node
  7. only create option is available

Expected result:

drop, properties and refresh option should be available for procedure.

Created by Fahar Abbas 2016-04-08

Connection lost error displayed if select properties section of database that is already disconnected (RM #1132)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1132
Originally created by Karen Blatchley at 2016-05-17 15:12:40 UTC.

If Database is disconnected and User want to check the properties section "Connection to the server has been lost!" message displayed. Please note that this issue is not reproducible on pgAdmin3.

Steps.

  1. Launch pgAdmin4
  2. create new database
  3. Right Click and select disconnect
  4. Select the properties

Created by Fahar Abbas 2016-04-20

edit new role creation: account expires field shows current/system date on edit (RM #1116)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1116
Originally created by Karen Blatchley at 2016-05-17 14:28:42 UTC.

  1. Launch pgAdmin4
  2. Create new User and set expiry date 31-March-2016
  3. User created successfully.
  4. select created role -> properties -> Definition-> click and try to edit account expires field
  5. on calender it shows current date; click outside account expires field
  6. account expires field will get updated with current date

observation:
it should show user mentioned date

Created by Priyanka Shendge 2016-03-29

Logging class (RM #786)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/786
Originally created by Dave Page at 2014-08-22 12:42:34 UTC.

Create a logging class to log events to a logfile:

  • The logfile should be configurable by the user, but have a sensible default value for the platform.
  • 4 log levels should be supported.
    • None
    • Normal
    • SQL
    • Debug
  • Functions should be provided to allow developers to write messages to the logfile, with variadic printf-style formatting, at each available log level.
  • Messages at lower levels than the current log level should be discarded.

Create new objects(like Foreign Data Wrappers) should not available if user login with non root user (RM #1124)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1124
Originally created by Karen Blatchley at 2016-05-17 14:41:24 UTC.

In case user login with non root user and check the create new option in foreign data wrapper and it's visible and technically that is wrong approach and user can not create this object with non root user and as a reference we can check this approach in pgAdmin 3 and behavior is different. I am raising this issue only Foreign Data Wrappers and it might be reproducible with other objects.

Steps:

  1. Launch pgAdmin4
  2. create non root user with login right
  3. user created successfully.
  4. Disconnect with server
  5. Under login screen provide non root user
  6. connect with server
  7. Expand Foreign Data Wrappers node and check the create option

Created by Fahar Abbas 2016-04-13

create new FTS parser and FTS template issue under pgAgent job scheduler node (RM #1122)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1122
Originally created by Karen Blatchley at 2016-05-17 14:39:16 UTC.

If user expand ppas-9.5 server and select system level catalog node, Select pgAgent job scheduler and create new FTS parser and FTS template then empty information displayed, as per my investigation on pgAdmin3, new create new FTS parser and FTS template is not displayed under system catalog and it' should be removed under pgAdmin4.

  1. Install pgadmin4 setup on Ubuntu 14.04 Linux 64
  2. Install PPAS-9.5 GA installer(server must be installed)
  3. Launch pgAdmin4
  4. Connect to PPAS-9.5 server
  5. Expand database edb
  6. Expand catalogs.
  7. Select pgAgent job scheduler
  8. Try to create FTS parser and FTS template

Expected result:

create new FTS parser and FTS template should be removed under pgAgent job

Created by Fahar Abbas 2016-04-08

Layout isn't getting saved (RM #1102)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1102
Originally created by Karen Blatchley at 2016-05-17 14:00:53 UTC.

If user re-arranged the tab settings (Properties, statistics etc ...); its not getting saved on logout. To reflect the changes user has to refresh the browser window before logout.

Created by Priyanka Shendge 2016-02-23

There is no option available through right click for function node in special case if user try to create plpgsql function through right click and later on with query tool window (RM #1133)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1133
Originally created by Karen Blatchley at 2016-05-17 15:13:33 UTC.

Steps.

  1. Launch pgAdmin4 on Ubuntu 14.04 Linux 64 and install PG-9.5 GA Installer
  2. Connect to PG-9.5 server
  3. Before launching query tool window
  4. try to create plpgsql function with char data type and in code section
    provide:

begin
return 1;
end;
5. Click on SQL tab and copy this query
6. Close the query tool window without creating this function

  1. Open Query tool window:

Just past the code:

CREATE FUNCTION public.abbas()
RETURNS "char"
LANGUAGE 'plpgsql'
NOT LEAKPROOF
AS $function$
begin
return 1;
end;
$function$;

  1. Function created successfully
  2. closed query tool window
  3. click refresh on function node
  4. Click on this particular node
  5. Right click on this function

Created by Fahar Abbas 2016-04-20

System preferences issues (RM #1131)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/1131
Originally created by Karen Blatchley at 2016-05-17 15:11:51 UTC.

If user check show system data as false and Click on ok button, then true option available instead of false. Even user can not hide under node section

Steps.

  1. Launch pgAdmin4
  2. click on File> Preferences
  3. Then check the false option and click on ok
  4. Then again click on File> Preferences and check show system data

Expected Result:

System preferences change according to the modification.

Created by Fahar Abbas 2016-04-20

User settings class (RM #787)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/787
Originally created by Dave Page at 2014-08-22 12:52:57 UTC.

A class should be created to allow the storage and retrieval of arbitrary configuration settings.

  • Each setting should be specified by a path, for example, "Servers/1/IP Address"

  • A function to retrieve a setting value should be provided, taking an option parameter specifying a default value to be returned if the setting is not in the config file.

  • A function should be provided to set or update a configuration parameter.

  • The settings file format should be easily human readable.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.