Re: [GENERAL] query and pg_dump problem on my postgresql 6.5.3/Redhat 6.2

2003-12-06 Thread Wind Wood
hi, The disk just had problem, I used fsck to fix it, But the problem of database is still there.   After I read the postgresql document and found this: -- COPY stops operation at the first error. This should not lead to problems in the event of a COPY FROM, but the target relation will, of

[GENERAL] ERRORs after upgrade from 7.2.1 to 7.4 about nonexisting large objects

2003-12-06 Thread Dirk Försterling
Hi, sorry for reposting, but it seems my message just hit nothing but air. If I posted to the wrong list or did something else wrong with the message, please let me know. I really want to know what's going on but still found nothing. I do not know when and where the statements are produced that le

Re: [GENERAL] query and pg_dump problem on my postgresql 6.5.3/Redhat 6.2

2003-12-06 Thread Martijn van Oosterhout
Hmm, you do realise that 6.5 is *really* *really* old. Who knows how many bugs there are. There have been *5* major releases since and many more minor ones. I remember back then, 6.5 had many quirks that required a vacuum to fix (or couldn't be fixed at all). I remember when creating a temporary t

Re: [GENERAL] Misplaced modifier in Postgresql license

2003-12-06 Thread Bruce Momjian
Robert Treat wrote: > > > All of the arguments about license changes have been gone over in great > > > detail in the archives (I think the last major go-round on the topic was > > > in the summer of 2000). No one who has been around long enough to > > > remember those flame wars is interested in

Re: [GENERAL] transaction in progress

2003-12-06 Thread Bruce Momjian
Rick Gigger wrote: > Is there a convenient way to tell in postgres if a transaction has been > started or not? libpq has PQtransactionStatus, though I wonder why we don't have this visible via a read-only GUC variable to make it easier for other languages. Anyone? -- Bruce Momjian

Re: [GENERAL] postgresql locks the whole table!

2003-12-06 Thread Bruce Momjian
Greg Stark wrote: > > Dr NoName <[EMAIL PROTECTED]> writes: > > > My question is why??? The two insert operations do not > > conflict with each other (at least not in the > > real-world situation). Also, why does the foreign key > > make a difference? > > It's not locking the whole table, it's l

Re: [GENERAL] Making a tree with "millions and millions" of dynamic

2003-12-06 Thread Arjen van der Meijden
> Rick Gigger wrote: > > I was glad to see this topic come up on the list as I was > about to start asking about some of these issues myself. I > would like to discuss each of the methods I have researched > so far for doing trees in sql and see if anyone has some > experience or insite into

Re: Any *current* summary of postgres-r 7.2 status? (was Re: [GENERAL]

2003-12-06 Thread Bruce Momjian
Postgres-R is not ready for production, and development seems to have stopped., and I don't know what multi-master solutions we can really offer right now. We do have several master/slave replication solutions. --- Bopoliss

Re: [GENERAL] xor for text

2003-12-06 Thread Tino Wildenhain
Hi Berend, [EMAIL PROTECTED] wrote: Anyone have a good function for byte-by-byte XOR of text or varchar data (or does one exist already in pg which I missed in the documentation)? ~Berend Tober You should have a look at pg_crypt which offers a wider range of cryptographic functions for postgres. I

[GENERAL] Feedback? Is there interest in a PostgreSQL-based CRM suite friendly to shared hosting?

2003-12-06 Thread Chris Travers
Hi all; This seems at least somewhat on-topic here, so at the risk of seeming shamelessly self-promoting, I figured I would ask. I am the main developer of an open source CRM suite (http://hermesweb.sourceforge.net). We are in the beta-testing of our 0.3.0 release which will include experimental

Re: [GENERAL] transaction in progress

2003-12-06 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > libpq has PQtransactionStatus, though I wonder why we don't have this > visible via a read-only GUC variable to make it easier for other languages. Because it'd be useless --- the only way to interrogate it would be via SHOW or some other SQL command, wh

Re: Any *current* summary of postgres-r 7.2 status? (was Re: [GENERAL]

2003-12-06 Thread Bopolissimus Platypus
On Saturday 06 December 2003 20:50, Bruce Momjian wrote: > Postgres-R is not ready for production, and development seems to have > stopped., and I don't know what multi-master solutions we can really > offer right now. We do have several master/slave replication solutions. thanks. i'll look at t