Re: [GENERAL] Unicode database question

m/base_de_donnees.html is an example). I had to write a little bit of code to escape accents in search pages so école and ecole will get results. Cheers Tony Grant -- www.tgds.net Library management software toolkit, redhat linux on Sony Vaio C1XD, Dreamweaver MX with Tomcat and PostgreSQL

Re: [GENERAL] Are you frustrated with PostgreSQL

t over MySQL? Yes. Yes. > > 5. How often do your PostgreSQL run into problem or crash? Are most of the > > problem caused by PostgreSQL itself? I had a hardware failure and thanks to the list was able to get all my data back from a 6.x generation database. Tony Grant -- www.tgds.

Re: [GENERAL] LATIN1 encoding

On Wed, 2003-07-02 at 13:32, Alejandro Javier Pomeraniec wrote: > Hello !! > > Can i configure a table or an entire database to use LATIN1 ascii encoding? createdb -E LATIN1 my_db_name Cheers Tony Grant ---(end of broadcast)--- TIP

Re: [GENERAL] How many fields in a table are too many

ase Application Programming with Linux" Wiley. There are some good table design chapters even for non Linux people. Good database design helps make PostgreSQL run fast. Cheers Tony Grant -- www.tgds.net Library management software toolkit, redhat linux on Sony Vaio C1XD, Dreamweave

Re: [GENERAL] [pgsql-advocacy] interesting PHP/MySQL thread

e a very good image when it comes to stability or security for example. It may be better marketing to say "you can use PostgreSQL with Zope, Tcl/tk, Python, JSP or even PHP". Rather than "you _HAVE_ to use PHP as a front end if you want to run MySQL because, if you want to use anyt

[GENERAL] inserting data into multiple tables

ames to the table and get the newly created individual_id. Then I though of using a function to write the book_id and the individual_id to refers_to. QUESTIONS I am using JSP so the ideal seems to be stored functions in pl/pgsql? What is the best order to do this in order to prevent a performance hit?

Re: [GENERAL] locale and spanish acute

On Mon, 2001-09-17 at 22:49, Martín Marqués wrote: > But I want it to work with más too. For that I would need to change that > query for this one: > > select count(*) from tab1 where to_ascii(col1) ILIKE to_ascii($1) > > Right? Right that will work because the content and the request is c

Re: [GENERAL] locale and spanish acute

) works for me. The variable is passed via .jsp Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html ---(end of broadcast)-

Re: [GENERAL] valid NULL DATE value

Peter Eisentraut, Oliver Elphick, len morgan, Thank you. \N did the trick with pgaccess. I have just cleaned up over 15000 database records in BBEdit (the data was on a Mac server) and now ama trying to remember what I did last time to get my accents right... When will I ever learn to take note

[GENERAL] valid NULL DATE value

about importing DATE? Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html ---(end of broadcast)--- TIP 6: Have you se

Re: [GENERAL] Printable report generation

esql itself. I have the same problem but I need a guide on JDBC serialization. I would like to put a button on a JSP that will save the result of a query to local disk as a tab delimited file. That will permit me to open it in AppleWorks for mailing label printing. Any pointers greatly appreciated C

[GENERAL] user guide

seeing the international following of the software. For a newcomer this could save a certain number of hours of headscratching when the accentuated characters don't show up... If I was to rate the manual I would say "better than many manuals for shrinkwrap software but loses steam towards the end&q

Re: [GENERAL] html to postgres...

Thanks to all for the input. Because of the limits of my knowledge of perl, C etc... I'll do a batch job from BBEdit. I have found a Tidy plugin for BBEdit, installed the latest version of BBEdit Lite and the HTML tools. All I need now is to write up the description for the XML output. While it

[GENERAL] html to postgres...

Hello, I have several hundred HTML (!) pages that need to be converted to a format that in turn can be imported into PostgreSQL. They are all built on a very similar grid. Any thoughts? Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html

[GENERAL] Re: [JDBC] JDBC and stored procedures

On 11 Jul 2001 10:20:29 -0400, Dave Cramer wrote: > The GetProcedures function in the driver does not work. OK. I bet it is on the todo list =:-D > You should be able to a simple select of the stored proc however Yes! thank you very much!!! SELECT getcountryname(director.country) did the tri

Re: [GENERAL] Books on PostgreSQL?

ic card does this in X too. I will have Acrobat 5 in the next few days. If you are interested maybe it would be worth while to convert the .ps docs to e-book format? Off home - temperature is back up over 30° again so time for a beer or two. Cheers Tony Grant -- RedHat Linu

Re: [GENERAL] More Red Hat information

bout $4475 Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html ---(end of broadcast)--- TIP 2: you can get off all list

Re: [GENERAL] Red Hat to support PostgreSQL

server it needs to be hardened a little, but that is no big deal. On the Power tools disk in that set there was Postgresql. Having read the then non free licence of mySql I installed Postgresql. Yes things really are that simple out here in user land. Cheers Tony Grant -- RedHat

Re: [GENERAL] Storage limits in PostgreSQL?

py / pasted in at least two passes. 32 K is playing with the devil - I wouldn't try over 24. Makes designing web apps "fun". Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with Postgr

[GENERAL] XML question

