Re: Why mention to Oracle ?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Why mention to Oracle ?
Date: 2024-09-20 16:18:13
Message-ID: CAKFQuwaMemdvcyA+QNtb5t6TDdbDEAW03wB7ES4k0r9ZZTBB+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Sep 20, 2024 at 5:37 AM Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> wrote:

> Why PostgreSQL DOCs needs to show or compare the Oracle way of doing
> things ?
>
> I understand that on page Porting from Oracle PL/SQL is ok to mention
> Oracle, but there are other places where it's not needed. Or, if it's ok to
> mention, why not mention SQL Server or MySQL or any other ?
>

It would be a boon to the community if someone were to put together a
web/wiki page or mini-app that details this kind of information and, if
considered accurate and relevant enough by the community, link to that more
globally while also remove the random and incomplete references of this
nature from the main documentation. As it stands the info is at least
relevant, and its incompleteness doesn't cause enough grief, IMO, to
warrant its outright removal absent there existing an alternative.

> Bug Reporting Guidelines
> Especially refrain from merely saying that “This is not what SQL
> says/Oracle does.”
>

I would agree that this admonishment be re-worded. I suggest:

If referencing some external authority, like the SQL Standard or another
relational database product, mention it, but also include the literal
output values.

David J.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2024-09-20 16:19:32 Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica.
Previous Message Nathan Bossart 2024-09-20 16:09:51 Re: Should rolpassword be toastable?