Re: dblinks

Hi,

I meant to say, the architecture will NOT be able to be changed.

Regards,
Sumaya
-----Original Message-----
From: sumaya(at)silvermoongroup(dot)com [mailto:sumaya(at)silvermoongroup(dot)com]
Sent: Sunday, May 18, 2008 04:47 AM
To: 'Jonah H. Harris', sumaya(at)silvermoongroup(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] dblinks

Hi,

I'm using enterpisedb.

The thing is it does return data, it's just that if there is a date column on the table, it gives me the error. Is there no way around this? Unfortunately the architecture will be able to be changed.

Thanks,
Sumaya
-----Original Message-----
From: Jonah H. Harris [mailto:jonah(dot)harris(at)gmail(dot)com]
Sent: Saturday, May 17, 2008 07:31 PM
To: sumaya(at)silvermoongroup(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] dblinksre

On Sat, May 17, 2008 at 6:58 PM, wrote: > statement looks like > select * from mytable(at)mydblink; Postgres does not support this style of database link syntax. Are you using Oracle or EnterpriseDB? -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah(dot)harris(at)enterprisedb(dot)com Edison, NJ 08837 | http://www.enterprisedb.com/