>
> So assuming all this is done in regular userland. built from source
> etc, you'll need to do a couple things. Each version needs to be
> built with a different --prefix. I prefer something like
> --prefix=/home/myusername/pg83 and --prefix=/home/myusername/pg91 and
> so on. This will put the
On Fri, 2012-01-06 at 07:12 +0100, Stefan Keller wrote:
> Hi Igor
> 2011/12/16 Igor Neyman wrote: > But I think,
> your problem is right here:
> >
> > " running VACUUM FULL pg_largeobject"
> >
> > If you are running "VACUUM FULL ..." on the table, you should follow it
> > with the "REINDEX TABLE
Sorry,
Option 1) is wrong answer... :)
Option 2 should work
Sent from my Windows Phone
--
From: Misa Simic
Sent: 06/01/2012 08:34
To: Kevin Duffy; pgsql-general@postgresql.org
Subject: RE: [GENERAL] function return update count
You could try:
1) return UPDATE
You could try:
1) return UPDATE table
OR
2) use plpsql function instead of SQL
UPDATE table
GET DIAGNOSTICS = ROW_COUNT
RETURN
Kind regards,
Misa
Sent from my Windows Phone
--
From: Kevin Duffy
Sent: 06/01/2012 06:21
To: pgsql-general@postgresql.org
Subject: [GENER
Hi Igor
2011/12/16 Igor Neyman wrote: > But I think,
your problem is right here:
>
> " running VACUUM FULL pg_largeobject"
>
> If you are running "VACUUM FULL ..." on the table, you should follow it with
> the "REINDEX TABLE ...", at least on PG versions prior to 9.0.
I'm pretty sure that VACUU
Hello:
I am try to get a function to return the count of the rows updated within
the function.
As in the following, I wan the number of rows updated to be returned.
This is a simple update, other update statements that I need to write will
be complicated.
CREATE OR REPLACE FUNCTION est_idio_retu
On Thu, Jan 5, 2012 at 9:48 PM, Nishad Prakash wrote:
>
> I'd like to keep my current installation (8.3.3) alive and running while
> installing and running 9.1.2 on the same server. Can I do this using only
> the existing postgres superuser account? I'd want to create two different
> initdb loca
Hi,
On Jan 5, 2012, at 12:54 PM, Merlin Moncure wrote:
> see:
> http://www.postgresql.org/docs/9.1/interactive/cube.html
>
> and pay special attention to gist indexing portions. cube only
> indexes box operations, but you can cull the sphere using 3d distance
> formula for points between inner
I'd like to keep my current installation (8.3.3) alive and running while
installing and running 9.1.2 on the same server. Can I do this using
only the existing postgres superuser account? I'd want to create two
different initdb locations, and run the versions on different ports, of
course,
Lee Hachadoorian wrote:
On 01/05/2012 06:18 PM, Tom Lane wrote:
Are there really 23000 populated values in each row? I hesitate to
suggest an EAV approach, but it kinda seems like you need to go in that
direction. You're never going to get decent performance out of a schema
that requires 100-w
On Thu, Jan 5, 2012 at 6:10 PM, Lee Hachadoorian
wrote:
>
> Many of the smaller geographies, e.g. census tracts, do in fact have data
> for the vast majority of the columns. I am trying to combine it all into one
> table to avoid the slowness of multiple JOINs (even though in practice I'm
> never
On 01/05/2012 06:18 PM, Tom Lane wrote:
ERROR: joins can have at most 32767 columns
It's the sum of the number of columns in the base tables.
That makes sense. I totally misunderstood the message to be referring to
the number of joined columns rather than table columns.
I've asked this li
Lee Hachadoorian writes:
> How is the number of columns in a join determined? When I combine somewhere
> around 90 tables in a JOIN, the query returns:
> ERROR: joins can have at most 32767 columns
It's the sum of the number of columns in the base tables.
> I'm sure most people will say "Why th
How is the number of columns in a join determined? When I combine somewhere
around 90 tables in a JOIN, the query returns:
ERROR: joins can have at most 32767 columns
SQL state: 54000
I'm sure most people will say "Why the hell are you joining 90 tables."
I've asked this list before for advice on
Wendi/Craig
I have seen an installation issue very similar to this. It has been happening
on Windows 7 x86 systems. We are using postgres as the DB for our application
and I have incorporated the postgres installer into our installer, we also use
Bitrock. We are using postgres 8.4.4. It's been
"'Isidor Zeuner'" writes:
> using the latest git source code, I found that libpq will let the
> connection stall when getRowDescriptions breaks on an out of memory
> condition. I think this should better be handled differently to allow
> application code to handle such situations gracefully.
The
On Thu, Jan 5, 2012 at 11:01 AM, wrote:
> Hi,
>
> I have a data set of several hundred thousand points. Each point is saved as
> a three dimensional coordinate, i.e. (x, y, z). What I'd like to do is given
> a point in that space, get a list of all of the points in the table within
> some radi
Hi,
I have a data set of several hundred thousand points. Each point is saved as a
three dimensional coordinate, i.e. (x, y, z). What I'd like to do is given a
point in that space, get a list of all of the points in the table within some
radius.
I'm familiar with the q3c package that does this
On Wednesday, January 04, 2012 11:42:01 pm Bruno Boettcher wrote:
> On Wed, Jan 04, 2012 at 10:06:53AM -0800, Adrian Klaver wrote:
> Hello!
>
>
> ok, got it, from your lines i saw that the binaries of the server were
> removed
> so i copied them over from the other server, and got the server
On Wed, Jan 04, 2012 at 10:06:53AM -0800, Adrian Klaver wrote:
Hello!
> So when you are running pg_ctlcluster 9.0 main start what user are you
> running
> as?
tried as root...
>
> Have you tried to directly start the 9.0 cluster as the postgres user?:
just tried, same error
postgres@agenda
On Wed, 4 Jan 2012 15:50:25 +0100, Bruno Boettcher wrote:
Hello!
just made a stupid move... upgraded a working system and without
checking if the backup was ok
so i end up with a debian system having upgraded to 9,1 without
converting the database, and a scrambled backup which is totall
On 04/01/2012 16:15, Andreas Kretschmer wrote:
Birta Levente wrote:
Hi all
I use postgresql 9.1.2 on centos 6.2 and I want to use pgfouine, but in
my log file appear #011, #015 ... characters and the pgfouine can't
handle it.
Can I configure the server or rsyslog to log without these characte
22 matches
Mail list logo
