[pgadmin-support] Use of obsolete libpq API

2015-06-21 Thread Craig Ringer
Hi PgAdmin-III still uses the obsolete macro PQnoPasswordSupplied . It should instead use PQconnectionNeedsPassword(...). Context: pgadmin/dlg/dlgSelectConnection.cpp: newconn->GetLastError().Cmp(wxString(PQnoPasswordSupplied, wxConvUTF8)) == 0) -- Craig Ringer http://

Re: [pgadmin-support] Massively annoying bug still not fixed in v1.20 :-(

2015-01-08 Thread Craig Ringer
On 20 December 2014 at 00:08, Magnus Hagander wrote: > > On Dec 19, 2014 5:02 PM, "Craig Ringer" wrote: > > > > On 12/19/2014 11:57 PM, Dave Page wrote: > > > Right - we'd have to store the entries somewhere based on the target > > > server and

Re: [pgadmin-support] Massively annoying bug still not fixed in v1.20 :-(

2014-12-19 Thread Craig Ringer
callback for a password prompt, but it doesn't. Guess we should add that. If libpq gets an auth request from the server and has no password from the connection string, it should invoke a callback (if supplied) that lets the client supply a password dynamically. -- Craig Ringer

Re: [pgadmin-support] Massively annoying bug still not fixed in v1.20 :-(

2014-12-19 Thread Craig Ringer
s to instead use a callback within pgadmin . -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.p

Re: [pgadmin-support] Massively annoying bug still not fixed in v1.20 :-(

2014-12-19 Thread Craig Ringer
ften fail because the port number won't match. Why not handle it like libpq does? Connect, and if the server asks for a password *then* prompt the user. You can do this with a libpq connection callback. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development,

Re: [pgadmin-support] password support

2014-03-04 Thread Craig Ringer
ns? > http://wiki.postgresql.org/wiki/FAQ#I.27m_installing_PostgreSQL_on_Windows_or_OS_X_and_don.27t_know_the_password_for_the_postgres_user -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgadmin-support mailing li

Re: [pgadmin-support] Restoring PostgreSQL Database Backup

2014-02-06 Thread Craig Ringer
f pg_restore directly. Alternately, you can run the 8.4 pg_restore without a database name to convert the custom-format dump to a plain SQL script. Then you can use psql to apply that script to the 8.3 machine. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Developmen

Re: [pgadmin-support] Format SQL (external tool)

2014-02-06 Thread Craig Ringer
may involve revisions to the way they're implemented, and sometimes the project may choose not to accept a patch, but usually it'll be received with a grateful "thanks, that's handy". -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x

[pgadmin-support] Outdated and misleading docs on vacuum

2013-08-10 Thread Craig Ringer
to install an automatic job, that performs a VACUUM job regularly to keep your database in a neat state." which suggests that it *predates autovacuum*. Pointed out by http://dba.stackexchange.com/q/47900/7788 . -- Craig Ringer

Re: [pgadmin-support] I can not install PostgreSQL 9.2

2013-03-24 Thread Craig Ringer
pgsql-b...@postgresql.org -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: [pgadmin-support] Fwd: How to run query by command prompt in Postgres

2013-03-20 Thread Craig Ringer
ouble understanding something in the documentation please explain what you've already tried, where you're getting stuck, and the SPECIFIC problem you're having in a post to the pgsql-general mailing list. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: [pgadmin-support] pgAdmin and AWS Redshift Connection problems

2013-03-08 Thread Craig Ringer
checked the code, but in this > case I suspect it's checking the default tablespace so it can build > the reverse engineered SQL queries it displays correctly, and to > display the correct default value in object creation dialogues. > There's unlikely to be anything you can do

Re: [pgadmin-support] GetHierarchy

2013-02-28 Thread Craig Ringer
On 03/01/2013 12:14 PM, bhanu udaya wrote: > > I need a query to retrieve all the n level hierarchy when a Child > node_id is passed. I think you're probably looking for the pgsql-general mailing list or Stack Overflow. This list is focused on the PgAdmin-III program. --

Re: [pgadmin-support] pgAdmin dying when renaming a function

2012-11-13 Thread Craig Ringer
" Details? Error message or crash information? How are you renaming the function? Via the PgAdmin GUI? Can you post an exact list of steps so we can reproduce the problem, including the function, database and schema names? -- Craig Ringer http://www.2ndQuadrant.com/

Re: [pgadmin-support] problems

2012-08-31 Thread Craig Ringer
I'd advise you to contact Poker Tracker's tech support for an issues with Poker Tracker. -- Craig Ringer On 09/01/2012 05:51 AM, Morten Nergaard wrote: hi i have downloaded poker tracker 3 to my mac.. so will i use posture SQL.. But didn't understand what and where to wr

Re: [pgadmin-support] Create or Update Function

2012-07-09 Thread Craig Ringer
spect the CREATE OR REPLACE is failing because of bad function syntax or similar, so a following invocation of the function is causing your function foo() does not exist error. -- Craig Ringer

Re: [pgadmin-support] Posgres 9.1.4

2012-07-06 Thread Craig Ringer
.microsoft.com/gp/lifean35) . For a longer term solution, start here: http://support.microsoft.com/ph/1131 . -- Craig Ringer

Re: [pgadmin-support] [GENERAL] MS Access 2007 update write conflict problem & resolution

2010-03-20 Thread Craig Ringer
rning off "row versioning". -- Craig Ringer -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [GENERAL] [pgadmin-support] PostgreSQL

2008-09-15 Thread Craig Ringer
ux one for valgrind and everything else, plus a Windows one for VC++'s debugger. -- Craig Ringer -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support