Marc G. Fournier wrote:
> On Tue, 10 May 2005, Bruce Momjian wrote:
>
> > Bruce Momjian wrote:
> >> Tom Lane wrote:
> >>> "Greg Sabino Mullane" <[EMAIL PROTECTED]> writes:
> > Does anyone know why so many LEFT JOINs are used in psql/describe.c to
> > join to the pg_namespace table, like he
On Tue, 10 May 2005, Bruce Momjian wrote:
Bruce Momjian wrote:
Tom Lane wrote:
"Greg Sabino Mullane" <[EMAIL PROTECTED]> writes:
Does anyone know why so many LEFT JOINs are used in psql/describe.c to
join to the pg_namespace table, like here:
Yes, pg_relnamespace is definitely not null. I've actua
Bruce Momjian wrote:
> Tom Lane wrote:
> > "Greg Sabino Mullane" <[EMAIL PROTECTED]> writes:
> > >> Does anyone know why so many LEFT JOINs are used in psql/describe.c to
> > >> join to the pg_namespace table, like here:
> >
> > > Yes, pg_relnamespace is definitely not null. I've actually already
Tom Lane wrote:
> "Greg Sabino Mullane" <[EMAIL PROTECTED]> writes:
> >> Does anyone know why so many LEFT JOINs are used in psql/describe.c to
> >> join to the pg_namespace table, like here:
>
> > Yes, pg_relnamespace is definitely not null. I've actually already removed
> > the left joins from m
"Greg Sabino Mullane" <[EMAIL PROTECTED]> writes:
>> Does anyone know why so many LEFT JOINs are used in psql/describe.c to
>> join to the pg_namespace table, like here:
> Yes, pg_relnamespace is definitely not null. I've actually already removed
> the left joins from my \df patch, since I had to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Does anyone know why so many LEFT JOINs are used in psql/describe.c to
> join to the pg_namespace table, like here:
>
> I thought a pg_class row always pointed to a valid pg_namespace row
> because of our dependency restrictions.
Yes, pg_relnamesp
Does anyone know why so many LEFT JOINs are used in psql/describe.c to
join to the pg_namespace table, like here:
printfPQExpBuffer(&buf,
"SELECT c.oid,\n"
" n.nspname,\n"
" c.relname\n"
"FROM pg_catalog.pg_class c\n"
" LEFT JOIN pg_catalog.pg_namespace n ON
