one ask - Mailing list pgsql-general

From Partyka Robert
Subject one ask
Date
Msg-id Pine.LNX.4.21.0011272322440.1272-100000@saturn.alpha.pl
Whole thread Raw
Responses Re: one ask  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
any can explain me why I get every error and notice errors twice ?


<--cut-->

n=# create table (
n(# );
ERROR:  parser: parse error at or near "("
ERROR:  parser: parse error at or near "("
n=# create table a (
n(# index int4 not null,
n(# a char(20) not null,
n(# unique (index),
n(# primary key (index)
n(# );
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for
table
'a'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for
table
'a'
CREATE
nasz_system=# select version();
                            version
---------------------------------------------------------------
 PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.3
(1 row)



regards

BoBsoN


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [SQL] a script that queries database periodically
Next
From: "Callis, Adam"
Date:
Subject: I got Pl/Perl working on Solaris!