I am getting the following error when trying to execute a plpgsql funtion:
PSTERROR: could not load library /usr/pgsql-9.2/lib/plpgsql.so:
/usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan
This is on a SL6.3 system running postgres 9.2.2
We set this server up about
The best strategy is fixing your data-model so that you have a unique key. As
you found out already, e-mail addresses aren't very suitable as unique keys
for people. For this particular case I'd suggest adding a surrogate key.
Alternatively, you might try using (first_name, email) as your
Hi there
I have installed 9.2.2 on a Debian Squeeze VM.
I am trying to install a third party extension.
1) For the extension I did make make install.
2) I now see the extension files in /usr/share/postgresql/9.2/extension/...
(files .sql and .control)
3) When I issue CREATE EXTENSION ... I
On 11 February 2013 07:47, Alban Hertroys haram...@gmail.com wrote:
On Feb 11, 2013, at 2:23, Tim Uckun timuc...@gmail.com wrote:
This works pretty good except for when the top 100 records have
duplicated email address (two sales for the same email address).
I am wondering what the best
I read it that he has multiple sales from the same person? In which case
pretending that the two sales were from different people isn't the correct
result at all.
Actually it turns out that both cases exist.
I may be missing the point of the query, but wasn't it to add an entry for
each
On 02/11/2013 02:33 AM, P. Broennimann wrote:
Hi there
I have installed 9.2.2 on a Debian Squeeze VM.
I am trying to install a third party extension.
1) For the extension I did make make install.
2) I now see the extension files in
/usr/share/postgresql/9.2/extension/... (files .sql and
Merlin Moncure escribió:
http://citusdata.com/blog/57-postgresql-full-text-search
http://www.postgresql.org/message-id/511164ef.8010...@dalibo.info
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general
Roger Niederland ro...@niederland.com writes:
I am getting the following error when trying to execute a plpgsql funtion:
PSTERROR: could not load library /usr/pgsql-9.2/lib/plpgsql.so:
/usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan
This is on a SL6.3 system
Hi,
On Mon, 2013-02-11 at 09:47 -0500, Tom Lane wrote:
After restarting the postgres service, the error went away.
So you had upgraded, but not actually restarted the server ...
just for future reference, SLES apparently doesn't do a service
restart automatically during package upgrade.
On 2/11/2013 6:47 AM, Tom Lane wrote:
Roger Niederland ro...@niederland.com writes:
I am getting the following error when trying to execute a plpgsql funtion:
PSTERROR: could not load library /usr/pgsql-9.2/lib/plpgsql.so:
/usr/pgsql-9.2/lib/plpgsql.so: undefined symbol:
I had seen that thread, and that's how I came in contact with L J Bayuk (the
person who owns the pgtclng sourceforge project and who answered the
questions) and followed his advice, which is how I came to create the 64 bit
build. I am still experiencing problems.
It's possible that I have missed
Le lundi 11 février 2013 à 08:03 -0600, Merlin Moncure a écrit :
http://citusdata.com/blog/57-postgresql-full-text-search
I find it strange that
'Probability that a new thread gets a response'
sits below 60% for the 'general' list
In my mailbox, which holds the last 2628 messages from the
Le lundi 11 février 2013 à 17:20 +0100, Vincent Veyron a écrit :
Le lundi 11 février 2013 à 08:03 -0600, Merlin Moncure a écrit :
http://citusdata.com/blog/57-postgresql-full-text-search
I find it strange that
'Probability that a new thread gets a response'
sits below 60% for the
2013/2/11 Roger Niederland ro...@niederland.com:
On 2/11/2013 6:47 AM, Tom Lane wrote:
Roger Niederland ro...@niederland.com writes:
I am getting the following error when trying to execute a plpgsql
funtion:
PSTERROR: could not load library /usr/pgsql-9.2/lib/plpgsql.so:
I've been seeing the following error in one database of ours:
cache lookup failed for relation 7640518
The SQL that apparently triggers this is:
drop table if exists ns_e5461ae570429d0b7863cce9ef4d4ead;
Unfortunately, manual attempts to reproduce the issue have failed. In
normal
David Clymer david.cly...@vistashare.com writes:
I've been seeing the following error in one database of ours:
cache lookup failed for relation 7640518
Always the same OID, or does it change?
The SQL that apparently triggers this is:
drop table if exists
I'm confused by the error message. Is a cache miss an error condition?
Thanks
Peter
On Feb 11, 2013 6:22 PM, Tom Lane t...@sss.pgh.pa.us wrote:
David Clymer david.cly...@vistashare.com writes:
I've been seeing the following error in one database of ours:
cache lookup failed for relation
2013/2/11 Tom Lane t...@sss.pgh.pa.us:
David Clymer david.cly...@vistashare.com writes:
I've been seeing the following error in one database of ours:
cache lookup failed for relation 7640518
Always the same OID, or does it change?
The SQL that apparently triggers this is:
drop table
=?UTF-8?B?UMOpdGVyIEtvdsOhY3M=?= peter.dunay.kov...@gmail.com writes:
I'm confused by the error message. Is a cache miss an error condition?
Well, this isn't a cache miss, it's more of a there's no such OID in
the pg_class catalog condition. Normally you see something more
user-friendly; but in
I'm looking for some good visual query builder which can be used by
non-tech people for some ETL tasks. Do you have any recommendation?
Libreoffice Base?
I know it has a visual query builder and it does support PostgreSQL, but
I have no clue what it is worth, since I tend to use SQL instead.
On Mon, Feb 11, 2013 at 12:20 PM, Tom Lane t...@sss.pgh.pa.us wrote:
David Clymer david.cly...@vistashare.com writes:
I've been seeing the following error in one database of ours:
cache lookup failed for relation 7640518
Always the same OID, or does it change?
It appears that almost
On Mon, Feb 11, 2013 at 12:47 PM, Pavel Stehule pavel.steh...@gmail.comwrote:
2013/2/11 Tom Lane t...@sss.pgh.pa.us:
David Clymer david.cly...@vistashare.com writes:
I've been seeing the following error in one database of ours:
cache lookup failed for relation 7640518
Always the same
On Mon, Feb 11, 2013 at 1:13 PM, David Clymer
david.cly...@vistashare.comwrote:
On Mon, Feb 11, 2013 at 12:47 PM, Pavel Stehule
pavel.steh...@gmail.comwrote:
2013/2/11 Tom Lane t...@sss.pgh.pa.us:
David Clymer david.cly...@vistashare.com writes:
I've been seeing the following error in
2013/2/11 David Clymer david.cly...@vistashare.com
On Mon, Feb 11, 2013 at 1:13 PM, David Clymer david.cly...@vistashare.com
wrote:
On Mon, Feb 11, 2013 at 12:47 PM, Pavel Stehule
pavel.steh...@gmail.comwrote:
2013/2/11 Tom Lane t...@sss.pgh.pa.us:
David Clymer
David Clymer david.cly...@vistashare.com wrote:
The SERIALIZABLE isolation mode is being used in 9.0, and
REPEATABLE READ in 9.2, which should be the same thing, correct
(eg. 9.0 serializable ~ 9.2 repeatable read)?
Correct.
In 9.0 SERIALIZABLE and REPEATABLE READ are exactly same. In 9.1
Vincent Veyron wrote:
I find it strange that
'Probability that a new thread gets a response'
sits below 60% for the 'general' list
This seems indeed too low.
I happen to collect these messages in a database since mid-2005. As a point
of comparison, the numbers I get until today
On Feb 11, 2013, at 2:17 PM, Daniel Verite dan...@manitou-mail.org wrote:
Vincent Veyron wrote:
I find it strange that
'Probability that a new thread gets a response'
sits below 60% for the 'general' list
This seems indeed too low.
I happen to collect these messages in a
What's the canonical way of doing this? Various failed attempts include:
select array_length(%%'a=1'::hstore - 'a=1'::hstore, 1)
select array_length(%%('a=1'::hstore - 'a=1'::hstore), 1)
select array_length(avals('a=1'::hstore - 'a=1'::hstore), 1);
select array_length(akeys('a=1'::hstore -
Thank you, Tom!
Recently, as I wanted to drop a schema (PG 8.2), I had to wade through a
number of such messages and keep dropping rows in the pg_dependency table
with the OID specified in the messages. When I was finally able to drop the
schema, I wanted to drop the user (who previously owned
Can PG V9.1* support a DB that's on an NFS disk?
I googled around, but nothing popped out.
Also, would you happen to know the answer to this for MySQL v5.5*?
Thanks in Advance.
On 2/11/2013 4:22 PM, Gauthier, Dave wrote:
Can PG V9.1* support a DB that's on an NFS disk?
I googled around, but nothing popped out.
Also, would you happen to know the answer to this for MySQL v5.5*?
Thanks in Advance.
That would be (IMHO) very ill-advised. In the event of a
On Mon, Feb 11, 2013 at 12:35 PM, Andrew Satori d...@druware.com wrote:
On Feb 11, 2013, at 2:17 PM, Daniel Verite dan...@manitou-mail.org wrote:
Vincent Veyron wrote:
I find it strange that
'Probability that a new thread gets a response'
sits below 60% for the 'general' list
On 02/11/2013 03:02 PM, Scott Marlowe wrote:
Welcome to the perception of the outsider. I am in infrequent poster here, but in my
6 years of doing PostgreSQL for Mac, I get 3-4 emails a week asking for help on
PostgreSQL issues that contain some variation of the phrase 'I posted to a
On 02/11/2013 08:18 AM, Carlo Stonebanks wrote:
I had seen that thread, and that's how I came in contact with L J Bayuk (the
person who owns the pgtclng sourceforge project and who answered the
questions) and followed his advice, which is how I came to create the 64 bit
build. I am still
On 2/11/2013 11:17 AM, Daniel Verite wrote:
I happen to collect these messages in a database since mid-2005. As a point
of comparison, the numbers I get until today for pgsql-general are 3348
messages that appear to be outside of any thread (no In-Reply-To field or
References field that points
Hi all;
Im looking for in information and resources to setup postgresql 8.0.5
in Ubuntu server . tq
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 02/11/2013 03:40 PM, Wan Hashim wrote:
Hi all;
Im looking for in information and resources to setup postgresql 8.0.5
in Ubuntu server . tq
Is there a reason you want to install a version that is no longer supported?
Also I believe you mean Ubuntu 12.10, correct?
--
Adrian Klaver
our legacy system required postgresql 8.0 to run. we are in the
process of upgrading the application and database.
we must have postgresql 8.8 to keep the system running at this moment .
if possible , we want to run in Ubuntu 12. we can consider older
version of OS if it can help .
tq
On Tue,
On 02/11/2013 04:29 PM, Wan Hashim wrote:
our legacy system required postgresql 8.0 to run. we are in the
process of upgrading the application and database.
we must have postgresql 8.8 to keep the system running at this moment .
if possible , we want to run in Ubuntu 12. we can consider older
On 2/11/2013 4:29 PM, Wan Hashim wrote:
our legacy system required postgresql 8.0 to run.
are you sure it requires this old version? most software works with
newer versions with little or no changes.
--
john r pierce 37N 122W
somewhere on the middle
On Mon, Feb 11, 2013 at 5:22 PM, Gauthier, Dave dave.gauth...@intel.comwrote:
Can PG V9.1* support a DB that's on an NFS disk?
I googled around, but nothing popped out.
Also, would you happen to know the answer to this for MySQL v5.5*?
Thanks in Advance.
I've done this
Hi,
On Mon, 2013-02-11 at 22:22 +, Gauthier, Dave wrote:
Can PG V9.1* support a DB that's on an NFS disk?
http://www.postgresql.org/message-id/25517.1191038...@sss.pgh.pa.us
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL
The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
poorly written software.
For OP: Install from source, if you don't need EXACTLY the old 8.0.5
version at least look at the bug fixed version 8.0.latest (28 or so?)
On Mon, Feb 11, 2013 at 6:17 PM, John R Pierce
Wait I think it was 8.2 wasn't it?
On Mon, Feb 11, 2013 at 7:58 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
poorly written software.
That was 8.3, not 8.1.
Scott Marlowe scott.marl...@gmail.com writes:
The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
poorly written software.
That was 8.3, not 8.1.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On 02/11/2013 06:59 PM, Scott Marlowe wrote:
Wait I think it was 8.2 wasn't it?
http://www.postgresql.org/docs/8.3/interactive/release-8-3.html
E.24.2.1. General
Non-character data types are no longer automatically cast to TEXT
(Peter, Tom)
Previously, if a non-character value was
On Mon, Feb 11, 2013 at 5:29 PM, Wan Hashim whas...@gmail.com wrote:
our legacy system required postgresql 8.0 to run. we are in the
process of upgrading the application and database.
we must have postgresql 8.8 to keep the system running at this moment .
if possible , we want to run in Ubuntu
Does somone know the object overlap likely between pg and pgxc repositories?
I ask because I could just git clone pgxc, or I could add a remote for
pgxc to my pg git clone, and make sure the branches are added, and
fetch that remote.
And in this way, common files/ objects are properly shared in
This may not be the best place to ask these questions and you could
have considered using postgres-xc-general mailing list from the
Postgres-XC project site. Anyways, see my comments below.
On Tue, Feb 12, 2013 at 11:06 AM, Zenaan Harkness z...@freedbms.net wrote:
Does somone know the object
On Mon, Feb 11, 2013 at 6:36 AM, Andrew Taylor andydtay...@gmail.com wrote:
Here's what I did to fix this in Ubuntu 12.10.
Now I cannot explain (a) why this problem came into being or (b) what the
science is behind my fix. This was my first dive into Linux logs and there
being seemingly an
I believe the software can work with any postgresql 8.0.* . It is possible to
install pg 8.0 in current release of linux?
Sent from my HTC
- Reply message -
From: Scott Marlowe scott.marl...@gmail.com
To: Wan Hashim whas...@gmail.com
Cc: Adrian Klaver adrian.kla...@gmail.com,
Not from a package. I don't think any recent distros have a repo with
8.0 in it, so you'll have to build from source. HOWEVER, building
from source is REAL easy with postgresql.
sudo apt-get install build-essential # ubuntu build tools
apt-get install libreadline-dev # used by pgsql to have
second line should be
sudo apt-get install libreadline-dev
of course. unless you're logged in as root.
On Tue, Feb 12, 2013 at 12:26 AM, Scott Marlowe scott.marl...@gmail.com wrote:
Not from a package. I don't think any recent distros have a repo with
8.0 in it, so you'll have to build from
On 2/11/2013 11:26 PM, Scott Marlowe wrote:
./configure --prefix=/opt/postgres# or wherever you want pg to install
and depending on your application's requirements, you may want to enable
perl, python or whatever and whatever other optional stuff you may need..
--
john r pierce
Thank you @
Sent from my HTC
- Reply message -
From: Scott Marlowe scott.marl...@gmail.com
To: whas...@gmail.com whas...@gmail.com
Cc: Adrian Klaver adrian.kla...@gmail.com, pgsql-general@postgresql.org
pgsql-general@postgresql.org
Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu
Thank you Scot. I will try
Sent from my HTC
- Reply message -
From: Scott Marlowe scott.marl...@gmail.com
To: whas...@gmail.com whas...@gmail.com
Cc: Adrian Klaver adrian.kla...@gmail.com, pgsql-general@postgresql.org
pgsql-general@postgresql.org
Subject: [GENERAL] Installing Postgress
56 matches
Mail list logo
