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
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.3
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 operator
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...@fossology.org
--
Sent
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)?
I can't
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 logging
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
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
Open Source Program
(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 the
master will contain no data.
Thanks,
Bob Gobeille
b...@fossology.org
has millions of files (some distro iso's have ~7M
files), I want to store them in their own partition.
Many thanks for the confirmation!
Bob Gobeille
b...@fossology.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On Jul 29, 2009, at 7:02 AM, Jasen Betts wrote:
On 2009-07-27, Bob Gobeille bob.gobei...@hp.com 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
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 bob.gobei...@hp.com 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
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
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 to your subscription:
http
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
18 matches
Mail list logo