You are talking about /usr/local/data; so I assume that you are trying this on Linux or some other Nixen.You just need to use the --prefix option to configure... Here's what I typically do:
Download/'CVS checkout' the sources. Enter the source directory, and invoke configure like this:./configure
Gurjeet Singh wrote:
You are talking about /usr/local/data; so I assume that you are trying this
on Linux or some other Nixen.
You just need to use the --prefix option to configure... Here's what I
typically do:
Download/'CVS checkout' the sources. Enter the source directory, and invoke
Ritesh Nadhani wrote:
As I see, using the default MAKE for postgresql will set the data
directory etc. in /usr/local/data etc which I dont have access to as a user.
Specify the --prefix=DIR argument to configure, pointing to a directory
you can write (presumably within your $HOME). You can
[EMAIL PROTECTED] wrote:
Thanks to all who replied.
The reason I wanted to go 64-bit on our Fujitsu sparc-alikes was that
our sysadmins switched to 64-bit Perl as part of the standard
package, and that broke our DBD::Pg interface. With no warning, we
started getting a message about Pg.so,
Lenorovitz, Joel wrote:
I'd like to create a trigger function whose use can extend to multiple
tables by employing the special variables available (e.g., TG_RELNAME).
[snip]
Any advice
on outputting the values of the variables to the console for inspection
during testing would be welcome as
On Tue, Oct 31, 2006 at 11:47:56PM -0500, Tom Lane wrote:
Because we depend on libc's locale support, which (on many platforms)
isn't designed to switch between locales cheaply. The fact that we
allow a per-database encoding spec at all was probably a bad idea in
hindsight --- it's out front
Lenorovitz, Joel wrote:
I'd like to create a trigger function whose use can extend to multiple
tables by employing the special variables available (e.g., TG_RELNAME).
Below is a simple version of such a function that ought to prevent
insertion of greater than 4 total records in the table that
Tomi NA wrote:
2006/10/31, Albe Laurenz [EMAIL PROTECTED]:
You feed it to the command line interface psql.
Example:
psql -h host -p port -d database -U user dump.sql
It's a good enough solution in most cases, but when the rowcount
starts to skyrocket, it simply doesn't seem to cut it (at
From time to time I get Notice: Unknown: Cannot set connection to blocking
mode in Unknown on line 0.
What it is? Is it really a problem with postgresql. I am using Apache/2.2.3
(Unix) PHP/5.1.6/ postgresql 8.1
---(end of broadcast)---
TIP 4:
On 10/31/06, Devrim GUNDUZ [EMAIL PROTECTED] wrote:
Hi,
On Tue, 2006-10-31 at 09:31 -0800, Richard Broersma Jr wrote:
I heard that reiser4 is not yet stable. And that there is a chance
that it wont be since its author is in detention.
Here are the links:
Thanks Tom, for your reply.
Tom Lane wrote:
Carlos Moreno [EMAIL PROTECTED] writes:
Why is it that the database
cluster is resrticted to a single locale (or single set of locales) instead
of being configurable on a per-database basis?
Because we depend on libc's locale support,
Dear Sir/Madam,
I have a staff directory, which group staff in various categories I would
like to group the staff members in there specific categories,
Below is query is query I am running, it works fine and returns the output
below. My question is, how do I Group the staff members in there
We are trying to get something faster than ~ '%foo%';
Which Tsearch2 does not give us :)
Hmm, why not with GIN? :) Although, right now GIN doesn't support prefix search,
it's possible to use it.
Brain storm method:
Develop a dictionary which returns all substring for lexeme, for example for
Teodor Sigaev wrote:
We are trying to get something faster than ~ '%foo%';
Which Tsearch2 does not give us :)
Hmm, why not with GIN? :) Although, right now GIN doesn't support prefix
search, it's possible to use it.
Well they run 8.1 :)
Joshua D. Drake
Brain storm method:
Develop a
2006/11/1, Alban Hertroys [EMAIL PROTECTED]:
Tomi NA wrote:
2006/10/31, Albe Laurenz [EMAIL PROTECTED]:
You feed it to the command line interface psql.
Example:
psql -h host -p port -d database -U user dump.sql
It's a good enough solution in most cases, but when the rowcount
starts to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, Oct 31, 2006 at 08:55:04PM -0800, Joshua D. Drake wrote:
We are not storing bytea [...]
[...]
Hmm, have you tried to create a functional trigram index on the
equivalent of strings(bytea_column) or something like that?
Hrm. Sorry for
Andreas Kretschmer wrote:
Jure Ložar [EMAIL PROTECTED] schrieb:
Hi.
Is it possible to limit number of left join rows that match condition to 1?
I don't want to have hits from first table multiplied when more then 1 row
matches on left join condition.
I'm not sure if i understand
Does anyone know what's happened to the news.postgresql.org server? I
haven't been able to access it now for a couple of days.
Regards,
Ben
CARILLION VALUES
Openness - Collaboration - Mutual Dependency - Professional Delivery
-Sustainable Profitable Growth - Innovation
On 10/31/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
How widespread is the use of PostgreSQL on Solaris? I am beginning to sense
that community support is not currently very strong on this platform, and that
pgsql may not be the best candidate for my current project -- installing LXR on
a
am Wed, dem 01.11.2006, um 10:58:21 +0100 mailte Bobby Gontarski folgendes:
From time to time I get Notice: Unknown: Cannot set connection to blocking
mode in Unknown on line 0.
What it is? Is it really a problem with postgresql. I am using Apache/2.2.3
(Unix) PHP/5.1.6/ postgresql 8.1
Bobby Gontarski wrote:
From time to time I get Notice: Unknown: Cannot set connection to
blocking mode in Unknown on line 0.
What it is? Is it really a problem with postgresql. I am using
Apache/2.2.3 (Unix) PHP/5.1.6/ postgresql 8.1
I can't find the string connection to blocking mode in the
Ritesh Nadhani wrote on 01.11.2006 07:51:
Hello All
Me and my professor are planning to work upon machine learning in
postgresql over tsearch2. So I have some questions:
We have a server where Postgresql is running without any problem with
postgres username and admin rights. I have a user
Martin Kuria wrote:
Dear Sir/Madam,
I have a staff directory, which group staff in various categories I
would like to group the staff members in there specific categories,
Below is an output I would like to achieve can this be achived my using
the Group by or I can write a script to
Hello All
Thanks for all the suggestions. I was able to configire and compile it.
I set the data directory to one of my directories, use 'initdb'
successfully. I am also able to start the pgsql and can see that it is
running on port as I had configured.
Now the problem is when I try to
Karsten Hilbert [EMAIL PROTECTED] writes:
Could this paragraph be put into the docs and/or the FAQ,
please ?
Section 21.2. Character Set Support already has something about it:
Important: Although you can specify any encoding you want for a
database, it is unwise to choose an
On Wed, Nov 01, 2006 at 11:41:43AM +0100, Karsten Hilbert wrote:
Could this paragraph be put into the docs and/or the FAQ,
please ? Along with the recommendation that if you require
multiple encodings for your databases you better had your OS
locale configured properly for UTF8 and use UNICODE
hello,
can the the current time family functions (CURRENT_TIMESTAMP, LOCALTIME,
etc) reach the '24:00:00' value ?
I want to compare LOCALTIME = '24:00:00'::TIME and I am curios to know
if LOCALTIME '24:00:00'::TIME is sufficient.
thanks,
razvan radu
---(end of
On 11/1/06, Teodor Sigaev [EMAIL PROTECTED] wrote:
[snip]
Brain storm method:
Develop a dictionary which returns all substring for lexeme, for example for
word foobar it will be 'foobar fooba foob foo fo oobar ooba oob oo obar oba ob
bar ba ar'. And make GIN functional index over your column
On Wed, Nov 01, 2006 at 08:50:30PM +0100, Martijn van Oosterhout wrote:
Could this paragraph be put into the docs and/or the FAQ,
please ? Along with the recommendation that if you require
multiple encodings for your databases you better had your OS
locale configured properly for UTF8 and
[EMAIL PROTECTED] wrote:
On Tue, Oct 31, 2006 at 08:55:04PM -0800, Joshua D. Drake wrote:
We are not storing bytea [...]
[...]
Hmm, have you tried to create a functional trigram index on the
equivalent of strings(bytea_column) or something like that?
Hrm. Sorry for my impolite
On Tue, 31 Oct 2006, Joshua D. Drake wrote:
Yes we do (and can) expect to find text among the bytes. We have
searches running, we are just running into the maximum size issues for
certain rows.
you can use substr() to be safe, if schema change doesn't available
Sincerely,
Joshua D.
Thanks to all of you.
I have get it up and running according to my needs. Help by everybody is
appreciated!
Richard Huxton wrote:
Gurjeet Singh wrote:
You are talking about /usr/local/data; so I assume that you are trying
this
on Linux or some other Nixen.
You just need to use the
why don't you just use '00:00:00'::time
and avoid the issue?
IMHO there shouldn't even be a 24:00:00, because that would imply that there
is a 24:00:01 - which there is not.
It should go from 23:59 to 00:00
But then, I didn't write the spec for time in general, so maybe there is a
24:00 which
Dear Richard,
Thanks for your response, you are right I am trying to do headings, I
thought I could do it from writing a SQL statement, but as you have
suggested it can only be achieved on the client code, I wish one day it can
be achieved with a SQL Statament thanks again .
Kind Regards.
Carlos Moreno [EMAIL PROTECTED] writes:
... The one that does the case conversion correctly (read: as I
expect it as per Spanish or French rules) is 8.1.4 with en_US locale
(LC_CTYPE and LC_COLLATE both showing en_US.UTF-8). PG 7.4.14, *even
with locale es_ES*, does not do the case conversion
Before using the createdb binary, su the Linux console as the same user which you used while doing the initdb process on your $PGDATA folder.Thanks,Shoaib MirEnterpriseDB (
www.enterprisedb.com)On 11/1/06, Ritesh Nadhani [EMAIL PROTECTED] wrote:
Hello AllThanks for all the suggestions. I
36 matches
Mail list logo
