Hi,
Sorry for late reply, I think you will having some script that drops and
creates daily partitions etc, command for disabling/removing any constraint
can be placed before these statements so that when the script runs it does
the needful.
Regards,
Muhammad Ikram
Bitnine global
On Tue, Jul 2,
On Tuesday, July 2, 2024, Stuart Campbell
wrote:
> This is a question for AWS. Community PostgreSQL doesn't have any of
>> these concepts, and this is all proprietary modifications to PostgreSQL by
>> Amazon.
>
>
> Maybe my question can be re-summarised as: do DDL operations on temporary
> table
> On Jul 2, 2024, at 18:16, Stuart Campbell
> wrote:
>
> My understanding was that under the hood, AWS uses the logical replication
> features that are present in community Postgres. If that's incorrect then I'm
> sorry for the off-topic post.
Yes, but: The idea of a "degraded" replication
>
> This is a question for AWS. Community PostgreSQL doesn't have any of
> these concepts, and this is all proprietary modifications to PostgreSQL by
> Amazon.
My understanding was that under the hood, AWS uses the logical replication
features that are present in community Postgres. If that's in
> On Jul 2, 2024, at 17:47, Stuart Campbell
> wrote:
> My question is whether there is some workaround that will let me create
> indexes on a temporary table, and also let me drop the temporary table, in a
> way that doesn't end up "degrading" replication? (Presumably that means
> avoiding
Hello,
I'm trying to use a blue/green deployment in Amazon RDS, which uses
Postgres logical replication to keep blue and green environments in sync.
Some parts of our app use temporary tables, and in some cases we CREATE
INDEX on those tables and sometimes DROP and recreate them.
The CREATE INDE
> On Jul 2, 2024, at 15:11, Rich Shepard wrote:
> This data set is the
> only one I've encountered that has a very few multiple email addresses for a
> person.
That's pretty common out in the world. Just pulling a small dataset I have
available, 4+ email addresses per customer happen frequen
On Tue, 2 Jul 2024, Christophe Pettus wrote:
To be clear, I wasn't suggesting stuffing them all into a text column with
a delimiter, but storing them in a text *array* field, each email address
one component of the array.
Okay. I've not before done that and will learn how. This data set is the
> On Jul 2, 2024, at 14:57, Rich Shepard wrote:
> Using text rather than varchar() is a good suggestion.
To be clear, I wasn't suggesting stuffing them all into a text column with a
delimiter, but storing them in a text *array* field, each email address one
component of the array.
On Tue, 2 Jul 2024, Christophe Pettus wrote:
If you are absolutely 100% sure there will never be any metadata
associated with each email address (like a "valid" flag), you can use
TEXT[] array to store them. Otherwise, it's best to move them into a table
with a foreign key back to the owning rec
> On Jul 2, 2024, at 14:47, Rich Shepard wrote:
> Is there a way
> to accommodate multiple email addresses other than entering both with a
> forward slash separating them in the varchar(64) email address column?
If you are absolutely 100% sure there will never be any metadata associated
with
In data made available from a state regulatory agency I find a few instances
where a facility contact has two email addresses. While multiple locations
are accommodated because they're in a table separate from the facility name
and details, all people associated with a facility and location are in
On Tue, 2 Jul, 2024, 12:43 pm Muhammad Ikram, wrote:
> Hi Yudhi,
>
> I think disabling foreign keys before maintenance will help.
>
> --
> Muhammad Ikram
>
Do you mean to say call the parent table first for maintenance followed by
child, and remove all the foreign key first which are pointing to
Hi Yudhi,
I think disabling foreign keys before maintenance will help.
Regards,
Muhammad Ikram
Bitnine global
On Tue, Jul 2, 2024 at 11:41 AM yudhi s wrote:
> Hello All,
> In postgres we are seeing issues during automatic partition maintenance
> using pg_partman extension. So basically it auto
14 matches
Mail list logo
