Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@giddie
Created August 3, 2010 09:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save giddie/506116 to your computer and use it in GitHub Desktop.
Save giddie/506116 to your computer and use it in GitHub Desktop.
Started POST "/users/7" for 127.0.0.1 at Tue Aug 03 10:35:00 +0100 2010
PK and serial sequence (5.7ms) SELECT attr.attname, seq.relname
FROM pg_class seq,
pg_attribute attr,
pg_depend dep,
pg_namespace name,
pg_constraint cons
WHERE seq.oid = dep.objid
AND seq.relkind = 'S'
AND attr.attrelid = dep.refobjid
AND attr.attnum = dep.refobjsubid
AND attr.attrelid = cons.conrelid
AND attr.attnum = cons.conkey[1]
AND cons.contype = 'p'
AND dep.refobjid = '"user_roles_users"'::regclass
PK and custom sequence (2.9ms) SELECT attr.attname,
CASE
WHEN split_part(def.adsrc, '''', 2) ~ '.' THEN
substr(split_part(def.adsrc, '''', 2),
strpos(split_part(def.adsrc, '''', 2), '.')+1)
ELSE split_part(def.adsrc, '''', 2)
END
FROM pg_class t
JOIN pg_attribute attr ON (t.oid = attrelid)
JOIN pg_attrdef def ON (adrelid = attrelid AND adnum = attnum)
JOIN pg_constraint cons ON (conrelid = adrelid AND adnum = conkey[1])
WHERE t.oid = '"user_roles_users"'::regclass
AND cons.contype = 'p'
AND def.adsrc ~* 'nextval'
TypeError (expected Array (got String) for param `role_ids'):
Rendered /opt/ruby-enterprise/lib/ruby/gems/1.8/gems/actionpack-3.0.0.rc/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (1.7ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment