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