Postgres Pro
Downloads
Home   >   mailing lists

Failed to create View after Access migration - Mailing list pgadmin-support

From Raymond Tsang
Subject Failed to create View after Access migration
Date
Msg-id OF9EBBA770.421F4E21-ONCA256C0C.007E8B61-CA256C0C.007F1900@servex.com.au
Whole thread Raw
List pgadmin-support
Tree view 
Hi,

I have successfully migrated Access 2000 to PostgreSQL v7.2.1. However,
when I want to create View, I receive errors even I create a very simple
one:
Create View ordersview As
Select * from Orders;

The error message I got is:

An error has occured in pgAdmin II:frmView.cmdOK_Click:
Number: -2147467259
Description: Error: Relation "orders" does not exist

Can somebody give me advise please? I have installed MDAC v2.7, pdAdmin II
v1.2 and PostgreSQL v7.2.1, and I am running on Windows 2000.

Regards,

Raymond Tsang
Business Development Manager
Bluechip Infotech Pty Ltd
P: (02) 8745 8434
F: (02) 8745 8499
raymondt@bluechipit.com.au
http://www.bluechipit.com.au

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Migrate MsAccess Query to PostgreSQL
Next
From: "Thomas A. Lowery"
Date:
Subject: Re: Failed to create View after Access migration