[HACKERS] Fwd: [SQL] Distributed keys

2003-12-24 Thread Michael Glaesemann
Begin forwarded message: From: Michael Glaesemann [EMAIL PROTECTED] Date: December 23, 2003 3:42:24 PM CST To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: [SQL] Distributed keys Hello all! An area of the relational database model that is not included in the SQL standard are distributed

[HACKERS] Distributed keys / Inheritance

2003-12-24 Thread Michael Glaesemann
Here's Tom Lane's response to my original post on pgsql-sql: This seems to have considerable overlap with the problem of indexing inheritance hierarchies (so that constraints on tables with children would work as people expect). It may be that it's sufficient to solve it for inheritance cases,

[HACKERS] (Mis?)Behavior of \copy with -f and \i

2003-12-24 Thread Mark Feit
Greetings... I've run into a problem with the way \copy behaves when psql is reading its input from a file using either the -f command line option or the \i command. (Not that it matters in this case, but this is PostgreSQL 7.4 on i686-pc-linux-gnu, compiled with gcc.) The following...

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-24 Thread Ivelin Ivanov
That was uncalled for. Statements like this do not make the Postgres community any healthier. You don't have any benefit of pushing back Java users. Ivelin --- Jean-Michel POURE [EMAIL PROTECTED] wrote: Le Mardi 09 Décembre 2003 16:15, Ivelin Ivanov a écrit : I think that a co-bundle

Re: [GENERAL][ADMIN][HACKERS]data fragmentation

2003-12-24 Thread Joshua D. Drake
Hello, An quicker option would be to use rsync (on a stopped database of course). You can rsync to a new directory (off the filesystem) and then reformat the data filesystem and move it back. J Somasekhar Bangalore wrote: Hi, I too had the same problem; There was one query which used to