[GENERAL] pgFormatter v2.1 has been released

QL-2011 and PostgreSQL specifics keywords. May works with any other databases too. It shares the same code with pgBadger, so any improvement made in the parser is reversed to pgBadger. Tool created by Gilles Darold. pgFormatter can work as a console program or as a CGI. It will automatically detect his envi

Re: Fwd: Re: [GENERAL] Variable not found

y idea? > > > Best guess it is stored in a table in the schema. As Adrian says, there's no equivalent with PostgreSQL. You will need to use custom variable in postgresql.conf or a table to store your global information. Best regards, -- Gilles Darold Consultant PostgreSQL http://dalibo.com - http://dalibo.org

Re: [GENERAL] date with month and year

: SELECT extract ( year FROM school_day ) AS year; SELECT substring ( firstname FROM 1 FOR 10 ) AS sname; SELECT substr ( firstname, 1, 10 ) AS strpart FROM mytable; Best regards, -- Gilles GPL tools at http

[GENERAL] [Windows] Feedback on PG?

Hello I'm looking for an open-source DBMS that runs on Linux and Windows. In order to make an informed choice, I would like some feedback on the Windows port of PostgreSQL, as compared to MySQL and Firebird (if you know of yet other solutions, I'm also interested.) Is the Windows port on

Re: [GENERAL] [Windows] Feedback on PG?

At 10:20 20/05/2009, Richard Huxton wrote: You'll probably need to give some details of how you intend to use it. One-off on large server hardware? Hundreds of copies deployed around the world on XP machines 5 years old? Sorry, forgot about this point: It's just for concurrent accesses from

Re: [GENERAL] [Windows] Feedback on PG?

At 10:29 20/05/2009, Simon Riggs wrote: We get this question a lot. Yes, there are many technical differences between various open source products. Sorry about that. I should have dwelved deeper and read this before asking:

Re: [GENERAL] [Windows] Feedback on PG?

At 10:58 20/05/2009, Craig Ringer wrote: I suspect a lot of that comes down to user/admin knowledge as much as anything. [...] That said, there are also a few bugs lurking that only affect the Windows version. [...] I've used Pg on my laptop at various points when it's been running Windows,

Re: [GENERAL] PL/java?

Java ! Regards Gilles Darold Alex Knight wrote: Daniel, thank you kindly for your input. However, mod_perl is absolutely slower than most any j2ee application. If all you are doing is keeping a session variable to count number of hits on a web page, then sure, perl is more than sufficient

[GENERAL] PG log analyzer v1.1

, I've planed it to the end of the year :-) Regards, Gilles Darold ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [GENERAL] Newbie DBD::Pg question

Hi, Extraction of large amount of data is not realistic especially with CGI, then DBI/DBD::Pg always return all data received from a query so if you don't want to tired your machine, the better way is to use cursor in a transaction (or query) or the LIMIT+OFFSET keywords. Regards Gilles

Re: [GENERAL] Oracle to Pg tool

Hi, Another point regarding /contrib or other directory like /tools is to centralize tools for Pg. Also I can't be sure to always have an URL. This one is dependant on the company I'm working now. Life is moving. Regards Bruce Momjian wrote: [ Charset US-ASCII unsupported, converting... ]

[GENERAL] Oracle to Pg tool

Hi, As I previous searched a tool to convert Oracle database to PostgreSQL and really found nothing, there's now a piece of perl code I've written that can become a great tool to do this job. It currently extract the database schema table definition of an Oracle database and output a sql script

Re: [GENERAL] Oracle to Pg tool

Add on on ora2pg. Table grant extraction is done. It is based on group/users grants. Oracle has ROLES that I understand as groups and users associated to these roles. So I create a group for each role and alter it by adding the users. And then set grants to each tables. Let me now if I have

Re: [GENERAL] wierd problems with DBI/DBD::pg?

code related to them. Do you use mod_perl ? I presume you're 'Internal error' is from Apache log... What version of DBI and DBD are you using ? Regards, Gilles I'm not here tomorow but can take a look on wenesday... Michelle Murrain wrote: I recently upgraded from 6.5 to 7.1, and it mostly went

