-----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----- -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches