search for: relkind

Displaying 4 results from an estimated 4 matches for "relkind".

2006 Mar 16
3
inserted_at seems buggy in production mode?
...39;) LIMIT 1 SQL (0.000319) BEGIN PK and serial sequence (0.017476) SELECT attr.attname, name.nspname, 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.relnamespace = name.oid 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 = ''match_comments''::regclass MatchComment Create...
2006 Jul 20
4
Help with Rails and postgres with sequence numbers (global?)
...[4;35;1mSQL (0.016000) BEGIN [4;36;1mPK and serial sequence (0.031000) [0;1m SELECT attr.attname, name.nspname, 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.relnamespace = name.oid 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 = ''partsgroup''::regclass [4;35;1mPK and custom sequence...
2005 Nov 07
0
pk_and_sequence_for(table) bug?
...pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid 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.c...
2008 Mar 08
9
Validation error handling on related models
I have 2 models, entity and client. Entity has_one client and client belongs_to entity. Entity has attributes name and legal_name. Entity also has an unique index on (lower(name)). The pKey for both is the conventional Rails id. Client has a fKey constraint on entity_id and is indexed in entity_id. In controllers/clients_controller.rb I have: # GET /clients/new # GET /clients/new.xml