RC1 question of reloading data

From: Theodore Petrosky <tedpet5(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: RC1 question of reloading data
Date: 2003-11-11 19:38:24
Message-ID: 20031111193824.28906.qmail@web41008.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I just downloaded and installed RC1 (7.4) on OSX 10.3.
Everything went smoothly for the config. make and
install.

while reloading the data (from pg_dump in 7.3) I
inadvertently screwed up. Or maybe not...

my dump file was as1.out so I...

psql < as1.out

I knew it was wrong the moment after I hit the return
as I did not specify the database (i did create it
with createdb). I did not get any error message. I
went looking to see if the data was pushed somewhere
bad like template1. But couldn't find it.

I did load my data correctly but, where did the first
set go? Did it just disappear into the ether?

Ted Petrosky

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message lucas sultanum 2003-11-11 22:51:27 Locking Mechanism
Previous Message SHADOWPLAY - Dave Adams 2003-11-11 06:15:38 Selecting from a VIEW is NOT optimized like a similar SELECT statement