Skip site navigation (1) Skip section navigation (2)

Weird backup file

From: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
To: "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>, reina(at)nsi(dot)edu
Subject: Weird backup file
Date: 2000-11-17 19:27:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
I backed up my database from Postgres 6.5.3 and migrated to 7.0.2
several a few months ago. For some reason, data was lost in the
transition. I've finally pinned it down to the attached file (abridged
to point out the problem).

It looks like two things happened in the backup. First, when I move from
'G' to 'F' in the names column, I seem to lose the column called
'dsp_chan'. Second, the double quotes around the float_4 array called
'spike_hist' aren't included.

I'm not sure if the double quotes are necessary, but the missing column
is probably a problem. I added this column after the database was
created by using 'alter table ellipse_cell_proc add column dsp_chan' and
then put it in the correct position by using:

SELECT  name, arm, rep, cycle, hemisphere, area, cell, dsp_chan,
spike_hist INTO xxx FROM ellipse_cell_proc;
DROP TABLE ellipse_cell_proc;
ALTER TABLE xxx RENAME TO ellipse_cell_proc;

Can anyone explain what went wrong with the backup or where I erred
adding the column?


Attachment: backup.sql
Description: text/plain (14.9 KB)

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-11-17 19:59:11
Subject: Re: Coping with 'C' vs 'newC' function language names
Previous:From: Martin A. MarquesDate: 2000-11-17 19:08:26
Subject: Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group