Re: Reference by output in : \d - Mailing list pgsql-patches

From Brendan Jurd
Subject Re: Reference by output in : \d
Date
Msg-id 37ed240d0804160942x22dd8da4y7776ee6484d9ebf4@mail.gmail.com
Whole thread Raw
In response to Re: Reference by output in : \d  (kenneth d'souza <kd_souza@hotmail.com>)
List 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-----

pgsql-patches by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] Text <-> C string
Next
From: "Brendan Jurd"
Date:
Subject: Re: [HACKERS] Text <-> C string