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

Re: PDF book July 2, 2000 version

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: rrowell(at)shreve(dot)net
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: PDF book July 2, 2000 version
Date: 2000-07-04 13:56:51
Message-ID: 200007041356.JAA22646@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Can someone comment on this?  Why doesn't OID work in foreign keys. 
Seems this is a bug.

> First off I want to say thank your for creating a sorely needed reference and
> sharing it with the online world via the PDF document.
> 
> I do have one minor complaint though.  I'm learning Postgres from your book
> although I'm familiar with the basics of SQL.   I was at first excited then
> discouraged by the OID section of your book.  I think a much needed
> addition to the OID limitations section is that the OID field can not be
> referenced in a foreign key.  IE
> 
> CREATE TABLE t1( i INTEGER);
> CREATE TABLE t2( id OID REFERENCES t1(oid));//dose not work
> 
> You use the OID is a foreign key of sorts in the example, but you never qualify
> that using the foreign key constraint system in Postgres will not allow you to
> automate this.  I realize the OID section comes long before the constraints
> chapter, but a quick qualification would still make things clearer. Without
> the ability to use the OID field as a reference for foreign keys, it's
> usefulness is very limited.
> 
> Keep up the good work, I can't wait to buy the finished product!
> 
> _________________________
> Richard Rowell
> rrowell(at)shreve(dot)net
> 
> Perl is the unix world's equivalent of VB - and just as much of an abomination.
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-07-04 14:00:08
Subject: Re: heap_create with OID?
Previous:From: Sevo StilleDate: 2000-07-04 13:33:35
Subject: Re: [HACKERS] proposed improvements to PostgreSQL license

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