Re: PATCH: Support smallserial columns in Edit Data window

From: Sanket Mehta <sanket(dot)mehta(at)enterprisedb(dot)com>
To: "J(dot)F(dot) Oster" <jinfroster(at)mail(dot)ru>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: PATCH: Support smallserial columns in Edit Data window
Date: 2014-10-29 07:22:41
Message-ID: CA+yw=mPFngjqPkBdzmGfTsHOZ7=gO7+ZD0q_4oAgwcf+oGNG0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi J.F.,

Thank you for the explanation.
I have reviewed the patch.
It resolves both issues mentioned in the explanation.

Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Tue, Oct 28, 2014 at 10:16 PM, J.F. Oster <jinfroster(at)mail(dot)ru> wrote:

> Hello Sanket,
>
> Steps to reveal issues:
>
> 1. Prepare test tables:
> CREATE TABLE tserial2 (
> a smallserial NOT NULL,
> dat text,
> CONSTRAINT tserial2_pkey PRIMARY KEY (a)
> );
>
> -- Create these for reference (to compare):
> CREATE TABLE tserial(
> a serial NOT NULL,
> dat text,
> CONSTRAINT tserial_pkey PRIMARY KEY (a)
> );
> CREATE TABLE tserial8(
> a bigserial NOT NULL,
> dat text,
> CONSTRAINT tserial8_pkey PRIMARY KEY (a)
> );
>
> 2. Open Edit data window for tserial2. Bug#1: the header for column "a"
> shows
> datatype "smallint" instead of "smallserial".
>
> 3. Insert one row into tserial2.
>
> 4. Select whole new row by pressing on row header and copy it to
> clipboard (Ctrl-C or with context menu on row header).
>
> 5. Move to last row (*) and Paste into it (Ctrl-V or context menu).
> Bug#2: A confirmation dialog should appear ("This table contains
> serial ..."), but it doesn't.
>
>
> Tuesday, October 28, 2014, 1:27:29 PM, you wrote:
>
>
> SM> Can you please explain in which case it will create issue if bug is
> not applied?
>
>
> SM> On Mon, Oct 27, 2014 at 4:14 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> SM> Ashesh, can you review/commit this please?
>
> SM> On Fri, Oct 24, 2014 at 8:12 PM, J.F. Oster <jinfroster(at)mail(dot)ru>
> wrote:
> >> Hello!
> >>
> >> This patch adds a few missing lines of code to handle smallserial
> >> columns the same way as serial and bigserial.
> >>
>
> --
> Best regards,
> J.F.
>
>

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Ashesh Vashi 2014-10-30 05:32:09 pgAdmin III commit: Clear the Undo/Redo history, when a file is opened
Previous Message Mads Jensen 2014-10-28 20:15:30 Completion