Re: [GENERAL] Problem installing Postgresql

Hi, What package do you have downloaded ? You need the full install not just the base package. Regards, Gilles Al wrote: I am running OpenLinux 2.3 (Caldera) out of the box. Trying to install PostGreSQL I seem to be unable to get past the 'make' process. Errors I get at the end

Re: [GENERAL] Re: Compile PL/Perl

Hi, It works for me with 5.6.0 ! Hans-Jrgen Schnig wrote: Hans-Jrgen Schnig schrieb: Does anyone know why perl Makefile.pl doesn't produce a useful Makefile with RedHat 7.0 (Perl 5.6) and PostgreSQL 7.0.3? Hans After some hard hours of debugging and testing I finally found

[GENERAL] Re: [HACKERS] Call for platforms AIX 4.3.3 Failed

Gilles DAROLD wrote: Hi, I am currently testing beta6 on AIX 4.3.3 on a RS6000 H80 with 4 cpu and 4 Go RAM I use : ./configure --with-CC=/usr/local/bin/gcc --with-includes=/usr/local/include --with-libraries=/usr/local/lib All seem to be ok, There just

Re:[GENERAL] Call for platforms AIX 4.3.3 Failed

Peter Eisentraut wrote: This could be a name mangling problem. Maybe the linker needs to be invoked specially when building C++ libraries. Maybe the C++ compiler driver needs to be invoked directly. This could especially be a problem if you're using the GNU compiler with system libraries,

Re: [GENERAL] ODBC with Visio

probably do not have open source. I don't think PostgreSQL can handle this syntax but it will be a great feature to uniformize my perl source code :-) even if it does nothing. Regards Gilles DAROLD Steven Saner wrote: I am trying to get Visio (5.5 Enterprise) on Win98/NT to talk with Postgres

Re: [GENERAL] illegal characters

(such as quotation marks) contained within the string and adding the required type of outer quotation marks. $sql = $dbh-quote($string); Regards Gilles DAROLD Oleg Lebedev wrote: Hello, I am using postgresql to store data passed from a web page. A user may enter whatever text she wants

[GENERAL] Re: Connection Pool

Hi, Just try it and you will trust it ! Personnaly I use it for a long time... but don't trust me I'm a persistance mistake, perhaps one day I will write a pool of mistake :-) Regards Gilles DAROLD August Zajonc wrote: Apache is multi-process. What are you talking about? If I define global

Re: [GENERAL] Connection pooling

Hi, With Apache/mod_perl it is very simple to enable DB connection persistance. in your perl script : use vars qw($dbh); $dbh ||= DBI::connect($datasrc, $dbuser, $dbpwd); That create a persistance connection to your DB and you do not have to care about a pool of connection. Double pipe do

Re: [GENERAL] Re: PL/Perl compilation error

Hi, Do you use the file GNUmakefile and ppport.h I recently send to the list ? What is your version of Perl ? Could you send me output of your build ? Regards, Gilles DAROLD Larry Rosenman wrote: Broke my build on UnixWare 7.1.1... May be perl version confusion... See my post to -hackers

[GENERAL] PL/Perl compilation error

patch ppport.patch rm ppport.patch Thanks to Kenneth Albanowski for his PPPort.pm usefull package and to Tom Lane for his ligth. Note: the attachment is a tar of all modified and added files in the source tree. Regards, Gilles DAROLD ppport-change.tar.gz

Re: [GENERAL] Out of memory errors with mod_perl

Hi, I've got this very bad message with Apache 1.3.6 running mod_perl and postgresql 6.3.2 with a site hosted by an ISP. They just allocate a max of 10 Mo of memory for each user. For me this was a message coming from server resources. Not enougth memory. At home with the same configuration I

Re: [GENERAL] PL/Perl compilation error

