[GENERAL] Finding recursive dependencies

ewrite 192095 i a <-- pg_type 192094 i a <-- pg_rewrite 192099 n a <-- pg_type 192094 i <-- pg_type 192093 i (6 rows) -- Same query for b: tree ----- b b <-- pg_rewrite 192099 n b <-- pg_rewrite 192099 i b <-- pg_type 192098 i b <-- pg_type 192098 i <-- pg_type 192097 i (5 rows) -- Best regards, Joel Jacobson Glue Finance

Re: [GENERAL] Finding recursive dependencies

It appears to me it's necessary to join the object type specific tables, such as pg_rewrite, to build a complete tree? If so, that's fine, I just wondered if I had missed something making it possible to avoid it. -- Best regards, Joel Jacobson Glue Finance

Re: [GENERAL] Finding recursive dependencies

2011/1/3 Tom Lane : >        select refobjid ... where objid matches and deptype = 'i' > then it'd be easy, but you only get one UNION ALL per recursive query. Ah, I see! Thanks for explaining. Now I get it. -- Best regards, Joel Jacobson Glue Finance -- Sent via pgsql

[GENERAL] Class dependencies

re defined, i.e. other classes the given class depend on. For instance, is it correct to assume constraints always can be dropped, i.e. no other class (nor other constraints) can depend on them? -- Best regards, Joel Jacobson Glue Finance -- Sent via pgsql-general mailing list (pgsql-general@pos

[GENERAL] psql \s not working - OS X

I'm trying the new 9.1b2 release and got a weird problem with the \s command to show the latest history, for some reason it's trying to write to /dev/tty instead of printing out to stdout: Joel-Jacobsons-MacBook-Pro:~ joel$ uname -a Darwin Joel-Jacobsons-MacBook-Pro.local 10.7.4 Darwin Kernel Vers

[GENERAL] Finding all 8.4->9.x incompatible PL/pgSQL functions with conflicting parameter/column names causing "column reference ... is ambiguous" errors

t where there is a conflict. Would it be possible to somehow automatically scan through all functions and getting a list of the functions which have this problem? Thanks! Best regards, Joel Jacobson

[GENERAL] How to access insert/update counts for aborted subtransaction (or current transaction)

tions always return the same results in the same transaction, this is of course what you usually want to happen, but in my case I want the ability to override this. Thankful for any ideas. -- Best regards, Joel Jacobson Glue Finance E: j...@gluefinance.com T: +46 70 360 38 01 Postal address:

[GENERAL] Synchronous replication + Fusion-io = waste of money OR significant performance boost? (compared to normal SATA-based SSD-disks)?

y advice! Best regards, Joel Jacobson Trustly Group AB (former Glue Finance AB) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general