public inbox for [email protected]  

help / color / mirror / Atom feed

From: Stuart Campbell <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: Unexpected modification of check constraint definition
Date: Thu, 8 Jan 2026 08:59:52 +1100
Message-ID: <CAAZ6SnweFKohrh9UecMLUtR7CJ5d=qNfjbfPyAJD_-b5O1XM8A@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAAZ6SnzFLQzraWws7_ZKjGtJ+XNK+Hz9DStGbEPzzHKjUXqELQ@mail.gmail.com>
	<[email protected]>

On Thu, Jan 8, 2026 at 2:24 AM Adrian Klaver <[email protected]>
wrote:

> https://www.postgresql.org/docs/current/datatype-character.html
>
> "text is PostgreSQL's native string data type, in that most built-in
> functions operating on strings are declared to take or return text not
> character varying. For many purposes, character varying acts as though
> it were a domain over text."


Thanks. It seems like I should generally prefer to use text over varchar.
(I've read advice along those lines elsewhere.)


> When you did the dump/restore cycles where they from and to the same
> Postgres version/instance?


Yes. In the example I provided, that was all from the same Postgres 16.4
instance.

Regards,
Stuart

-- 
This communication and any attachments may contain confidential information 
and are intended to be viewed only by the intended recipients. If you have 
received this message in error, please notify the sender immediately by 
replying to the original message and then delete all copies of the email 
from your systems.

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Unexpected modification of check constraint definition
  In-Reply-To: <CAAZ6SnweFKohrh9UecMLUtR7CJ5d=qNfjbfPyAJD_-b5O1XM8A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox