6 ms·

PostgreSQL 10.2 Released

139 points by Elect2 9y ago

mberger 9y ago
From the release notes: >Fix sample INSTR() functions used to help transition from Oracle(r) PL/SQL to PostgreSQL PL/pgSQL to correctly match Oracle functional behavior TIL PL/pgSQL exists so I googled it. In the page for porting from Oracle PL/SQL: >Instead of packages, use schemas to organize your functions into groups. Does anyone know if there are plans to introduce packages in Postgres? Doesn't putting function in different schemas mean you have to grant select/update permissions to the schemas that talk to other schemas? *edit:formatting
- pritambaral 9y ago
  > Doesn't putting function in different schemas mean you have to grant select/update permissions to the schemas that talk to other schemas? In Pg, schemas don't talk to schemas. When a function is run, it runs with the privilege level of either the user that called it, or the user that defined it.
jlmorton 9y ago
> Please note that PostgreSQL changed its versioning scheme with the release of version 10.0, so updating to version 10.2 from 10.0 or 10.1 is considered a minor update. While this looks like an important update, note that it's not a new feature release.
- stingraycharles 9y ago
  Hmm I'm a bit confused. Why did they decide to do this ?
  - grzm 9y ago
    Largely because the previous version numbering was sometimes confusing for the opposite reason: Postgres "major" releases were sometimes interpreted as point releases. For example, 9.1 to 9.2 was major version jump. While that was understood by those who already understood the versioning scheme, it was often confusing to those outside the community. Josh Berkus discusses this here: http://www.databasesoup.com/2016/05/changing-postgresql-version-numbering.html http://www.databasesoup.com/2016/05/changing-postgresql-vers...
piinbinary 9y ago
> Spinlock fixes and support for Motorola 68K and 88K architectures I'm astounded that they support those architectures
- anarazel 9y ago
  > I'm astounded that they support those architectures I work on PG, and I'm regularly astounded too... As long as the compilers are new enough, the burden isn't too high though. Previously it prevented us from using atomics for some concurrency optimized things, but now we've an atomics implementation that, at compile time, falls back to a spinlock backed atomics implementation. Slightly complicated by the fact that we don't even have a hard dep on a spinlock implementation, falling back to semaphores :) Ah. Fun. But seriously, the thing that hurts more is that we only require a C89 compiler :/
  - pritambaral 9y ago
    > But seriously, the thing that hurts more is that we only require a C89 compiler :/ Indeed. For a glimpse for the non-PG-hackers (like me), there's an ongoing attempt discussed in the PG-hackers mailing list to use stdbool.h.
    - wahern 9y ago
      That can be tricky because you can't emulate the semantics of the C99 bool type. In C99 (bool)256 == 1 but on systems which emulate bool with, e.g., an 8-bit unsigned char then (bool)256 == 0
      - petereisentraut 9y ago
        Another problem is that the bool provided by stdbool.h is 4 bytes on some platforms, which breaks PostgreSQL all over the place.
- collyw 9y ago
  What uses those these days?
nileshtrivedi 9y ago
I'd like to see updated versions of PL/v8 ship. The situation with building v8 is so bad ( https://github.com/plv8/plv8/issues/251#issuecomment-364541059 https://github.com/plv8/plv8/issues/251#issuecomment-3645410... ), that almost the entire cloud infrastructure (AWS, Heroku, Docker) is stuck with an ancient version of PL/v8.
- bdcravens 9y ago
  AWS only goes up to 9.6.5 - I don't know that PL/v8 is the reason for that.
- chillax2 9y ago
  The solution is to fire whoever convinced you that javascript belongs in your database.
  - nileshtrivedi 9y ago
    Pl/v8 is at least safer than PL/Python due to being properly sandboxed ;-)
chinhodado 9y ago
It's a shame that Postgres 10 still ships with the abomination that is pgAdmin 4. You don't have a lot of other choices either (the pgAdmin 3 LTS version still throws error left and right when connection to a postgres 10 DB)
- grzm 9y ago
  This is package specific. pgAdmin is a separate project. There are other tools out there (there is a recent Show HN thread for a macOS client and the comments include other tools), though to be honest I use psql almost exclusively, so I'm not one to ask for recommendations.
- petereisentraut 9y ago
  Try OmniDB perhaps? (disclaimer: my employer (but open source))
- tpkj 9y ago
  Agreed. Tried pgAdmin 4, and it's not a happy user experience. Reverting back to pgAdmin 3 gives errors, depending on what you attempt to do. I have Navicat, and some features are good, yet some are frustrating. Postgres needs a "gold standard" ux tool. Maybe there is one, but I have not used it before.
- petagonoral 9y ago
  dbeaver is free & can connect to multiple db types. (have used it with postgres as i agree that pgAdmin 4 is v. bad interface)
- dvdgsng 9y ago
  BigSQL offers a LTS version of pgAdmin 3 that supports PostgreSQL 10: https://www.openscg.com/bigsql/pgadmin3/ https://www.openscg.com/bigsql/pgadmin3/ DBeaver is another great alternative.

