Re: Failed to create View after Access migration

From: "Thomas A(dot) Lowery" <tlowery(at)stlowery(dot)net>
To: Raymond Tsang <RaymondT(at)bluechipit(dot)com(dot)au>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Failed to create View after Access migration
Date: 2002-08-06 05:20:53
Message-ID: 20020806012053.A19498@stllnx1.stlassoc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Tue, Aug 06, 2002 at 09:08:14AM +1000, Raymond Tsang wrote:
> 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;

> Description: Error: Relation "orders" does not exist

Try "Orders" (identifiers require quoting if Upper case is used)

Tom

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message sticky 2002-08-07 11:16:32 bug-report
Previous Message Raymond Tsang 2002-08-05 23:08:14 Failed to create View after Access migration