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

2001-01-18 Thread Tony Grant
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...

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

2001-01-18 Thread Tony Grant
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] initdb failing

2001-01-18 Thread Tony Grant
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...

[GENERAL] Re: initdb doesn not create template1 database

2001-01-19 Thread Tony Grant
/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] Re: initdb doesn not create template1 database

2001-01-19 Thread Tony Grant
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: Bad book review

2001-02-16 Thread Tony Grant
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: IDE or RAD tools

2001-03-19 Thread Tony Grant
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

Re: [GENERAL] ongoing holy grail thread

2001-04-09 Thread Tony Grant
;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] JDBC compile

2001-04-10 Thread Tony Grant
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] JDBC and Perl compiling problems w/ postgresql-7.1rc4

2001-04-11 Thread Tony Grant
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

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

2001-04-13 Thread Tony Grant
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]

[GENERAL] Two questions

2001-04-18 Thread Tony Grant
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

[GENERAL] Strange locale goings on

2001-04-24 Thread Tony Grant
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

2001-04-24 Thread Tony Grant
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

Re: [GENERAL] Ideal hardware configuration for pgsql

2001-05-04 Thread Tony Grant
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

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

2001-05-04 Thread Tony Grant
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] Re: Which Front End for Postgresql

2001-05-21 Thread Tony Grant
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

2001-05-21 Thread Tony Grant
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

[GENERAL] need some help with a SELECT

2001-05-21 Thread Tony Grant
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

[GENERAL] XML question

2001-06-05 Thread Tony Grant
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] Libpq problems

2000-03-29 Thread Teruel Tony
Hi, I'm interacting with postgeSQL using C languaje, I'm having compilation problems. I set the compilation definition as: PGSQL_INCLUDE=/usr/local/pgsql/include/libpq (that's where I got the path to libpq) and I'm using something like this (I'm using sockets) to compile: cc -s -I/usr/local/pgs

[GENERAL]

2000-04-25 Thread Teruel Tony
Hi, I'm having this message when trying to perform a query.. someone knows what do I have to do to fix it? Thanks pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. We have lost

Re: [GENERAL]

2000-04-25 Thread Teruel Tony
Hi, The query is simple: select count(*) from table; I have the same error message with almost all queries, I'm trying to debug what's new on that table (data) because it was working fine.. The version I'm using: PostgreSQL 6.5.3 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.66 The tabl

Re: [GENERAL] large database

2012-12-11 Thread Tony CL Chan
deployment. Thanks Tony P.S. Today I did some stress tests on my PostgreSQL staging server: a) insert 2 billions records into the test table, b) full scan the table. here are some test results: Facts: Number of records: 2 billions records inserted today Full table scan: about 16.76 minut

<    2   3   4   5   6   7