pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Gary Stainburn <gary.stainburn@ringways.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: create view error
Date: Mon, 7 Jul 2003 15:05:43 -0200 (GMT+2)
Message-ID: <Pine.LNX.4.44.0307071505120.9194-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <200307071240.23936.gary.stainburn@ringways.co.uk>

On Mon, 7 Jul 2003, Gary Stainburn wrote:

> Hi folks,
> 
> I know I'm missing something blindingly obvious, can someone point it out to 
> me please.
> 
> create table locos (		-- Locos table - contains details of locos
> lid     	int4 default nextval('loco_lid_seq'::text) unique not null,
> lclass		int4 references lclass(lcid),	-- Loco Class
> lbuilt		date,				-- Date off-shed
> lcme		int4 references cme(cmid), 	-- Chief Mechanical Engineer
> lname		character varying(30),		-- Name of Loco
> lcomments	text				-- free text comments
> );
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index 'locos_lid_key' for 
> table 'locos'
> NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
> CREATE
> create table lnumbers ( -- alternate loco numbers
> lnid		int4 not null references locos(lid),
> lnumber		character varying(10),
> lncurrent	bool,
> primary key	(lnid, lnumber)
> );
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'lnumbers_pkey' 
> for table 'lnumbers'
> NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
> CREATE
> create view loco_dets as
>   select * from locos l
>       left outer join 
>         (select * from lclass) lc on lc.lcid = l.lclass
>       left outer join
>         (select lnumber from lnumbers) ln on ln.lnid = l.lid and ln.lncurrent 
 
                        ^^^
                        select also lnid

> = true
>       left outer join
>         (select * from company) c on c.coid = lc.lcompany;
> ERROR:  No such attribute or function ln.lnid
> 

-- 
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-210-8981112
fax:    +30-210-8981877
email:  achill at matrix dot gatewaynet dot com
        mantzios at softlab dot ece dot ntua dot gr




view thread (5+ messages)

Message-ID: <Pine.LNX.4.44.0307071505120.9194-100000@matrix.gatewaynet.com>
Permalink:  ../Pine.LNX.4.44.0307071505120.9194-100000@matrix.gatewaynet.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.44.0307071505120.9194-100000@matrix.gatewaynet.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: achill@matrix.gatewaynet.com, gary.stainburn@ringways.co.uk
  Subject: Re: create view error
  In-Reply-To: <Pine.LNX.4.44.0307071505120.9194-100000@matrix.gatewaynet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox