On Tue, 2006-07-04 at 22:41, Chris wrote:
> Carlos H. Reimer wrote:
> > Hi,
> >
> > I´m planning to migrate from 7.4 to 8.0.7 and I discovered some strange
> > behavior during migration.
> >
> > pg_dump inserted GRANT to phantom groups. They do not exist in pg_group;
> >
> > When the script created by pg_dump is processed by psql during restore,
> > these GRANTs produce a lot of errors.
>
> pg_dump won't include users and groups. pg_dumpall would include that
> information but of course includes all databases.
Alternately, if you give pg_dumpall the -g switch, you'll get just that
global user data.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
