On Thu, Jun 16, 2016 at 6:55 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
You have not provided information as to the O/S of the PostgreSQL
server or your PgAdmin remote system (I suspect Windows), but
regardless, you
> are just asking for trouble by doing development over a remote connection.
> You should verify there is no delay by connecting directly to the PostgreSQL server and testing the CREATE OR REPLACE
there.I suspect you will have none or very minimal delay.
> Hopefully PostgreSQL is on a Linux O/S and you can use Putty for Windows
http://www.chiark.greenend.org.uk/~sgtatham/putty/download.htmlto connect directly
> and develop.
I responded on his other thread. Locks need to be ruled out before
investigating other problems. Exotic causes of this problem could be
storage problems or weird network issues (especially on windows). But
locks need to be ruled out first.
merlin