Hi,
one of my dbs has the following settings:
ALTER ROLE hibuser IN DATABASE kpi
SET default_transaction_read_only = 'off';
ALTER DATABASE kpi
SET search_path = "$user", pg_temp;
I would like to remove hibuser settings using pgAdmin so I navigate to db
node in explorer tree, right click on db
Connecting to the database server just took 62 seconds, which defaults to the
database that has almost all of the 36,000+ objects. Another 40 seconds to
open any of the schemas within that database. Once the schema is opened any
of the tabs within are very fast, unless we refresh them. Anot
On Fri, 2013-01-04 at 11:57 +0100, Guillaume Lelarge wrote:
> On Fri, 2012-12-28 at 23:52 +1100, Evan Martin wrote:
> > I think Ctrl-R is good for refresh (like Firefox and other browsers) and
> > Ctrl-Shift-C sounds fine, too.
>
> OK.
>
> > For Cancel Query I'd suggest "Del" - it "deletes" the
On Fri, 2012-12-28 at 23:52 +1100, Evan Martin wrote:
> I think Ctrl-R is good for refresh (like Firefox and other browsers) and
> Ctrl-Shift-C sounds fine, too.
OK.
> For Cancel Query I'd suggest "Del" - it "deletes" the process.
> For Terminate backend: Shift-Del - it "really delets" it, like
Hi,
On Fri, 2013-01-04 at 07:18 +0100, Annette Ketils wrote:
> HiMy Secunia PSI informs, that I should update the postgreSQL 9.0. I don't
> know, what kind of program it is, and I have to update it manually. Can you
> help me? Annette Ketils
You'll need
On Thu, 2013-01-03 at 13:43 -0600, Robert Klaus wrote:
>
> This message was posted in the pgsql-general and novice lists, and I was
> cirected here . . . sorry for those of you receiving multiple posts.
>
>
>
>
>
> We have 36,000+ rows returned by " SELECT oid, format_type(oid, typtypmod)
>
On Thu, 2013-01-03 at 16:11 +, Campbell, Lance wrote:
> PostgreSQL 9.2.2
> pgAdmin 1.16.1
> pgAdmin > Tools > Server Status
>
> When viewing the Server Status window I notice that my queries look like this:
>
> SELECT * FROM tablex WHERE id=$1
>
> How can I display the full query without the
Hi,
On Thu, 2013-01-03 at 13:25 +0800, Thomas Joseph wrote:
> [...]
> This is my first week with PostgreSQL and pgAdmin.
> So, I am not even sure if this is an erroneous situation.
>
> I am using Postgresql-9.2.2-1-windows.exe installer and the pgAdmin3 came
> with it.
> To interact with PG, I
Hello all.
I'm seeing this bug from 1.10 version, or maybe earlier.
When you opened pgadmin, and sql window, and server restarted, execution of
sql asks if I want to reconnect, but it hangs anyway.
If I try to browse pgadmin tree, it detects that there's no server, ask If
I want to reconnect, and
