I do not want the deleted
records to participate in the constraint logic.
Kindest regards,
Dionisis
On Wed, 26 Jul 2023 at 11:18, Thomas Kellerer wrote:
> Dionisis Kontominas schrieb am 26.07.2023 um 11:00:
> > Hello all,
> >
> > In the Subject I mention what I am intending
Hello all,
In the Subject I mention what I am intending to do. Letme put some
context; this is my table:
portal_user_role
(
f_id INTEGER NOT NULL,
f_portal_user_id INTEGER NOT NULL,
f_portal_role_id INTEGER NOT NULL,
f_is_active BOOLEAN NOT NULL,
f_is_deleted BOOLEAN NOT NUL
wrote:
> Why are you specifying the collation to be "C" when the default db
> encoding
> is UTF8, and UTF-8 has Greek, Chinese and English encodings?
>
> On 2/5/23 17:08, Dionisis Kontominas wrote:
> > Hello all,
> >
> > I have a question regardin
2023 at 01:19, Tom Lane wrote:
> Dionisis Kontominas writes:
> >I suppose that affects the outcome of ORDER BY clauses on the field,
> > along with the content of the indexes. Is this right?
>
> Yeah.
>
> >Assuming that the requirement exists, to store UTF-8
responding suitable Ctype?
Regards,
Dionisis
On Mon, 6 Feb 2023 at 00:24, Tom Lane wrote:
> Dionisis Kontominas writes:
> > Let's say that the definition is for example as follows:
> > name character varying(8) COLLATE pg_catalog."C" NOT NULL
> > and als
uot;C" NOT NULL
and also assume that the database default encoding is UTF8 and also the
Collate and Ctype is "C"". I plan to store strings of various languages in
this field.
Are these the correct settings that I should have used on creation of
the database?.
Thank you in Advanc
code tool/framework is
found then they can be abolished.
Thank you for your response!
On Fri, 21 Oct 2022 at 19:36, Adrian Klaver
wrote:
> On 10/21/22 10:25 AM, Dionisis Kontominas wrote:
> > Hello Adam,
> >
> > Thank you for your response. Regarding the details:
or Redhat Server or other.
2. OLTP applications. Up to 10 - 50 GB database size. The user interface
is Web-based, currently using Oracle APEX, Tomcat+ORDS and Oracle Database
as a back-end.
Thank you for your time!
Kindest regards,
Dionisis Kontominas
On Fri, 21 Oct 2022 at 19:20
like pgREST
or similar / alternative and what are the experiences?
Thanks In advance!
Kindest regards,
Dionisis Kontominas