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
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
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
);
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"
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
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
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
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
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
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
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
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
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
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
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
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
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
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
18 matches
Mail list logo