Re: [GENERAL] running PostGres without installing it

2006-08-05 Thread Merlin Moncure
On 8/6/06, jesus martinez <[EMAIL PROTECTED]> wrote: hello, how are you ? i want to distribute a copy of PostGres to my clients. they really dont know anything about installing programs or configurating remote RDBMS sql-servers, so i dont want to give them the "official-PostGres-installer.exe" b

[GENERAL] running PostGres without installing it

2006-08-05 Thread jesus martinez
hello, how are you ? i want to distribute a copy of PostGres to my clients. they really dont know anything about installing programs or configurating remote RDBMS sql-servers, so i dont want to give them the "official-PostGres-installer.exe" but my own installer.exe (win32) that: 1) install the P

[GENERAL] Consulta

2006-08-05 Thread Feri@
Hola a todos, soy nuevo en esto y estoy pasando de mysql a postgres, alguien seria tan amable de explicarme como puedo obtener en un array los nombres de las tablas de una determinada base de datos en postgres. Les agradezco de antemano su colaboración.   Feri@-- Este mensaje ha sido analiz

Re: [GENERAL] Slow transfer speeds

2006-08-05 Thread Tom Lane
hansell baran <[EMAIL PROTECTED]> writes: > [ slow data retrieval using ODBC on Windows ] You'd probably be better off taking this to the pgsql-odbc list. There are some related threads in the archives: http://archives.postgresql.org/pgsql-odbc/2006-01/msg00208.php http://archives.postgresql.org/p

Re: [GENERAL] Ajax/PostgreSQL

2006-08-05 Thread John Jawed
If you take a peek at the CVS version of phpPgAdmin, you will see the "autocomplete" functionality for foreign keyed columns when doing "insert row" or "edit row". You can easily get started with that by using the pagila database and trying to insert some data into film_category. $ cvs -d:pserver

Re: [GENERAL] Ajax/PostgreSQL

2006-08-05 Thread Tyler MacDonald
Paul M Foster <[EMAIL PROTECTED]> wrote: > I'm doing some massive (internal company) applications using PHP, which > query extensive PostgreSQL tables. This is fine, but obviously it often > requires multiple web pages to get something done. Supposedly, AJAX > promises to make web pages more int

Re: [GENERAL] Ajax/PostgreSQL

2006-08-05 Thread Robby Russell
On Aug 5, 2006, at 3:42 PM, Paul M Foster wrote: But from what I can see, it would require PostgreSQL bindings in Javascript, and some way to pass the data back so that PHP could use it. No, you should be able to this all within PHP with a AJAX library. 99% of my ajax experience has been

Re: [GENERAL] missing chunk number 0 for toast value xxxxx

2006-08-05 Thread Robby Russell
On Aug 5, 2006, at 4:29 PM, Robby Russell wrote: I'm seeing this weird issue pop up on one a database. This seems to work... robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE title ~* 'postgresql' LIMIT 20; count --- 19 (1 row) ...but these two seem to be causing an err

Re: [GENERAL] Ajax/PostgreSQL

2006-08-05 Thread Peter Wilson
Paul M Foster wrote: > I'm doing some massive (internal company) applications using PHP, which > query extensive PostgreSQL tables. This is fine, but obviously it often > requires multiple web pages to get something done. Supposedly, AJAX > promises to make web pages more interactive. But from what

[GENERAL] missing chunk number 0 for toast value xxxxx

2006-08-05 Thread Robby Russell
I'm seeing this weird issue pop up on one a database. This seems to work... robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE title ~* 'postgresql' LIMIT 20; count --- 19 (1 row) ...but these two seem to be causing an error now. robbyonrails_typo_dev=# SELECT count(id) FR

Re: [GENERAL] Ajax/PostgreSQL

2006-08-05 Thread Gavin M. Roy
The way to handle this is to make your ajax call PHP scripts which handle your data and return your XML for the Javascript (or HTML). AJAX makes HTTP requests, it does not talk directly to the database server. In essence to do what you're asking you would need a JavaScript implementation

Re: [GENERAL] Ajax/PostgreSQL

2006-08-05 Thread Jorge Godoy
Paul M Foster <[EMAIL PROTECTED]> writes: > Here's an example: The user wants to enter a bill (accounts payable) into the > system. He first has to pick a vendor. Normally, this would entail a PHP page > that generates a PostgreSQL query. The user would then get a second page with > various vendor

[GENERAL] Ajax/PostgreSQL

2006-08-05 Thread Paul M Foster
I'm doing some massive (internal company) applications using PHP, which query extensive PostgreSQL tables. This is fine, but obviously it often requires multiple web pages to get something done. Supposedly, AJAX promises to make web pages more interactive. But from what I understand, I'd have t

Re: [GENERAL]

2006-08-05 Thread Raymond O'Donnell
On 5 Aug 2006 at 19:32, luciano wrote: > I stop the postmaster service and then i copy the directory in an > other place. Restart the postmaster and then test someting > modifications. Then i stop the service and restore the saved data > directory Now the postmaster dont start any more The recom

[GENERAL] Slow transfer speeds

2006-08-05 Thread hansell baran
Hi. I'm new at using PostgreSQL. I have found posts related to this one but there is not a definite answer or solution. Here it goes.Where I work, all databases were built with MS Access. The Access files are hosted by computers with Windows 2000 and Windows XP. A new server is on its way and only

[GENERAL]

2006-08-05 Thread luciano
I stop the postmaster service and then i copy the directory in an other place. Restart the postmaster and then test someting modifications. Then i stop the service and restore the saved data directory Now the postmaster dont start any more Wy?   Cucchi Luciano C.R.A.E.M. sncVia E.De Nicola 7

Re: [GENERAL] PostgreSQL Internals

2006-08-05 Thread Tom Lane
"=?ISO-8859-1?Q?Germ=E1n_H=FCttemann_Arza?=" <[EMAIL PROTECTED]> writes: > I'm a student of computer science from Asunci=F3n, Paraguay and I need to d= > o > an investigation about file layout, file organization, organization of > records in files, storage access, access methods, indexing and hashi

Re: [GENERAL] pg_xlog not cleaned up

2006-08-05 Thread Christian Kastner
Tom Lane wrote: > Christian Kastner <[EMAIL PROTECTED]> writes: >> That's not what I'm seeing. The following log messages are repeated >> every few minutes after a successful backup run: > >> LOG: Archivbefehl >/usr/local/bin/archive_wal.sh >> pg_xlog/000100020009.0018C208.backup >> 0

[GENERAL] PostgreSQL Internals

2006-08-05 Thread Germán Hüttemann Arza
Hi,I'm a student of computer science from Asunción, Paraguay and I need to do an investigation about file layout, file organization, organization of records in files, storage access, access methods, indexing and hashing of PostgreSQL database. I searched widely in the Internet but I didn't find muc