Displaying 3 results from an estimated 3 matches for "relnamespace".
Did you mean:
getnamespace
2006 Jul 20
4
Help with Rails and postgres with sequence numbers (global?)
...a.attisdropped
ORDER BY a.attnum
[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;...
2006 Mar 16
3
inserted_at seems buggy in production mode?
...matches.id =
''159'') 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''::regc...
2005 Nov 07
0
pk_and_sequence_for(table) bug?
...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...