What steps will reproduce the problem? 1. Create a table in postgres with the following schema:

create table domains ( id serial primary key, created_at timestamp, updated_at timestamp );

2. Dump schema with sequel -d postgres://postgres@localhost/testdb

What is the expected output? What do you see instead?

The expected output is

Sequel.migration do up do create_table(:domains) do primary_key :id DateTime :created_at DateTime :updated_at end end

down do drop_table(:domains) end end

The actual output is

Sequel.migration do up do create_table(:domains) do primary_key :id String :domain_catalog String :domain_schema DateTime :created_at DateTime :updated_at String :domain_name String :data_type String :character_maximum_length String :character_octet_length String :character_set_catalog String :character_set_schema String :character_set_name String :collation_catalog String :collation_schema String :collation_name String :numeric_precision String :numeric_precision_radix String :numeric_scale String :datetime_precision String :interval_type String :interval_precision String :domain_default String :udt_catalog String :udt_schema String :udt_name String :scope_catalog String :scope_schema String :scope_name String :maximum_cardinality String :dtd_identifier end end

down do drop_table(:domains) end end

What version of the product are you using? On what operating system?

I am on Linux, ruby 1.8.7 ree 2010.02, sequel 3.12.1

This is because the domains table exists in multiple schemas in your database, and there isn't a way to specify a specific schema on the command line.

In this case, the domains table is in the information schema in addition in being in your own schema. Database#tables in the postgres adapter assumes the public schema if no schema is provided and no default schema is used, but returns tables without the schema name. However, when parsing the schema for a table, if no schema is given and no default schema is used, it will take tables from every schema.

There's two ways to fix that. One is assuming the public schema when parsing the schema for a table. The alternative is to not assume any particular schema when getting the tables or parsing the schema for a table, and if no schema is given and no default schema is used, just exclude the default schemas other than public (pg_catalog, pg_toast, pg_temp_1, pg_toast_temp_1, and information_schema).

I think the second alternative is better in the long run, so I'll probably go with that. I'm currently on vacation, but I'll try to commit a fix for this early next week. In the meantime, try this patch that uses the first alternative: http://pastie.org/1010397.txt

The first alternative still produces the incorrect dump

Thanks and don't worry about it during your vacation

Fixed: http://github.com/jeremyevans/sequel/commit/b33a367a3c0c4fc8c3a9c53429b442e77d9f42c7

Thanks for the report!