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

Re: Reference by output in : \d <table_name>

From: "Brendan Jurd" <direvus(at)gmail(dot)com>
To: "kenneth d'souza" <kd_souza(at)hotmail(dot)com>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Reference by output in : \d <table_name>
Date: 2008-04-16 16:42:25
Message-ID: 37ed240d0804160942x22dd8da4y7776ee6484d9ebf4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, Apr 16, 2008 at 10:00 PM, kenneth d'souza  wrote:
>  However,Why does the word "FOREIGN KEY" appear in the last line of your
> output. My original patch had the output like this.
>  Referenced by:
>   "bar_foo_fkey" IN public.bar(foo) REFERENCES foo(a)
>  The keyword "FOREIGN KEY" was removed by me as it would further cause a
> confusion.
>

Hi Kenneth,

Tom reinstated the "FOREIGN KEY" part of the definition when he
committed your patch.  I think it's fine with "FOREIGN KEY" left in
there; I don't find it confusing.  I actually think it makes the line
more descriptive and obvious.

> Secondly, since the table foo is altered with an addition of a new column
> "bar", it doesn't display in your output. Please double check.
>

You're right; it was just a copy-paste error I made when I was
composing my email.  The actual output from psql shows all columns as
expected.

Cheers,
BJ
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: http://getfiregpg.org

iD8DBQFIBixv5YBsbHkuyV0RArJSAJ0eDes2V0nwlgQuNE0GjJxwW4Ey8gCgiWTw
UjSjF8EJaTDSTQnkTfgSasY=
=xdOl
-----END PGP SIGNATURE-----

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2008-04-16 17:26:05
Subject: Re: [PATCHES] Avahi support for Postgresql
Previous:From: Andrew DunstanDate: 2008-04-16 15:46:38
Subject: Re: [HACKERS] Text <-> C string

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