[HACKERS] Missing files after make install ?

2009-02-12 Thread Olivier Thauvin
Hi, I am the packager of postgresql for mandriva, and I receive this bug to today https://qa.mandriva.com/show_bug.cgi?id=47722 postgresql8.3-contribe missed some files like uuid-ossp.sql Description of problem: uuid-ossp was not found in the .spec file By take a look in the /contrib/README

[HACKERS] Missing files after make install ?

2009-02-12 Thread Olivier Thauvin
Hi, I am the packager of postgresql for mandriva, and I receive this bug to today https://qa.mandriva.com/show_bug.cgi?id=47722 postgresql8.3-contribe missed some files like uuid-ossp.sql Description of problem: uuid-ossp was not found in the .spec file By take a look in the /contrib/README

[HACKERS] request feature: alter view add column (or something like)

2008-02-29 Thread Olivier Thauvin
Sometimes, I have to add column to table, then adding the column to some view. Currently it impossible to alter a view to add a new column, which is really annoying. The only solution is to drop the view, and all dependented view, then recreating everything. Someone on #postgresqlfr said me

Re: [HACKERS] [Pgsqlrpms-hackers] ident auth vs. encrypting ident daemons

2006-06-15 Thread Olivier Thauvin
Le jeudi 15 juin 2006 22:29, Tom Lane a écrit : Currently, the Red Hat and (I believe) PGDG RPMs set up ident authentication as the default, by running initdb with --auth='ident sameuser' I think several other binary distros do the same. Just to notice Mandriva still provide

Re: [HACKERS] gprof SELECT COUNT(*) results

2005-11-25 Thread Olivier Thauvin
Le Vendredi 25 Novembre 2005 16:20, Tom Lane a écrit : Qingqing Zhou [EMAIL PROTECTED] writes: I can see your computer is really slow, so my theory is that since it is easy to hold a running-slowly horse than a fast one, so my spinlock on a 2.4G modern machine should takes relatively longer

Re: [HACKERS] PL/php in pg_pltemplate

2005-11-24 Thread Olivier Thauvin
Le Jeudi 24 Novembre 2005 18:07, Peter Eisentraut a écrit : Tom Lane wrote: I don't see any strong reason for enforcing that as policy, if the language maintainer wants an entry. (But is Alvaro the maintainer of pl/php?) My recollection is that we identified some pros and cons of having

[HACKERS] vacuumlo doesn't seems to have help

2005-11-12 Thread Olivier Thauvin
Postresql 8.1.0: I was looking what does vacuumlo provide in contrib, but it seems there is a problem with messages given by this program: [EMAIL PROTECTED] regress]$ /usr/bin/vacuumlo vacuumlo: missing required argument: database name Try 'vacuumlo -?' for help. [EMAIL PROTECTED] regress]$

[HACKERS] Module incompatibility detection between 8.0 and 8.1

2005-11-10 Thread Olivier Thauvin
I just make postgresql 8.1 rpm for mandriva and I was making basic test. I made in pgfoundry the module pgrpm (rpm function in postgres). However after installing postgresql 8.1 I have: ERREUR: unable to load library «/usr/lib64/pgsql/pgrpm.so»: /usr/lib64/pgsql/pgrpm.so: undefined symbol:

Re: [HACKERS] SETOF function call

2005-04-19 Thread Olivier Thauvin
/pgheader.c?rev=1.1content-type=text/x-cvsweb-markup Of course patch/comments are welcome. Regards, Philip. On Tuesday 19 April 2005 11:53, Tom Lane wrote: Olivier Thauvin [EMAIL PROTECTED] writes: Datum header_querytxt(PG_FUNCTION_ARGS) { elog(NOTICE, querytxt); Datum

Re: [HACKERS] Urgent

2005-04-18 Thread Olivier Thauvin
Le Monday 18 April 2005 13:47, ElayaRaja S a écrit : Hi, I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and i have to install postgresql 7.4.5. Plz let me know how to uninstall completely - postfesql 7.3.2 rpm -e postgresql ? I am not sure this kind of question should

[HACKERS] SETOF function call

2005-04-18 Thread Olivier Thauvin
I hope I am on good list, else point me where I should ask. I create a C function like this: CREATE -- IFUPDATE or REPLACE FUNCTION rpmquery(rpmheader, INT) RETURNS SETOF TEXT AS 'MODULE_PATHNAME', 'header_query' LANGUAGE C IMMUTABLE STRICT; (do not take care, code come from the