[pgadmin-support] Query editor broken feature in 1.4.1

On Windows, in the query editor the drop down with the active connection no longer brings up the dialog window to select a different database when selecting . Thanks, Laurent ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

[pgadmin-support] Positioning the panes

Hi, I can't position the 3 windows panes in the main window like I'd like to. In 1.4.3 I had the object browser on the left ocuppying 1/3 width and 100% vertical. The other 2/3 are split vertically between the properties and the SQL pane. Try to drag the panes around and see if you can get them t

Re: [pgadmin-support] Positioning the panes

- Drag the object explorer to the left so it fills the left-side This is on Windows XP anyway! Andy. Laurent Yaish wrote: > Hi, > > I can't position the 3 windows panes in the main window like I'd like to. > In 1.4.3 I had the object browser on the left ocuppying 1/3 wi

[pgadmin-support] Error occured on 1.8.0-beta3

upon connecting to the database I get: An error has occured: ERROR: syntax error at or near "pg_get_userbyid" LINE 1: ... T ts.oid, spcname, spclocation, " AS secription pg_get_use... I am running postgresql 8.1.2 on redhat Let me know if you need more info

Re: [pgadmin-support] ERROR: duplicate key violates unique constraint "client_alerts_PK"

Hi Rob, In your insert, do not explicitly specify a value for the primary key, instead use NEXTVAL('client_alerts_seq') which will return the next valid value and increment the sequence. i.e: insert into clients_alerts (id, client_id, alert_message, alert_complete, date, staff_id) values(NEXTVAL

Re: [pgadmin-support] restoring a backup and maintaining dependencies?

There is no difference between running this script and using the pgadmin gui. pgadmin is just a front end to the database, it generates the same sql that you would write manually. If your table is group_items, name your sequence group_items_seq Laurent On 9/12/07, Robert Starr <[EMAIL PROTECTED]

Re: [pgadmin-support] ERROR: duplicate key violates unique constraint "client_alerts_PK"

my bad... I missed the post about the default value.. On 9/12/07, Guillaume Lelarge <[EMAIL PROTECTED]> wrote: > Laurent Yaish a écrit : > > Hi Rob, > > > > In your insert, do not explicitly specify a value for the primary key, > > instead use NEXTVAL('cli

[pgadmin-support] Keyboard bindings on OS X for pgadmin 1.8.2

Hey folks, Would it be possible to change the pgAdmin keyboard shortcuts for OS X to make use of common Mac shorcuts? Some examples: - in the Query window, Cmd + arrow would be great instead of the current Fn + arrow to navigate to beggining or end of a line/document - Cmd + w to close a window I

[pgadmin-support] Database COMMENT in pgAdmin III v1.10.0 RC1

Hi, v1.10.0 RC1 does not display database comments in the SQL pane or in the properties window using postgresql 8.1.9 The comment is displayed fine using pgadmin v1.8.4 Thanks, Laurent -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscriptio

Re: [pgadmin-support] Database COMMENT in pgAdmin III v1.10.0 RC1

On Sat, Jun 27, 2009 at 11:18 AM, Dave Page wrote: > On Thu, Jun 25, 2009 at 5:25 PM, Laurent > Yaish wrote: >> Hi, >> >> v1.10.0 RC1 does not display database comments in the SQL pane or in >> the properties window using postgresql 8.1.9 >> The comment is