Loading...

Follow MacLochlainns Weblog on Feedspot

Continue with Google
Continue with Facebook
or

Valid
A student asked how you print output from PL/pgSQL blocks. The student wanted to know if there was something like the following in Oracle ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
MacLochlainns Weblog by Maclochlainn - 6d ago
I ran across an interesting nuance between Oracle and Postgres with the double-pipe operator. I found that the following query failed to ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
You can’t disable a foreign key constraint in Postgres, like you can do in Oracle. However, you can remove the foreign key constraint ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
You can’t disable a not null constraint in Postgres, like you can do in Oracle. However, you can remove the not null constraint from a ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
You can’t disable a not null constraint in Postgres, like you can do in Oracle. However, you can remove the not null constraint from a ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
The Postgres 11 database documentation says that it supports naming constraints. While you can create a table with named constraints ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
MacLochlainns Weblog by Maclochlainn - 2w ago
In MySQL and Oracle, you set a session variable quite differently. That means you should expect there differences between setting a ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
MacLochlainns Weblog by Maclochlainn - 3w ago
As I committed to a student, here are sample programs for writing a Python query against the Postgres 11 database. The first one returns ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
MacLochlainns Weblog by Maclochlainn - 3w ago
While attempting an install of pgAdmin and updating a Fedora 30 environment, I encountered a conflict on the upgrade of MySQL 8.0.17-1 to ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
MacLochlainns Weblog by Maclochlainn - 1M ago
Many developers already know about the change from int to serial in Postgres. Serial is simpler because it automatically makes the column ..read more

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview