Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group