Shouldn’t:-
timezone = 'Europe/London’
Set this automatically? Which is what we have in postgresql.conf
> On 4 Apr 2017, at 22:32, Basques, Bob (CI-StPaul)
> wrote:
>
> daylight savings time?? (CDT vs CEN time?)
>
>
>> On Apr 4, 2017, at 4:27 PM, Dave Barte
All of our scheduled jobs are running 1 hour after the time being set in
PGAdmin III
Any idea why?
The servers report the correct date and the timezone on postgres is set
correctly.
SELECT now(); also gives me the date I expect?
--
Sent via pgadmin-support mailing list (pgadmin-support@post
completion.
Can this be changed?
Dave Barter
d...@phased.co.uk
@citizenfishy
www.phased.co.uk
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
When trying to add a new value to “Minute” in a Repeat for a job scheduled
by pageant I get:-
ERROR: malformed array literal:
"[true,false,false,false,false,true,false,false,false,false,true,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,false
When trying to add a new value to “Minute” in a Repeat for a job scheduled by
pageant I get:-
ERROR: malformed array literal:
"[true,false,false,false,false,true,false,false,false,false,true,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,fals
When trying to add a new value to “Minute” in a Repeat for a job scheduled by
pageant I get:-
ERROR: malformed array literal:
"[true,false,false,false,false,true,false,false,false,false,true,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,fals
When trying to add a new value to “Minute” in a Repeat for a job scheduled by
pageant I get:-
ERROR: malformed array literal:
"[true,false,false,false,false,true,false,false,false,false,true,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,fals
Using latest release candidate on Mac OSX El Capitan
If I run a query in the query window. I am unable to select the ouput from the
Data Output pane. This used to work fine in pgadmin3
I may be missing a UI trick?
Dave Barter
d...@phased.co.uk
@citizenfishy
www.phased.co.uk
--
Sent via
I’ve recreated it again
See attached screenshot
For info the JSON for id 6343 is [{"name":"people_and_property","app_id":37}]
Field 8256 is [“whole..”,”.. ….]
I have conformed the issue exists with another field that is of type [{ …}]
It appears to be an is
,
record_count integer,
status character,
date_uploaded timestamp without time zone,
CONSTRAINT files_pkey PRIMARY KEY (file_id)
)
INHERITS (ng_toplevel.files)
WITH (
OIDS = FALSE
)
Dave Barter
d...@phased.co.uk
@citizenfishy
www.phased.co.uk
> On 19 Sep 2016, at 13:41, Murtuza Zabuaw
Apologies if I have missed this elsewhere
JSON columns in tables are appearing as [Object object] when viewing data so
you cannot edit or view json as you used to be able to do in pagadmin3
I am using pgadmin 4 1.0-rc1 on Mac OSX
Is this by design or a bug?
Dave Barter
d...@phased.co.uk
; After setting the log_error_verbosity in postgres.conf have you reload the
> configuration of that server?
>
>
> Regards,
> Sanket Mehta
> Sr Software engineer
> Enterprisedb
>
> On Fri, Aug 28, 2015 at 5:30 PM, Dave Barter <mailto:d...@phased.co.uk>>
anks, but this is not what I want. I need to change the log_error_verbosity
but still see the log messages
>
> Regards,
> Sanket Mehta
> Sr Software engineer
> Enterprisedb
>
> On Wed, Aug 26, 2015 at 12:51 AM, Dave Barter <mailto:dave.bar...@gmail.com>> wrote:
&g
Is it possible to alter the pgadmin client settings for display of
NOTICE/ERROR messages
I want to add log_error_verbosity=terse to prevent display of all of the
context messages.
I can set this in postgresql.conf server side and it works but pgadmin
still displays the context messages client s
LANGUAGE PLPGSQL
Displays as:-
CREATE OR REPLACE FUNCTION ng_research.test(
filter_param json DEFAULT 'attributes'::character varying,
prefix_param character varying DEFAULT ARRAY['FA'::text,
column_prefixes character varying[] DEFAULT 'FT'::text)
RETURNS json AS
$BODY$
BEGIN
END;
$BODY$
LANGUAGE plpgsql
--
Dave Barter
Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy
more joyful ;-)
This error happens in all versions of PGADMIN 1.18 upwards, we’re currently
testing the beta 1.20 but can cause it in earlier versions.
Thanks for any help.
Dave
--
Dave Barter
Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy
versions of PGADMIN 1.18 upwards, we’re currently
testing the beta 1.20 but can cause it in earlier versions.
Thanks for any help.
Dave
--
Dave Barter
Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy
V1.18.1)
--
Dave Barter
Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy
out to an external editor. This would make
life a lot easier not only for data editing but also for stored procedure
development.
Is this on the roadmap at all? If not my company may be willing to do the work
if we are pointed at the best way to achieve it.
Thanks
Dave
--
Dave Barter
Web: http
pgadmin is terrible for editing json in the database
This could be fixed very quickly by allowing the use of an external editor
--
Dave Barter
Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy
environment
which is multi-screen. It also appears to happen when multiple query
windows are open. How can I gather more information to file a full bug
report when the crash happens next time? Or is it a known issue.
--
Dave Barter
21 matches
Mail list logo
