Thread: pgAdmin4 1.0-beta3 - Cannot set "Primary key / Not NULL" on column in "The Table Dialog"

Hi,

I cannot set "Primary key / Not NULL" in "The Table Dialog". I see
"Error saving properties: INTERNAL SERVER ERROR - 'cltype'"

How to reproduce?

1. Create table
    CREATE TABLE test (
        id serial,
        txt text not null
    )
2. In sidebar, right click on "test" table and select "Properties"
3. Select "Columns"
4. Set "Primary key" to "Yes" on "id" column
5. Press "Save" button
6. "Error saving properties: INTERNAL SERVER ERROR - 'cltype'"
7. Go to point 4 and try with "Not NULL" field - the same error message

Tested on: Pgadmin4 1.0-beta3, Windows 7 x64, Server: PostgreSQL 9.5.3
on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
4.8.5-4), 64-bit


Regards,
Krzysztof Otręba

<p dir="ltr">Hi Krzysztof,<p dir="ltr">We've made few bug fixes in the same area in last few days, is it possible to
checkit with the latest code (if possible).<p dir="ltr">Harshal,<p dir="ltr">Can you please confirm it has been
fixed?<br/> If not - can you please create an issue in redmine, and work on it.<p dir="ltr">--<br /> Thanks &
Regards,<br/> Ashesh Vashi<div class="gmail_extra"><br /><div class="gmail_quote">On Aug 5, 2016 00:42, "Krzysztof O"
<<ahref="mailto:krzotr@gmail.com">krzotr@gmail.com</a>> wrote:<br type="attribution" /><blockquote class="quote"
style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br /><br /> I cannot set "Primary key / Not
NULL"in "The Table Dialog". I see<br /> "Error saving properties: INTERNAL SERVER ERROR - 'cltype'"<br /><br /> How to
reproduce?<br/><br /> 1. Create table<br />     CREATE TABLE test (<br />         id serial,<br />         txt text not
null<br/>     )<br /> 2. In sidebar, right click on "test" table and select "Properties"<br /> 3. Select "Columns"<br
/>4. Set "Primary key" to "Yes" on "id" column<br /> 5. Press "Save" button<br /> 6. "Error saving properties: INTERNAL
SERVERERROR - 'cltype'"<br /> 7. Go to point 4 and try with "Not NULL" field - the same error message<br /><br />
Testedon: Pgadmin4 1.0-beta3, Windows 7 x64, Server: PostgreSQL 9.5.3<br /> on x86_64-pc-linux-gnu, compiled by gcc
(GCC)4.8.5 20150623 (Red Hat<br /> 4.8.5-4), 64-bit<br /><br /><br /> Regards,<br /> Krzysztof Otręba<br /><br /><br />
--<br/> Sent via pgadmin-support mailing list (<a
href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.<wbr/>org</a>)<br /> To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgadmin-support" rel="noreferrer"
target="_blank">http://www.postgresql.org/<wbr/>mailpref/pgadmin-support</a><br /><br /></blockquote></div><br /></div> 

Hi,

Yesterday I tested Primary Key / Not Null bug on Fedora 24 x64
(Postgresql 9.2, 9.3. 9.5) with the latest code from GIT.

Everything is working, I can set PP / NN correctly - no errors.

Bug has been fixed.


Regards,
Krzysztof Otręba

2016-08-05 3:44 GMT+02:00 Ashesh Vashi <ashesh.vashi@enterprisedb.com>:
> Hi Krzysztof,
>
> We've made few bug fixes in the same area in last few days, is it possible
> to check it with the latest code (if possible).
>
> Harshal,
>
> Can you please confirm it has been fixed?
> If not - can you please create an issue in redmine, and work on it.
>
> --
> Thanks & Regards,
> Ashesh Vashi
>
>
> On Aug 5, 2016 00:42, "Krzysztof O" <krzotr@gmail.com> wrote:
>
> Hi,
>
> I cannot set "Primary key / Not NULL" in "The Table Dialog". I see
> "Error saving properties: INTERNAL SERVER ERROR - 'cltype'"
>
> How to reproduce?
>
> 1. Create table
>     CREATE TABLE test (
>         id serial,
>         txt text not null
>     )
> 2. In sidebar, right click on "test" table and select "Properties"
> 3. Select "Columns"
> 4. Set "Primary key" to "Yes" on "id" column
> 5. Press "Save" button
> 6. "Error saving properties: INTERNAL SERVER ERROR - 'cltype'"
> 7. Go to point 4 and try with "Not NULL" field - the same error message
>
> Tested on: Pgadmin4 1.0-beta3, Windows 7 x64, Server: PostgreSQL 9.5.3
> on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
> 4.8.5-4), 64-bit
>
>
> Regards,
> Krzysztof Otręba
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
>