pgAdmin data grid editing date or time values

From: "Paul Hughes" <paul(at)dependable-software(dot)com(dot)au>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin data grid editing date or time values
Date: 2010-05-18 04:34:28
Message-ID: 000201caf643$67a0beb0$36e23c10$@com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

I'm running pgAdmin1.12.0 beta (on XP Pro SP3) against PostgreSQL 9.0 beta 1
server (on Vista Business Server).

Pressing the Delete key in the edit grid with a date or time field value
selected always causes pgAdmin to crash.

To reproduce, run the following script:

DROP TABLE IF EXISTS test_me;
CREATE TABLE test_me
(
jobid integer NOT NULL,
jobdate date NOT NULL,
starttime time without time zone NOT NULL,
CONSTRAINT "ixjobid" PRIMARY KEY (jobid)
);
INSERT INTO test_me(jobid, jobdate, starttime) VALUES (1, '2010-05-01',
'08:30:00');
INSERT INTO test_me(jobid, jobdate, starttime) VALUES (2, '2010-05-05',
'15:30:00');
INSERT INTO test_me(jobid, jobdate, starttime) VALUES (3, '2010-05-10',
'15:00:00');
INSERT INTO test_me(jobid, jobdate, starttime) VALUES (4, '2010-05-30',
'10:00:00');

Highlight the table in pgAdmin and click the edit grid button.
In the edit gridr, click in one of the date or time cells to highlight the
cell.
Click again to put the highlighted cell into edit mode (so it shows the
current value as selected text).
Press delete (this causes the crash).

I have also encountered random crashes whilst editing date and or time
values without pressing delete but I've been unable to reproduce these
reliably.

Regards, Paul Hughes.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2010-05-18 20:25:08 Re: pgAdmin data grid editing date or time values
Previous Message Richard Broersma 2010-05-14 20:47:43 Re: reporting feature request