hello, Just a couple of questions: - what is the _most popular_ way of storing XML data in posgresql? - what is the _best_ way of stocking XML data in postgresql? Quick and nasty opinion poll... Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com

[GENERAL] need some help with a SELECT

I was thrown out of math class in high school... All these dark secrets which are coming out now... I don't want code I want the logic so that I can try to write the code for myself. TIA Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedi

Re: [GENERAL] Re: Re: Which Front End for Postgresql

On 21 May 2001 13:02:21 +, Michelle Murrain wrote: > Actually, I was going to investigate this for FileMaker - are their > postgresql ODBC drivers for the mac? I couldn't find any. M$ ones should work. There is one for 4D ($$$) Cheers Tony Grant -- RedHat Linux on Sony Vaio

Re: [GENERAL] Re: Which Front End for Postgresql

Hi, Does anybody know of any issues with Mac OS 9.x and either AppleWorks or Excel and ODBC access to a Postgres backend? I have a client who needs to print labels and who has AppleWorks. Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html

[GENERAL] Moving to 7.1.1

me. JDBC compiled just fine. And now I have logging working as advertized to boot. Great work guys! Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html

Re: [GENERAL] DB Getting Slower and Slower and Slower....

When I moved from 7.0.3 to 7.1RC4 I changed the JDK. Read the JDK changelogs they mention something Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html ---(end of broadcast)--- TIP 6: Have you se

Re: [GENERAL] Ideal hardware configuration for pgsql

other machine now. There are issues with kernel 2.4.x read Alan Cox's ramblings on it. Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html ---(end of broadcast)--- TIP 3: if posting/reading

[GENERAL] Converting queries to upper case

Another question I am submitting my JDBC queries via HTML form. Is it best to convert the query to UPPER CASE with java script in the form when submitting it? Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html ---(end

[GENERAL] Strange locale goings on

Hello, I am querying my French language data via JDBC. Accented caracters do not get returned. When I query via Webmin (Perl???) accents are just fine. Quid??? Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html

[GENERAL] Two questions

BOUL&Submit=Rechercher but I really want the SELECT to look for %BOUL% dont I? 2. What is the best sollution for printing address lables from a Postgresql database? pgaccess, a Java application... Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/lin

Re: [GENERAL] Re: ongoing holy grail thread - VICTORY!!!

should maybe get this info out to Macromedia to supplement the MySQL stuff that is already in Ultradev. Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] JDBC and Perl compiling problems w/ postgresql-7.1rc4

ore using "Using driver on this machine" It won't connect to the server yet but I suspect that this is more likely a connection configuration problem. Looking into it. Still for the final 7.1 version I would _really_ like to be able to compile everything on my machine... Cheers Tony

[GENERAL] JDBC compile

javac] Note: Some input files use or override a deprecated API. [javac] Note: Recompile with -deprecation for details. [javac] 4 errors is all that this gives me. Hey guys it has to be easier than this the rest of the compile went really well... Cheers Tony Grant -- RedHat Linux on

Re: [GENERAL] ongoing holy grail thread

;m tired, I've been working on this all day so I think I'll go home soon. I am very happy it is the first time I have managed to compile postgres for years. With ant and java support no less!! Good word developpers! Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.an

[GENERAL] Re: IDE or RAD tools

ment. If you need a WWW thin client throw in Enhydra/Kelp application server. Cheers Tony Grant ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[GENERAL] Re: Bad book review

his cheese. His data base server crashed??? Come on now Bruce! We all get a bad review from time to time. Don't lose any sleep. Your next book will be perfect - "Dreamweaver Ultradev application building with Postgresql" =:-` Cheers Tony Grant

[GENERAL] Re: initdb doesn not create template1 database

On 2001.01.19 16:10:33 +0100 Tom Lane wrote: > Tony Grant <[EMAIL PROTECTED]> writes: > > /usr/bin/initdb: /tmp/initdb.29795: Permission denied > > Pretty odd. Uh, you're sure /tmp is world-writable? U... I had a mail server problem that nuked my /tmp directo

[GENERAL] Re: initdb doesn not create template1 database

/bin/initdb: /tmp/initdb.29795: Permission denied /usr/bin/initdb: /tmp/initdb.29795: No such file or directory initdb failed. Removing /home/postgres. rm: cannot remove directory `/home/postgres': Permission denied Failed. Removing temp file /tmp/initdb.29795. Cheers Tony Grant -- It's just some computers connected together...

[GENERAL] initdb failing

ch file or directory initdb failed. Removing /home/postgres. rm: cannot remove directory `/home/postgres': Permission denied Failed. Removing temp file /tmp/initdb.29795. HELP =;-` Cheers Tony Grant -- It's just some computers connected together...

Re: [GENERAL] RE: Why is there so much MySQL bashing???

On 2001.01.18 17:31:29 +0100 Lamar Owen wrote: > Tony Grant wrote: > > > > > > > > That can't be good for PostgreSQL, can it? > > > > Neither can not being able to do rpm -Uvh and have it work first > time... > > H... When was the la

[GENERAL] RE: Why is there so much MySQL bashing???

re to get a Postgresql / JSP application hosted when there are hundreds of ISPs hosting Mysql / JSP... All these things must change. Just being better is not good enough - the Mac is a better desktop computer than a Windows PC. Cheers Tony Grant -- It's just some computers connected together...