Displaying 3 results from an estimated 3 matches for "nspname".
Did you mean:
ns_name
2006 Jul 20
4
Help with Rails and postgres with sequence numbers (global?)
...pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = ''partsgroup''::regclass
AND a.attnum > 0 AND NOT 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 =...
2006 Mar 16
3
inserted_at seems buggy in production mode?
...;"comment", "id"=>"159", "controller"=>"match"}
Match Load (0.001001) SELECT * FROM matches WHERE (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...
2005 Nov 07
0
pk_and_sequence_for(table) bug?
...fault_sequence_name "players"
=> "players_id_seq"
>> Player.connection.pk_and_sequence_for "players"
=> nil
>>
Here''s what RoR sends to the postgresql server with this last method call
LOG: statement: 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...