Tom Lane wrote:
> > CREATE TABLE pfam (swiss_id varchar(16) NOT NULL, pfam_family
> > varchar(32), comment varchar(80), sequence_data varchar(-5));
>
> Hrm. varchar(-5) is pretty obviously broken :-(. I don't want to
> guess what sort of aberration prompted that output from pg_dump
> --- 6.3.2
George Armhold <[EMAIL PROTECTED]> writes:
>> So, how about showing us the first 20 or so lines of db.backup? You
>> can't really expect us to guess much from this amount of info ...
> Fair enough question.
> CREATE TABLE pfam (swiss_id varchar(16) NOT NULL, pfam_family
> varchar(32), comment v
Tom Lane wrote:
> So, how about showing us the first 20 or so lines of db.backup? You
> can't really expect us to guess much from this amount of info ...
Fair enough question.
select datdba into table tmp_pg_shadow from pg_database where
datname = 't
emplate1';
delete from pg_shadow wher
George Armhold <[EMAIL PROTECTED]> writes:
>> psql:/home/armhold/db.backup:13: ERROR: parser: parse error at or near "-"
>> psql:/home/armhold/db.backup:14: ERROR: Relation 'pfam' does not exist
>> psql:/home/armhold/db.backup:20: invalid command \.
So, how about showing us the first 20 or so l
I'm trying to migrate from PostgreSQL 6.3.2 under IRIX to version
7.0.2 under RedHat 7.0. I've dumped my old database with
"pg_dumpall -o > db.backup", but I'm having problems restoring this
data to the new machine. I'm using "psql -d template1 < db.backup" to
restore the data, but I'm getting
