[PATCHES] Have psql \dD show checks

2005-04-03 Thread Greg Sabino Mullane 

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1


Patch to show check information when listing domains via \dD in psql.
Per question by Edmund Bacon on the pgsql-general list.

- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200504030911
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-

iD8DBQFCT+t8vJuQZxSWSsgRAog3AJwOp8ac7xvgQ1lt2sDTu2hwAr63hwCfYz2T
GqxgS3t64mF4Vn8Ie5n8hvo=
=a1GE
-END PGP SIGNATURE-


Index: describe.c
===
RCS file: /projects/cvsroot/pgsql/src/bin/psql/describe.c,v
retrieving revision 1.114
diff -c -r1.114 describe.c
*** describe.c  1 Apr 2005 05:30:38 -   1.114
--- describe.c  3 Apr 2005 13:07:14 -
***
*** 1579,1592 
  WHEN t.typnotnull AND 
t.typdefault IS NULL THEN 'not null'\n
  WHEN NOT t.typnotnull 
AND t.typdefault IS NOT NULL THEN 'default '||t.typdefault\n
  ELSE ''\n
!END as \%s\\n
  FROM pg_catalog.pg_type t\n
!LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace\n
  WHERE t.typtype = 'd'\n,
  _(Schema),
  _(Name),
  _(Type),
! _(Modifier));
  
processNamePattern(buf, pattern, true, false,
   n.nspname, t.typname, NULL,
--- 1579,1595 
  WHEN t.typnotnull AND 
t.typdefault IS NULL THEN 'not null'\n
  WHEN NOT t.typnotnull 
AND t.typdefault IS NOT NULL THEN 'default '||t.typdefault\n
  ELSE ''\n
!END as \%s\,\n
!  
pg_catalog.pg_get_constraintdef(r.oid, true) as \%s\\n
  FROM pg_catalog.pg_type t\n
!JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace\n
!LEFT JOIN pg_catalog.pg_constraint r ON t.oid = r.contypid\n
  WHERE t.typtype = 'd'\n,
  _(Schema),
  _(Name),
  _(Type),
! _(Modifier),
! _(Check));
  
processNamePattern(buf, pattern, true, false,
   n.nspname, t.typname, NULL,



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [PATCHES] unused variable ShmemBootstrap

2005-04-03 Thread Neil Conway 
Alvaro Herrera wrote:
Oops, somehow I left that parth out of the patch.
Thanks, both patches applied.
-Neil
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faq

Re: [PATCHES] Update to download info in install docs

2005-04-03 Thread Neil Conway 
Robert Treat wrote:
Inspired by comments from steve [EMAIL PROTECTED], adds a few urls for 
more download options. 
Thanks for the patch -- I applied a modified version (we can't use 
ulink url=...description/ulink since that won't work for printed 
versions of the docs).

-Neil
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PATCHES] Update to download info in install docs

2005-04-03 Thread Peter Eisentraut 
Neil Conway wrote:
 Thanks for the patch -- I applied a modified version (we can't use
 ulink url=...description/ulink since that won't work for
 printed versions of the docs).

Sure it will.  We use that all over the place.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

Re: [PATCHES] Update to download info in install docs

2005-04-03 Thread Tom Lane 
Peter Eisentraut [EMAIL PROTECTED] writes:
 Neil Conway wrote:
 Thanks for the patch -- I applied a modified version (we can't use
 ulink url=...description/ulink since that won't work for
 printed versions of the docs).

 Sure it will.  We use that all over the place.

Not since Bruce took them all out a few days ago ;-).  If you were
unhappy with that you should have spoken up.  I thought the problem
was that the default printed representation doesn't show the URL
and is thus pretty useless.

regards, tom lane

---(end of broadcast)---
TIP 8: explain analyze is your friend