Thread: 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 } [ ... ] ] ^ Thisshould be a ] | Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo atPop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
> 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 ] [
ONUPDATE 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,
Pennsylvania19026
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 atPop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
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 byGCC 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 atPop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
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
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 atPop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================