I am attaching external database 'b' to database 'a',
ATTACH DATABASE b AS d_b; and then trying to create a view that uses tables from the attached database, CREATE VIEW v AS SELECT d_b_t.col, d_a_t.col FROM d_b.tbl AS d_b_t JOIN tbl AS d_a_t ON... I get the following error -- view v cannot reference objects in database d_b(1) is that not allowed? -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation https://edu.osgeo.org/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
