[BUGS]

2005-05-22 Thread shd
i am trying to get some help around this, i couldnt find anywhere not on cygwin.com or anywhere else and i also saw that many others have the same problem on forums but no replies. please help : thanks in advance creating configuration files... ok creating template1 database in /usr/local/pgsql/

[BUGS] drop + create database restores previous tables and data

2005-05-22 Thread Douglas Toltzman
I just installed Postgres v 8.0.3. I loaded by databases, then decided to reload a database. I dropped the database with dropdb (I also tried DROP DATABASE in pgsql), then I recreated the database with createdb. When I tried to reload the data from the database dump, I got errors because the

Re: [BUGS] drop + create database restores previous tables and data

2005-05-22 Thread John Hansen
Maybe you restored to template1 by mistake? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Toltzman > Sent: Monday, May 23, 2005 4:38 AM > To: pgsql-bugs@postgresql.org > Subject: [BUGS] drop + create database restores previous > tables a

Re: [BUGS] BUGS

2005-05-22 Thread Jaime Casanova
On 5/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > i am trying to get some help around this, i couldnt find anywhere not on > cygwin.com or anywhere else and i also saw that many others have the same > problem on forums but no replies. please help : > thanks in advance > > > creating con

Re: [BUGS] pg_dump table ordering bug [8.0.1]

2005-05-22 Thread Mark Shewmaker
On Thu, 2005-03-24 at 17:27 -0500, Tom Lane wrote: > Andreas Lange <[EMAIL PROTECTED]> writes: > > Our upgrade from 7.4.6 to 8.0.1 only had one small glitch. Two tables > > got dumped in the wrong order (before their dependecies) and had to get > > their contents added manually after the restore.