>
> ------
> On Thursday, June 15, 2017, 9:15:59 PM EDT, Richard Greenwood <
> richard.greenw...@gmail.com> wrote:
>
>
> Like is this a charade? Am I hallucinating? Are computer professionals
> still using MS Windows?
>
> On Thu, Jun 15,
be "too graphical" if that makes
> sense, and haven't tried pgAdmin4. My scanning of this mailing list leads
> me to believe what you are saying is reasonably accurate even if your tone
> is not: there are a number of active discussions on this very topic on this
> mailing list right now.
>
> David J.
>
>
>
--
Richard W. Greenwood, PLS
www.greenwoodmap.com
polygeom geometry(957204)
Like "957204" is not being translated to "MultiPolygon, 3739". Any ideas or
should I be asking this on the postgis list?
Thanks,
Rich
--
Richard W. Greenwood, PLS
www.greenwoodmap.com
> pgadmin-support-ow...@postgresql.org] *On Behalf Of *Richard Greenwood
> *Sent:* 24 May 2017 14:15
> *To:* pgadmin-support@postgresql.org
> *Subject:* [pgadmin-support] pgAdmin4 speed
>
>
>
> There were several recent comments on this list about pgAdmin4 being slow
>
t and then using pgAdmin4 in a web
browser. I suggest that folks who are bothered by the speed (lack of) in
standalone mode give the server + browser setup a try. The server is
launched with a single command:
python /path/to/pgAdmin4.py
then navigate to:
localhost:5050
Rich
--
Richard W.
On 2017-05-20 14:23, Raymond O'Donnell wrote:
On 20/05/17 11:17, rich...@xentu.com wrote:
On 2017-05-19 14:45, rich...@xentu.com wrote:
On 2017-05-19 14:20, Adam Brusselback wrote:
I seriously may go back to PostgreSQL 9.3 so that I can use pgAdmin
III until I can wean myself off the tool.
Y
On 2017-05-19 14:45, rich...@xentu.com wrote:
On 2017-05-19 14:20, Adam Brusselback wrote:
I seriously may go back to PostgreSQL 9.3 so that I can use pgAdmin
III until I can wean myself off the tool.
You don't have to revert your database version to use pgadmin III,
the newest release works f
On 2017-05-19 15:13, Michal Kozusznik wrote:
It means you don't have to switch into pgAdmin4 just because you are
using recent version of database.
pgAdmin3 v1.22.2 supports pg9.6 (at least it doesn't throw exceptions
for common tasks)
MK
On 19.5.2017 15:45, rich...@xentu.com wrote:
On 2017-05-
On 2017-05-19 14:20, Adam Brusselback wrote:
I seriously may go back to PostgreSQL 9.3 so that I can use pgAdmin
III until I can wean myself off the tool.
You don't have to revert your database version to use pgadmin III,
the newest release works fine with Postgres 9.6, and there is also the
Bi
r a huge fan of pgAdmin III; I mean, it
seemed to do its job okay, but after using pgAdmin 4, suddenly I have
newfound respect for pgAdmin III.
Sorry,
Eric
Yep, it's horrible.
Why everything has to look like a web application is beyond me. If I
wanted that, I could use something like p
gt;>
>> I created a "Read-only" User in PostgreSQL via a Role with "SELECT" ONLY
>> privilege on all tables in a schema as shown below:
>>
>>
>>
>> GRANT SELECT ON ALL TABLES IN SCHEMA [schema_name] TO [role_name]
>>
>> GRANT [role_name] TO [user_name]
>>
>>
>>
>> Next, I test this by trying to UPDATE a column in a table (same schema as
>> above) with pgAdmin/psql and this works fine by giving a response that the
>> user has no permission - 'ERROR: permission denied for relation
>> .'
>>
>>
>>
>> Next, I connect with the same user in QGIS and add a layer from the same
>> table (same schema as above). I open the attribute table for the layer,
>> turn on editing mode (by clicking on the pencil-like icon), and edit the
>> same field/column above. To my surprise, the edit was saved successfully
>> without any permission error prompt.
>>
>>
>>
>> Next, I check the value of the field/column (same table/schema as above)
>> in pgAdmin/psql and it is having the new (edited) value from QGIS. This is
>> rather strange as it seems QGIS is bypassing the permissions set for the
>> same user in the PostgreSQL/PostGIS database.
>>
>>
>>
>> I will be glad if someone can help me unravel this mystery.
>>
>>
>>
>>
>>
>>
>>
>
>
--
Richard W. Greenwood, PLS
www.greenwoodmap.com
cript certainly doesn't know how to use 3.0 in 2.8
> compatibility mode.
>
I believe there are a few things to verify and test enabling this to be
possible:
http://docs.wxwidgets.org/trunk/overview_changes_since28.html
It *would* be nice to migrate to the new wx Widge
hink that pgAdmin is counting the time to
traverse the result set, but that's purely speculation.
From: Guillaume Lelarge
To: Richard D Levine
Cc: Dave Page , hushthatb...@hushmail.com,
"pgadmin-support@postgresql.org"
,
pgadmin-support
When I have pgAdmin, my app, and PG all running on the same machine,
pgAdmin reported query times are one or two orders of magnitude slower than
times for the same query reported by turning on statement logging.
From: Dave Page
To: hushthatb...@hushmail.com
Cc: "pgadmin-support@post
because Windows
does not support scanning your own machine (localhost) this way.
Nmap scan report for localhost (127.0.0.1)
Host is up.
PORT STATE SERVICE
...
5432/tcp unknown postgresql
...
Nmap done: 1 IP address (1 host up) scanned in 2.13 seconds
You can get nmap from:
http://nmap.org/do
I can find no reference in any Postgres or EnterpriseDB documentation to
MATERIALIZED VIEW. Are you using pgAdmin with a different DB engine? I'm
confused. I would also love to have materialized views.
|>
| From: |
|>
>-
se a connection pooler.
You'll also need to reduce work_mem to 1MB or so.
--
Richard Huxton
Archonet Ltd
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
Hello,
I've just installed pgAdmin 1.16.1 under for Windows
(http://ftp.postgresql.org/pub/pgadmin3/release/v1.16.1/win32/pgadmin3-1.16.1.zip)
running windows 8 64bit.
Installation was successful and connection to databases is successful as well
however when an incorrect password is entered duri
y not a bug, but it is an undesirable
'feature' that adds hurdles to altering existing DDL. I expect that
this would affect table and domain constraints.
I'll mention this as a feature request on the general mailing list.
--
Regards,
Richard Broersma Jr.
--
Sent via pgadmin-sup
pnt_name::text, '(^\\d{1,2...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Query returned successfully with no result in 157 ms.
--
Regards,
Richard Broersma Jr.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.
urrences of the regular expression strings and re-apply the E.
Is there any way to get 'Create Script' to do this automatically?
--
Regards,
Richard Broersma Jr.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://ww
kage by the name of gtk-qt-engine available, either installed or
in the repository.
Also a suggestion: on startup, default the focus of the language selector to
[ok] rather than [cancel] and have the program remember the choice.
Thanks,
Hope this is an ok bug report.
Richard C.
okay i'll give it a try thanks.
On Fri, May 14, 2010 at 1:38 PM, Guillaume Lelarge
wrote:
> Le 14/05/2010 19:56, Richard Broersma a écrit :
>> On Fri, May 14, 2010 at 10:37 AM, Guillaume Lelarge
>> wrote:
>>
>>> Can you send us a screenshot? I don't actu
[platform] Windows XP
[version] 1.10.2
I'd be nice if the comment field in reports such as the "data
dictionary" report would auto-wrapped. Notice how long comments get
truncated when printing the report.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Use
e to the truncated data values. I've also seen
this with null valued boolean fields.
Part of the solution would be configure the ODBC driver to use
PostgreSQL's xmin for optimistic locking. Of-course this doesn't fix
MS-Accesses inability to handle the ranges of many of PG data-t
ted because of error
Process returned exit code 1.
----
Richard Casey, PhD
RMRCE/CSUCB/CEM
Campus Delivery 1690
Colorado State University
Ft. Collins, CO 80523
Ph: 970-491-8568
Cell: 970-980-5975
Email: richard.ca...@colostate.edu
--
Sent via pgadmin-support mailing list (pgadmin-support@postgres
Dave Page wrote:
On Wed, Jun 18, 2008 at 5:48 PM, Richard Tector
<[EMAIL PROTECTED]> wrote:
I might be missing the point here, but I can't seem to get pgAdmin to
initiate an SSL encrypted connection to any of our PostgreSQL servers
(mainly 8.2, some 8.3) but using password (md5) aut
d not read certificate" or "could not read private key file"
messages. This makes sense if I were trying to connect using client
ceritificates for authentication but not for md5 type auth.
Any thoughts on the matter would be much appreiciated.
Kind regards,
Richard Tector
P
Can someone please tell me where pgadmin II is now located? Having
tried via various routes to find it, I always seem to get re-directed
back to the pagamin III page.
Thanks in advance.
--
Cheers,
Richard Blackwell Ph : 778.782.4092
Manager, Information Technology
Raphaël Enrici wrote:
Richard Huxton a écrit :
Regarding pgadmin3-data
File on mirror(s) = 2722978 bytes
Size in "Packages"/apt-cache show = 2722412
Hello Richard,
when did that begin? I've reworked on the repository this week end to
add signing I may have done something wro
he show" is
2722412
Packaging issue?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 6: explain analyze is your friend
ta_1.6.3-1~pgaoetch1_all.deb
Size mismatch
E: Unable to fetch some archives, maybe run apt-get update or try with
--fix-missing?
Have checked a German mirror too, and confirmed it's not just UK#2 with
that filesize.
I'm upgrading from 1.6.2-1~pgaoetch1 though I don't think it's
g the date/month etc of a day ) ?
Use PAM/LDAP/Kerberos to handle your passwords and you have access to
all sorts of options.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
How do I get an email address removed from this list?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Christopher
Kings-Lynne
Sent: Thursday, June 15, 2006 10:29 PM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Bug with passwords that
I receive the following error when attempting to run Pgadmin3 1.2.2.
"Unable to initialize gtk, is DISPLAY set properly?"
Rich
-> libpq.so.4.0. Any suggestions?
OS SuSE 9.1
Pgadmin-1.2.2 built from source
Rich
Richard Radcliffe,Owner, Kondor WaffenamtSi Pace volat, para bellum
Is anyone working on the debian package for pgAdmin III v1.2 Beta-3 ?
They are not at
ftp://ftp.eu.postgresql.org/pub/unix/db/postgresql/pgadmin3/beta/debian
Thanks,
--
Richard van den Berg, CISSP
Trust Factory B.V. | http://www.trust-factory.com/
Bazarstraat 44a | Phone: +31 70
Andreas Pflug wrote:
In any case, we'd appreciate further feedback on this topic (positive or
negative).
Ok, I compile wxwindows 2.5.3 from source and pgadmin3 using the current
CVS version. I can see the content of the schemas now!
Thanks a lot for the quick fix.
--
Richard van den Berg,
.3 at this moment. The official
experimental debian packages are stuck at 2.5.1.
In any case, we'd appreciate further feedback on this topic (positive or
negative).
Compiling wxwidgets is too much of an effort right now. I'll give it a
try over the weekend.
--
Richard van den Be
or the note though.
Sincerely,
--
Richard van den Berg, CISSP
Trust Factory B.V. | http://www.trust-factory.com/
Bazarstraat 44a | Phone: +31 70 3620684
NL-2518AK The Hague | Fax : +31 70 3603009
The Netherlands |
---(end of broadcast)-
formation_schema')
ORDER BY 1, nspname
The result of this query does list the schema with the correct OID
(2518196330).
The question is: why does pgadmin3 think the oid for the schema is
2147483647 ?
I have this problem with a bunch of schema's, which makes pgadmin3 quite
useless for me
t take this as complaining. I realize its beta, and its not
something I could offer to help code and..oh yes, its free.
regards
Richard
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
ented?
What other client tool do people use for this?
regards
Richard
---(end of broadcast)---
TIP 8: explain analyze is your friend
[EMAIL PROTECTED] wrote:
it seems that richard is using woody ( the debian stable release ).
Actually, I am not. I'm running a mix of testing and unstable on my
system. I used the stable pgadmin3 distribution however.
As I'm linking dynamically debian packages to postgre, I used th
2.2 1:2.95.4-17 The GNU stdc++ library
ii libtiff3g 3.5.7-2 Tag Image File Format library
ii xlibs 4.2.1-11 X Window System client libraries
ii zlib1g 1:1.2.1-3 compression library - runtime
-- no debconf information
--
Richard van den Berg, CISSP
Trust Fa
Richard Bacon babbled:
far too much to be useful ;-o - sorry
Anyway,
Looked at the configure script and saw a need for xml.h in
/usr/local/include/xrc
found xml.h in /usr/local/xml
so I created a link from one to t'other.
configure completed hapily, I'm now compiling pgadmin3
Than
r libpq-fe.h... yes
checking pgsql in /usr... ok
checking for wxWindows... yes
configure: error: you need to install the xrc package from
wxWindows/contrib/src/stc
Dave Page wrote:
Hi Richard,
-Original Message-
From: Richard Bacon [mailto:[EMAIL PROTECTED]
Sent: 17 September 2003 23:35
able-debug
...
configure: error: you need to install the xrc package from wxWindows/contrib/src/stc
it looks like the install is not working, is this because I need to
replace @DESTDIR@ in the Makefiles with something? if so what?
TIA
Richard
---(end of
other fiales mentioned in an earlie post COMdlg32,
(22/05/2000) comct232 and comct332 were missing but have been reinstalled and
reregistered these are dated 23/06/1998
Any help would be grateflly received
Richard
===Richard Hurst
Senior Officer - Systems
unsubscribe
_
http://www.latinmail.com. Gratuito, latino y en español.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
unsubscribe, please
_
http://www.latinmail.com. Gratuito, latino y en español.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs
I run PostgreSQL version 7.1.3 on my Redhat linux server.
When I try to connect with pgadmin I get the
next error message :
An error has occured in pgadmin
II : frmConnect.cmdConnect_click:
Number: -2147467258
Description: Could not connect to server; Could
not connect to remo
52 matches
Mail list logo
