Hi! Please find attached postgresql-7.3.4-r1.ebuild and a patch so that it will be capable of recursive queries. Syntax will be similar to Oracle's 'CONNECT BY' feature. Patch origin: http://gppl.terminal.ru/index.eng.html (by Evgen Potemkin) Christian
Created attachment 19923 [details] postgresql-7.3.4-r1.ebuild (Update) Recursive queries in PostgreSQL. Syntax alike 'CONNECT BY' in Oracle.
Created attachment 19924 [details, diff] Patch to PostgreSQL: recursive queries Patch from Evgen Potemkin. Url: http://gppl.terminal.ru/index.eng.html
Created attachment 19925 [details] Patch to PostgreSQL: recursive queries readme Original url: http://gppl.terminal.ru/readme.html
hi I think we should create a new local USE flag for this patch because some people including me don't like to apply a thirdparty patch at all times. What do you think?
Created attachment 19963 [details] postgresql-7.3.4-r1.ebuild (Update) new local USE flag: pg-hier for patch application. Else, it will compile as plain ebuild 7.3.4 marked package as masked ('~platform')
I think it is a good idea. I didn't know about local IUSE flags :-<. A new ebuild is submitted (marked as masked), with a local USE flag called 'pg-hier' (normally disabled), which permits patch compilation. Else, it will behave as plain official postgresql-7.3.4.ebuild Thanx for the suggestion :->
Thanks for the change. I noticed another point. It's better to download the patch to distfiles because the patch is not small. If it's fixed I'll commit this ebuild as postgresql-7.3.4-r1. Thanks.
Created attachment 20007 [details] postgresql-7.3.4-r1.ebuild (Update) Hi! New version. Patch file and documentation is downloaded into distfiles as a unique file. Documentation goes into /usr/share/doc/postrgresql-7.3.4-r1 This at the condition that masked packages are selected, and the local IUSE 'pg-hier' flag is setted, else it behaves as plain postrgresql-7.3.4.ebuild
Thank you for the change. I just commited this ebuild to portage tree. Thanks, Masatomo
Thanks :-)