I'm currently running PG 9.1 on Linux, and PgAdmin on Windows. Which
platform(s) does pg_agent need to be built on? The "service" aspect
suggests the db host, but the requirement for WxWidgets suggests it's
building a GUI component...
It'd be nice to be able to right click on a foreign key value in a table
view and have a menu option (in addition to the existing "filter on
value", etc) to open a new table view on the referenced table filtered
to just the matching record.
Mike Blackwell
mike.blackw...@rrd.com
The Logfile window seems not to want to tile horizontally. I tried
closing and reopening it. It will only display as the only window
(covering Activity, et al) or as a pane on the right side with the other
windows on the left. Is this intended behavior? If not, is there a way
to reset the "curr
The quick search keys in the object browser window seem to operate a
little differently. They will now search the children of the
(unexpanded) currently selected node as well as the currently expanded
nodes. I don't recall it doing that before.
Mike Blackwell
--
Sent via pgadmin-su
If the server connection drops while on the server status page, a popup is
created every time the page refreshes.
To reproduce, connect to a server an monitor it, then stop the server.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscri
.
___
Mike Blackwell | RR Donnelley Technology Services
Is there a place in pg-admin that shows what index (if any) a table is
clustered on? If not, could it be added?
Mike
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
I sent the last to the wrong list. Sorry about that.
However, if anyone does have an answer, I'll gladly accept it.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
I have a database which was originally created with LATIN1 encoding.
I'd like to move it to UTF8. The data will load ok (COPY) but I am
getting 'invalid byte sequence for encoding..." messages when accessing
the data.
Is there a way to automatically convert the offending characters, or to
easil
Would it be possible, perhaps as an option, to display the relation
name, and possibly the type, in the Server Status Lock display?
Mike
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
htt
Is there a way to build only pgagent without having to install wxwidgets
and build the entire package? I normally run pgAdmin from a windows
machine, but the database is on a linux server which doesn't have
wx-widgets (or really any windowing stuff) installed.
---(end
A small annoyance: Newlines in table field comments appear to be stripped
when the table is displayed in the Object Browser table list (upper right
window). This makes multiline comments difficult to read. It'd be nice
if the newline were replaced with a space instead.
No rush on my part - j
Windows XP SP2
pgAdmin dated 19 Oct 2007
various 8.x.x versions of PostgreSQL
---
The overloading of Ctl-V in the Edit window has been causing problems for
me. Normally I use it while editing a field to paste a value. However,
if the field is not open for editing (hasn't been clicked on tw
To reproduce:
Select a table in the object browser window.
Select Grant Wizard from the Tools menu.
or
Right click on a table in the object browser and select Grant Wizard.
Note the Selection window does not list any tables, and OK cannot be
selected after adding the permission information.
On Windows.
When connecting to a pre-8.2.0 version of PostgreSQL, a popup with the
following message is displayed:
ERROR: syntax error at or near "pg_get_userbyid"
Line 1: ...T ts.oid, spcname, spclocation, " AS description pg_get_use...
The following line has a carrot under the 'o' in 'spcloca
Is there a way to change the order of the servers in the Servers list?
It'd be nice if they were alphabetically sorted.
I've installed the admin functions per the README.adminpack under
PostgreSQL 8.2.3's contrib/adminpack directory, but PgAdmin (1.6.2) still
says the functions are not installed on the server. This happens even
after restarting both PostgreSQL and PgAdmin.
Any thoughts as to what I may be missi
PgAdmin 1.6.0
Windows XP (current SP/fixes)
postgresql 8.1.3 (also 7.x)
To recreate:
Highlight a table in the server browser. Choose a table that will
take a while to load in the table edit view.
Be sure View All is selected in the options.
Click on the edit table butto
Erwin wrote on 11/24/2006 07:50:21 PM:
> Maybe this is not what Mike has been thinking of, but I'd like to
> propose an improvement in this context: cycle all columns at once by
> double clicking the top left corner of the grid.
That's exactly what I'm looking for. Clicking on indivdual columns
PgAdmin 1.3.0
Windows 2000
PostgreSQL 8.0.1
PostgreSQL automatically defines a Composite Type for each table when it
is created (manual 8.11.1). These types can then be used in a subsequent
CREATE TABLE. PgAdmin does not add these Types to the Create Table
dialog's type list.
-
> Andreas Pflug <[EMAIL PROTECTED]> wrote on 11/19/2004 10:07:58
AM:
> To detect such a column, it must have been retrieved, which wouldn't
> help for your problem...
>
Intersting. Using psql the column can be retrieved and displayed very
quickly, so I assumed the issue was in the formatting
Andreas Pflug <[EMAIL PROTECTED]> wrote on 11/19/2004 10:07:58 AM:
> Very bad idea. If pgAdmin offers to edit the column at all, the field
> content must be complete. Anything else would lead to many bad
surprises.
Point taken. Still, going unresponsive for minutes is not a good trait
for any
RC-1 consistantly locks up in the Edit Data window when viewing a table or
view containing a long text field with embeded newlines.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister
23 matches
Mail list logo
