Hi!
On Wed, Oct 27, 2021 at 3:56 AM Michael Lewis wrote:
> If you end up with no rows changing from an insert or delete, something seems
> awry. Unless you mean 0 rows affected.
Isn't this the same? Isn't the number of rows affected the same as the
number of rows changing? For example:
DELETE
Mitar schrieb am 26.10.2021 um 09:05:
> I would like to test inside trigger_function if the table really
> changed. I have tried to do:
>
> PERFORM * FROM ((TABLE old_table EXCEPT TABLE new_table) UNION ALL
> (TABLE new_table EXCEPT TABLE old_table)) AS differences LIMIT 1;
> IF FOUND THEN
> ...
On Wed, Oct 27, 2021 at 11:49 AM Julien Rouhaud wrote:
>
>
> Most likely you had a different version of the glibc or ICU libraries
> on the new system, which lead to your indexes on collatable datatypes
> partially corrupted. See https://wiki.postgresql.org/wiki/Collations
> for more details.
>
>
> Oh, very interesting. I thought that this is not possible because WHEN
> condition on triggers does not have NEW and OLD. But this is a very
> cool way to combine rules with triggers, where a rule can still
> operate by row.
>
> That is not true
create table test(i integer);
create function te
Hi,
I hope this is the correct place for this question.
I'm trying to restore a database where adding foreign key constraints takes
most of the time. Does there exist a simple way to make either pg_dump or
pg_restore handle them as "not valid", and defer the validation.
--
Eld på åren og sol p
On Sat, Oct 23, 2021 at 10:40 PM Adrian Klaver
wrote:
> On 10/23/21 13:00, Дмитрий Иванов wrote:
> > Да.
> > Python extension issues occurred on Windows Server 2012 and Windows 10
> > Pro. Experimentally, when installing version 3.7.4, everything worked.
>
> If you used the EDB installer for the
Tore Halvorsen writes:
> I'm trying to restore a database where adding foreign key constraints takes
> most of the time. Does there exist a simple way to make either pg_dump or
> pg_restore handle them as "not valid", and defer the validation.
No. It's kind of a neat idea perhaps, but it's not t
That would be appending it for "pg_catalog.pg_get_constraintdef(oid) AS
condef" in getConstraints in pg_dump.c?
On Wed, Oct 27, 2021 at 3:27 PM Tom Lane wrote:
> Tore Halvorsen writes:
> > I'm trying to restore a database where adding foreign key constraints
> takes
> > most of the time. Does
Tore Halvorsen writes:
> That would be appending it for "pg_catalog.pg_get_constraintdef(oid) AS
> condef" in getConstraints in pg_dump.c?
No, you want to mess with the text printed by dumpConstraint().
regards, tom lane
Hi!
On Wed, Oct 27, 2021 at 12:56 PM Marcos Pegoraro wrote:
>> Oh, very interesting. I thought that this is not possible because WHEN
>> condition on triggers does not have NEW and OLD. But this is a very
>> cool way to combine rules with triggers, where a rule can still
>> operate by row.
>
> Th
Then I'll try that, thank you :)
On Wed, Oct 27, 2021 at 4:04 PM Tom Lane wrote:
> Tore Halvorsen writes:
> > That would be appending it for "pg_catalog.pg_get_constraintdef(oid) AS
> > condef" in getConstraints in pg_dump.c?
>
> No, you want to mess with the text printed by dumpConstraint().
On Wed, 2021-10-27 at 11:21 +1300, Lucas wrote:
> The snapshots are done this way:
> 1. Grab the latest applied WAL File for further references, stores that in a
> variable in Bash
> 2. Stop the Postgres process
> 3. Check it is stopped
> 4. Start the Block level EBS Snapshot process
> 5. Applied
Hi,
After experiencing issues related to the existence of two different
PostgreSQL versions installed on the same machine, I decided to do a
"remove --purge postgresql*" and reinstall postgresql-13. Now the output
of "psql --version" is "psql (PostgreSQL) 13.4 (Ubuntu 13.4-1)".
However, tryin
On 10/27/21 08:51, Jérémy Garniaux wrote:
Hi,
After experiencing issues related to the existence of two different
PostgreSQL versions installed on the same machine, I decided to do a
"remove --purge postgresql*" and reinstall postgresql-13. Now the output
of "psql --version" is "psql (Postgre
Hi Adrian,
Thanks for answering on both sides!
Le 27/10/2021 à 17:58, Adrian Klaver a écrit :
On 10/27/21 08:51, Jérémy Garniaux wrote:
Hi,
After experiencing issues related to the existence of two different
PostgreSQL versions installed on the same machine, I decided to do a
"remove --purg
Hello,
I'm hoping to get some suggestions on what to do here. I am running PostgreSQL
version 13.2 and am shipping the WAL files to a standby server. Once a day I
restart the standby server and it recovers the new WAL files that have been
shipped to it. Everything was working great until yes
On 10/27/21 9:01 AM, Jérémy Garniaux wrote:
Hi Adrian,
Thanks for answering on both sides!
Same response as to your SO question:
What is the output of pg_lsclusters?
Ver Cluster Port Status Owner Data
directory Log file
12 main 5432 down,binaries_missing
> --- example: lets get 3 sequences
>
> select next_sequence(), next_sequence(), next_sequence();
> --- inspect the table to see what happned
> select * from my_sequence;
Thanks for your input on this issue.
SQLP
Sent with ProtonMail Secure Email.
Hi,
I'm trying to extract text from a jsonb 'string'. Simply casting
gives me the string wrapped in quotes:
foo=# select '"foo"'::jsonb::text;
text
---
"foo"
(1 row)
This, of course, makes kind of sense, since it /is/ the JSON's
textual representation.
What is the canonical wa
Hi,
I'm creating my first ever extension. The function that I'm trying to write
takes the schema and name of a table, and adds it in a table with all the
tables the extension follows.
In that table I want the schema, name and oid of the table.
I created a C function for that. Here is the code
On Wed, Oct 27, 2021 at 12:39 PM Louise Grandjonc
wrote:
> I'm creating my first ever extension. The function that I'm trying to write
> takes the schema and name of a table, and adds it in a table with all the
> tables the extension follows.
> In that table I want the schema, name and oid of th
Adrian,
Le 27/10/2021 à 19:30, Adrian Klaver a écrit :
Your Postgres 13 cluster is up and listening on 5433.
Your choices:
1) Connect using psql -d -U -p 5433
2) Open:
sudo vi /etc/postgresql/13/main/postgresql.conf
and change
port = 5433
to
port = 5432
and then restart server.
Wh
On 10/27/21 12:51, Jérémy Garniaux wrote:
Adrian,
Le 27/10/2021 à 19:30, Adrian Klaver a écrit :
While you are at it:
sudo pg_dropcluster 12 main
to get rid of the orphaned cluster.
Great, thanks for your help. Everything is back in order now.
I found out about Pg clusters in the process
Thank you! I used that. The segmentation fault came from a later code in my
hook. But that helped.
> On Oct 27, 2021, at 12:47 PM, Peter Geoghegan wrote:
>
> On Wed, Oct 27, 2021 at 12:39 PM Louise Grandjonc
> wrote:
>> I'm creating my first ever extension. The function that I'm trying to writ
On Wed, Oct 27, 2021 at 11:58 AM wrote:
>
> I've found out that one can treat a string singleton as if it
> were an array:
>
> foo=# select '"foo"'::jsonb ->> 0;
>?column?
> --
>foo
> (1 row)
>
> which conveniently returns the right type. My question: can I rely
> on that, o
At Wed, 27 Oct 2021 16:42:52 +, "Ryan, Les" wrote in
> 2021-10-27 10:26:31.467 MDT [2012] LOG: redo starts at 419/5229A858
...
> 2021-10-27 10:26:36.188 MDT [2012] LOG: restored log file
> "00010419005A" from archive
> 2021-10-27 10:26:36.750 MDT [2012] LOG: consistent recover
On Thu, Oct 28, 2021 at 7:28 AM Kyotaro Horiguchi
wrote:
>
> At Wed, 27 Oct 2021 16:42:52 +, "Ryan, Les" wrote in
> > 2021-10-27 10:26:31.467 MDT [2012] LOG: redo starts at 419/5229A858
> ...
> > 2021-10-27 10:26:36.188 MDT [2012] LOG: restored log file
> > "00010419005A" from
27 matches
Mail list logo
