[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 the

[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 fi

[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 fi

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 .sql.in)

Re: [HACKERS] SETOF function call

2005-04-19 Thread Olivier Thauvin
ndry.org/cgi-bin/cvsweb.cgi/pgrpm/pgrpm/pgheader.c?rev=1.1&content-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

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 postgr

[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: Me

[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]$ /usr

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 >

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 relativel