Re: [HACKERS] What is this...?

>
>
> I might have missed somethign with all the dump/reload discussions that
> went on, but what is:
>
> postgres(at)zeus> psql -e -f db.dump template1
> \connect template1
> connecting to new database: template1
> select datdba into table tmp_pguser from pg_database where datname =
> 'template1';
> QUERY: select datdba into table tmp_pguser from pg_database where
> datname = 'template1';
> SELECT
> delete from pg_user where usesysid <> tmp_pguser.datdba;
> QUERY: delete from pg_user where usesysid <> tmp_pguser.datdba;
> DELETE 0
> drop table tmp_pguser;
> QUERY: drop table tmp_pguser;
> DROP
> copy pg_user from stdin;
> QUERY: copy pg_user from stdin;

^^^^^^^ COPY into a view? Cool!

> Enter info followed by a newline
> End with a backslash and a period on a line by itself.
> >>
>
>
> And then it just stops...?
>
> This is using pg_dump/pg_dumpall from 6.2.1, before shutting down v6.2.1,
> to create the db.dump file...
>
>
>
>
>

So we missed something when renaming pg_user into pg_shadow.
Damn.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #