Failed to create View after Access migration

From: "Raymond Tsang" <RaymondT(at)bluechipit(dot)com(dot)au>
To: pgadmin-support(at)postgresql(dot)org
Subject: Failed to create View after Access migration
Date: 2002-08-05 23:08:14
Message-ID: OF9EBBA770.421F4E21-ONCA256C0C.007E8B61-CA256C0C.007F1900@servex.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(at)bluechipit(dot)com(dot)au
http://www.bluechipit.com.au

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Thomas A. Lowery 2002-08-06 05:20:53 Re: Failed to create View after Access migration
Previous Message Dave Page 2002-08-05 07:26:55 Re: Migrate MsAccess Query to PostgreSQL