News for hackers. Stuff that matters.
Re:Postgresql 9.3 Released by johnyzee on Monday September 09, 2013 @01:08PM (#6354648)
I am building a (free) web interface for Postgres that aims to be fun and easy to use: http://www.teampostgresql.com

It has a lot of user friendly features particularly for data viewing and navigation, such as clicking through foreign key references to referenced rows, and the other way, looking up rows that reference this one, plus a lot of other stuff that I missed from other admin packages.

There's a demo here: http://teampostgresql.herokuapp.com/

Happy to answer any questions.

Re:Postgresql 9.3 Released by gdulli on Monday September 09, 2013 @06:12PM (#6356616)
It looks promising. I wanted to try it out but I got this error when it was reading the metadata on my database:

"Encountered more 0 entries in index columns list than there were expressions in 'indexprs' expressions list for index 'activity_emd5_00_expr_activity_type_expr1_idx'. Current count = '1', parsed expressions = 1, 'indexprs' value='({OPEXPR :opno 3963 :opfuncid 3948 :opresulttype 25 :opretset false :opcollid 100 :inputcollid 100 :args ({VAR :varno 1 :varattno 6 :vartype 114 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 6 :location 43} {CONST :consttype 25 :consttypmod -1 :constcollid 100 :constlen -1 :constbyval false :constisnull false :location 60 :constvalue 12 [ 48 0 0 0 118 101 114 116 105 99 97 108 ]}) :location 57} {OPEXPR :opno 3963 :opfuncid 3948 :opresulttype 25 :opretset false :opcollid 100 :inputcollid 100 :args ({VAR :varno 1 :varattno 5 :vartype 114 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 5 :location 89} {CONST :consttype 25 :consttypmod -1 :constcollid 100 :constlen -1 :constbyval false :constisnull false :location 108 :constvalue 6 [ 24 0 0 0 105 100 ]}) :location 105})'"

For your reference, here's that index:

"activity_emd5_00_expr_activity_type_expr1_idx" UNIQUE, btree ((source_details ->> 'vertical'::text), activity_type, (activity_details ->> 'id'::text))

Re:Postgresql 9.3 Released by johnyzee on Tuesday September 10, 2013 @02:09AM (#6358445)
Thank you, I will look into this. What is your PG version if I may ask?
Re:Postgresql 9.3 Released by gdulli on Tuesday September 10, 2013 @09:33AM (#6359879)
9.3beta2
Re:Postgresql 9.3 Released by johnyzee on Monday September 23, 2013 @09:01AM (#6430517)
Hey, you might not get this but the issue you reported is now fixed (failure to resolve segmented index expressions after some changes to PG system functions). Thanks for reporting this and let me know if I can help with anything.
Re:Postgresql 9.3 Released by afiler on Monday September 09, 2013 @04:09PM (#6355827)
Is it open-source?
Re:Postgresql 9.3 Released by johnyzee on Tuesday September 10, 2013 @02:11AM (#6358452)
Not currently, but that may change.