From: Michael P. <mic...@gm...> - 2013-08-21 00:10:03
|
On Wed, Aug 21, 2013 at 9:05 AM, West, William <ww...@uc...> wrote: > Michael, > > I ran the following query successfully on a remote node coord2 from node > coord1: > > postgres=# EXECUTE DIRECT on coord2 'select clock_timestamp()'; > clock_timestamp > ------------------------------- > 2013-08-20 16:42:16.647818-07 > (1 row) > > And the reverse works as well > > postgres=# EXECUTE DIRECT on coord2 'select clock_timestamp()'; > clock_timestamp > ------------------------------- > 2013-08-20 16:50:25.552218-07 > (1 row) > > > > So they are capable of communication. Does this give you an idea of why > can't I do DML statements across nodes? Did you try to the Datanodes? -- Michael |