226 reputation
312
bio website linkedin.com/in/robbednark
location Portland, Oregon, USA
age 45
visits member for 2 years, 9 months
seen Nov 5 at 15:34

Software Developer, most enthusiastically in Python and Django.


Nov
5
comment Is a Postgres long-running query aborted if the connection is lost/broken?
Wow, just what I was looking for, an excellent detailed answer! Thanks @Craig_Ringer!
Nov
5
accepted Is a Postgres long-running query aborted if the connection is lost/broken?
Oct
30
awarded  Curious
Oct
29
awarded  Commentator
Oct
29
comment Is a Postgres long-running query aborted if the connection is lost/broken?
Thanks @jjanes. Can you point to any documentation or source code that indicates this?
Oct
29
asked Is a Postgres long-running query aborted if the connection is lost/broken?
Oct
26
awarded  Popular Question
Oct
23
awarded  Yearling
Aug
5
awarded  Popular Question
May
28
awarded  Notable Question
Dec
8
awarded  Popular Question
Oct
2
awarded  Notable Question
Jul
2
awarded  Popular Question
May
8
awarded  Popular Question
Sep
6
comment How to list all views in SQL in PostgreSQL?
Thanks @Phil. However, that command returns 128 rows, whereas \dv returns 57 rows. It seems to be giving me system views as well, like "tables", "columns", "domains", "pg_role", etc. How do I get just the views that I created?
Sep
6
asked How to list all views in SQL in PostgreSQL?
Jul
27
revised How to verify postgresql db restore from pg_dump file
Added sequence link that @ocharles gave in his comment.
Jul
27
suggested suggested edit on How to verify postgresql db restore from pg_dump file
Jul
25
comment Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists?
Thanks @Erwin_Brandstetter! Another excellent answer from you, I sure appreciate it.
Jul
25
accepted Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists?