[GENERAL] Migrate from mysql

Hy folks, I'm trying to migrate a database running on mysql for the famous www.redmine.org from mysql to postgresql. I was looking for ressources and I found this : http://www.olimpiks.ru/2011/03/redmine-mysqlpostgresql-converter.html The process is almost perfect except for the binary datas.

Re: [GENERAL] Conditionnal validation for transaction

Le 19/03/2012 16:57, Simon Riggs a écrit : On Mon, Mar 19, 2012 at 3:28 PM, Florent THOMAS wrote: Hy all of you, 1 - Is there a way to have conditions for committing transactions like in oracle : http://www.scribd.com/doc/42831667/47/Validation-conditionnelle-de-transaction-62 2 - Is there

[GENERAL] Conditionnal validation for transaction

Hy all of you, 1 - Is there a way to have conditions for committing transactions like in oracle : http://www.scribd.com/doc/42831667/47/Validation-conditionnelle-de-transaction-62 2 - Is there a way to declare local variables for a SQL statement without beiing in a function? regards

Re: [GENERAL] Multi server query

Great thanks to all of you regards Le 19/03/2012 09:58, Sergey Konoplev a écrit : Hi, On Mon, Mar 19, 2012 at 12:12 AM, Florent THOMAS wrote: How do you query multi servers and multi databases on postgresql? Look at this http://wiki.postgresql.org/wiki/PL/Proxy

[GENERAL] Multi server query

Hy all of you, How do you query _multi servers_ and multi databases on postgresql? Regards

Re: [GENERAL] need a query

and what abourt that : http://www.postgresql.org/docs/8.4/interactive/functions-string.html Le lundi 29 mars 2010 à 14:44 +0600, AI Rumman a écrit : > I need a query to get the initial letter of the words: > Like: > > Ispahani Public School IPS > Ahmed Iftekhar AI > > Any

Re: [GENERAL] PERFORM not working properly, please help..

And what about that : http://www.postgresql.org/docs/8.4/interactive/xfunc-sql.html#XFUNC-SQL-FUNCTIONS-RETURNING-SET Maybe my french english disallowed me to understand right the question, but I think that this item could help in a way! Le vendredi 19 février 2010 à 11:04 +0100, Pavel Stehule a

Re: [GENERAL] Attribute a value to a record

0 à 14:33 +0100, Wappler, Robert a écrit : > On 2010-02-03, Florent THOMAS wrote: > > > Dear laurenz Albe, > > > > Thank you for answering so fast. for me, the variable ventilation_local > > is defined as a record type. So as I wrote on the other mail, I made > >

Re: [GENERAL] Attribute a value to a record

Le mercredi 03 février 2010 à 14:38 +0100, Florent THOMAS a écrit : > Thank you, > > As I posted on a french list, whene I start to develop trigger bigger > than 10lines, I always come back on developper habits and forget > database aspects. > So I WILL PRINT IT ON MY W

Re: [GENERAL] Attribute a value to a record

vrier 2010 à 10:05 +0100, Albe Laurenz a écrit : > Florent THOMAS wrote: > > I'm currently running on pg8.4 and I have a trigger with a loop : > > > > FOR ventilation_local IN (SELECT * FROM XXX) LOOP > > IF (mytest) THEN > > ventilation_local.m

Re: [GENERAL] Attribute a value to a record

D IF; END LOOP; the first notice and the second one are different. Unfortunately, when I get out from the LOOP, the result doesn't seems to be updated in the table Best regards Le mercredi 03 février 2010 à 00:28 +0100, Florent THOMAS a écrit : > Hello, > > I'm currentl

[GENERAL] Attribute a value to a record

Hello, I'm currently running on pg8.4 and I have a trigger with a loop : FOR ventilation_local IN (SELECT * FROM XXX) LOOP IF (mytest) THEN ventilation_local.myfield:=mynewvalue; END IF; END LOOP; my problem is that the record doen't accept the new value. I've chek before the val

Re: [GENERAL] combine SQL SELECT statements into one

Hi, If I were you, I worked like this. First make a union of those three query Then make a crosstab : http://www.postgresonline.com/journal/index.php?/archives/14-CrossTab-Queries-in-PostgreSQL-using-tablefunc-contrib.html documented here : http://www.postgresql.org/docs/8.4/interactive/tablefunc

Re: [GENERAL] problem with triggers

31, 2010 at 4:53 PM, Florent THOMAS wrote: > > Hy everybody, > > > > I have a problem with 2 triggers. > > > > I work on 3 tables : > > table A ==> with one trigger after insert that insert values in table B > > Table B ==> with one trigger after insert

[GENERAL] problem with triggers

Hy everybody, I have a problem with 2 triggers. I work on 3 tables : table A ==> with one trigger after insert that insert values in table B Table B ==> with one trigger after insert that insert values in table C Table C As I insert values on table A, I have a message that indicates the EXECUTE s

[GENERAL] dynamic crosstab

Am I right or is ther a way to let the query generate the columns and there name without naming them? Best regards Florent THOMAS