Re: [GENERAL] getting around---division by zero on numeric

* sum(cost) / sum(sales) seems very similar to sum(cost). --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29

Re: [SPAM] Re: [GENERAL] Question about stored procedures

You should have a look at the following item of documentation : http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html   Patrick --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18

Re: [GENERAL] ERROR: type "temp_gc" already exists

. The code is somehow more heavy to write but really the application is now robust where it was not... Regards, Patrick --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29

Re: [GENERAL] detection of VACUUM in progress

impacted Or perhaps you could try pg_autovacuum which will run VACUUM for you based on statistics... Regards, Patrick ------- Patrick Fiche email : [EMAIL PROTECTED] tel :

Re: [GENERAL] Removing all users from a group

SELECT RemoveUsersFromGroup( 'test' ) Regards, Patrick   ------- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --

Re: [GENERAL] psql from Linux script

uot;" If it can help you... ---- --- Patrick Fiche email : [EMAIL PROTECTED] tel : 01 69 29 36 18 --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bernard Sen

Re: [GENERAL] getting last day of month

You could try : SELECT int4(EXTRACT( DAYS FROM CURRENT_DATE + '1 month'::interval - CURRENT_DATE )); ------- Patrick Fiche email : [EMAIL PROTECTED] tel : 01 6

Re: [GENERAL] Getting actual number of rows updated

HERE name LIKE '%abc%' ---- --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [GENERAL] template1 problems

Tom Lane recently pointed one excellent article dealing with this problem... http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php Regards, Patrick --- Patrick Fiche email : [EMAIL PROTECTED] tél

Re: [GENERAL] help about the function

ot; GROUP BY "VALIDITY"."RV_ID", "VALIDITY"."VALIDITY") sve;   Regards, Patrick   --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 -

Re: [GENERAL] renumber id's in correct order (compact id's)

gards, Patrick ------- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of peter pilsl Sent: mardi

Re: [GENERAL] Using pg_dump in a cron

Thanks Tom, You are absolutely right, the commandt stty istrip was the first line of my .profile... Regards, Patrick --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18

[GENERAL] Using pg_dump in a cron

ice or address What's wrong with it ? ------- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 ---  

Re: [GENERAL] How to recover from : "Cache lookup failed for rela

ly shut down; automatic recovery in progress LOG: redo starts at 0/A7110340 FATAL: the database system is starting up LOG: record with zero length at 0/A77BF950 LOG: redo done at 0/A77BF918 LOG: database system is ready ERROR: cache lookup failed for relation 463558 CONTEXT: SQL statement "CREATE TEMP TABLE Tmp_

Re: [GENERAL] How to recover from : "Cache lookup failed for rela

--- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom Lane Sent: lundi 23 mai 2005 16:50 To: [EMAIL

Re: [GENERAL] How to recover from : "Cache lookup failed for rela

0 | n ------- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message- From: Tom La

Re: [GENERAL] How to recover from : "Cache lookup failed for rela

tried the following : - REINDEX DATABASE alis; - DROP SCHEMA pg_temp_4 ( CASCADE ) - from the shell : reindexdb alis - Tried to stop/restart PostgreSQL, - vacuum Patrick ---- --- Patrick Fiche email : [EMAIL PROTECTED

[GENERAL] How to recover from : "Cache lookup failed for relation "

that nothing will remove this type   Thanks for your help Patrick ----------- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 ---  

[GENERAL] Execution shell commands from Function

s, Patrick ------- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 ---  

Re: [GENERAL] Password Encryption / PgAdmin

Thanks, I forgot to mention md5 encryption in pg_hba.conf... --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18

[GENERAL] Password Encryption / PgAdmin

--- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 ---  

[GENERAL] pgadmin on Solaris

Hi,   Is Solaris 10 supported platform for pgAdmin III. If yes, where is the distribution or what's the way to compile it on Solaris 10.   Thanks Patrick --- Patrick Fiche email : [EMAIL PROTECTED

[GENERAL] PsqlODBC / Unix

l/lib/psqlodbc.so: symbol ucs2_to_utf8: referenced symbol not found (0)   I didn't succeed in getting psqlodbc traces. Could anyone give me a clue on what's happening and how to correct it ?   Thanks -------

[GENERAL] psqlodbc / Solaris 10

to_ucs2_lf: referenced symbol not found   Does anyone have an idea on how to solve this problem... I guess it's only a configuration issue but don't know how to solve.   Thanks ------- Patrick Fiche emai

Re: [GENERAL] Change Windows path to Unix path...

Thanks, That's exactly what I was looking for. --- Patrick Fiche email : [EMAIL PROTECTED] tel : 01 69 29

[GENERAL] Change Windows path to Unix path...

7;t succeed to replace '\' by '/' in the filename. Could anybody help me.   Thanks Patrick ----------- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 ---  

Re: [GENERAL] Use of temporary tables in functions

  --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: jeudi 21 avril 2005 15

[GENERAL] Use of temporary tables in functions

REINDEX command to free some space on the disk.   Does the problem still exist in version 8 ? Thanks for your answers.   Patrick --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 ---  

Re: [GENERAL] Get Number of milliseconds for an intervall

Sorry, I forgot to say in PL/pgSQL   --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18

[GENERAL] Get Number of milliseconds for an intervall

Hi,   I would like to get the elapsed time in milliseconds between 2 dates... Does anyone have an idea of how to do it ?   Thanks Patrick --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 ---  

Re: [GENERAL] Temporary Tables

needs...     --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message-From: [EMAIL PROT

Re: [GENERAL] Temporary Tables

ution is to use EXECUTE for all queries using temporary tables --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 3

Re: [GENERAL] truncate/create slowness

e case but hope it will help... ------- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Origin

Re: [GENERAL] Books for experienced DB developer

trick --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message- From: Tino Wildenhain [mailto:[EMAIL PROTECTED] Sent: vendredi 7 janvier 2005 12:

Re: [GENERAL] Books for experienced DB developer

I'm afraid this is still a problem. >From my knowledge, Postgres function is able to return a single result-set not multiple. I may have missed some facility... Regards, Patrick --- Patrick Fich

Re: [GENERAL] Books for experienced DB developer

trick --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROT

Re: [GENERAL] Creating index on a view?

Some time ago, an excellent tutorial on materialized views with PostgreSQL was pointed at this address http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Patrick > -- - > Patrick

Re: [GENERAL] Help with syntax for timestamp addition

Have a try at this syntax SELECT number FROM procedures WHERE date + CAST( numdays || ' days' AS interval ) <= CURRENT_TIMESTAMP; Patrick > -- ----- > Patrick Fiche > email : [EMAIL PROTE

Re: [GENERAL] query with table alias

Title: query with table alias The correct query would be "select f.c1, f.c2 from foo f;" if you want to use alias   Patrick   --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 2

Re: [GENERAL] Tables and Indexes

Hi, I think that TABLESPACE is what you need... It's now available in Postgresql, just look at the syntax in documentation. > -- - > Patrick Fiche > email : [EMAIL PROTECTED] > tél

[GENERAL] Possible bug with LABEL and LOOP in 8.0

lity to indicate the LABEL in EXIT statement...   Regards,   Patrick ------- Patrick Fiche email : [EMAIL PROTECTED] ---   Protected by Polesoft Lockspam http://www.polesoft.com/refer.html

Re: [GENERAL] Time at end of transaction

Hi, I think that timeofday() should solve your issue. Just take care that this function returns text instead of timestamp... You will have to cast it. Patrick > -- - > Patrick Fiche > email

[GENERAL] psql : how to make it more silent....

." Is there a way to get rid of these messages   Thanks   ------- Patrick Fiche email : [EMAIL PROTECTED

[GENERAL] Confused with LABEL and LOOP

trol reached end of function without RETURNCONTEXT:  PL/pgSQL function "test"   If I just change EXIT LOOP1 to EXIT -> everything is OK I think we previously had the possibility to indicate the LABEL in EXIT statement...   Regards,   Patrick -----

[GENERAL] Performance for indexes on functions

function used when creating the index : SELECT ... WHERE substr( col1, 1, 5 ) = '.'. Do you recommend or not to use this kind of indexes ? Excuse me it it's not really clear but if necessary, I will try to explain it better... Thanks a lot Patrick FICHE

[GENERAL] Physical data storage

Hi, Does anyone know where I could find a documentation describing physical storage format in Postgres ? Thanks Patrick Fiche