On Aug 16, 2006, at 8:23 AM, Matteo Bertini wrote:
Hello all!
I'm quite new to pg, but I'm using it quite a lot in the last few
monts.
Deeping in new features, I found a question: is it possible to hint
an unique result from a select?
Mainly, thinking about partitions, I'd like to crea
On Aug 30, 2006, at 2:49 PM, Dennis Reaves wrote:
Hello all!
I'm trying to install postgresql and I'm getting the following error;
error: failed dependencies:
libc.so.6(GLIBC_2.3) is needed by postgresql-8.1.4-3PGDG
libcrypto.so.4 is needed by postgresql-8.1.4-3PGDG
On Aug 30, 2006, at 4:10 PM, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve Atkins wrote:
On Aug 30, 2006, at 2:49 PM, Dennis Reaves wrote:
[snip]
I've no doubt that current Postgresql versions will compile from
source and run on 7.2, but you're fairly u
On Sep 2, 2006, at 7:32 AM, Marc Evans wrote:
Hello -
I am curious as to people's opinion about best practices in
deployment of pgsql in a high-availablity (HA) situation. By HA I
mean that data loss must be as close to zero as possible, and that
web servers using the DB need to be deplo
On Sep 6, 2006, at 9:50 AM, Andrew Sullivan wrote:
Hi,
Now that the DNS is back (thanks!), I thought I'd ask why the ra bit
is set on the responses. Are those servers providing recursion to
the whole Net? (They seem to be.) If so, that's a Bad Thing.
There's not anything like universal ag
On Sep 6, 2006, at 5:29 PM, Joshua D. Drake wrote:
Also the servers are volunteer provided, so
it's not really anyones business other than the server owners.
Given that the entire postgresql.org infrastructure just went off the
air because of what sure looked to me like an error in
administrat
On Sep 6, 2006, at 5:58 PM, Tim Allen wrote:
Steve Atkins wrote:
On Sep 6, 2006, at 5:29 PM, Joshua D. Drake wrote:
When you commit to providing services to this community, it is
absolutely the business of that community on how the
infrastructure is managed.
It is the business of the
On Sep 6, 2006, at 6:41 PM, Joshua D. Drake wrote:
Irrelevant details of the server configuration that do not
directly affect those services aren't really something to gossip
about on a public mailing list, though.
The two are quite different things.
Andrew was apparently suggesting th
On Wed, Jan 14, 2004 at 12:37:55PM -0800, Joshua D. Drake wrote:
> >I used to have that complaint until I got more aquainted with the docs.
> >When I used to use mysql I found that if I used search feature on their
> >docs
> >I could find exactly what I was looking for almost immediately. When I
On Thu, Jan 22, 2004 at 01:04:29PM -0700, Rick Gigger wrote:
[PostgreSQL ill-suited to embedded use]
> How about the following comment from an earlier post:
>
> > Now, while I think that an embedded fork of PostgreSQL is completely
> > missing the point I do think that a low maintenance fork or
On Fri, Jan 30, 2004 at 12:38:43PM +0100, NTPT wrote:
> > I have a large table (potentially tens or hundreds of millions of rows) and
> > I need to extract some number of these rows, defined by an integer primary
> > key.
> >
> > So, the obvious answer is
> >
> > select * from table where id i
On Fri, Feb 06, 2004 at 04:53:47PM +, C G wrote:
>
> I'm trying to get a table containing all the user created tables, which
> contains the column name and their types. Basically, I want to be able to
> do "\d all_user_tables" - but I can't use the \d notation.
>
> I tried to combine the p
On Fri, Feb 13, 2004 at 01:51:24PM +, Richard Huxton wrote:
> On Friday 13 February 2004 10:59, Karsten Hilbert wrote:
> > > Well, thousands of tables is probably "too much", but a hundred tables or
> > > two in a database shouldn't cause problems. Don't see why you'd want them
> > > though.
>
On Wed, Apr 14, 2004 at 10:15:51PM +0900, Alex wrote:
> Hi,
> is the file system approach really easier and faster? What if you need
> to protect the image data e.g. you dont want users just to just dowload
> the pictures directly from your website?
It can be much faster, if implemented correctl
On Tue, May 11, 2004 at 12:58:55AM +0200, Ivan Sergio Borgonovo wrote:
> thanks to everyone.
> Curiously enough, trying to figure out what was wrong with my code,
> I've been able to write versions with the wrong spelling that didn't
> complain. That brought me astray.
>
> Anyway does anyone know
I have an application where each user session opens and maintains a
long-lived connection to the postgresql backend database.
I need to keep a small amount of information (things like a unique
session identifier, the application - as opposed to database - username
and so on) that is local to each
Is there any way to look at the database as though you were inside another
sessions transaction?
I've had two cases recently where this would have been somewhat useful. In one,
a select into query ran for several hours and it would have been nice to
see that it was running correctly. In the other
On Thu, Sep 09, 2004 at 07:56:20AM -0500, Vic Cekvenich wrote:
> What would be performance of pgSQL text search vs MySQL vs Lucene (flat
> file) for a 2 terabyte db?
> thanks for any comments.
My experience with tsearch2 has been that indexing even moderately
large chunks of data is too slow to
Is there a safe way to convert varchar(n) to text, other than create
a new column, update, delete column, rename?
I have a number of databases that were built with varvhar(n) and which
should have been done with text. They're in production, and I'd rather
not take the downtime needed to convert so
On Fri, Sep 17, 2004 at 10:56:36AM -0400, Tom Lane wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
> > On Wednesday 15 September 2004 12:29, Steve Atkins wrote:
> >> Is there a safe way to convert varchar(n) to text, other than create
> >> a new column, update
On Tue, Sep 21, 2004 at 04:24:21PM -0400, Christopher Petrilli wrote:
> Has anyone investigated having either high, or low urgency queries? A
> system I'm working on has a constant inflow of data, which has some
> queries gainst it which might require long sequential scans. I'm not
> that worried a
On Tue, Oct 12, 2004 at 11:01:08AM -0400, Jerry LeVan wrote:
> Hi,
> I am futzing around with Andrew Stuarts "Catchmail" program
> that stores emails into a postgresql database.
>
> I want to avoid inserting the same email more than once...
> (pieces of the email actually get emplaced into several
401 - 422 of 422 matches
Mail list logo
