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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-patches by date

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