On 14 July 2012 13:57, Guillaume Lelarge wrote:
> On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote:
>> Use of the CTID system column would work.
>
> I don't see how that could work. CTIDs obviously are unique, but anyone,
> updating a line will get another CTID for t
On 12 July 2012 12:20, Jan-Peter Seifert wrote:
> Hello,
>
> I have a feature request for the 'Edit data' window that is available for
> each table in pgAdmin.
>
> As the OID column is not guaranteed to contain unique OIDs it would be nice
> to have additional/other fallback options ( via check
it.d/iptables restart
>
> and I got in!
>
> Thanks Thom.
>
Well it was Guillaume who guided you in that direction, not I. :)
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
t; I can ping my server fine.
>
> I appreciate any ideas.
>
What message comes up when failing to connect?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On 2 July 2011 23:57, Thom Brown wrote:
> On 2 July 2011 13:11, Guillaume Lelarge wrote:
>> On Sat, 2011-07-02 at 10:23 +0100, Thom Brown wrote:
>>> Hi
>>>
>>> How does one run CLUSTER on a table using the PgAdmin GUI? (assuming I
>>> have an inde
On 2 July 2011 13:11, Guillaume Lelarge wrote:
> On Sat, 2011-07-02 at 10:23 +0100, Thom Brown wrote:
>> Hi
>>
>> How does one run CLUSTER on a table using the PgAdmin GUI? (assuming I
>> have an index I selected "clustered" on)
>>
>
> AFAICT, y
Hi
How does one run CLUSTER on a table using the PgAdmin GUI? (assuming I
have an index I selected "clustered" on)
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreS
On 27 June 2011 15:33, Dave Page wrote:
> On Mon, Jun 27, 2011 at 3:30 PM, Thom Brown wrote:
>> On 25 June 2011 12:40, Thom Brown wrote:
>>> Hi,
>>>
>>> I'm using PgAdmin III 1.14.0 beta 1 on 64-bit OSX 10.6.8, and whenever
>>> I type an openin
On 25 June 2011 12:40, Thom Brown wrote:
> Hi,
>
> I'm using PgAdmin III 1.14.0 beta 1 on 64-bit OSX 10.6.8, and whenever
> I type an opening parenthesis in the SQL Editor and attempt to use a
> newline it crashes the whole application. This happens regardless as
> to
On 20 June 2011 20:20, Dave Page wrote:
> On Mon, Jun 20, 2011 at 2:42 PM, Thom Brown wrote:
>>
>> Okay, updated patch attached. This enables modification of fill
>> factor on existing tables and primary keys.
>
> Thanks Thom - patch applied with one minor fix (you m
On 20 June 2011 11:00, Dave Page wrote:
> On Fri, Jun 17, 2011 at 6:39 PM, Thom Brown wrote:
>> On 17 June 2011 18:18, Thom Brown wrote:
>>> On 17 June 2011 18:16, Thom Brown wrote:
>>>
>>>> Very well then. Dodgy patch attached.
>>>
>>
On 17 June 2011 18:18, Thom Brown wrote:
> On 17 June 2011 18:16, Thom Brown wrote:
>> On 16 June 2011 15:41, Dave Page wrote:
>>> On Thu, Jun 16, 2011 at 2:45 PM, Thom Brown wrote:
>>>> Hi,
>>>>
>>>> I'm using PgAdmin III 1.14.0 beta
On 17 June 2011 18:16, Thom Brown wrote:
> On 16 June 2011 15:41, Dave Page wrote:
>> On Thu, Jun 16, 2011 at 2:45 PM, Thom Brown wrote:
>>> Hi,
>>>
>>> I'm using PgAdmin III 1.14.0 beta 1 and noticed that if I go into the
>>> properties dialo
On 16 June 2011 15:41, Dave Page wrote:
> On Thu, Jun 16, 2011 at 2:45 PM, Thom Brown wrote:
>> Hi,
>>
>> I'm using PgAdmin III 1.14.0 beta 1 and noticed that if I go into the
>> properties dialog box for a table, the Fill Factor field cannot be
>> modif
n the Fill Factor field. However, it still cannot be modified.
Also, the properties dialog box for a primary key also has a Fill
Factor field, and values can be entered into it, but the OK button
stays greyed out and the SQL tab shows nothing to be changed.
Thanks
--
Thom Brown
Twitter: @dar
lish, it disappears again, thus I anticipate
> this is a bug in PgAdmin on multilanguage support.
>
> Thank you for your support,
>
>
I'm also using 1.12.1 but don't have that problem. (see attached image)
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Regi
eemed to be wrong database selected to install
> pgagent which is not the above case.
>
> Any help would be appreciated.
>
>
Have you got the jobs node enabled? This is done by going to File > Options
> Browser and ticking the "pgAgent Jobs" option.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
e you
used? Mine doesn't default to anything. If I click on the ellipsis and type
a filename without an extension into the file browser and click OK, it just
comes up with the path and the filename I typed without an extension.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
On 27 October 2010 14:08, Julius Tuskenis wrote:
> 2010.10.27 15:22, Michael Shapiro rašė:
>>
>> Thom Brown has it basically right. I want to be able to take the results
>> of what is in the grid editor and produce insert stmts.
>
> Yes - this kind of tool would be ha
table (col_a, col_c, col_g) VALUES (1, 'stuff', true);
INSERT INTO my_table (col_a, col_c, col_g) VALUES (2, 'things', true);
INSERT INTO my_table (col_a, col_c, col_g) VALUES (6, 'misc', false);
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Lin
On 6 October 2010 16:18, Guillaume Lelarge wrote:
> Le 06/10/2010 17:12, Thom Brown a écrit :
>> On 6 October 2010 16:03, Robert Ayrapetyan
>> wrote:
>>> Hello.
>>>
>>> pgAdmin 1.12.0 (windows version) crashes when perform following steps:
>>
On 22 October 2010 12:46, Dave Page wrote:
> On Fri, Oct 22, 2010 at 12:02 PM, Thom Brown wrote:
>> However, I have noticed an extra level of sheen in this version. Have
>> you guys changed something? The tabs look shiny and the toolbar looks
>> less bulky.
>
> Are y
On 22 October 2010 12:31, Guillaume Lelarge wrote:
> Le 22/10/2010 03:51, Thom Brown a écrit :
>> On 22 October 2010 00:34, Guillaume Lelarge wrote:
>>> Le 19/10/2010 13:29, Thom Brown a écrit :
>>>> On 19 October 2010 21:24, Thom Brown wrote:
>>>>>
On 22 October 2010 11:51, Thom Brown wrote:
> On 22 October 2010 00:34, Guillaume Lelarge wrote:
>> Le 19/10/2010 13:29, Thom Brown a écrit :
>>> On 19 October 2010 21:24, Thom Brown wrote:
>>>> On 19 October 2010 21:08, Guillaume Lelarge wrote:
>>>>
On 22 October 2010 00:34, Guillaume Lelarge wrote:
> Le 19/10/2010 13:29, Thom Brown a écrit :
>> On 19 October 2010 21:24, Thom Brown wrote:
>>> On 19 October 2010 21:08, Guillaume Lelarge wrote:
>>>> You're right. Done in this new attached patch.
>>&g
On 19 October 2010 21:24, Thom Brown wrote:
> On 19 October 2010 21:08, Guillaume Lelarge wrote:
>> You're right. Done in this new attached patch.
>
> Yep, that's excellent :) One problem is that if you zoom in and
> scroll down to a high-numbered row, it's crop
On 19 October 2010 21:08, Guillaume Lelarge wrote:
> Le 19/10/2010 21:15, Thom Brown a écrit :
>> On 19 October 2010 19:43, Guillaume Lelarge wrote:
>>> Le 19/10/2010 08:15, Guillaume Lelarge a écrit :
>>>> Le 19/10/2010 00:27, Dave Page a écrit :
>>
dit grid, and other
>>> grids we may be using such as those on the debugger.
>>>
>>
>> +1
>>
>
> If they use the ctlSQLResult, they should be fine. I tried on the edit
> grid and it worked.
>
> Two patchs attached: one for the font customization (which could be
> commited to 1.12 and master), one for the mousewheel support (which will
> only be applied to master).
>
> Any comments before I commit them?
Yes, the scrollwheel zoom should really also increase the height of
rows and size of text on column titles/row numbers too if that's
possible. And I'm wondering if the zoom should be persistent.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
le, Blocked and Slow. The
colours are configured in the options section. By default, Active is
green, Idle is blue, Blocked is salmon red and Idle is a kind of sandy
brown.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
--
Sent via pgadmin-sup
On 12 October 2010 10:41, Dave Page wrote:
> On Thu, Oct 7, 2010 at 4:59 PM, Guillaume Lelarge
> wrote:
>> Le 07/10/2010 13:56, Dave Page a écrit :
>>> On Tue, Oct 5, 2010 at 11:03 AM, Thom Brown wrote:
>>>> Okay, I've tried reproducing it by asking
onents the result grid
>> bigger.
>
> Thats what I thought, but I tested it on Mac and found it didn't work.
> wxMac bug?
Or, if you're a bit awesome, implement the ability to use CTRL +
scrollwheel and CTRL + (+/-) to zoom in/out.
--
Thom Brown
Twitter: @darkixion
IRC (free
On 7 October 2010 12:56, Dave Page wrote:
> On Tue, Oct 5, 2010 at 11:03 AM, Thom Brown wrote:
>> Okay, I've tried reproducing it by asking it to show the edit view
>> without restricting the number of results, but seems to be fine. But
>> if I open with limited to
gt; 5. File selection dialog will appear
> 6. Push "Cancel" in file selection dialog ->
> pgAdmin crashes.
Yes, I can recreate this too.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
--
Sent via pgadmin-support mailing list (pgadm
On 5 October 2010 11:03, Thom Brown wrote:
> On 5 October 2010 10:20, Dave Page wrote:
>> On Fri, Oct 1, 2010 at 2:32 PM, Thom Brown wrote:
>>> 2010-10-01 13:37:13 BST LOG unexpected EOF on client connection
>>> 2010-10-01 13:37:12 BST LOG could not r
On 5 October 2010 10:20, Dave Page wrote:
> On Fri, Oct 1, 2010 at 2:32 PM, Thom Brown wrote:
>> 2010-10-01 13:37:13 BST LOG unexpected EOF on client connection
>> 2010-10-01 13:37:12 BST LOG could not receive data from client: No
>> connection could be made becau
On 1 October 2010 14:21, Thom Brown wrote:
> On 1 October 2010 14:12, Dave Page wrote:
>> On Fri, Oct 1, 2010 at 2:00 PM, Thom Brown wrote:
>>> I can't recreate this, so it may not be much help, but I left PgAdmin
>>> running with no query windows open at all, an
On 1 October 2010 14:12, Dave Page wrote:
> On Fri, Oct 1, 2010 at 2:00 PM, Thom Brown wrote:
>> I can't recreate this, so it may not be much help, but I left PgAdmin
>> running with no query windows open at all, and eventually I noticed my
>> PC slowing right down
ed on a cluster node.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
<>
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
is there that much of a cost of doing the scan
anyway? The user will nearly always need to open the schema node
anyway.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
On 21 September 2010 21:40, Guillaume Lelarge wrote:
> Le 21/09/2010 22:05, Guillaume Lelarge a écrit :
>> Le 21/09/2010 14:37, Thom Brown a écrit :
>>> On 21 September 2010 13:31, Guillaume Lelarge
>>> wrote:
>>>> Le 21/09/2010 14:25, Thom Brown a écrit
On 21 September 2010 13:31, Guillaume Lelarge wrote:
> Le 21/09/2010 14:25, Thom Brown a écrit :
>> Hi all,
>>
>> I think the query history box should be labelled, or at least have a
>> tooltip. A colleague of mine was confused by the presence of the new
>> drop-
this drop-down.
Could it be made clearer what the function of this box is. Like
"Previous queries" or "Statement history". And update the help to
show this with an explaination as to its function?
Thanks
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Regis
2010/7/13 jinbok.lee :
> Hello…
>
> I’m an engineer in charge of commercial program with using Postgre DB.
>
>
>
> My question is…
>
> What we have to type the specified password when we install ‘Postgre’
> program.
>
> It is so difficult for users using our product to remember the password and
> i
On 29 June 2010 16:53, Jordan Preston wrote:
> Hi,
> Your program is excellent, and would like to help see it become better.
>
> I have a few comments / questions/ concerns:
>
> I am on Windows XP, and unfortunately PG Admin crashes often, and hangs then
> crashes when there are database chang
On 18 June 2010 15:04, Dave Page wrote:
> On Fri, Jun 18, 2010 at 9:50 AM, Thom Brown wrote:
> > On 18 June 2010 14:48, Dave Page wrote:
> >>
> >> On Fri, Jun 18, 2010 at 9:47 AM, Thom Brown
> wrote:
> >> > I have both PgAdmin III and Postgres Stud
On 18 June 2010 14:48, Dave Page wrote:
> On Fri, Jun 18, 2010 at 9:47 AM, Thom Brown wrote:
> > I have both PgAdmin III and Postgres Studio installed, but with only
> PgAdmin
> > III running, if I press F1 in a query window, it goes to the EnterpriseDB
> > site. This
I have both PgAdmin III and Postgres Studio installed, but with only PgAdmin
III running, if I press F1 in a query window, it goes to the EnterpriseDB
site. This is on v1.12.0 beta 2 on Windows.
Thom
On 26 May 2010 06:07, venkat chalamala wrote:
> Hi,
>
> This is venkat and after opening the netbeans i'm unabletoconnect to
> Postgres Databases.
> I have the database name, trackversa and port numberand all.
>
> but i'm unable toconnect, please diagnose the problem.
>
> thank you.
>
There's ver
On 5 May 2010 13:54, Giuseppe Sacco wrote:
> Hi all,
> is there any way to get an empty window for querying data? Currently,
> when I press the SQL button, I always get a window with a CREATE
> statement for the currently selected object / databases, view, schema,
> table, ...)
>
> Thank you very
On 17 March 2010 11:40, Guillaume Lelarge wrote:
> Le 17/03/2010 12:37, Thom Brown a écrit :
> > On 17 March 2010 11:29, javib wrote:
> >
> >>
> >> Thanks for replying so fast Thom. I tried the following line and it
> didn't
> >> work:
>
On 17 March 2010 11:29, javib wrote:
>
> Thanks for replying so fast Thom. I tried the following line and it didn't
> work:
>
> CREATE TABLESPACE otraParti LOCATION '/media/Iomega HDD(F:)'
>
> and I'm getting the following error:
> ERROR: couldn't define permissions for directory «/media/Iomega H
On 17 March 2010 11:10, javib wrote:
>
> Hello,
> I would like to create a database in a different hard drive than the one in
> which pgadmin is installed. I've been looking through the options of
> pgadmin
> and I haven't seen anything. The reason I'm doing this is because this new
> database I'
On 3 February 2010 14:01, Dave Page wrote:
>> For example, if I select the
>> equivalent of B4 through C10, upon right-clicking on that range I'd
>> want to see an option that would let me copy what has been selected.
>
> I'm not sure where the disabled cut/copy/paste context menu is coming
> from
On 3 February 2010 13:40, Dave Page wrote:
> On Wed, Feb 3, 2010 at 12:30 PM, Thom Brown wrote:
>> On 3 February 2010 12:22, Dave Page wrote:
>>>
>>> Setting the background colour isn't the issue, it's adding an icon to
>>> indicate the sort direc
On 3 February 2010 12:22, Dave Page wrote:
>
> Setting the background colour isn't the issue, it's adding an icon to
> indicate the sort direction which is the most valuable indicator imho.
>
Yes, and when you pointed out that I could right-click a cell and
select sorting options there, I found t
On 3 February 2010 12:00, Dave Page wrote:
> On Wed, Feb 3, 2010 at 11:58 AM, Thom Brown wrote:
> > On 3 February 2010 11:57, Dave Page wrote:
> >>
> >> On Wed, Feb 3, 2010 at 11:46 AM, Thom Brown
> wrote:
> >> > Hi,
> >> >
> >>
On 3 February 2010 11:57, Dave Page wrote:
> On Wed, Feb 3, 2010 at 11:46 AM, Thom Brown wrote:
> > Hi,
> >
> > Currently on pgAdmin III, to sort a column in the Edit data screen, you
> have
> > to click on the filter icon (or select Sort / Filter from the Tools
Hi,
Currently on pgAdmin III, to sort a column in the Edit data screen, you have
to click on the filter icon (or select Sort / Filter from the Tools menu)
and define sorts in there. What I'd like to be able to do is have something
like the following when right-clicking on a column heading:
Sort
2009/12/10 Florent THOMAS
> Hello,
>
> I would like to know if there's a function that allows to insert values in
> table using a csv file?
>
> Best regards
>
You can use the COPY command for that:
http://www.postgresql.org/docs/8.4/interactive/sql-copy.html
Regards
Thom
2009/11/18 Raymond O'Donnell :
> On 18/11/2009 17:20, Thom Brown wrote:
>> Where can I find a list of aggregate funtions? I can't find them
>> anywhere. I'm using v1.10.0. This page says it's supported:
>> http://pgadmin.org/features.php
>
> I thi
Where can I find a list of aggregate funtions? I can't find them
anywhere. I'm using v1.10.0. This page says it's supported:
http://pgadmin.org/features.php
Thanks
Thom
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.
2009/10/27 Alain MATHIEU
> Hi,
>
> I get the message "ERROR: unrecognized configuration parameter
> "shared_preload_libraries" when attempting to open the triggers node.
> I am working on Mac OS X 10.5.8.
> I use pgAdmin3 V 1.10.0 (Jun 27 2009, rev: 7948).
>
>
>
I believe this is a known issue an
It depends which operating system you want it for.
Windows: http://pgadmin.org/download/windows.php
Mac OSX: http://pgadmin.org/download/macosx.php
OpenSuse: http://pgadmin.org/download/opensuse.php
RPM, Slackware and Solaris aren't available as version 1.10 on the site yet,
but you can compile i
2009/10/6 Dave Page
>
> The code to implement it in the current dialogues would be quite messy
> I expect. There is a TODO item which has had a little work put into it
> already to replace the main table dialogue and the sub dialogues with
> one 'uber' window - that project should make it easier
I've noticed (at least in pgAdmin III v1.8.4) that I can't create a foreign
key constraint pointing to the table I'm in the process of creating. I can
do it manually though. Here's an example:
CREATE TABLE testtable
(
id serial NOT NULL,
parent_id integer,
CONSTRAINT pk_testtable_id PRIMARY
65 matches
Mail list logo
