psql.txt

text/plain

Download

[rotweiler@pss5 schema]$ psql --version
psql (PostgreSQL) 7.0.3
contains readline, history support
Portions Copyright (c) 1996-2000, PostgreSQL, Inc
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.
[rotweiler@pss5 schema]$ type psql
psql is hashed (/usr/local/pgsql/bin/psql)
[rotweiler@pss5 schema]$ type pg_ctl
pg_ctl is /usr/local/pgsql/bin/pg_ctl
[rotweiler@pss5 schema]$ psql
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

rotweiler=> drop table unique_id;
DROP
rotweiler=> drop table domain;
DROP
rotweiler=> \q
[rotweiler@pss5 schema]$ psql < postgresql.sql
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'domain_pkey' for table 'domain'
ERROR:  Relation 'unique_id' does not exist
[rotweiler@pss5 schema]$ psql < postgresql.sql
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'domain_pkey' for table 'domain'
ERROR:  Relation 'unique_id' does not exist
[rotweiler@pss5 schema]$ psql < postgresql.sql
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'domain_pkey' for table 'domain'
ERROR:  Relation 'unique_id' does not exist
[rotweiler@pss5 schema]$ psql < postgresql.sql
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'domain_pkey' for table 'domain'
ERROR:  Relation 'unique_id' does not exist

...

[rotweiler@pss5 schema]$ psql < postgresql.sql
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'domain_pkey' for t
able 'domain'
ERROR:  Relation 'unique_id' does not exist
[rotweiler@pss5 schema]$ psql < postgresql.sql
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'domain_pkey' for t
able 'domain'
ERROR:  Relation 'unique_id' does not exist
[rotweiler@pss5 schema]$ psql
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

rotweiler=> select * from unique_id;
ERROR:  Relation 'unique_id' does not exist
rotweiler=> select * from domain;
ERROR:  Relation 'domain' does not exist
rotweiler=> create table unique_id(
rotweiler(> session integer,
rotweiler(> id integer);
CREATE
rotweiler=> \q
[rotweiler@pss5 schema]$ psql < postgresql.sql
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'domain_pkey' for t
able 'domain'
ERROR:  Relation 'domain' does not exist
[rotweiler@pss5 schema]$ psql < postgresql.sql
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'domain_pkey' for t
able 'domain'
NOTICE:  mdopen: couldn't open unique_id: No such file or directory
NOTICE:  RelationIdBuildRelation: smgropen(unique_id): No such file or directory
NOTICE:  mdopen: couldn't open unique_id: No such file or directory
ERROR:  Relation 'domain' does not exist
[rotweiler@pss5 sc