Re: [GENERAL] Unicode database question

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 ---(end of broadcast

Re: [GENERAL] Are you frustrated with PostgreSQL

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.net Library management software toolkit, redhat linux on Sony Vaio

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 7: don't

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

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, Dreamweaver MX with Tomcat and PostgreSQL

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

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 anything else, tough... Cheers Tony Grant

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

Re: [GENERAL] locale and spanish acute

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 3: if posting/reading through Usenet, please

[GENERAL] valid NULL DATE value

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 searched our list

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

Re: [GENERAL] Printable report generation

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 Cheers Tony Grant -- RedHat Linux

[GENERAL] user guide

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. Cheers Tony Grant

[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

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

[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

Re: [GENERAL] Books on PostgreSQL?

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 Linux on Sony Vaio C1XD/S http://www.animaproductions.com

Re: [GENERAL] Storage limits in PostgreSQL?

designing web apps fun. 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 5: Have you

Re: [GENERAL] Red Hat to support PostgreSQL

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 Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http

Re: [GENERAL] More Red Hat information

see licensing per server, or even per CPU, but licensing any server application per user quickly becomes ridiculous when the server is supporting any internet application. I posted the cost of 4D licence for web connected database and 10 local clients a few days ago: about $4475 Cheers Tony

[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

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

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 C1XD/S http

[GENERAL] need some help with a SELECT

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 Macromedia UltraDev

[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] Ideal hardware configuration for pgsql

. 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 through Usenet, please send an appropriate

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

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 searched our list archives? http

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

=BOULSubmit=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/linux2.html

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

ment 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

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 Grant -- RedHat Lin

[GENERAL] JDBC compile

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

[GENERAL] Re: IDE or RAD tools

. 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

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

5: 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] RE: Why is there so much MySQL bashing???

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

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 last time you tried? Yesterday... The RedHat 6.2 rpms are broken

[GENERAL] initdb failing

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