[pgadmin-support] No text for error messages only numbers
Hi, Since I have upgraded to version 1.6.1, I do not get error messages text any more, only error numbers ! ? ! Is there something to configure to get the text too ? Have fun, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re : [pgadmin-support] No text for error messages only numbers
Sorry, more details : I am running PgAdmin III on Windows XP against a PosgreSQL 8.1 server on Linux (Ubuntu 6.06). I have downloaded PgAdmin from the PgAdmin web site. I am indeed talking about the Query tool. If I type in and run : select sdfgdfh I get the following error message: ERREUR: SQL state: 42703 I would suspect it is something to do with localization and languages. In version 1.4.3, I get the error message: ERREUR: la colonne «sdfgdfh» n'existe pas The error message is (quite clerarly ;-) !) in French, even though I have set up PgAdmin in English Language (File=> Options => General user language: (en_us) English . If anybody could find a way for me to use version 1.6.1 and to get error messages (in French or English, I don't care), that would be a great help. Cheers, [EMAIL PROTECTED] The Travelling Froggy TravellingFroggy.info - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org Envoyé le : Mardi, 5 Décembre 2006, 14h03mn 00s Objet : Re: [pgadmin-support] No text for error messages only numbers Laurent ROCHE wrote: > Hi, > > Since I have upgraded to version 1.6.1, I do not get error messages text any > more, only error numbers ! ? ! > > Is there something to configure to get the text too ? What OS? Did you compile it yourself? I assume you're talking about the query tool, in which case you should get output such as: -- Executing query: select * form pg_class ERROR: syntax error at or near "form" SQL state: 42601 Character: 10 (that's on the History tab). Regards Dave ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re : Re : [pgadmin-support] No text for error messages only numbers
Thanks Dave. I understand the message comes from the PG server, but if I switch PgAdmin to a language, I would have expected LC_MESSAGES to be switched to the same value, so I get server messages in the same language ... but that's a completely separate issue. Let me know if there's anything I can do, to get my error messages in clear text ... in the mean time, I'll stop making errors ! ;-) Thanks again for your help, [EMAIL PROTECTED] - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org; Guillaume Lelarge <[EMAIL PROTECTED]> Envoyé le : Mardi, 5 Décembre 2006, 15h19mn 42s Objet : Re: Re : [pgadmin-support] No text for error messages only numbers Laurent ROCHE wrote: > Sorry, more details : > I am running PgAdmin III on Windows XP against a PosgreSQL 8.1 server on > Linux (Ubuntu 6.06). > I have downloaded PgAdmin from the PgAdmin web site. > > I am indeed talking about the Query tool. > If I type in and run : > select sdfgdfh > > I get the following error message: > ERREUR: > SQL state: 42703 > > I would suspect it is something to do with localization and languages. > In version 1.4.3, I get the error message: > ERREUR: la colonne «sdfgdfh» n'existe pas > > The error message is (quite clerarly ;-) !) in French, even though I have set > up PgAdmin in English Language (File=> Options => General user language: > (en_us) English . > > If anybody could find a way for me to use version 1.6.1 and to get error > messages (in French or English, I don't care), that would be a great help. The error message comes from PostgreSQL, so it'll ve in whatever language the server sends to pgAdmin. Guillaume - are you able to test this? Any idea what's going on? Regards, Dave. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ___ Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire. http://fr.mail.yahoo.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re : Re : [pgadmin-support] No text for error messages only numbers
Any news about this problem, anyone ? Have fun, [EMAIL PROTECTED] The Travelling Froggy TravellingFroggy.info - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org; Guillaume Lelarge <[EMAIL PROTECTED]> Envoyé le : Mardi, 5 Décembre 2006, 15h19mn 42s Objet : Re: Re : [pgadmin-support] No text for error messages only numbers Laurent ROCHE wrote: > Sorry, more details : > I am running PgAdmin III on Windows XP against a PosgreSQL 8.1 server on > Linux (Ubuntu 6.06). > I have downloaded PgAdmin from the PgAdmin web site. > > I am indeed talking about the Query tool. > If I type in and run : > select sdfgdfh > > I get the following error message: > ERREUR: > SQL state: 42703 > > I would suspect it is something to do with localization and languages. > In version 1.4.3, I get the error message: > ERREUR: la colonne «sdfgdfh» n'existe pas > > The error message is (quite clerarly ;-) !) in French, even though I have set > up PgAdmin in English Language (File=> Options => General user language: > (en_us) English . > > If anybody could find a way for me to use version 1.6.1 and to get error > messages (in French or English, I don't care), that would be a great help. The error message comes from PostgreSQL, so it'll ve in whatever language the server sends to pgAdmin. Guillaume - are you able to test this? Any idea what's going on? Regards, Dave. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ___ Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire. http://fr.mail.yahoo.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[pgadmin-support] Backup dialog window: bad size
Hi, I assume this has been told before ... but as I did not find anything about it in the mailing list archive ! With PgAdmin III 1.6.1 on WinNT SP2. The Backup dialog window (that pops up when doing Tools ==> backup ...) is sized too small: the "..." button (to browse for a file) is not visible (and the right side of the group boxes either). It should be better sized. And in French language, the options group box is too small: the text for the checboxes labels is over the right side of the box. Extra: a little feature request ! If the directory path for the file (when clicking on the "..." button) could be kept from one file generation to another, that would be great ! And if the filename could be *also* kept ... we would get close to perfect ;-) ... on that feature ! Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Erwin Brandstetter <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] Cc : pgadmin-support@postgresql.org Envoyé le : Jeudi, 7 Décembre 2006, 12h49mn 25s Objet : Re: [pgadmin-support] Comments cut off after line break [EMAIL PROTECTED] wrote: > Erwin Brandstetter wrote: > >> Maybe this happens on purpose to shorten lengthy comments. > > It does. > >> But then again, a better way would probably be to print the first x >> (200?) characters (substituting spaces for linebreaks) and append ' >> ...' if there is more. > > Chopping at the first line is more flexible as it allows the user some > control over what is shown there. I have committed a change to add ... > if it truncates at all though. Even better so, I agree. Regards Erwin ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re : Re : Re : [pgadmin-support] No text for error messages only numbers
Hi, OK, I have found what the problem is ! My databases are in UTF8, with another charset (LATIN1, ...) that works fine. And I have checked: pgAdmin III v 1.4.3 can display the error messages of a UTF8 database (as well as non UTF8). So something got broken along the way ! Good luck fixing it. Any estimates for the roll-out of 1.6.2 ? (I have read the the particulary annoying bug of empty tables not being editable is fixed in 1.6.2) Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Guillaume Lelarge <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Envoyé le : Vendredi, 8 Décembre 2006, 17h02mn 56s Objet : Re: Re : Re : [pgadmin-support] No text for error messages only numbers Laurent ROCHE a ecrit le 08/12/2006 17:01: > Postgres is: > "PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC gcc-4.0.gcc-opt (GCC) > 4.0.3 (Ubuntu 4.0.3-1ubuntu5)" > > And PgAdmin v 1.6.1 does not work when PgAdmin 1.4.3 does work. > > But, as I said in another message, strangely, on the same server, I do get > error messages (with 1.6.1) with one database and no error message with the > other ! ? ! > I am going to investigate a bit more to find out what are the differences > between the databases (and narrow it down to simple example) , and I will > post an update. > OK, thanks. Just keep me informed. -- Guillaume. ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re : [pgadmin-support] No text for error messages only numbers
Any news about that one ? Have fun, [EMAIL PROTECTED] The Travelling Froggy TravellingFroggy.info - Message d'origine De : Laurent ROCHE <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Cc : [EMAIL PROTECTED] Envoyé le : Jeudi, 14 Décembre 2006, 16h33mn 25s Objet : Re : Re : Re : [pgadmin-support] No text for error messages only numbers Hi, OK, I have found what the problem is ! My databases are in UTF8, with another charset (LATIN1, ...) that works fine. And I have checked: pgAdmin III v 1.4.3 can display the error messages of a UTF8 database (as well as non UTF8). So something got broken along the way ! Good luck fixing it. Any estimates for the roll-out of 1.6.2 ? (I have read the the particulary annoying bug of empty tables not being editable is fixed in 1.6.2) Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Guillaume Lelarge <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Envoyé le : Vendredi, 8 Décembre 2006, 17h02mn 56s Objet : Re: Re : Re : [pgadmin-support] No text for error messages only numbers Laurent ROCHE a ecrit le 08/12/2006 17:01: > Postgres is: > "PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC gcc-4.0.gcc-opt (GCC) > 4.0.3 (Ubuntu 4.0.3-1ubuntu5)" > > And PgAdmin v 1.6.1 does not work when PgAdmin 1.4.3 does work. > > But, as I said in another message, strangely, on the same server, I do get > error messages (with 1.6.1) with one database and no error message with the > other ! ? ! > I am going to investigate a bit more to find out what are the differences > between the databases (and narrow it down to simple example) , and I will > post an update. > OK, thanks. Just keep me informed. -- Guillaume. ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re : Re : [pgadmin-support] No text for error messages only numbers
Well, that I would not know till 1.6.2 is realeased ! ;-) Thanks for trying. I will see how it goes when 1.6.2 goes out. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Guillaume Lelarge <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org Envoyé le : Mardi, 19 Décembre 2006, 23h54mn 20s Objet : Re: Re : [pgadmin-support] No text for error messages only numbers Laurent ROCHE a écrit : > Any news about that one ? > I still can't reproduce it. My databases are also in UTF-8. Some are in LATIN1. I tried with en and fr pgAdmin. I have no problem. But I'm using 1.6.2. Perhaps Dave already fixed it ? Regards. -- Guillaume. ___ Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire. http://fr.mail.yahoo.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[pgadmin-support] PG Admin on the command line = pg_dump
Hi, I would like to automate the generation of a backup script of a schema (which I used to perform with PG Admin backup command). I looked into pg_dump command: it does the job BUT not correctly for me as it does not create SERIAL column but INTEGER and then it creates SEQUENCES (I have scripts parsing the generated SQL file and looking for SERIAL columns). I was wondering if it is possible to use command line switches to make the fantastic PG Admin III generate a script (without any user interaction). I could not see any thing in the doc about that, so I am asking you guys and gals. Cheers, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re : [pgadmin-support] PG Admin on the command line = pg_dump
Hi, I am puzzled why when I use pg_dump I get a script with INTEGER and SEQUENCE and when you (i.e. PG Admin) use pg_dump you get a script with SERIAL ? Do you pass extra undocumented options to pg_dump ? What version of pg_dump do you use in PG Admin III 1.6.1 ? (I have used 8.1 and 8.2 with the same results) Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org Envoyé le : Mercredi, 27 Décembre 2006, 10h07mn 18s Objet : Re: [pgadmin-support] PG Admin on the command line = pg_dump Laurent ROCHE wrote: > Hi, > > I would like to automate the generation of a backup script of a schema (which > I used to perform with PG Admin backup command). > I looked into pg_dump command: it does the job BUT not correctly for me as it > does not create SERIAL column but INTEGER and then it creates SEQUENCES (I > have scripts parsing the generated SQL file and looking for SERIAL columns). > > I was wondering if it is possible to use command line switches to make the > fantastic PG Admin III generate a script (without any user interaction). > I could not see any thing in the doc about that, so I am asking you guys and > gals. pgAdmin just uses pg_dump to generate it's backup scripts, so we don't have any command line options to this as we'd just say 'use pg_dump'. Regards, Dave. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org ___ Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire. http://fr.mail.yahoo.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] Still no text for error messages only numbers for 1.6.2 (aka the Saga continues)
Hi All (and Guillaume), Happy new year to all ... with less crazy bugs for everyone than in 2006 (and that's including me ... please). So I have upgraded to the latest and shiny PGAdmin 1.6.2 ... and I still have the same problem I had in 1.6.1. If I have a database set with UTF-8 character set then when I type the following (in the query tool window): sdfhsdfj I get: ERREUR: État SQL :42601 Caractère : 1 In a query tool with LATIN1 or SQL_ASCII characterset, I get: ERREUR: erreur de syntaxe sur ou près de «sdfhsdfj» État SQL :42601 Caractère : 1 Which is what I would expect (at least till the PG syntax de not change ;-) ! ). I do not have this problem with PG Admin 1.4.3, which will write: ERREUR: erreur de syntaxe sur ou près de «sdfhsdfj» au caractère 1 Of course, you would have guessed from the error messages that I am in French locale for the client (Windows XP SP2) and for the Server (Ubuntu 6.06, PG 8.1). Let me know if you need more info about this. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Laurent ROCHE <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Cc : [EMAIL PROTECTED] Envoyé le : Jeudi, 14 Décembre 2006, 16h33mn 25s Objet : Re : Re : Re : [pgadmin-support] No text for error messages only numbers Hi, OK, I have found what the problem is ! My databases are in UTF8, with another charset (LATIN1, ...) that works fine. And I have checked: pgAdmin III v 1.4.3 can display the error messages of a UTF8 database (as well as non UTF8). So something got broken along the way ! Good luck fixing it. Any estimates for the roll-out of 1.6.2 ? (I have read the the particulary annoying bug of empty tables not being editable is fixed in 1.6.2) Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Guillaume Lelarge <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Envoyé le : Vendredi, 8 Décembre 2006, 17h02mn 56s Objet : Re: Re : Re : [pgadmin-support] No text for error messages only numbers Laurent ROCHE a ecrit le 08/12/2006 17:01: > Postgres is: > "PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC gcc-4.0.gcc-opt (GCC) > 4.0.3 (Ubuntu 4.0.3-1ubuntu5)" > > And PgAdmin v 1.6.1 does not work when PgAdmin 1.4.3 does work. > > But, as I said in another message, strangely, on the same server, I do get > error messages (with 1.6.1) with one database and no error message with the > other ! ? ! > I am going to investigate a bit more to find out what are the differences > between the databases (and narrow it down to simple example) , and I will > post an update. > OK, thanks. Just keep me informed. -- Guillaume. ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com __ Do You Yahoo!? En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible contre les messages non sollicités http://mail.yahoo.fr Yahoo! Mail ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] Backup file not UTF-8 (introduced bug in 1.6.2)
Hi, A bug has been introduced in the version 1.6.2: when backing up in a file, the file produced is not in UTF-8 format even though it is specified in the preferences. That used to work in 1.6.1 Cheers, [EMAIL PROTECTED] The Computing Froggy __ Do You Yahoo!? En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible contre les messages non sollicités http://mail.yahoo.fr Yahoo! Mail ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re : Re : [pgadmin-support] Backup file not UTF-8 (introduced bug
Hi, But the problem is that using pg_dump does not produce the same file format than PG Admin (re: SERIAL, see on of my previous post). So you are using the pg_dump routine when I use the command line: it's different anyway with different options. Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]>; "pgadmin-support@postgresql.org" Envoyé le : Mercredi, 10 Janvier 2007, 9h46mn 16s Objet : Re: Re : [pgadmin-support] Backup file not UTF-8 (introduced bug Laurent ROCHE wrote: > Well, something changed between the two versions ... as I don't get the file > in the same format I used to have. The only thing that's changed in the backup code since 1.6.0 is the copyright comment and a line of code to center the dialogue over it's parent. The culprit is almost certainly pg_dump - try running it from the command line and see what happens. Regards, Dave ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re : Re : Re : [pgadmin-support] Backup file not UTF-8 (introduced bug
Hurrah ! End of a long story ! I should have read the messages from the backup dialog more carefully, and I would have seen the pg_dump command ! And I would have noticed that PG Admin uses its own pg_dump. So my problems (using pg_dump v8.2 instead of PG Admin: SERIAL replaced by INT and SEQUENCES, and going from v1.6.1 to v1.6.2: wrong UTF-8 format) can be solved just by using a previous version of pg_dump (the one from PGAdmin 1.4., for example) to generate my file. Sorry for being a pain. And thanks for solving that problem in the end. Saying that, as Guillaume suggested, it could be a good idea to be able to choose the pg_dump, one wants to use with PG Admin ... but I suppose replacing the pg_dump.exe file in the PG Admin directory should do the trick. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org Envoyé le : Mercredi, 10 Janvier 2007, 10h56mn 47s Objet : Re: Re : Re : [pgadmin-support] Backup file not UTF-8 (introduced bug Laurent ROCHE wrote: > Hi, > > But the problem is that using pg_dump does not produce the same file format > than PG Admin (re: SERIAL, see on of my previous post). So you are using the > pg_dump routine when I use the command line: it's different anyway with > different options. > How can it not produce the same file format - it calls pg_dump to do the backup!! As for the options, pgAdmin shows the command line it uses on the messages tab when you run the backup so you can easily duplicate what it's doing. Regards, Dave __ Do You Yahoo!? En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible contre les messages non sollicités http://mail.yahoo.fr Yahoo! Mail ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[pgadmin-support] Re : Still no text for error messages only numbers for 1.6.2 (aka the Saga continues)
Hi, Can anyone help me, on this one ? Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Laurent ROCHE <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Cc : [EMAIL PROTECTED] Envoyé le : Mardi, 9 Janvier 2007, 15h39mn 57s Objet : Still no text for error messages only numbers for 1.6.2 (aka the Saga continues) Hi All (and Guillaume), So I have upgraded to the latest and shiny PGAdmin 1.6.2 ... and I still have the same problem I had in 1.6.1. If I have a database set with UTF-8 character set then when I type the following (in the query tool window): sdfhsdfj I get: ERREUR: État SQL :42601 Caractère : 1 In a query tool with a database set with LATIN1 or SQL_ASCII characterset, I get: ERREUR: erreur de syntaxe sur ou près de «sdfhsdfj» État SQL :42601 Caractère : 1 Which is what I would expect (at least till the PG syntax does not change ;-) ! ). I do not have this problem with PG Admin 1.4.3, which will write: ERREUR: erreur de syntaxe sur ou près de «sdfhsdfj» au caractère 1 Of course, you would have guessed from the error messages that I am in French locale for the client (Windows XP SP2) and for the Server (Ubuntu 6.06, PG 8.1). Let me know if you need more info about this. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine ---- De : Laurent ROCHE <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Cc : [EMAIL PROTECTED] Envoyé le : Jeudi, 14 Décembre 2006, 16h33mn 25s Objet : Re : Re : Re : [pgadmin-support] No text for error messages only numbers Hi, OK, I have found what the problem is ! My databases are in UTF8, with another charset (LATIN1, ...) that works fine. And I have checked: pgAdmin III v 1.4.3 can display the error messages of a UTF8 database (as well as non UTF8). So something got broken along the way ! Good luck fixing it. Any estimates for the roll-out of 1.6.2 ? (I have read the the particulary annoying bug of empty tables not being editable is fixed in 1.6.2) Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Guillaume Lelarge <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Envoyé le : Vendredi, 8 Décembre 2006, 17h02mn 56s Objet : Re: Re : Re : [pgadmin-support] No text for error messages only numbers Laurent ROCHE a ecrit le 08/12/2006 17:01: > Postgres is: > "PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC gcc-4.0.gcc-opt (GCC) > 4.0.3 (Ubuntu 4.0.3-1ubuntu5)" > > And PgAdmin v 1.6.1 does not work when PgAdmin 1.4.3 does work. > > But, as I said in another message, strangely, on the same server, I do get > error messages (with 1.6.1) with one database and no error message with the > other ! ? ! > I am going to investigate a bit more to find out what are the differences > between the databases (and narrow it down to simple example) , and I will > post an update. > OK, thanks. Just keep me informed. -- Guillaume. ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com __ Do You Yahoo!? En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible contre les messages non sollicités http://mail.yahoo.fr Yahoo! Mail ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re : [pgadmin-support] Re : Still no text for error messages only numbers for 1.6.2 (aka the Saga continues)
Hi Christophe, It does not change a thing ! If I type: SET client_encoding TO 'LATIN9'; sdfghsdfh; In 1.6.2, I get: ERREUR: État SQL :42601 Caractère : 37 When in 1.4.3, I get : ERREUR: erreur de syntaxe sur ou près de «sdfghsdfh» au caractère 1 And in 1.6.2, but LATIN1 character set database, I get: ERREUR: erreur de syntaxe sur ou près de «sdfghsdfh» État SQL :42601 Caractère : 37 Let me know, if I can help some more. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Christophe Chauvet <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org Envoyé le : Lundi, 15 Janvier 2007, 18h13mn 47s Objet : Re: [pgadmin-support] Re : Still no text for error messages only numbers for 1.6.2 (aka the Saga continues) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Laurent Can you try this SET client_encoding TO 'LATIN9' before sending your query ? Christophe. P.S .You can send me your answer in french if you prefer ? Laurent ROCHE a écrit : > Hi, > > Can anyone help me, on this one ? > > > Have fun, > [EMAIL PROTECTED] > The Computing Froggy > > - Message d'origine > De : Laurent ROCHE <[EMAIL PROTECTED]> > À : pgadmin-support@postgresql.org > Cc : [EMAIL PROTECTED] > Envoyé le : Mardi, 9 Janvier 2007, 15h39mn 57s > Objet : Still no text for error messages only numbers for 1.6.2 (aka the Saga > continues) > > Hi All (and Guillaume), > > > So I have upgraded to the latest and shiny PGAdmin 1.6.2 ... and I still have > the same problem I had in 1.6.1. > > If I have a database set with UTF-8 character set then when I type the > following (in the query tool window): > sdfhsdfj > I get: > ERREUR: > État SQL :42601 > Caractère : 1 > > In a query tool with a database set with LATIN1 or SQL_ASCII characterset, I > get: > ERREUR: erreur de syntaxe sur ou près de «sdfhsdfj» > État SQL :42601 > Caractère : 1 > > Which is what I would expect (at least till the PG syntax does not change ;-) > ! ). > > I do not have this problem with PG Admin 1.4.3, which will write: > ERREUR: erreur de syntaxe sur ou près de «sdfhsdfj» au caractère 1 > > Of course, you would have guessed from the error messages that I am in French > locale for the client (Windows XP SP2) and for the Server (Ubuntu 6.06, PG > 8.1). > > Let me know if you need more info about this. > > > > Cheers, > [EMAIL PROTECTED] > The Computing Froggy > > - Message d'origine > De : Laurent ROCHE <[EMAIL PROTECTED]> > À : pgadmin-support@postgresql.org > Cc : [EMAIL PROTECTED] > Envoyé le : Jeudi, 14 Décembre 2006, 16h33mn 25s > Objet : Re : Re : Re : [pgadmin-support] No text for error messages only > numbers > > Hi, > > OK, I have found what the problem is ! > My databases are in UTF8, with another charset (LATIN1, ...) that works fine. > > And I have checked: pgAdmin III v 1.4.3 can display the error messages of a > UTF8 database (as well as non UTF8). > So something got broken along the way ! > > Good luck fixing it. > > Any estimates for the roll-out of 1.6.2 ? > (I have read the the particulary annoying bug of empty tables not being > editable is fixed in 1.6.2) > > > Cheers, > [EMAIL PROTECTED] > The Computing Froggy > > > - Message d'origine > De : Guillaume Lelarge <[EMAIL PROTECTED]> > À : Laurent ROCHE <[EMAIL PROTECTED]> > Envoyé le : Vendredi, 8 Décembre 2006, 17h02mn 56s > Objet : Re: Re : Re : [pgadmin-support] No text for error messages only > numbers > > Laurent ROCHE a ecrit le 08/12/2006 17:01: >> Postgres is: >> "PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC gcc-4.0.gcc-opt >> (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)" >> >> And PgAdmin v 1.6.1 does not work when PgAdmin 1.4.3 does work. >> >> But, as I said in another message, strangely, on the same server, I do get >> error messages (with 1.6.1) with one database and no error message with the >> other ! ? ! >> I am going to investigate a bit more to find out what are the differences >> between the databases (and narrow it down to simple example) , and I will >> post an update. >> > > OK, thanks. Just keep me informed. > > - -- Christophe Chauvet <[EMAIL PROTECTED]> AZNetwork -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (MingW32) iD8DBQFFq7ZKMl/S4ZhUIzERApc6AKC9YjnE1LbaDHVi1GIObzwxbLLYiwCgmhDA UKUfpk9I61+9rGL6XsL6Y/c= =HIPu -END PGP SIGNATURE- ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re : [pgadmin-support] Re : Still no text for error messages only
Thanks Guillaume, for having a look again. Last time, you looked: I had 1.6.1 and you were using 1.6.2 (kind of beta: from the source), and we thought it will be solved with the new version. But it's not ! I have done a new test: I create a new db with UTF8, and another with LATIN1. If I type an incorrect command in a SQL editor connected to the LATIN1 db, I get the error message, and when connected to the UTF8 db I get the error message only with the number. Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Guillaume Lelarge <[EMAIL PROTECTED]> À : Dave Page <[EMAIL PROTECTED]> Cc : Laurent ROCHE <[EMAIL PROTECTED]>; pgadmin-support@postgresql.org Envoyé le : Lundi, 15 Janvier 2007, 18h47mn 34s Objet : Re: [pgadmin-support] Re : Still no text for error messages only Dave Page a ecrit le 15/01/2007 17:46: > Did you get a chance to look at this Guillaume? > I already looked at this and wasn't able to reproduce it. I will try again tonight. Perhaps I missed something. Regards. -- Guillaume. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re : Re : [pgadmin-support] Re : Still no text for error messages
Hi, I have installed a Win32 PG 8.1.5 on my machine and I can not reproduce this bug on that server. So it is server dependant: you knew that already as you could not reproduce the bug. ;-) Still, it is also client dependant, as I get correct error messages with PG Admin 1.4.3 (on the other server) ! ? ! ? The non working server configuration is Ubuntu 6.06 (Dapper Drake-installed in French) and Postgres 8.1.4: PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC gcc-4.0.gcc-opt (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5) I did not install Postgres, so I do not know the options used to install it. It should be the default install (pretty much): if you need me to give details (a conf file or something else). Let me know, and I will provide it. However, you will have to be fairly precise as I am quite new to PostgreSQL. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Guillaume Lelarge <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org Envoyé le : Mardi, 16 Janvier 2007, 0h41mn 48s Objet : Re: Re : [pgadmin-support] Re : Still no text for error messages Laurent ROCHE a écrit : > Thanks Guillaume, for having a look again. > > Last time, you looked: I had 1.6.1 and you were using 1.6.2 (kind of beta: > from the source), and we thought it will be solved with the new version. > But it's not ! > > I have done a new test: I create a new db with UTF8, and another with LATIN1. > If I type an incorrect command in a SQL editor connected to the LATIN1 db, I > get the error message, and when connected to the UTF8 db I get the error > message only with the number. > OK, I think it would be really helpful to get all informations. I tried with a 8.2.1 postgresql server that I configured with ./configure --prefix=/home/guillaume/pgsql-8.2.1 --enable-nls I then compiled and installed it make && make install I initialized the cluster : initdb -D /home/guillaume/pgsql-8.2.1/data and created two databases : createdb -E LATIN1 dblatin1 createdb -E UTF8 dbutf8 When I try to execute a wrong query (select * from jkdqlsdjkfhqklsdjh), I always have the error number and the error string. Can you give us more details ? for example, which options did you use to initialize the cluster ? Regards. -- Guillaume. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[pgadmin-support] COPY my_table FROM STDIN
Hi, I am trying to run a COPY my_table FROM STDIN from pgAdmin ... but I can not manage to get it to work ! It runs with psql ! Here is a short version of the command: COPY xfrt.import_cpts FROM STDIN; 1DG 16930 7 JAN 071 2DG 25430 7 JAN 072 3DG 34617 7 JAN 073 \. Am I missing something obvious ? Cheers, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[pgadmin-support] Vacuum nag !
Hi, I am working on an import of databases, so I keep dropping and re-creating schemas, and then populating tables. Even, if I do a VACUUM ANALYSE on the entire DB, PG Admin will prompt me to perform a VACUUM when I use one of the tables populated. Is this normal ? I would have thought that considering I have already done a VACUUM ANALYSE, I would not need to do it again ! ;-) ... or am I missing something ? I could check the "don't give me experts advice" in the preferences, but as I am quite a newbee in PG, I feel I need them ! ;-) Cheers, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[pgadmin-support] Crash and sending report !
Hi, When ever there's a crash (it's about every other time ... when I close PG Admin ... so no big deal ;-) !) is it worth me sending the report to Microsoft ? Does it get to the PG Admin people in the end ? Cheers, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-support] Crash at closing [was: Crash and sending report !]
I am closing it, mostly by clicking on the close button (red arrow) ... but not always. It does not always crash (tryed just now, but no closed OK) ... but I won't be able to tell what's making it crash. I have set the debug log in the parameters so at the next crash, I will send the log. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]>; pgAdmin Support Envoyé le : Vendredi, 19 Janvier 2007, 12h31mn 28s Objet : Re: Re : [pgadmin-support] Crash and sending report ! Laurent ROCHE wrote: > Hi, > > The crashes happen when I close PG Admin (v 1.6.2). But because of my error > messages problems (see other posts) I run PG A 1.4.3 too (for the SQL editor). > So maybe, there's conflict (freeing libraries or something like this ?). > > I am not bothered about it, as it's an unusual situation to run two different > versions side to side ... and it only crashes when exiting the program. > OK, I'm losing track of the threads here - seems this one got hijacked and I didn't notice :-( How do you close pgAdmin? Does it always crash, or only after performing a specific task? (running 2 versions in parallel should not matter) Regards, Dave ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[pgadmin-support] Bad Tabulation in French
Hi, Guillaume, (or whoever is in charge of French localisation for Preferences), There's a problem when selecting "Tabulation" as field separator, the separator is ... "Tabulation" I mean the string not the actual Tab character: probably too much translation here ! ;-) Have fun, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[pgadmin-support] Copy from Edit data, Paste into OpenOffice Spreadsheet
Hi Gals & Guys, Any of you has achived to copy Copy from Edit data window and then Paste into OpenOffice Spreadsheet ? I have tryed to change the field separators parameter (File ==> Preferences, Request tab) but I still get everything into one column ! It's probably an OOo bug, but I wondered whether there is a solution for this (except to paste the data into a text file and open the text file into OOo spreadsheet, which I did). Cheers, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re : [pgadmin-support] Copy from Edit data, Paste into OpenOffice Spreadsheet
Well, it works for me too ... in english ! It's down to the problem I mentioned in another post: when using the French version "Tab" is translated by "Tabulation" and does not produce Tab separated file ! I just need to shorten the string from Tabulation to Tab ... and it works even in French ! I suppose an easy way to avoid this would be to have a choice of separation characters with radio buttons (; , | tab) and the last one with an edit zone to be able to type in your own ! Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org; [EMAIL PROTECTED] Envoyé le : Vendredi, 19 Janvier 2007, 17h24mn 56s Objet : Re: [pgadmin-support] Copy from Edit data, Paste into OpenOffice Spreadsheet Laurent ROCHE wrote: > Hi Gals & Guys, > > Any of you has achived to copy Copy from Edit data window and then Paste > into OpenOffice Spreadsheet ? > > I have tryed to change the field separators parameter (File ==> Preferences, > Request tab) but I still get everything into one column ! > It's probably an OOo bug, but I wondered whether there is a solution for this > (except to paste the data into a text file and open the text file into OOo > spreadsheet, which I did). Tab works for me using NeoOffice on Mac (NeoOffice is a port of OpenOffice to Mac's Aqua interface). Regards, Dave ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 6: explain analyze is your friend
[pgadmin-support] Re : Crash at closing [was: Crash and sending report !]
Just add a crash when closing ! Here is what I could get from MS crash report: AppName: pgadmin3.exe AppVer: 1.6.2.99 ModName: ntdll.dll ModVer: 5.1.2600.2180 Offset: 00018fea Not sure that can help. If there's way to get more info let me know ! Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Laurent ROCHE <[EMAIL PROTECTED]> À : Dave Page <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org Envoyé le : Vendredi, 19 Janvier 2007, 13h33mn 15s Objet : Crash at closing [was: Crash and sending report !] I am closing it, mostly by clicking on the close button (red arrow) ... but not always. It does not always crash (tryed just now, but no closed OK) ... but I won't be able to tell what's making it crash. I have set the debug log in the parameters so at the next crash, I will send the log. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]>; pgAdmin Support Envoyé le : Vendredi, 19 Janvier 2007, 12h31mn 28s Objet : Re: Re : [pgadmin-support] Crash and sending report ! Laurent ROCHE wrote: > Hi, > > The crashes happen when I close PG Admin (v 1.6.2). But because of my error > messages problems (see other posts) I run PG A 1.4.3 too (for the SQL editor). > So maybe, there's conflict (freeing libraries or something like this ?). > > I am not bothered about it, as it's an unusual situation to run two different > versions side to side ... and it only crashes when exiting the program. > OK, I'm losing track of the threads here - seems this one got hijacked and I didn't notice :-( How do you close pgAdmin? Does it always crash, or only after performing a specific task? (running 2 versions in parallel should not matter) Regards, Dave ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[pgadmin-support] Re : Re : Crash at closing [was: Crash and sending report !]
Unfortunately, as I have said earlier, I haven't found the way to reproduce the bug ... I just know that once in a while it crashes. Is there a way, to set up a debug/trace mode, so I can send you a debug log when it crashes ? Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org Envoyé le : Vendredi, 26 Janvier 2007, 9h50mn 59s Objet : Re: Re : Crash at closing [was: Crash and sending report !] Laurent ROCHE wrote: > Just add a crash when closing ! > > Here is what I could get from MS crash report: > AppName: pgadmin3.exe AppVer: 1.6.2.99 ModName: ntdll.dll > ModVer: 5.1.2600.2180 Offset: 00018fea > > Not sure that can help. Unfortunately not. > If there's way to get more info let me know ! A reproducable way to crash it would be a huge help! Regards, Dave. ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re : [pgadmin-support] Crashing v1.6.2 with a syntax error
Hello Erwin, I am interested in the part "I get an error message with only the error code". I have the same problem, however in the rest of your message you do have an error message with the error code " FEHLER: Fehler »Syntaxfehler« bei »loc« SQL state: 42601 Character: 1" How do you achieve this ? My problem is that, if my database is in UTF-8, I will not get any error messages, just the code. Is that the same for you ? Have you found a solution to have an error message ? So far we have not been able to reproduce this error: it seems its due to my PG server configuration (Ubuntu with French locale), other configurations (including on WinXP machine) work fine. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Erwin Brandstetter <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Mercredi, 21 Février 2007, 2h06mn 21s Objet : [pgadmin-support] Crashing v1.6.2 with a syntax error Hi developers! Hi Dave! Testing pgAdmin III v1.6.2 rev: 5837, client Win XP, host Debian Sarge, PG 8.1.4. / Debian Etch, PG 8.2.1. I have found a 'reliable' way to crash pgAdmin. Look at the following query: select * from loc where loc like 'a%' loc = 'b'; Note the syntax error: "and" is missing in the WHERE clause. If I run this from the SQL query dialogue window I get an error message with only the error code - but that has been reported before. FEHLER: Fehler »Syntaxfehler« bei »loc« SQL state: 42601 Character: 1 However, if I open the edit grid with a filter and enter the faulty WHERE clause, pgAdmin crashes. I have run tests with a variety of tables and operators in PG 8.1.4 and PG 8.2.1. Any of the following WHERE clauses triggers a crash. fld1 like 'a%' fld2 = 'b' fld1 = 'a%' fld2 = 'b' fld1 = 'a%' fld1 = '%a%' ... The "essential" part ist the "%" at the end of the first string. An observation I have made along the way: Look at the error message I get from pgAdmin for the following WHERE clause: loc = '%a' loc = '' Note that the % is in front this time (does not trigger a crash). An error has occurred: FEHLER: Fehler >>Syntaxfehler<< bei >>b<< Line 1: EXPLAIN SELECT * FROM loc WHERE loc = '0x1.1f9d8ap-997' loc = '' ^ The string containing the character "%" is scrambled in a weird way. The caret in the next line points to a seemingly random position. If I run it from psql, I get a similar error message. Only the string is not scrambled, and the caret is in a reasonable position. event=# select * from loc where loc = '%a' loc = ''; FEHLER: Fehler »Syntaxfehler« bei »loc« at character 36 ZEILE 1: select * from loc where loc = '%a' loc = ''; ^ I have tried to switch the "user language" in the pgAdmin options from English to German. To no effect. It might have to do with locales. From my postgresql.conf: lc_messages = '[EMAIL PROTECTED]' I have tried changing it to: lc_messages = 'C' After that the error message was scrambled differently: loc = '%a' loc = '' An error has occurred: ERROR: syntax error at or near "loc" LINE 1: EXPLAIN SELECT * FROM loc WHERE loc = '0x1.518a0fp-1002' loc = '' ^ But it crashes just as well. loc = 'a%' loc = '' Regards Erwin ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re : [pgadmin-support] pgadmin as main postgresql GUI interface
Hi, my two cents on that interesting thread: I come from a database developer background. I have used quite a few tools in the past years on different RDBMs (mainly Sybase, MS SQL-Server, and a bit of Oracle). When I have started using PG at the end of last year, I looked at the tools around. I am quite pleased with PG Admin but I was also looking at other tools of easier access for non developer users. I did not find any thing really satisfying but using OOo connecting with JDBC, did the job OK : it is possible to browse through the tables, to create queries graphically and to modify tables. I even used it at the beginning to create queries graphically (when I did not the DB well). Today, I do not use it anymore, but some in our team do, and that works OK for not too demanding users. Also you might want to have a look at DB-Visualizer: it's more a developper tool but it could work for you too. Last point (but not least ;-) ! ), we are only using OOo on Windows XP, so I don't know about the reliability on AMD with Debian, but the functions should be the same. May be the JDBC connection will solve some of your troubles. Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Seb <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Dimanche, 25 Février 2007, 6h05mn 45s Objet : Re: [pgadmin-support] pgadmin as main postgresql GUI interface On Sat, 24 Feb 2007 19:54:13 +0100, Michael Eschweiler <[EMAIL PROTECTED]> wrote: [...] > You could try knoda (www.knoda.org) and/or rekall > (www.rekallrevealed.org). Unless you don't want do more complicated > things knoda could be a good choice (but I don't know nothing about the > report generator - I never used it). As of my experience knoda seems to > be a little buggy: For example if you try to trigger some code in python > from a combobox the program executes it twice. But for simple purposes > it should work. I tried rekall in a very early stage (2 or 3 years ago) > but as the layout of texts in the different widgets on the screen wasn't > that good, and as I wanted to work with larger texts I changed to > knoda. Now rekall seems to have improved considerably and comes with a > detailed manual. Thanks, I should check the current state of knoda. Last time I tried it ~1 yr ago, it allowed only minimal functionality to interact with PostgreSQL. Kexi invariably crashes in my system (AMD64) when doing things with PostgreSQL. I tried rekall during the last few days, but it crashes soon after connecting to a database. Some of these problems may be happening only in AMD64. Indeed, Debian's Openoffice.org packages are very recent, but are already more stable than the apps mentioned above. However, it also crashes frequently during connections with PostgreSQL (or MySQL) connections and, again, functionality is very limited. Particularly, I'd like to have some GUI do something like M$ Access' relationship. In the meantime, I've also tried to figure out how to use my old *.mdb files through ODBC directly. Basically, using unixODBC to connect to the *.mdb from a *nix app (say GNU R for stats analysis). I've been using Codeweavers' Crossover as I migrate things over to PostgreSQL, and this plan seems possible: http://www.codeweavers.com/support/docs/wine-user/config-odbc although I haven't yet understood the last step of their configuration guidelines. -- Seb ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re : [pgadmin-support] Display of error message
I though I had a pal ;-) ... I am on my own again (see Erwin answer below). Guillaume have you managed to do more testing, on a Ubuntu machine ? Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Erwin Brandstetter <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org; [EMAIL PROTECTED] Envoyé le : Vendredi, 2 Mars 2007, 13h57mn 48s Objet : Re: [pgadmin-support] Display of error message [...] >> I am interested to know if you've managed to reproduce Laurent's problem >> though, in which *only* the error number is shown in the Query Tool, and >> no text at all. > > No, I have not seen that. OK, thanks. Regards, Dave ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re : [pgadmin-support] Display of error message
Albin , I suspect you are having the same problem as I have. For me, when the db is set with UTF8 charset I get only error numbers, but on the same server but with db set with other charset (say LATIN1) I do see error messages. Let us know. Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Erwin Brandstetter <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] Cc : Dave Page <[EMAIL PROTECTED]>; [EMAIL PROTECTED]; pgadmin-support@postgresql.org Envoyé le : Vendredi, 2 Mars 2007, 23h00mn 35s Objet : Re: [pgadmin-support] Display of error message Hi Albin! Most interesting, especially as your setup looks much like mine. And I do see error messages. cc-ing Dave and Laurent as they might take special interest in your case. So I keep it in English. Some more information might be useful: encoding of the database?-- \l command in psql or select the database node in pgAdmin and read from the SQL pane. client_encoding?-- show client_encoding; "German as default language" in pgAdmin? Or in postgresql (-> postgresql.conf)? Way of connecting? Via TCP/IP to port 5432 or some other method? And maybe the setting in your postgresql.conf might be of interest. BTW, backports.org has updated to postgresql 8.1.8 a couple of days ago. You may want to apt-get update & upgrade .. Regards Erwin [EMAIL PROTECTED] wrote: > Erwin Brandstetter wrote: > >> [EMAIL PROTECTED] wrote: > >>> I am interested to know if you've managed to reproduce Laurent's >>> problem >>> though, in which *only* the error number is shown in the Query Tool, >>> and >>> no text at all. >> >> No, I have not seen that. > > Hello, > > I have this problem with not showing the text message, just the number... > pgAdmin 1.6.2 (Jan 6 2007, rev: 5837; German as default language), > WinXP SP2 > PostgreSQL running remotely on Debian Sarge, 8.1.4 from the > "Backports-Repository" ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re : [pgadmin-support] Request for better visual feedback in the event of errors
I second that ! Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : jws <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Jeudi, 8 Mars 2007, 23h32mn 18s Objet : [pgadmin-support] Request for better visual feedback in the event of errors It would be very helpful if, when running a 15K line sql script and errors are encountered, the cursor could jump to the line in question so that it would be apparent where the problem is. Perhaps each line could be highlighted as it was executed, and the window could scroll to follow. The current behaviour is to add a dot to the left of the problem line, but it doesn't really stand out enough when paging through the script at high speed. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] Changing owner objects
Hi, Is there an easy way (in one go) to change the owner of all database objects with PG Admin ? I am creating a schema with a script that assign the objects owner to login (I mean conection role) A . Then I switch the schema owner to login (/conection role) B. But the objects are still owned by A. Is there an easy way in PG Admin to change the owner obejcts from A to B ? I have created a little script doing this but it's a shame I can not do this easily in PG Admin. (because my script is still a bit of a manual process as I don't know the PG database well enough to have a completely automatic script). May be, we changing the schema owner, PG Admin could prompt whether the schema objects owner should be changed as well (for each objects). Cheers, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re : [pgadmin-support] Changing owner objects
>>If you use PostgreSQL 8.2, you can >> REASSIGN OWNED BY A TO B; Good but I am using 8.1 >>We aren't sure that all objects in this schema are owned by the same >>user. But perhaps we can add some code to "emulate" REASSIGN OWNED for >>older PostgreSQL releases. That will be great ! Have fun, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re : [pgadmin-support] import from csv
Hi David, I have not seen any replied to that ... so here I go. No, there's no other option than psql AFAIK when using the COPY order with the data in the same file (COPY ... FROM STDIN). Dave explained before, that COPY uses the console and the PG Admin III edit tool is not a console app but a window app. But if you use a file and that file is on your PG server you can use the syntax, COPY my_table FROM '/home/me/data/my_file.csv' CSV; That will work but you will need to have the file on the same machine as the Postgres Server (that's why I put a Unix file name but that will work on Windows too). Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : David BOCCOU <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Lundi, 2 Avril 2007, 12h47mn 58s Objet : [pgadmin-support] import from csv Hi all I’ve read that the ‘Copy’ command could not be used with pgAdmin III : is there an alternative way to import data from a .csv file using pgAdmin, or is mandatory to use psql ? Thank you for reading me David ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com
[pgadmin-support] PG Admin talks to me ... at last !
Hi Dave, Guillaume and All, Some of you (Dave & Guillaume) may remember I had a problem with PG Admin III 1.6, that did not display error messages (only the code but not the message it self) when PG Admin III 1.4 and psql will display the full error message. After a bit of investigation with Guillaume we defined it was down to my server configuration (PG 8.1 on Ubuntu 6.06) but could not find what was wrong. It looks like it was a locale configuration problem. Last week, I had an upgrade of the locales package and then of PostgreSQL (going to 8.1.9): as a result my PostgreSQL would not run anymore. After a lot of looking around I realised the error came from the locale definition, for some reason the collate order seems not to be defined in french. Hence with a definition of /etc/environement like LANGUAGE=fr_FR LC_MESSAGES=fr_FR LC_COLLATE=POSIX LANG=fr_FR Not only I did not get any errors with my Linux commands, and PostgreSQL will start BUT also I now have the error messages (in english) from the PG Admin Query Tool ! ! HURRAH ! ! HURRAH ! ! HURRAH ! ! I don't understand why the locales definition on the server might change something in the way PG Admin display error messages (when others like PG Admin 1.4 and psql are not bothered) ... but it looks like it does ! Anyway, after being a pain for a while (in particular for Guillaume and Dave), I wanted to share my joice with you guys ... and that might help somebody else in the future. Thanks to all who helped me fixing this Have fun and ... sorry for the long email, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re : [pgadmin-support] pgAdmin III 1.6.3 for ubuntu feisty uploaded.
Hi, what about having a 1.6.3 build in the backports of Dapper Drake (6.06 LTS) as it is long term support I would not expect people using it to move to a newer OS version ... but would apreciate a more recent pgAdmin (than 1.4.3). Just a suggestion ! Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Raphaël Enrici <[EMAIL PROTECTED]> À : PgAdmin Hackers <[EMAIL PROTECTED]>; Pgadmin Support Envoyé le : Dimanche, 20 Mai 2007, 18h41mn 20s Objet : [pgadmin-support] pgAdmin III 1.6.3 for ubuntu feisty uploaded. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dear all, Althoug pgAdmin III 1.4.3 is delivered in the universe ubuntu/feisty repository, I've just uploaded a build of pgAdmin III 1.6.3 for Feisty to our developer host. It should propagate to PostgreSQL mirrors in the next hours/days. Please refer to the new instructions from our website [1] to proceed to installation of the package. Have fun! Regards, Raphaël [1] http://www.pgadmin.org/download/ubuntu.php -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGUHowx3NpDPptARMRAlqfAJ4qgfFcnh2M1LiYdPiui7aG55TcyACgoX0Q mIxlsfCv58nkJThPGtlbowA= =2ES+ -END PGP SIGNATURE- ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[pgadmin-support] List to Father Christmas
Hi, As I have managed to get error messages displaying correctly in PG-Admin (thanks to a correct configuration on the PG Server), I have switched to version 1.6.3, and I am sending this request feature list (I know it's not Christmas anymore, Easter is already gone passed ... but I always hope). A bit of background about me: I have been working in the database for more than 10 years, doing consultancy work and working for an editor of database tools (CAST). I have been mainly working with Sybase and SQL-Servers (a bit with Oracle) and recently with Derby and PostgreSQL ;-) ! All that to say, I have used quite a few tools to work with databases in many configurations at many sites ... but always, the same ideas are coming back ! ;-) My feature request list: A/ Editor A-1/ Search & replace Cancel The "Cancel" button should be "Close": as hitting it does not cancel anything but just close the window. By the way in the French version, the second label "Remplacer par" is slightly too long, and overides the begining of the text field box. A-2/ History results Keeping the results of the query would be useful (as an option). In particular, for the next point ! A-3/ History navigation Being able to navigate (previous/next) through the history of the requests typed in, would be really useful. That's a feature I used to have in a previous tool and I missed it a lot. B/ Table Editor B-1/ modify new column It's really annoying that after creating a new column but still in the table editor, it's not possible to modify it (modify button greyed out). The typical thing is creating a new column not null, and entering a lengthy comment on the column. Then when I click OK on the table editor it's complaining that there are null values on that column (of course, I have just created it) so I want to correct the column definition (to make it NULLable for example) ... BUT I CAN'T ! ! ! I have to delete the column and then to create it again ! :-( C/ Result set / Edit Data Windows C-1/ INSERT INTO Copy/Paste I would like to copy lines from the data grid, and paste them into the SQL command windows as an INSERT INTO. May be a special COPY could do this. C-2/ Close all Edit data windows It will be great to be able to close all the Edit Data windows in one command (File ==> Close All Edit Data) C-3/ Edit Data window title The title of the Edit Data windows is note very helpful: it's too long and the very meaningful information (the table name) is at the end. So when I browse through my many EditData windows opened (see previous remark ;-) !), all I can see is the name the application, the name of the server and that's it. When I say browsing through my EditData windows, I mean either cycling through applications with Alt+Tab or hovering the icons in the task bar. And the text I get is typically: pgAdmin III Edit Data - Server ServNm (servnm:5432) - my_database_name_ when I would like to see pgAdmin III Edit - table_name - my_database_name_ - ServNm (Note: The names table_name, my_database_name_, ServNm are quite representative in length of what I used on the many projects I have worked on in more than 10 years) To me I don't see, the point of having the full Server ServNm (servnm:5432): ServNm is enough. May be a solution will be to have the name configurable via preferences ? (in the long term, but in short term changing the order would be nice) C-4/ Edit Data in Table Tab It will be nice to have an extra tab in the table view (next to Properties, Statistics, Dependencies, Dependents): Edit Data. That would be what we get when doing View Data ==> View Top 100 rows on that table. That will be really quicker when looking up data on a few tables. If performance is an issue for some people, that could be an option to turn on or off. C-5/ new IDENTICAL Edit Data window Asking confirmation before opening a new IDENTICAL Edit Data window, would be nice (and offering to switch to the existing as an alternative). As the feature request C-4 is not already implemented, I often open many data windows to read the tables content. As I don't always remember what's already opened (age is not helping ;-) !), I open several times the same data windows ! Thanks for reading that far ! ;-) Have fun, [EMAIL PROTECTED] The Computing Froggy ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 6: explain analyze is your friend
[pgadmin-support] Edit Data windows title [aka RE: List to Father Christmas]
Of course the port number is essential BUT at the moment the Edit Data windows title is of the form: MyServerName (HostRef:PortNumb) - dbName - tableName (note that I changed the notation from my previous post to try and be clearer) However the point (to me) of giving a name to a connection (MyServerName) is to avoid the need for the information HostRef:PortNumb (and login): it's up to the user to give meaningfull name (to the connections) to be able to differentiate connections on the same host with different port numbers and/or different logins. My 2 cents, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Cc : [EMAIL PROTECTED] Envoyé le : Mercredi, 23 Mai 2007, 19h11mn 14s Objet : Re: [pgadmin-support] List to Father Christmas On May 22, 3:06 pm, [EMAIL PROTECTED] (Laurent ROCHE) wrote: (...) > To me I don't see, the point of having the full Server ServNm (servnm:5432): > ServNm is enough. You raised a couple of interesting points. Just a quick comment here: the port number is essential if you have several database clusters running on different ports on the same server (as I do). Regards Erwin ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq __ Stockage illimité de vos mails avec Yahoo! Mail. Changez aujourd'hui de mail ! ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] Connection names and Query Windows
Hi, (While talking of connection names, see other post "Edit Data windows title") I just realised the connection name was not used at all in the Query window. That's more than a shame because if I want to use another connection, a little window pops up and offer to change database with a dropdown of all database names (so far so good ;-) ! ) BUT also to change connection. It could be really interesting to change connections however the little pop up window offers a drop down with a list of hostReference:PortNumber. As I have many connections on the same server with different logins, this is useless to me as I see many times the same thing. I would have prefered to see the ConnectionName given in the connection window. By the way, the same apply for the Query window title instead of seeing "databaseName on hostRef:PortNumb" I would prefer to see "databaseName on ConnectionName". Then it's up to the user to manage the connection in a sensible maner. Cheers, [EMAIL PROTECTED] The Computing Froggy _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re : [pgadmin-support] Improvement to Dropped DB Connections
- Message d'origine De : Bob <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Jeudi, 24 Mai 2007, 2h52mn 23s Objet : [pgadmin-support] Improvement to Dropped DB Connections In other words --- EVEN IF the DB connection is closed by accident, pgAdmin should not require the user to extra work to open it back up again. -- I second that ! --- Cheers, [EMAIL PROTECTED] _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-support] Feature Request: Rename DB in pgAdmin
Hi, Another feature request: I would like to be able to rename a database by right clicking on a database and choosing Rename from the context menu (which does not exist right now). I know I can do the same thing by opening a query window and writing a ALTER DATABASE ... RENAME TO ... command, but that would seems a nice command to have (particularly when developing and moving database around). Have fun, [EMAIL PROTECTED] The Computing Froggy _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re : [pgadmin-support] 1.6.3 and Ubuntu Feisty problems
>> 3) column headers are blank with no indication of the column name in the >> edit grids. > Wierd. I have seen this when the connexion to the database has been lost. _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1
Hi All, I have a table with a sequence. When I backup the table I get the following code (among other things): ... ALTER SEQUENCE documents_doc_id_seq OWNED BY documents.doc_id; ... However my server is PG 8.1 and this is 8.2 syntax. I understand pgAdmin runs a standard pg_dump but I would expect it to run a version compatible with my server ! ? ! Cheers, [EMAIL PROTECTED] The Computing Froggy _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re : [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1
OK, I understand that. May be that's a pg_dump issue: it should be compatible with the server it connects to, and not to its own version ? Still meanwhile I would think pgAdmin should allow installing other pg_dump executable. And it should switch from one to another to be able to generate a correct code, according to the server used. There could be different installer: one with only the latest tools and another one with all compatible tools versions to be able to work correctly on different servers ! Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Guillaume Lelarge <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] Cc : Laurent ROCHE <[EMAIL PROTECTED]>; pgadmin-support@postgresql.org Envoyé le : Lundi, 18 Juin 2007, 23h53mn 13s Objet : Re: [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1 Raymond O'Donnell a écrit : > On 18/06/2007 17:50, Laurent ROCHE wrote: > >> However my server is PG 8.1 and this is 8.2 syntax. I understand >> pgAdmin runs a standard pg_dump but I would expect it to run a >> version compatible with my server ! ? ! > > I run the Windows version of pgAdmin, and the installer bundles the > latest version of pg_dump available at the time of release - so this > would have been 8.2 with the current pgAdmin. > That's right. And bundling some releases has a cost. pgAdmin's package would be much more heavy. One way we could try is to put the other pg_dump releases on other packages and let the user chooses which one he wants to use. But, GUI won't be easy. At least, you can try with a 8.1 pg_dump release. (please, be sure to copy your existing pg_dump before anything). Regards. -- Guillaume. _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Using many pg_dump in pgAdmin (aka Re : Re : [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1)
Hi, Just to clarify what I mean. I am quite happy (or should I say: not too unhappy) to juggle with different version of pg_dump in my scripts. If that's the way it has to be, that's the way it has to be. See point A, below. But to me pgAdmin is a tool that must be easy to use. Hence, as it seems the rule of pg_dump usage is "if I connect to 8.1 server, I must use pg_dump 8.1; if I connect to a 8.2 server, I must use a 8.2 server; ...". There should be an option for doing that automatically: I should not need to switch from a pg_dump to another when I switch servers. So what I have in mind is: - default installation: use pgAdmin pg_dump - activate multi-pg_dump mode: give a directory where there's a tree with a directory for each server version used. And each directory contains the matching (to the directory name) pg_dump version. This way, the standard install is the same. But if I need to connect to different servers with different versions, I don't need to keep switching from one pg_dump to another all the time: pgAdmin will do it for me. I understand that's quite a lot of work to be done, but on a user perspective, that's the painless of doing it ... well, at least on my humble opinion, but I assume other users might have other views on the subject. Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine >>> May be that's a pg_dump issue: it should be compatible with the >>> server it connects to, and not to its own version ? > >> What do you mean? >Shipping every version of pg_dump, libpq & supporting DLL's back to v7.3 >by the sound of it! ** Point A ** Nope, just that pg_dump should generate code compatible with the server it connects too. I was told once on the PG list that pg_dump aim is to be able to backup and restore, with the newer version of the tool, that does not work on an older server. ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] Wish list and Doc Errors
Hi All, Following quite a few days using pgAdmin III (1.6.2 or 1.6.3 not sure) in a location with no internet connection, I have a few remarks ... plus a couple of questions about pgAgent which I have experimented for the first time. I know this is not really good timing considering you are busy with 1.8 but the first remark makes sense for that new release (the rest can wait). * Having the documentation for the latest PosgreSQL version will be nice. I know why you've decided not to deploy the PG doc anymore (see http://www.pgadmin.org/archives/pgadmin-support/2007-08/msg00072.php), but when working not connected (e.g. on a laptop without internet connection) it's still nice to have some documentation ... even if it's not the version one should want. As a trade off just having some documentation is nice. I understand from your post that getting the PG help file is time consuming : you could just have a pointer to the help web version of the latest PG version (installed locally) May be we could have the choice of: a link to the web site for the documentation matching the version of PG where PGAdmin is actually connected to, or the latest PG installed locally ? ! ? * pgAgent questions ? - Is pgAgent suitable to use in a production environment or is it just a development tool ? * pgAgent : suggestions (feature requests) - A "run now" function will be interesting, e.g. an extra command in the right click menu. - Wizard to install the pgAgent (instead of running a script). The wizard could create a set of "standard" jobs (disabled) to use as exmaples/templates, e.g. maintenance (VACUUM and REINDEX), backup (dump). - Defining a default database at the job level instead of the step level. Then to be able to copy/paste the job and just change the db name (to run the same thing on other db). Also defining a db_name macro to be able to reuse the name in the SQL produced (e.g. for REINDEX DATABASE db_name). Even better than the copy/paste would be to define a list of databases (instead of one) so the very same jobs can be ran on different dbs (of course one after the other). This would be very useful for maintenance jobs for instance. - check all and uncheck all buttons for the three lists of schedule Days tab. - when clicking on a step, one should see the code in the SQL pane (in particular when this is SQL ... but that would not hurt to display the script command as well). * Translation Errors - Sequence Start in French Version When editing a SEQUENCE the START value is translated by "Valeur Actuelle" which roughly translated would be "Last value", I would think a better translation should be "Prochaine valeur" (i.e. "Next Value") or "Valeur de départ" (i.e. "Start Value"). * Errors in pgAgent Documentation A few mistakes in the documentation spotted, with corrections suggestions ! - pgAgent Installation . Database setup 2nd paragraph: Once created, connect to the new database, and open the SQL tool. should be replaced by Connect to the "postgres" database (once created if needed), and open the SQL tool. . Service installation on Windows Usage: "C:\Program Files\pgAdmin III\pgAgent" REMOVE "C:\Program Files\pgAdmin III\pgAgent" INSTALL [options] should be replaced with: Usage: %PG_AGENT_EXE% REMOVE %PG_AGENT_EXE% INSTALL [options] Where %PG_AGENT_EXE% is the executable file of pgAgent. Depending on your installation, it could be: SET PG_AGENT_EXE="C:\Program Files\pgAdmin III\pgAgent.exe" for a pgAdmin III classic installation. OR SET PG_AGENT_EXE="C:\Program Files\PostgreSQL\8.2\bin\pgAgent.exe" for a PostgreSQL 8.x server classic installation. - pgAgent Jobs . Second phrase To configure jobs on your server, browse to the database in which the pgAgent database objects were created using pgAdmin. Should be replaced with: To configure jobs on your server, browse the server on which the pgAgent was installed (script run on postgres database). Have fun, [EMAIL PROTECTED] The Computing Froggy Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
[pgadmin-support] generating UPDATE SET ... WHERE PK = ...
Hi, I would like to generate with a request a SQL order like UPDATE tab1 SET col_a = ?, col_b = ? ... WHERE pk = ? for each table of a given schema (in fact what I want is slightly more complicated but if I can write the above, I will be able to get the rest). Will anyone be kind enough to share a piece of code doing this (from pgAdmin may be) ? Cheers, [EMAIL PROTECTED] The Computing Froggy _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
Re : [pgadmin-support] Support for older servers
Hi, My 2€: as long as the last version supporting PG 7.x is easily downloadable from the web ... I don't think that till be a problem; for the users. It's just for you guys (and the PG people), to know whether this is acceptable considering pgAdmin is packaged with PG (Windows version). In that case, you might end up packaging a pgAdmin not supporting PG 7.x which is not yet deprecated. Enjoy your weekend, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : pgadmin-hackers <[EMAIL PROTECTED]>; pgAdmin Support Envoyé le : Vendredi, 16 Novembre 2007, 13h24mn 00s Objet : [pgadmin-support] Support for older servers Should we consider dropping official support for PostgreSQL 7.x in the next major version of pgAdmin? Thoughts? /D ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
Re : [pgadmin-support] Column names in view
The only time when I have seen this (including for views), is when a data window has been opened then the data linked object (table or view) has been re-created(i.e. drop + create) then when doing a refresh on the data window, I don't see the colum names any more (even if they are identical), data is displayed OK though ... I always thought of this as a "feature" ! ;-) Have a good weekend, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Raymond O'Donnell <[EMAIL PROTECTED]> À : Pgadmin-Support Envoyé le : Samedi, 24 Novembre 2007, 15h02mn 15s Objet : [pgadmin-support] Column names in view Hi all, A funny one I see from time to timeI have one particular view which, when I click "View data", doesn't show up the column names in pgAdmin. It (pgAdmin) shows the names in two other views in the same database without any problem. SELECTing from the view in psql shows the column names, as does SELECTing in the query tool. There's nothing special about this view that I can see - it joins 5 tables together, and one column is calculated in the view (and given an alias also). I can send a dump of the database if it's any use - it's a development one, and so quite small (160kb zipped). Anyone else see this? I'm using pgAdmin 1.8 on Windows XP SP2, and PG 8.2.5 on the same machine. I seem to recall a bug along these lines in an earlier version of pgAdmin --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
[pgadmin-support] Re : [pgadmin-support] Información pgAdmin
Hola Ángela, Esto es una mailing list en Ingles solo. This is a mailing list in English only. La mailing list en Castellano es pgsql-es-ayuda ! Aqui esta la documentacion para PostgreSQL http://www.postgresql.org/docs/ click a la derecha en la version que utilizas Pero la documentacion para pgAdmin III (en Ingles solo tanbien) esta a: http://www.pgadmin.org/docs/1.8/index.html Y los sitios en Castellano : - Chile http://www.postgresql.cl/ - Peru http://www.postgresql.org.pe/ pgAdmin functiona con postgis, pero debes instalar postgis separamente si quieres utilizarlo. Si tienes màs pregunta, escribame a mi solo y no a toda la lista (porque la lista es solamente en ingles). Espero que puedes entenderme, porque mi español no esta tan bueno. Buena suerte, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Angela María Beltrán Sanchez <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Mardi, 8 Janvier 2008, 3h57mn 42s Objet : [pgadmin-support] Información pgAdmin Buen día He instalado postgresql 8.2.4 en win xp, pero no encuentro manuales o tutoriales acerca de la herramienta pgAdmin, todo viene como hacerlo por código , pero veo que las herramientas que esto trae pues le evita eso a uno, además requiero saber como exportar un script SQL que ya tiene la creación de las tablas, para no tener que repetirlo. Esta versión veo que trae adicional el postgis o debo instalar algo adicional?. Espero su pronta respuesta ya he mirado la documentación de la página postgresql.org pero como les digo todo es por código. Gracias por su atención Ángela Beltrán S. [EMAIL PROTECTED] _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail http://mail.yahoo.fr
[pgadmin-support] Reporting ?
Hi, I am trying to generate reports for my database. I have never used this before so I might be mising the obvious. I would like to generate what I would call a full report : for each table of the database, the comment on the table and for each field the definition, the comments and dependency. From what I have understood there's not a single report providing this. More over, if I want to get this information for all the tables in the database, I have to generate 2 or 3 reports for each table as there is no way to generate a report for a group of tables. Is there a way of doing this with pgAdmin III (I am using v 1.8.1) ? If not any other tool that I could use to perform this ? Thanks, [EMAIL PROTECTED] The Computing Froggy _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail http://mail.yahoo.fr
[pgadmin-support] Re : Reporting ?
Hi, So nobody is doing any reporting on the PG tables with pgAdmin ... or even something else ? Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Laurent ROCHE <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Mercredi, 23 Janvier 2008, 17h49mn 30s Objet : Reporting ? Hi, I am trying to generate reports for my database. I have never used this before so I might be mising the obvious. I would like to generate what I would call a full report : for each table of the database, the comment on the table and for each field the definition, the comments and dependency. From what I have understood there's not a single report providing this. More over, if I want to get this information for all the tables in the database, I have to generate 2 or 3 reports for each table as there is no way to generate a report for a group of tables. Is there a way of doing this with pgAdmin III (I am using v 1.8.1) ? If not any other tool that I could use to perform this ? Thanks, [EMAIL PROTECTED] The Computing Froggy Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail http://mail.yahoo.fr
Re : [pgadmin-support] Re : Reporting ?
Hi Dave, I understand you have plenty of things to do as it is. But may be being able to generate a report on many objects instead of only one would not be such a big work. Anyway autodoc does a good job at generating report. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> ... > > I am trying to generate reports for my database. ... > If not any other tool that I could use to perform this ? I don't know about other tools, but the pgAdmin reporting is more or less designed as an HTML 'screen dump', so only really allows you to report on the details of the currently selected object. Unfortunately we've got to the stage now where keeping up with all the cool features people want is going to take much more developer time than we actually have :-( /D ---(end of broadcast)--- TIP 6: explain analyze is your friend _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail http://mail.yahoo.fr
Re : [pgadmin-support] Re : Reporting ?
Hi, I thought there was something that could do something like that. Thanks for pointing me in the right direction. This is a great tool ... a shame there are a bit short in documentation, but by looking a bit more, one can find what he wants. Thanks Guillaume. Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Guillaume Lelarge <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org Envoyé le : Vendredi, 25 Janvier 2008, 10h31mn 18s Objet : Re: [pgadmin-support] Re : Reporting ? Laurent ROCHE wrote: > So nobody is doing any reporting on the PG tables with pgAdmin ... or > even something else ? > postgresql-autodoc is an easy tool to use with many output formats. See http://www.rbt.ca/autodoc/ for details. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail http://mail.yahoo.fr
Re : [pgadmin-support] Character encoding conversion
Mike, If I were you (actually that's what I did whne I had the same problem), I will convert the pg_dump file from LATIN1 charset to UTF8, then copy back into the new UTF8 database. And all should work fine. On windows you will find that text editors like TextPad and Scite (which runs on Linux too) will convert the file from LATIN1 to UTF8. On Linux there must be some command line tools, but I don't know them. I hope this helps. Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Mike Blackwell <[EMAIL PROTECTED]> À : pgAdmin Support Envoyé le : Samedi, 9 Février 2008, 15h22mn 23s Objet : [pgadmin-support] Character encoding conversion I have a database which was originally created with LATIN1 encoding. I'd like to move it to UTF8. The data will load ok (COPY) but I am getting 'invalid byte sequence for encoding..." messages when accessing the data. Is there a way to automatically convert the offending characters, or to easily locate them in a pg_dump file so they can be converted by hand? Mike ---(end of broadcast)--- TIP 6: explain analyze is your friend _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail http://mail.yahoo.fr
[pgadmin-support] Comments on column
Hi, There is a little bug in pgAdmin III 1.8.2 on Windows XP (at least). If one creates a new column with comments by opening the properties of an existing table, then going to Columns tab and clicking the Add button, the comments will NOT be saved. However, by adding a column directly (e.g. right click on the table from the object browser, "Add an Object ==> Add a column ..."), the comments WILL be saved. And if the column already exists and we add a comment to the existing column, either directly (right-clik on the column) or via the column tab of the table window, the comments will be saved. I hope this is clear. Have fun, [EMAIL PROTECTED] The Computing Froggy Envoyé avec Yahoo'>http://us.rd.yahoo.com/mailuk/taglines/isp/control/*http://us.rd.yahoo.com/evt=52423/*http://fr.docs.yahoo.com/mail/overview/index.html";>Yahoo! Mail. Une boite mail plus intelligente. _ Envoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr
Re : [pgadmin-support] Comments on column
A shame it won't be possible to type in column comments any more. I hope this is only for the creation from the columns tab and not the creation from the object browser. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Dave Page <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : pgadmin-support@postgresql.org Envoyé le : Jeudi, 6 Mars 2008, 17h17mn 46s Objet : Re: [pgadmin-support] Comments on column On Thu, Mar 6, 2008 at 3:58 PM, Laurent ROCHE <[EMAIL PROTECTED]> wrote: > > Hi, > > > There is a little bug in pgAdmin III 1.8.2 on Windows XP (at least). > > If one creates a new column with comments by opening the properties of an > existing table, then going to Columns tab and clicking the Add button, the > comments will NOT be saved. > However, by adding a column directly (e.g. right click on the table from the > object browser, "Add an Object ==> Add a column ..."), the comments WILL be > saved. > > And if the column already exists and we add a comment to the existing > column, either directly (right-clik on the column) or via the column tab of > the table window, the comments will be saved. That should already be fixed for 1.8.3: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi?rev=7053&view=rev -- Dave Page EnterpriseDB UK Ltd: http://www.enterprisedb.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk _ Envoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr
[pgadmin-support] FR: DROP column on CASCADE
Hi, A Feature Request: as we can perform a DROP ... CASCADE on some objects, it will be nice to be able to do so on columns as well. I am talking of adding a new entry on th right clikc on columns that will generate code like: ALTER TABLE my_table DROP COLUMN my_column CASCADE Have fun, [EMAIL PROTECTED] The Computing Froggy _ Envoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr
[pgadmin-support] Adding columns NOT NULL
Hi, There is a little anomaly in the way adding an extra column is treated in pgAdmin III 1.8.2. ... particularly if this is a NOT NULL column. When adding the column my_col with a DEFAULT value, the code generated will be: ALTER TABLE my_table ADD COLUMN my_col boolean; ALTER TABLE my_table ALTER COLUMN my_col SET DEFAULT false; This works fine ... as long as I don't insert columns with NOT NULL property. In which case, I SUPPOSE it generates: ALTER TABLE my_table ADD COLUMN my_col boolean NOT NULL; ALTER TABLE my_table ALTER COLUMN my_col SET DEFAULT false; This will not work, because the column is created with no default (hence no values) and does not support NULL values, hence creation fails. ** In pgAdmin, adding an extra column with NOT NULL property is impossible ! ** So I would suggest to generate the code: ALTER TABLE my_table ADD COLUMN my_col boolean NOT NULL DEFAULT false; Which does work ! And that allows to create a column with not NULL values, in one operation, and more importantly with the column populated. At the moment, to perform the same operation I have to - create the column, with NULL values. - update the table to populate the column - modify the column to NOT NULL ... or write my-self the ALTER TABLE statement ! Cheers, [EMAIL PROTECTED] The Computing Froggy _ Envoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr
[pgadmin-support] For the PG experts
Hi, I have posted this on the pg main list ... and as I had no sensible answers, I am trying here. Also, it's likely someone knows the answer as you need to get this info to display it in pgAdmin ! I would like to write a request where I would get the table name and column name of a sequence. I have been looking at the sytem table and could not link the sequence from pg_class to a table (and even less to a column). Any ideas ? Have fun, [EMAIL PROTECTED] The Computing Froggy _ Envoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr
Re : [pgadmin-support] Postgresql con DotNetNuke
Hola Luis, Esto es una mailing lista en ingles solo ! Ademas, se trata solo del programo pgAdmin III aquí y no de PostgreSQL Server. Tienes un problema de conexión a PostgreSQL y no es un problema de pgAdmin pero de configuración de PostgreSQL. Probablemente que tienes que modificar el data/pg_hba.conf Tendrás información en español al sitio: http://www.postgresql.cl/ Y hay mailing lista en español tan bien: pgsql-es-ayuda : http://archives.postgresql.org/pgsql-es-ayuda/ - English Hi Luis, This is a mailing list in english only. More over, this is only about the program pgAdmin and not the PostgreSQL Server. Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Luis Nieto <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Mercredi, 20 Août 2008, 15h08mn 27s Objet : [pgadmin-support] Postgresql con DotNetNuke saludos necesito ayuda ya que intento conectar DotNetNuke que es un manejador de contenidos con postgresql 8.1.3 todo bajo windows, visual studio express pero obtengo un error: No se ha podido establecer conexión ya que el equipo de destino ha denegado activamente dicha conexión que tipo de modificaciones puedo hacer para correguir ese error, es por .net o por el pgadmin III cualquier informacion que me pueda servir por favor pueden enviarme a mi correo de antemano gracias por su respuestas att. luis Yahoo! MTV Blog & Rock ¡Cuéntanos tu historia, inspira una canción y gánate un viaje a los Premios MTV! Participa aquí http://mtvla.yahoo.com/ _ Envoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr
[pgadmin-support] pgAdmin, PG 8.2 and Ubuntu 7.10
Hi, I have made an install of PostgreSQL on Ubuntu 7.10 with package: it installs PG 8.2. I have installed pgAdmin too but it installs pgAdmin 1.4 ... is this normal ? Is there a way to get pgAdmin 1.8.x by a package on Ubuntu 7.10 ? Just looking at http://www.pgadmin.org/download/ubuntu.php, it seems that it's needed to alter the source.list file . Why is this not done by default and why Ubuntu still keeps the old pgAdmin ? Cheers, [EMAIL PROTECTED] The Computing Froggy _ Envoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr
[pgadmin-support] xls export vs Data Migration tools [akaxls export function]
Hi, If you do a lot of data migration, I would recommend using an ETL tool. I am using Talend Open Studio, which is an Open Source software. It's based on the Eclipse framework, you define your jobs with a graphical tool (drag & drop components : DB tables, files -Excel, CSV, XML, ...-) and then it generates the code that you reuse in your program (Perl or Java). It took me only a couple of days to be able to use it and to run plenty of imports. I am not afiliated with them: it's just a great tool ... and Open Source ! I don't think it's the purpose of pgAdmin of doing a lot of extract. Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : W. Haslbeck <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Mardi, 9 Septembre 2008, 22h29mn 50s Objet : Re: [pgadmin-support] xls export function Hi, > It's unlikely that we'll add xls capabilities as it's a proprietary > format used on just one of the platforms we support - plus no one else > has asked for it until today! I'm more interested in fixing the CSV > issue you've run into. XLS (or Excel XML) output would really be a big benefit (at least for me). The big problem for me with CSV is that it can't describe datatypes. So you have to options: a) let excel guess the datatype, which is often wrong or b) set the datatype explicit at every CSV import for every column. When you do a LOT data migration (which is a part of my job at the moment, we're moving to SAP..) this can be very annoying. To prevent that excel uses a wrong datatype, I don't use CSV export in PgAdmin at all. I create a view for each dataset that has to be exported and load the view with the PostgreSQL ODBC driver to excel. Not very comfortable, but at least not as error-prone as CSV import. Creating an excel compatible XML output to PgAdmin shoudn't be to hard, I've done this before for other tools. I really like to implement this feature in PgAdmin, but no time atm. Creating an "real" XLS is probably a bit harder than XML (but in doubt you can always peek in e.g. perl's great Spreadsheet::WriteExcel module). Walter -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re : [pgadmin-support] trouble in installing postgreSQL 8.3
Serge, you emailed many mailing lists ... except the one you should have the PostgreSql mailing list "[EMAIL PROTECTED]". ... and I can not help you about the mentioned problem ... sorry ! Cheers, [EMAIL PROTECTED] The Computing Froggy De : "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> À : [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgadmin-support@postgresql.org; [EMAIL PROTECTED] Envoyé le : Vendredi, 14 Novembre 2008, 13h56mn 34s Objet : [pgadmin-support] trouble in installing postgreSQL 8.3 Hi, We experienced pb in installing the Postgres db because, at the end of the installation, the pgm generates an error messaging saying that the password authentification is failed. Trust me that I follow all the installation procedure. Aside this, I've got an error in creating the postgis db as well. As far as I know, your product is very interesting but in the meantime, would you please give some hands in resolving my problem. Feel free in contacting me as quick as possible. Best Regards, Mr LUC-CAYOL.
[pgadmin-support] Feature request: pgdump and version number / -i option
Hi, I am running pgAdmin III 8.1.4 on WinXP on a PG server 8.3.3. I am trying to backup a single table. When doing right-click on the table and "backup" command, it will fail because pgdump considers there's a mismatch between the server version (8.3.3) and the pgdump version (8.3) version. I get the following message: C:\Program Files\pgAdmin III\1.8\pg_dump.exe -h my_server -p 5432 -U postgres -F p -v -f "C:\Projects\table.sql" -t "\"public\".\"my_table\"" my_db pg_dump: server version: 8.3.3; pg_dump version: 8.3.0 pg_dump: aborting because of version mismatch (Use the -i option to proceed anyway.) pg_dump: *** aborted because of error I realise this is because pgdump is a bit too specific about the version number: for now, the solution is to run the command from the command line with the extra option -i. But in a future version, could we have an extra option in the backup popup to use the -i option ? Cheers, l...@u The Computing Froggy
Re : [pgadmin-support] Feature request: pgdump and version number / -i option
Still in my case (I assume other people too) pl/pgsql functions would not help as I work on a remote server from a workstation: I want the files on my workstation and not on a remote server that I only access for the database ! Cheers, l...@u The Computing Froggy De : Dave Page À : "Sufficool, Stanley" Cc : pgAdmin III support Envoyé le : Lundi, 12 Janvier 2009, 9h59mn 06s Objet : Re: [pgadmin-support] Feature request: pgdump and version number / -i option On Fri, Jan 9, 2009 at 11:16 PM, Sufficool, Stanley wrote: > > Can we get the database to handle this instead / also? > > If pg_dump / pg_restore were libs, could this be called via pl/pgsql > functions instead? If it were done in the right way, yes. The topic comes up on pgsql-hackers every now and again, but I'm not aware that anyone has worked on it. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re : [pgadmin-support] Soporte tecnico sobre la Base de Datos de PostgreSQL
Hola Fabian, Este lista es solamente en ingles. Hay sitios en español para PostgreSQL aqui : . http://www.postgres-arg.org . http://www.postgresql.org.pe Y hay una lista en español : http://archives.postgresql.org/pgsql-es-ayuda/ Hay más aqui : http://www.postgresql.org/community/lists/ Have fun, l...@u The Computing Froggy De : fabian lopez À : PostgreSQL Envoyé le : Mercredi, 25 Mars 2009, 14h09mn 17s Objet : [pgadmin-support] Soporte tecnico sobre la Base de Datos de PostgreSQL Cordial Saludo En estos momentos estoy haciendo un aplicativo con lenguaje ASP 3.0 (Active Server Page) y la base de datos en PostgreSQL, fui a la página de ustedes http://www.enterprisedb.com/products/pgdownload.do#windows y me descargue la version para Windows, pues ese aplicativo debe trabajar sobre esa plataforma. Al ser nuevo en el manejo de la Base de datos en PostgreSQL, quisiera que ustedes me pudieran colaborar en un tutorial, un enlace, colaboración por parte de su organización, entre otros, de cómo puedo crear una Base de Datos y crear un servidor. Creo que por lo que he leído se hace a través del pgAdmin III, actualmente descargue postgresql-8.3.7-1-windows.exe. Muchas gracias por la ayuda prestada. Atentamente, Fabián López Analista y Programador de Sistemas. >¡Sé el Bello 51 de People en Español! ¡Es tu oportunidad de Brillar! br>Sube tus fotos ya http://www.51bello.com/
