
postgresql=> \h create table
Command:     CREATE TABLE
Description: Creates a new table
Syntax:
CREATE [ TEMPORARY | TEMP ] TABLE table (
    column type
    [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
    [column_constraint_clause | PRIMARY KEY } [ ... ] ]
                                            ^
                       This should be a ]   |

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Sat, 5 May 2001 11:22:35 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
typo in psql's help
> postgresql=> \h create table
> Command:     CREATE TABLE
> Description: Creates a new table
> Syntax:
> CREATE [ TEMPORARY | TEMP ] TABLE table (
>     column type
>     [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
>     [column_constraint_clause | PRIMARY KEY } [ ... ] ]
>                                             ^
>                        This should be a ]   |

Vince, I can't find this anywhere.  What version is this?  I bet we
already fixed it.  In fact, I think I remember seeing the fix a while
ago.

My pgsql \h create table shows:

---------------------------------------------------------------------------

CREATE [ TEMPORARY | TEMP ] TABLE table_name (
    { column_name type [ column_constraint [ ... ] ]
      | table_constraint }  [, ... ]
    ) [ INHERITS ( parent_table [, ... ] ) ]

where column_constraint can be:
[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | UNIQUE | PRIMARY KEY | DEFAULT value | CHECK (condition) |
  REFERENCES table [ ( column ) ] [ MATCH FULL | MATCH PARTIAL ]
   [ ON DELETE action ] [ ON UPDATE action ]
   [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
}

and table_constraint can be:
[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) |
  PRIMARY KEY ( column_name [, ... ] ) |
  CHECK ( condition ) |
  FOREIGN KEY ( column_name [, ... ] ) REFERENCES table [ ( column [, ... ] ) ]
   [ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ]
   [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
}

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 7 May 2001 12:06:27 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: typo in psql's help
On Mon, 7 May 2001, Bruce Momjian wrote:

> > postgresql=> \h create table
> > Command:     CREATE TABLE
> > Description: Creates a new table
> > Syntax:
> > CREATE [ TEMPORARY | TEMP ] TABLE table (
> >     column type
> >     [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
> >     [column_constraint_clause | PRIMARY KEY } [ ... ] ]
> >                                             ^
> >                        This should be a ]   |
>
> Vince, I can't find this anywhere.  What version is this?  I bet we
> already fixed it.  In fact, I think I remember seeing the fix a while
> ago.

Yeah, I got a note from Peter saying it was fixed in 7.1.  Silly me, I
thought hub was running 7.1, psql must be 7.0.x.

---
postgresql=> select version();
                              version
-------------------------------------------------------------------
 PostgreSQL 7.1 on i386-unknown-freebsd4.2, compiled by GCC 2.95.2
(1 row)

postgresql=> \h create table
Command:     CREATE TABLE
Description: Creates a new table
Syntax:
CREATE [ TEMPORARY | TEMP ] TABLE table (
    column type
    [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
    [column_constraint_clause | PRIMARY KEY } [ ... ] ]
    [, ... ]
    [, PRIMARY KEY ( column [, ...] ) ]
    [, CHECK ( condition ) ]
    [, table_constraint_clause ]
    ) [ INHERITS ( inherited_table [, ...] ) ]
---

as just seen on hub a few minutes ago.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Mon, 7 May 2001 12:45:44 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: typo in psql's help
On Mon, 7 May 2001, Bruce Momjian wrote:

> > postgresql=> \h create table
> > Command:     CREATE TABLE
> > Description: Creates a new table
> > Syntax:
> > CREATE [ TEMPORARY | TEMP ] TABLE table (
> >     column type
> >     [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
> >     [column_constraint_clause | PRIMARY KEY } [ ... ] ]
> >                                             ^
> >                        This should be a ]   |
>
> Vince, I can't find this anywhere.  What version is this?  I bet we
> already fixed it.  In fact, I think I remember seeing the fix a while
> ago.

Did someone delete this one from the database?  I just went to close it
out and it's gone.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Mon, 7 May 2001 12:56:03 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: typo in psql's help
Vince Vielhaber <vev@michvhf.com> writes:
> Yeah, I got a note from Peter saying it was fixed in 7.1.  Silly me, I
> thought hub was running 7.1, psql must be 7.0.x.

Looks like there's an older psql in your PATH.  You could make sure with
"psql -V".

			regards, tom lane

Mon, 07 May 2001 17:03:12 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: typo in psql's help 
On Mon, 7 May 2001, Tom Lane wrote:

> Vince Vielhaber <vev@michvhf.com> writes:
> > Yeah, I got a note from Peter saying it was fixed in 7.1.  Silly me, I
> > thought hub was running 7.1, psql must be 7.0.x.
>
> Looks like there's an older psql in your PATH.  You could make sure with
> "psql -V".

Yup.  7.0.3.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Mon, 7 May 2001 21:46:40 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: typo in psql's help 