plperl.so. This patch (simple diff) applies to postgresql-7.0.2. See attachment... Regards Gilles DAROLD 328c328 if (SvTRUE(GvSV(PL_errgv))) --- if (SvTRUE(GvSV(errgv))) 334c334 elog(ERROR, "creation of function failed : %s", SvPV(GvSV(PL_errg

Re: [GENERAL] PL/Perl compilation error

repared. I have no time yet but I will take a look as soon as possible. Regards Gilles Alex Guryanow wrote: Hi, I have just installed Perl 5.6.0 and PostgreSQL 7.0.2. After successfull installation of both these programs I tried to make PL/Perl support. After running the commands from Postgr

Re: [GENERAL] Importing data into database

Take a look at the sql COPY command (\h COPY) it will do it as you want ! [EMAIL PROTECTED] wrote: How should I go about importing the contents of an Excel spreadsheet into a Postgres database table? I was considering a comma separated file, but am not sure how to import this into the

Re: [GENERAL] nested transactions

with PostgreSQL 6.5.3 , Perl DBI, Apache/mod_perl They are all running well and with transactions Gilles

Re: [GENERAL] Web front-end

Hi, I have seen DBengine on Freshmeat few weeks ago, perhaps this this what you are looking for... Regards, Gilles "Jeffrey A. Rhines" wrote: It seems i remember seeing somewhere that someone had developed a generic web front-end to Postgres. Was this a dream, or has someone

Re: [GENERAL] Trouble with RPM

such of words on my work... I like rpm, especialy for system update. Congratulation ! Gilles

Re: [GENERAL] responses to licensing discussion

to the University of California what programmers can do to protect their works ? Apology my poor understanding but it smell something wrong for me. Is PostgreSQL Inc. have the same need than Landmark/Great Bridge concerning this licence migration ? Regards, Gilles DAROLD

[GENERAL] Search engine down ?

Hi, I want to find information into your search engine for postgresql mailing list but I can't find any answer to my search. Typing SELECT or CURSOR or any other words in pgsql-general or pgsql-sql give me no output. Perhaps you have an indexation problem ? Regards

Re: [GENERAL] Search

in koi8-r whose locale present in almost all UNIX'es. I don't know about windows-1251. Perhaps this can't help you. But if you have japanese in you database, you can proceed a search on it so why not windows-1251 ? A+ Gilles

Re: [GENERAL] PG95 module for Apache1.3.x..?

at mod_perl : http://perl.apache.org/ and DBI-DBD at http://theory.uwinnipeg.ca/CPAN/by-name/DBD-Pg.html Sorry if it don't help you. Gilles Darold

Re: [GENERAL] 6.4.2 and 6.5 date usertype difference

calization with your previous installation of 6.4.2. The date format in your 6.5 sample is the default format for date, and for the 6.4.2 sample the format has been changed. Guess it help, there's stuff on localization on documentation. Gilles Darold

[GENERAL] Thanks for all your answers

, or perhaps France is not in the world :-) Here I can not find any offer with PostgreSQL and WWW services really cost a lot : $70-90/month for a normal little housed domaine name with 10Mo ! Thanks again, Regards, Gilles Darold

[GENERAL] ISP with PostgreSQL

because I use Perl/DBI but I really don't want to. I want PostgreSQL because I need PostgreSQL as a professional solution. Also, I'm a free developper. I do it by myself on my sleep time as most part of you, so I need cheapest services :-)))... Thanks a lot, Gilles Darold

Re: [GENERAL] Problems compiling

:-))) Regards Stuart Rison wrote: Hi, Part II (translation) : You need C++ compiler installed on you Linux box. See your log : checking for c++... no checking for g++... no This is the reason. Regard, Gilles. Does this mean you cannot compile PG 6.4.2 without a C++ compiler or just

Re: [GENERAL] Installer PostGres..

de s'exprimer en anglais sur cette mailing liste car je n'ai encore jamais vu d'article en francais :-) Bien, si tu n'y arrive pas, envoi moi un mail demain a mon adresse, je pourrais t'aider en ligne dans l'apres-midi... Bonne soiree et bon debut sur PostgreSQL A+, Regards Gilles Note : pour

Re: [GENERAL] How to display stored image on web page?

Hi, You just have to use the read() function directly into your image field. I think there is an example into the documentation, perhaps the programmers guide ? If not I can send you a perl script which is doing this kind of stuff! Regards, Bernie wrote: Now that I've stored several jpg's in