https://bugs.documentfoundation.org/show_bug.cgi?id=153431

--- Comment #7 from Alex Thurgood <[email protected]> ---
(In reply to Robert Großkopf from comment #6)


> Where did you get the information it has been changed to character varying
> (100)? I get the information it is "TEXT" when opening the table for editing
> in dBeaver.

>From a postgres console session, using 

\d "TABLENAME"


I tried to create a new table via the LO GUI, and chose MEMO (text) when
defining the character field, with an ID INT (4) field as the NON NULL PK.

When I query the table definition from the console, I get :

\d "Pets"
                Table "public.Pets"
 Column |  Type   | Collation | Nullable | Default 
--------+---------+-----------+----------+---------
 ID     | integer |           | not null | 
 Pet    | text    |           |          | 
Indexes:
    "Pets_pkey" PRIMARY KEY, btree ("ID")




I still can't reproduce the problem.

Could this be a difference between PG10 and PG13 ?

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to