139 points by Elect2 9y ago

From the release notes: >Fix sample INSTR() functions used to help transition from Oracle(r) PL/SQL to PostgreSQL PL/pgSQL to correctly match Oracle functional behavior TIL PL/pgSQL exists so I googled it. In the page for porting from Oracle PL/SQL: >Instead of packages, use schemas to organize your functions into groups. Does anyone know if there are plans to introduce packages in Postgres? Doesn't putting function in different schemas mean you have to grant select/update permissions to the schemas that talk to other schemas? *edit:formatting

pritambaral 9y ago
> Doesn't putting function in different schemas mean you have to grant select/update permissions to the schemas that talk to other schemas? In Pg, schemas don't talk to schemas. When a function is run, it runs with the privilege level of either the user that called it, or the user that defined it.

jlmorton 9y ago

> Please note that PostgreSQL changed its versioning scheme with the release of version 10.0, so updating to version 10.2 from 10.0 or 10.1 is considered a minor update. While this looks like an important update, note that it's not a new feature release.

stingraycharles 9y ago
Hmm I'm a bit confused. Why did they decide to do this ?
- grzm 9y ago
  Largely because the previous version numbering was sometimes confusing for the opposite reason: Postgres "major" releases were sometimes interpreted as point releases. For example, 9.1 to 9.2 was major version jump. While that was understood by those who already understood the versioning scheme, it was often confusing to those outside the community. Josh Berkus discusses this here: http://www.databasesoup.com/2016/05/changing-postgresql-version-numbering.html http://www.databasesoup.com/2016/05/changing-postgresql-vers...

piinbinary 9y ago

> Spinlock fixes and support for Motorola 68K and 88K architectures I'm astounded that they support those architectures

anarazel 9y ago
> I'm astounded that they support those architectures I work on PG, and I'm regularly astounded too... As long as the compilers are new enough, the burden isn't too high though. Previously it prevented us from using atomics for some concurrency optimized things, but now we've an atomics implementation that, at compile time, falls back to a spinlock backed atomics implementation. Slightly complicated by the fact that we don't even have a hard dep on a spinlock implementation, falling back to semaphores :) Ah. Fun. But seriously, the thing that hurts more is that we only require a C89 compiler :/
- pritambaral 9y ago
  > But seriously, the thing that hurts more is that we only require a C89 compiler :/ Indeed. For a glimpse for the non-PG-hackers (like me), there's an ongoing attempt discussed in the PG-hackers mailing list to use stdbool.h.
  - wahern 9y ago
    That can be tricky because you can't emulate the semantics of the C99 bool type. In C99 (bool)256 == 1 but on systems which emulate bool with, e.g., an 8-bit unsigned char then (bool)256 == 0
    - petereisentraut 9y ago
      Another problem is that the bool provided by stdbool.h is 4 bytes on some platforms, which breaks PostgreSQL all over the place.
collyw 9y ago
What uses those these days?

nileshtrivedi 9y ago

I'd like to see updated versions of PL/v8 ship. The situation with building v8 is so bad ( https://github.com/plv8/plv8/issues/251#issuecomment-364541059 https://github.com/plv8/plv8/issues/251#issuecomment-3645410... ), that almost the entire cloud infrastructure (AWS, Heroku, Docker) is stuck with an ancient version of PL/v8.

bdcravens 9y ago
AWS only goes up to 9.6.5 - I don't know that PL/v8 is the reason for that.
chillax2 9y ago
The solution is to fire whoever convinced you that javascript belongs in your database.
- nileshtrivedi 9y ago
  Pl/v8 is at least safer than PL/Python due to being properly sandboxed ;-)

chinhodado 9y ago

It's a shame that Postgres 10 still ships with the abomination that is pgAdmin 4. You don't have a lot of other choices either (the pgAdmin 3 LTS version still throws error left and right when connection to a postgres 10 DB)

grzm 9y ago
This is package specific. pgAdmin is a separate project. There are other tools out there (there is a recent Show HN thread for a macOS client and the comments include other tools), though to be honest I use psql almost exclusively, so I'm not one to ask for recommendations.
petereisentraut 9y ago
Try OmniDB perhaps? (disclaimer: my employer (but open source))
tpkj 9y ago
Agreed. Tried pgAdmin 4, and it's not a happy user experience. Reverting back to pgAdmin 3 gives errors, depending on what you attempt to do. I have Navicat, and some features are good, yet some are frustrating. Postgres needs a "gold standard" ux tool. Maybe there is one, but I have not used it before.
petagonoral 9y ago
dbeaver is free & can connect to multiple db types. (have used it with postgres as i agree that pgAdmin 4 is v. bad interface)
dvdgsng 9y ago
BigSQL offers a LTS version of pgAdmin 3 that supports PostgreSQL 10: https://www.openscg.com/bigsql/pgadmin3/ https://www.openscg.com/bigsql/pgadmin3/ DBeaver is another great alternative.