t-some
https://www.reddit.com/r/SQL/comments/15x97kw/sql_is_there_a_way_to_just_exclude_1_column_in/
Best regards
Erki Eessaar
Eessaar
From: jian he
Sent: Saturday, October 28, 2023 13:38
To: Erki Eessaar
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Issues with Information_schema.views
On Sat, Oct 28, 2023 at 5:27 PM Erki Eessaar wrote:
>
> Hello
>
>
> /*After that: i
or. However, I still cannot change the data in the database
through the views.
2. is_updatable=YES only after I add both UPDATE and DELETE DO INSTEAD NOTHING
rules.
My question is: are 1 and 2 the expected behaviour or is there a mistake in the
implementation of the information_schema view?
Best regards
Erki Eessaar
, it is not a "feature", it is a bug.
By the way, my small applications use domain NOT NULL constraints. This was the
reason why I asked are there any other examples in addition to those that I
provided that allow NULL's to NOT NULL columns.
Best regar
g a domain as a type (which it is not) and
sometimes treating NULL as a value (which it is not).
Best regards
Erki Eessaar
g, then it would mean that
systems actually rely on this constraint.
Best regards
Erki Eessaar
From: Tom Lane
Sent: Friday, October 13, 2023 08:37
To: Vik Fearing
Cc: Erki Eessaar ; pgsql-hackers@lists.postgresql.org
Subject: Re: PostgreSQL domains and NOT NULL
be that Oracle can
but PostgreSQL cannot.
Best regards
Erki Eessaar
The scenario that I tested both in PostgreSQL (16) and Oracle (23c).
***
/*PostgreSQL 16*/
CREATE DOMAIN d_name VARCHAR(50) NOT NULL;
CREATE TABLE Product_state_type (product_state_type_code SM
