Thread: psql bug? Segfault from source users != dest users

Hey guys,
I get a segfault when dumping a database from one machine to the other when
the new machine doesn't have a user that is on the other.

for example:
admin exists on source machine but not destination
when I 'psql -U postgres < input.sql'
I get:

\connect: FATAL 1:  SetUserId: user 'admin' is not in 'pg_shadow'
Segmentation fault (core dumped)

I can see why that should produce an error, but not a core dump.

--tony

"Metzidis, Anthony" <Metzidis@mednet.ucla.edu> writes:
> \connect: FATAL 1:  SetUserId: user 'admin' is not in 'pg_shadow'
> Segmentation fault (core dumped)

What version are you running?  I seem to recall that psql had a bug like
that for awhile, but I don't see it in 7.0.2 or later.

            regards, tom lane