Tom - Thanks for the direction. Searched but missed the announcement on eol.
Will try what you suggest. Would be great if under the down load page the
dialog only allowed selection of platform where the rpm’s are available.
Currently when you select version 16 both RHEL 6 and 7 can be selected u
Hello All,
We were having past experience in Oracle and are newly getting moved to
postgres database. In there we have schema which alternately also called as
Users and the super user was sys/system through which the dev team never
login but only DBA does. And DBA used to create some functional us
On 2024-02-16 01:34:01 +0100, Peter J. Holzer wrote:
> On 2024-02-15 16:51:56 -0700, David G. Johnston wrote:
> > What you see with an exact type is what you get, which allows for
> > implementing
> > equality, unlike inexact which requires epsilon checking.
>
> You can check binary fp values for
Sorry braindead. Shouldn’t be doing this on a Saturday.… version 16.2 for
RHEL7.9 x86_64. Original post should say “Version 16.2 binaries for RHEL 7”.
Currently have 14.5 and was looking to upgrade to 16.2. Download repo from site
only has up to 15 and no 16 binaries appear to be in the download
Am Sat, Feb 17, 2024 at 07:25:11PM +0100 schrieb Karsten Hilbert:
> +1 except that I've got use for both parts of the UNION on
> their own (they are both views themselves involving a bunch
> of joins with yet other tables, 4 or 5 each or so ;-)
Just for kicks, attached find the SQL change script
Am Sat, Feb 17, 2024 at 11:54:05AM -0500 schrieb Greg Sabino Mullane:
> > There will be a view giving rows for
> > each detail row enriched with master table data
> > UNION ALL
> > rows for each master row that does not have any detail row with
> > detail table colu
Adrian Klaver writes:
> On 2/17/24 09:49, Kerr Livingstone wrote:
>> Postgres version 6.2 …
> Yikes.
Indeed. I strongly suspect that the OP actually means 16.2.
> I believe you are looking at downloading the source:
Yeah, it's clear from
https://yum.postgresql.org/packages/
that Devrim has
Am Sat, Feb 17, 2024 at 09:33:11AM -0700 schrieb Rob Sargent:
> > So, is this doable within one SQL statement (short of
> > creating and running the abovementioned function in
> > one go ;-) ?
> >
>
> Perhaps your pk_detail can be defined as generated always identity?
Rob, I'm sure there's someth
Am Sat, Feb 17, 2024 at 08:55:57AM -0800 schrieb Adrian Klaver:
> >Dear list members,
> >
>
> >So, is this doable within one SQL statement (short of
> >creating and running the abovementioned function in
> >one go ;-) ?
>
> Don't know what version of Postgres you are on, assuming 15+ then maybe?:
On 2/17/24 09:49, Kerr Livingstone wrote:
Postgres version 6.2 …
Yikes.
As far as the archived versions:
https://yum.postgresql.org/repopackages/#pgredhatoldrepos
go back is 7.3.
I believe you are looking at downloading the source:
https://www.postgresql.org/ftp/source/v6.2/
and building
Postgres version 6.2 …
Sent from my iPhone
> On Feb 17, 2024, at 09:46, Adrian Klaver wrote:
>
> On 2/17/24 08:36, Kerr Livingstone wrote:
>> Are there version 6 binaries being generated for RHEL 7 ? The download page
>> indicates they should be there but the repo does not have a version 6 en
On Wed, Feb 14, 2024 at 7:43 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wednesday, February 14, 2024, Adam Fletcher
> wrote:
>>
>>
>> Is it possible to get the parameterized prepared query inside an FDW such
>> that it can be prepared/bind'd/execute'd on the receiving end of t
On 2/17/24 07:24, Karsten Hilbert wrote:
Dear list members,
So, is this doable within one SQL statement (short of
creating and running the abovementioned function in
one go ;-) ?
Don't know what version of Postgres you are on, assuming 15+ then maybe?:
MERGE
https://www.postgresql.org/doc
On Sat, Feb 17, 2024 at 10:24 AM Karsten Hilbert
wrote:
> There will be a view giving rows for
> each detail row enriched with master table data
> UNION ALL
> rows for each master row that does not have any detail row with
> detail table columns NULLed
>
A better
On 2/17/24 08:36, Kerr Livingstone wrote:
Are there version 6 binaries being generated for RHEL 7 ? The download page
indicates they should be there but the repo does not have a version 6 entry and
the download tree has nothing under the 7 directories. Binaries for RHEL 8/9
are there. Updating
Are there version 6 binaries being generated for RHEL 7 ? The download page
indicates they should be there but the repo does not have a version 6 entry and
the download tree has nothing under the 7 directories. Binaries for RHEL 8/9
are there. Updating to RHEL 8 is not currently possible.
Than
> On Feb 17, 2024, at 8:24 AM, Karsten Hilbert wrote:
>
> Dear list members,
>
> maybe I am overlooking something.
>
> PostgreSQL offers UPSERT functionality by way of
>
>INSERT INTO ... ON CONFLICT ... DO UPDATE ...;
>
> Consider this pseudo-code schema
>
>table master
>
Dear list members,
maybe I am overlooking something.
PostgreSQL offers UPSERT functionality by way of
INSERT INTO ... ON CONFLICT ... DO UPDATE ...;
Consider this pseudo-code schema
table master
pk_master serial primary key
value text
;
18 matches
Mail list logo
