Re: [HACKERS] Accessing Database files on a "read-only" medium...like a CD.

2001-10-07 Thread Serguei Mokhov
Kelly Harmon <[EMAIL PROTECTED]> wrote in message 9pr7f7$k0j$[EMAIL PROTECTED]">news:9pr7f7$k0j$[EMAIL PROTECTED]... > SO...I dug around through the code a little and found where the error was > coming from and changed the code so that if the open attempt with O_RDWR > fails, the code tries again

[HACKERS] Accessing Database files on a "read-only" medium...like a CD.

2001-10-07 Thread Kelly Harmon
I'm curious as to whether anybody has gotten PostgreSQL to work with a database that lives on some sort of read-only medium...like a CD. I've looked around in the newsgroups and I've seen a comment by Bruce Momjian that it can't currently be done...and I've seen a different comment by Tom Lane th

[HACKERS] Secure enough to use CVS version?

2001-10-07 Thread Kovacs Baldvin
Hello! I would like to ask your opinion and about your intuitions on the question: is it secure to use the cvs version of postgres instead of 7.1? (The more specific question is below...) Sorry for enlarging the traffic of th elist with this possibly non-interesting question. To be more precise

Re: [HACKERS] UTF-8 support

2001-10-07 Thread Serguei Mokhov
- Original Message - From: Tatsuo Ishii <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 3:12 AM > > Which ones belong to the backend and which ones to the frontend? > > Or even more: which ones belong to the backend, which ones > > to the frontend #1, which ones to the frontend #2,

Re: [HACKERS] [patch] ALTER RENAME and indexes

2001-10-07 Thread Tom Lane
It occurs to me that the real problem is not so much ALTER RENAME not doing enough, as it is psql doing the wrong thing. The \d display for indexes is almost entirely unhelpful, since it doesn't tell you such critical stuff as whether the index is a functional index nor which index opclasses are

Re: [HACKERS] ALTER RENAME and indexes

2001-10-07 Thread Brent Verner
On 07 Oct 2001 at 04:03 (-0700), Stephan Szabo wrote: | | On Sat, 6 Oct 2001, Brent Verner wrote: | | > On 06 Oct 2001 at 20:13 (-0400), Rod Taylor wrote: | > | Of course, in 7.1 foreign key constraints become rather confused when | > | you rename columns on them. | > 1) modify this tgargs val

Re: [HACKERS] ALTER RENAME and indexes

2001-10-07 Thread Stephan Szabo
On Sat, 6 Oct 2001, Brent Verner wrote: > On 06 Oct 2001 at 20:13 (-0400), Rod Taylor wrote: > | Of course, in 7.1 foreign key constraints become rather confused when > | you rename columns on them. > | > | create table parent (id serial); > | create table child (id int4 references parent(id) o