[GENERAL] unsubscribe

unsubscribe ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Looking for persons interested in a Beta version of a PostgreSQL reporting tool

Hello, I'm wondering if you can help. We are currently enabling QLR Manager (http://www.qlrmanager.com) to work with PostgreSQL. QLR (Query, Layout & Report) Manager is a php server based reporting and graphing tool that currently works with Oracle and MySQL. It runs on most any javascript ena

Re: [GENERAL] Will someone please be a vote taker.

Mike Cox wrote: > PostgreSQL 8.0 will be released on Wednesday, Jan 19, 2005. As of > today, there were 775 people who said they would like a PostgreSQL > newsgroup in a web poll. See the results here: > > http://www.postgresql.org/community/survey.36 . > > PostgreSQL 8.0 is a milestone release.

Re: [GENERAL] [ANNOUNCE] USENET vs Mailing Lists Poll ...

[EMAIL PROTECTED] writes: >On 30 Nov 2004 22:55:00 GMT, Woodchuck Bill <[EMAIL PROTECTED]> >wrote: >>Marc G. Fournier From: <[EMAIL PROTECTED]> wrote in >>news:[EMAIL PROTECTED]: >> >>> Just as an FYI ... the latest RFD is for *one* >>> comp

Re: [GENERAL] [ANNOUNCE] USENET vs Mailing Lists Poll ...

[EMAIL PROTECTED] (Bill Harris) writes: >"Marc G. Fournier" <[EMAIL PROTECTED]> writes: >> "If there was an official newsgroup for postgresql, would you switch >> to using Usenet from using the mailing lists?" >> As a side note, for those that

[GENERAL] Recovering data from corrupted table. Urgent Help!!

Hi: Is there any way to recover data from a corrupted table? I can only run SELECTs on certain WHERE conditions. I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex, always get error: ERROR: could not access status of transaction 4244329 DETAIL: could not open file "/usr/loc

[GENERAL] could not access status of transaction 4244329

Hi: I've migrated a couple of weeks ago from 7.4.2 to 7.4.5 and I am getting this error after executing a query: Warning: pg_exec() query failed: ERROR: could not access status of transaction 4244329 in /home/wisconsin/www/_proc/bbdd/_c_bbdd.php on line 160 ERROR ACCESO BASE DE DATOSERROR:

Re: [GENERAL] current transaction is aborted, commands ignored until

web browser and sometimes it worked and sometimes not. Thanks a lot. Ruben. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[GENERAL] Postgres memory usage

Hi: Our postgres database has tables with several million rows in a server running Red Hat 8.0 with 1GB of memory. Recently we are experiencing a low performance in the access to the server via HTTP, after rebooting the server the speed is the same. I have noticed that available memory is aparently

[GENERAL] Upgrading PostgreSQL 7.1.3

Hi: I'm planning to migrate a postgres database version 7.1.3 to a newer version. There are some tables with up to 5 million records and I'm begining to suffer from data corruption in indexes and tables. I did some hardware checkings and everything seems ok. The last move, as someone suggested

Re: [GENERAL] Moving tables between schemas

may need to grant rights in order to allow your users to > access the tables... > > Hope that helps > > John Sidney-Woollett > > create > > [EMAIL PROTECTED] wrote: > > > > Hi, > > > > In my database, I created a lot of tables before I f

[GENERAL] Moving tables between schemas

ynewschema2.table2 ? Thanks. Max ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] enumerated type..

can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] LOG table changes ...

---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] virtual fields on VIEW?

> SELECT ... >CASE > WHEN date < CURRENT_DATE THEN 'green'::text > WHEN date > CURRENT_DATE THEN 'red'::text > ELSE 'blue'::text >END >AS state, >(t1.field2 || t2.fieldA) AS stuff > FROM ... ]- aha thanx.. > >>> BOTH state and stuff will be only available for SELEC

Re: [GENERAL] why no answer? [Fwd: backup and restore just with use

hello scott, this is good news (for me ;-) )! what kind of client should be available (if i search for a good hoster in near future)? greetings hans Scott Marlowe schrieb: On Wed, 2004-06-16 at 23:28, [EMAIL PROTECTED] wrote: hello, thank you for your short - but

Re: [GENERAL] why no answer? [Fwd: backup and restore just with use

s Chris Browne schrieb: [EMAIL PROTECTED] ("[EMAIL PROTECTED]") writes: is there a way to do backup and restore just with the use of jdbc? You could presumably reimplement pg_dump in Java; that seems redundant in view of the fact that pg_dump is already implemented in C.

[GENERAL] security question

vent my db from beeing hacked? greetings hans ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[GENERAL] trigger statement

hello, is there a way to access the statement fiering a trigger from within a function (C for example) ? thanks, razvan radu ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's

[GENERAL] Convert TimeStamp to Date

--(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Easy way of pruning pg_data?

No they are not. I wondered if they were temporary space or something other. I might take a punt at moving them, but then again :-(! Thanks Lee - Original Message - From: "David Link" <[EMAIL PROTECTED]> To: "Lee Crampton" <[EMAIL PROTECTED]> Cc: <[EMAI

[GENERAL] Table Size/Performance

Is there a way to figure out which file represents which table? IE: I have a file 21691 and I want to know what table it is. Also, I've heard that pg splits tables when they get to about 1 gig. I have a table that could grow to that. It is 700+ megs now. Will performance/indexes be effected

[GENERAL] .mips.rpm

Hello, Where can I find postgresql-7.0.x.mips.rpm for my Qube 2?? I try to find them on the FTPs but I have seen anything please message me thanks __ Voila vous propose une boite aux lettres gratuite sur Voila Mail: http://mail.voila.fr

[GENERAL] jdbc, use of nested ResultSet loops.(longish, interesting I hope)

A few days ago I posted a query regarding a problem I had with errors I was incurring doing some nested queries with the jdbc driver. (having recently done a re-install my email history is in limbo for the moment) Found some of my problems were in messy ugly code, fixed some of the problems by

[GENERAL] TCL fonts

I am trying to run pgaccess from a remote X client. However all of the text on the screen is unreadable. Does anyone know what font the TCL front-end for pg uses? Dan Denault Network Administrator Corporation for Standards and Outcomes Phone: 412.968.3727 Fax : 412.968.3737 Cell : 412.370.3412

[GENERAL] parser

ser should do this since the context is as a field name. == Jeff MacDonald [EMAIL PROTECTED] irc: bignose on EFnet ==

<    1   2   3