[GENERAL] pgFormatter v2.1 has been released

SQL-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 env

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

t, any 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

FROM 1 FOR 10 ) AS sname; SELECT substr ( firstname, 1, 10 ) AS strpart FROM mytable; Best regards, -- Gilles GPL tools at http://www.darold.net/ (squidclamav - sendmailanalyzer - ora2pg - modproxyhtml - pgCluu squidguardmgr - sysusage - squidanalyz

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, and

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: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 a

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

Re: [GENERAL] PL/java?

ded to decide me: no more 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

[GENERAL] PG log analyzer v1.1

statistics, 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 G

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... ] >

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 to

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

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

and some source 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 upgrad

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 librari

[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/li

Re: [GENERAL] Re: Compile PL/Perl

Hi, It works for me with 5.6.0 ! Hans-Jürgen Schönig wrote: > Hans-Jürgen Schönig 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 testi

Re: [GENERAL] illegal characters

ters (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 > e

Re: [GENERAL] ODBC with Visio

m you 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 wi

[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

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 all

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 m

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

Re: [GENERAL] PL/Perl compilation error

rrgv and PL_na you will get > > success to compile the lib 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 <

Re: [GENERAL] full text indexing

#x27;t remember exactly what it does with search (AND/OR) but this depend on what you want as result, so hack it. Of course it's Perl... Search is very fast ! And in any way you can easily hack it to match your needs. Let me know if your are interested I will post it to the list. Regards,

Re: [GENERAL] Proposal for new PL/Perl README

rgv), PL_na)); --- > elog(ERROR, "plperl : error from function : %s", SvPV(GvSV(errgv), na)); Regard, Gilles

Re: [GENERAL] PL/Perl compilation error

s to be easily 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. Aft

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

Re: [GENERAL] Tables Question

Hi, > How can I retrieve the "names" of all the tables in my database ? Not sure what you are using but if you use DBI perl interface you can use this two functions : $sth = $dbh->table_info; @names = $dbh->tables; They works well with DBD::Pg. In psql simply type \d. this is certainly n

Re: [GENERAL] nested transactions

e around 4000 online shop running 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 som

Re: [GENERAL] Trouble with RPM

ow -- so, yes, it does > strike a nerve. Sorry for your nerve this was just and informative reflexion not a comparison otherwise I promise you I'll never use rh anymore :-) I understand that my message heart you a little, I don't like such of words on my work... I like rpm, especialy for system update. Congratulation ! Gilles

Re: [GENERAL] responses to licensing discussion

h belong 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

I can't store data 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..?

work with Apache take a look 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] Perl - Apache / Postgress

handle is used by two processes at the same time. Each child must have it's own unique connection handle. Gilles DAROLD

Re: [GENERAL] 6.4.2 and 6.5 date usertype difference

#x27;ve probably done a localization 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

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

difficult 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

time :-))) 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. > > > >Re

Re: [GENERAL] Problems compiling

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. Jonathan Scott wrote: > Hello fellow PostgreSQL users.:) > > I am having trouble with the con

Re: [GENERAL] Installer PostGres..

ecis. Je crois aussi le mieux c'est 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... Bonn

Re: [GENERAL] DISPLAYING BLOBS/images/text

Hi, You can use the lo_open() - lo_read() - lo_write() - lo_seek() C like functions that allow to read, write and more directly into your blobs and so display data on the fly... This is already in the documentation - PostgreSQL Programmer's Guide - Chapter 15. Large Objects. Martin Wong wrote:

Re: [GENERAL] Porting to RTOS

Hi Tim, Perhaps it's usefull for VxWorks or PostgreSQL to have such a port, but I think that a better way is to use Linux Real Time. You will have less port problems and probably no lost of time. Ok, this is my point of view! Tim Wadsworth wrote: > Hello, > > I was wondering how easy or other

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

[GENERAL] JDBC with POSTGRES

Hello, I have a little problem with connecting a Java standalone application and Postgresql 6.3.2. In fact it doesn't connect. Before sending you the error output, is anybody can tell me if I have to declare a user/password in the h_dba_conf if I want this to work? I ask this because I can't t