[GENERAL] combining db's- importing primary keys

2009-07-27 Thread Bob Gobeille
I would like to combine multiple databases (same schema) into one master db. Does anyone know how I can reconcile all my primary and foreign keys to maintain referential integrity. Many thanks, Bob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

Re: [GENERAL] combining db's- importing primary keys

2009-07-29 Thread Bob Gobeille
On Jul 29, 2009, at 7:02 AM, Jasen Betts wrote: On 2009-07-27, Bob Gobeille wrote: I would like to combine multiple databases (same schema) into one master db. Does anyone know how I can reconcile all my primary and foreign keys to maintain referential integrity. prefix them all with

Re: [GENERAL] combining db's- importing primary keys

2009-07-29 Thread Bob Gobeille
On Jul 29, 2009, at 8:26 AM, nha wrote: Hello, Le 29/07/09 15:02, Jasen Betts a écrit : On 2009-07-27, Bob Gobeille wrote: I would like to combine multiple databases (same schema) into one master db. Does anyone know how I can reconcile all my primary and foreign keys to maintain

[GENERAL] smart or dumb partition?

2009-08-07 Thread Bob Gobeille
); INSERT INTO master (myint) VALUES (2); INSERT INTO master (myint) VALUES (3); INSERT INTO master_1 (myint) VALUES (1); Is there anything wrong with this? It seems to work well but I am concerned that I may be missing something since the docs say "master> will contain no data"

Re: [GENERAL] smart or dumb partition?

2009-08-07 Thread Bob Gobeille
On Aug 7, 2009, at 5:44 PM, Greg Stark wrote: On Sat, Aug 8, 2009 at 12:27 AM, Bob Gobeille wrote: I gather from rtfm that it is typical to set up partitions so that the "master" table has no records. But from my understanding of partitions and doing some tests, I don't

Re: [GENERAL] Generating random unique alphanumeric IDs

2009-08-16 Thread Bob Gobeille
umbers that are guaranteed not to repeat after billions of iterations. It's very fast as well. Then translate the resulting integer into the character sequence of your choosing. Here is a reference: http://en.wikipedia.org/wiki/Linear_feedback_shift_register Bob Gobeille Hewlett Packard

[GENERAL] psql command line editor

2009-08-17 Thread Bob Gobeille
I use PSQL to set my editor to vi. This works as expected in psql, \e brings up vi and I edit away. Is there any way to set my psql command line editor to also use vi (just like I do with "set -o vi" in bash)? I can't find this in the docs. Thanks, Bob Gobeille b...@fossolo

Re: [GENERAL] psql command line editor

2009-08-17 Thread Bob Gobeille
On Aug 17, 2009, at 11:30 AM, Gobeille, Robert wrote: I use PSQL to set my editor to vi. This works as expected in psql, \e brings up vi and I edit away. Is there any way to set my psql command line editor to also use vi (just like I do with "set -o vi" in bash)? I can't find this in the docs

Re: [GENERAL] psql command line editor

2009-08-17 Thread Bob Gobeille
On Aug 17, 2009, at 12:46 PM, Alvaro Herrera wrote: Bob Gobeille wrote: I use PSQL to set my editor to vi. This works as expected in psql, \e brings up vi and I edit away. Is there any way to set my psql command line editor to also use vi (just like I do with "set -o vi" in bash

Re: [GENERAL] psql command line editor

2009-08-17 Thread Bob Gobeille
On Aug 17, 2009, at 1:18 PM, Alvaro Herrera wrote: Bob Gobeille wrote: I have in my .inputrc this line: set editing-move vi and it works like a charm. I tried this and can't get it to work. 1) I tried putting that in my .bashrc script and sourcing the file (and also loggi

Re: [GENERAL] psql command line editor

2009-08-17 Thread Bob Gobeille
On Aug 17, 2009, at 1:27 PM, Steve Atkins wrote: On Aug 17, 2009, at 12:15 PM, Bob Gobeille wrote: On Aug 17, 2009, at 12:46 PM, Alvaro Herrera wrote: Bob Gobeille wrote: I use PSQL to set my editor to vi. This works as expected in psql, \e brings up vi and I edit away. Is there any

Re: [GENERAL] psql command line editor

2009-08-17 Thread Bob Gobeille
On Aug 17, 2009, at 1:38 PM, kbarn...@kevinbarnard.net wrote: On Aug 17, 2009, at 1:46 PM, Alvaro Herrera wrote: Bob Gobeille wrote: I use PSQL to set my editor to vi. This works as expected in psql, \e brings up vi and I edit away. Is there any way to set my psql command line editor to

[GENERAL] text type has no default operator class for GIN?

2009-08-18 Thread Bob Gobeille
CREATE INDEX "ufile_name_search" ON "public"."uploadtree" USING GIN ("ufile_name"); ERROR: data type text has no default operator class for access method "gin" HINT: You must specify an operator class for the index or define a default operator class for the data type. This is on a new 8

Re: [GENERAL] text type has no default operator class for GIN?

2009-08-18 Thread Bob Gobeille
On Aug 18, 2009, at 3:46 PM, Gobeille, Robert wrote: CREATE INDEX "ufile_name_search" ON "public"."uploadtree" USING GIN ("ufile_name"); ERROR: data type text has no default operator class for access method "gin" HINT: You must specify an operator class for the index or define a default oper

Re: [GENERAL] text type has no default operator class for GIN?

2009-08-19 Thread Bob Gobeille
he original conf file (debian install) I didn't think of it. Bob Gobeille b...@fossology.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] plpgsql - sorting result set

2008-08-20 Thread Bob Gobeille
On Aug 20, 2008, at 7:37 PM, Merlin Moncure wrote: On Wed, Aug 20, 2008 at 7:20 PM, Robert Gobeille <[EMAIL PROTECTED]> wrote: Is it possible to sort a result set in plpgsql? That is, after building up the result set with RETURN NEXT from multiple queries, I'd like to sort the set before

Re: [GENERAL] plpgsql - sorting result set

2008-08-20 Thread Bob Gobeille
On Aug 20, 2008, at 10:11 PM, Gobeille, Robert wrote: On Aug 20, 2008, at 7:37 PM, Merlin Moncure wrote: On Wed, Aug 20, 2008 at 7:20 PM, Robert Gobeille <[EMAIL PROTECTED]> wrote: Is it possible to sort a result set in plpgsql? That is, after building up the result set with RETURN NEXT fr

[GENERAL] log rotate and open connections

2008-12-14 Thread Bob Gobeille
n the log rotates, daemon queries hang instead of returning an error about the lost connection. Suggestions? Thanks, Bob Gobeille Hewlett Packard Open Source Program Office (and http://fossology.org) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t