Thom Brown <thombrown@gmail.com> writes:
> How is pgAdmin determining the serial type in this case?
Most likely it's looking for the pg_depend entry that shows the sequence
as being "owned by" the column. However, that's an oversimplification
of reality. I would imagine that pgAdmin will lie to you in exactly
the same cases that used to break pg_dump (notably, where someone has
manually adjusted either the default expression or the sequence...)
regards, tom lane