Thom Brown <thombrown@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general