Re: [pgadmin-support] pgAdmin4 Server does not create SQLite tables

[Josh Berkus]

On 10/11/2016 01:47 PM, Dave Page wrote:
> 
> 
> On Tuesday, October 11, 2016, Josh Berkus  > wrote:

> Ah, so I can drop a path into config_local?
> 
> 
> Yes, per the example I sent yesterday. config_local.py (and
> config_distro.py) are sourced by config.py. config_distro is read first,
> and can be used by packagers to override distro-specific options, and
> then config_local is read to allow users to do further customisation.

So, currently there is no "DATA_DIR" parameter in config_local,
commented out or otherwise, and the parameter in config.py references a
bit of python code.  If users are expected to do this on their own,
you'll need at least a commented-out example in config_local.py.

Presumably I just set DATA_DIR to where I want the SQLite DB to go, yes?
 Or do I set it to its parent directory?  Code in config.py doesn't make
it clear.

-- 
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Pgadmin 4 view and sort table

[Josh Berkus]

Russell,

I'm responding as a fellow user.


>> Perhaps I am jumping the gun here, as the software is recently
>> released, but I am having trouble figuring out some basic operations
>> that I could do using PGAdmin 3.
>>
>> 1.  Open a table in its own window.  In PGAdmin 3, opening a table
>> opened its own window that was independent of the main system tree. 
>> This allowed for arranging multiple tables across screens.  Now, all
>> windows may float, but they are constrained within the application
>> window.  Is this by design, or am I missing something?  It makes it
>> infinitely more difficult to use when everything is constrained to a
>> single window.

This is definitely a limitation, I expect largely due to the convertion
to a browser-based primary application version.  Note that I'm using the
webserver, so I don't know if there's a way around this in the desktop app.

>>
>> 2.  When you view the data in a table, it does not seem possible to
>> sort the table.  Opening a table to view all records creates a
>> "Query-1" tab, which has a basic Select * by query, with order by the
>> primary key.  This is all greyed out and unable to be modified.  How
>> do you resort a table?

At this point?  Add "ORDER BY column" to the query.

-- 
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Issues with query window

[Josh Berkus]

Dave, all:


1. The column headers in the query result do not line up with the
columns of data.  See attached screenshot.

2. EXPLAIN does not display at all; the contents of the EXPLAIN tab are
always empty.

Server: PostgreSQL 9.6.0/pgAdmin4-web/python3.5/httpd
Client: Fedora Workstation/Firefox 49

-- 
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support