EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Met an error when creating a view  XML

Forum Index » GridSQL - General
Author Message
peng_liu

New member

Joined: 3 Feb 2010 05:15:35
Messages: 2
Offline

Hi,

In my test database, v1 is a view, and when I execute 'create view v2 as select v1.id from v1', it tips me 'ERROR: Table v1 has not been found in database test'. But if execute ''create view v2 as select id from v1', it'll be OK.
Why? It makes me puzzled.

Need your help, thanks.
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 444
Offline

n my test database, v1 is a view, and when I execute 'create view v2 as select v1.id from v1', it tips me 'ERROR: Table v1 has not been found in database test'. But if execute ''create view v2 as select id from v1', it'll be OK.


I have tried same on gridsql, it worked. Following ways I tried:






Please share the following information:
1. Version of GridSQL.
2. Definition

Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
peng_liu

New member

Joined: 3 Feb 2010 05:15:35
Messages: 2
Offline

Hi Vibhor_K,

Thank you for your reply.

Version: 'gridsql-src-1.1beta.tar.gz' compiled and run on ubuntu (two datanodes)
Definition: I tried below:


Maybe something is wrong with the version.
 
Forum Index » GridSQL - General
Go to:   
Powered by JForum 2.1.8 © JForum Team