search for: conrelid

Displaying 3 results from an estimated 3 matches for "conrelid".

Did you mean: conread
2006 Jul 20
4
Help with Rails and postgres with sequence numbers (global?)
...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 (0.031000) SELECT attr.attname, name.nspname, split_part(def.adsrc, ''\'''', 2) FROM pg_class t JO...
2006 Mar 16
3
inserted_at seems buggy in production mode?
...ROM 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 (0.002280) INSERT INTO match_comments ("body", "match_id", "player_id", "inserted_at") V...
2005 Nov 07
0
pk_and_sequence_for(table) bug?
...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 = ''players''::regclass DDL: CREATE TABLE "public"."players" ( "id" SERIAL,...