Hello,
consider the following table, query and error message:
create table t
(
"someColumn" int
);
select t.someColumn
from t;
ERROR: column t.somecolumn does not exist
Hint: Perhaps you meant to reference the column "t.someColumn".
For someone proficient
> t...@sss.pgh.pa.us wrote:
>
>> Bryn wrote:
>>
>> But this invocation makes the assertion fail:
>> call assert_make_ts_from_extracted_fields_from_ts_ok('0001-01-01 00:00:00
>> BC');
>> The 22008 error is reported thus:
>> date field value out of range: -1-01-01
>
> As of v14, make_timestamp[tz
Bryn Llewellyn writes:
> But this invocation makes the assertion fail:
> call assert_make_ts_from_extracted_fields_from_ts_ok('0001-01-01 00:00:00
> BC');
> The 22008 error is reported thus:
> date field value out of range: -1-01-01
As of v14, make_timestamp[tz] will accept negative year values
On 10/6/21 2:59 PM, Bryn Llewellyn wrote:
Everything that I say here applies to "make_timestamptz()", too. But my
code examples need less typing when I use plain "make_timestamp()".
(And sure enough, "raise info 'year: %', year" reports "-1".)
The doc for "make_timestamp()" here:
www.p
Everything that I say here applies to "make_timestamptz()", too. But my code
examples need less typing when I use plain "make_timestamp()".
It would seem to me that ordinary principles of good software design let one
expect that the rule that this procedure tests ought to hold:
create procedure
The engineers rebuilt the pgaudit extension and the issue went away on our end. Note that pgaudit is version specific and would need to be built for each version. I'd suggest if you're having a similar issue to ours that you rebuild pgaudit from source and try again. On Oct 6, 2021 10:06, Allie
it does work well for logical replication.
still its sad that it doesnt work for physical replication as, then, how to
ensure continuous availability for generic apps ??
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Wed, Oct 6, 2021 at 5:03 PM Guillaume Lelarge
wrote:
> Le mer.
On 10/6/21 2:58 AM, Marco Lechner wrote:
Hi,
how to merge two postgresql server instances into one? I have a
postgresql-11 and -12 instance on my server and want to upgrade both
(pg_upgrade?) into one postgresql-14 instance.
The bigger issue will be the merge. Define what that means in this
Troy,
I am running into the same problem where I am not able to deploy the pgaudit
parameter setting into the postgresql.conf file because every time I do that
and restart the postgresql cluster, it is just fail, I cannot get the pgaudit
setting on the postgresql.conf file. Have you find a solu
Le mer. 6 oct. 2021 à 13:46, Thomas Kellerer a écrit :
> Marc Millas schrieb am 06.10.2021 um 13:43:
> > on release 10, I remember reading something like: streaming replication
> is NOW upward compatible.
> > which could be understood as: its possible to have a master in rel 10
> and a slave in
Hi,
Just want to say THANK YOU all (Robert Haas, Vik Fearing, ..) for these feature
I just discover available since 9.6 !
although I am still in version 9.5
Philippe
On Wed, Oct 6, 2021 at 11:40 AM Daniel Gustafsson wrote:
> > On 6 Oct 2021, at 12:22, Laurenz Albe wrote:
> >
> > On Wed, 2021-10-06 at 10:44 +0100, Joao Miguel Ferreira wrote:
> >> I would like to try that yes, it would be a pleasure but I have zero
> knowledge on the dev tools, setups and proc
Marc Millas schrieb am 06.10.2021 um 13:43:
> on release 10, I remember reading something like: streaming replication is
> NOW upward compatible.
> which could be understood as: its possible to have a master in rel 10 and a
> slave in rel 11.
No, that's not possible.
For streaming replication
Hi,
on release 10, I remember reading something like: streaming replication is
NOW upward compatible.
which could be understood as: its possible to have a master in rel 10 and a
slave in rel 11.
Can someone confirm (or not !) this ?
if true, is the following scheme possible:
a master and a slav
> On 6 Oct 2021, at 12:22, Laurenz Albe wrote:
>
> On Wed, 2021-10-06 at 10:44 +0100, Joao Miguel Ferreira wrote:
>> I would like to try that yes, it would be a pleasure but I have zero
>> knowledge on the dev tools, setups and processes required for that.
>>
>> If someone gives me some pointe
On Wed, 2021-10-06 at 10:44 +0100, Joao Miguel Ferreira wrote:
> I would like to try that yes, it would be a pleasure but I have zero
> knowledge on the dev tools, setups and processes required for that.
>
> If someone gives me some pointers I would love to try it. I'm a software
> developer so
Hi,
how to merge two postgresql server instances into one? I have a postgresql-11
and -12 instance on my server and want to upgrade both (pg_upgrade?) into one
postgresql-14 instance.
The postgresql-14 instance does not exist yet (fresh install of postgresql-14
server packages). Using pg_upgrad
On Wed, Oct 6, 2021 at 10:33 AM Daniel Gustafsson wrote:
> > On 3 Oct 2021, at 18:56, Joao Miguel Ferreira <
> joao.miguel.c.ferre...@gmail.com> wrote:
>
> > is there a way to ask pg_dump to save a comment in the output file with
> the full command it is executing ?
>
> I think this idea has some
> On 3 Oct 2021, at 18:56, Joao Miguel Ferreira
> wrote:
> is there a way to ask pg_dump to save a comment in the output file with the
> full command it is executing ?
I think this idea has some merit. Given the amount of switches for tailoring
the dump that pg_dump has there is a point to kn
19 matches
Mail list logo
