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 yo
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 ...
On 11 February 2013 07:47, Alban Hertroys wrote:
> On Feb 11, 2013, at 2:23, Tim Uckun 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 strategy is for dealing wi
>
>
> 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
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-genera
Roger Niederland 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 running postgres 9.2
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 upgra
On 2/11/2013 6:47 AM, Tom Lane wrote:
Roger Niederland 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 SL
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 s
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 th
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
2013/2/11 Roger Niederland :
>
> On 2/11/2013 6:47 AM, Tom Lane wrote:
>>
>> Roger Niederland 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: und
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 operatio
David Clymer 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 ns_e5461ae570429d0b7863cce9ef4d4ead;
> Unfortunately,
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" wrote:
> David Clymer writes:
> > I've been seeing the following error in one database of ours:
> > "cache lookup failed for relation 7640518"
>
> Always the same OID, or do
2013/2/11 Tom Lane :
> David Clymer 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 ns_e5461ae570429d0b7863
=?UTF-8?B?UMOpdGVyIEtvdsOhY3M=?= 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 the case of going to re
> 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 wrote:
> David Clymer 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 all instances reference a different OI
On Mon, Feb 11, 2013 at 12:47 PM, Pavel Stehule wrote:
> 2013/2/11 Tom Lane :
> > David Clymer 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 apparen
On Mon, Feb 11, 2013 at 1:13 PM, David Clymer
wrote:
> On Mon, Feb 11, 2013 at 12:47 PM, Pavel Stehule
> wrote:
>
>> 2013/2/11 Tom Lane :
>> > David Clymer writes:
>> >> I've been seeing the following error in one database of ours:
>> >> "cache lookup failed for relation 7640518"
>> >
>> > Alw
2013/2/11 David Clymer
> On Mon, Feb 11, 2013 at 1:13 PM, David Clymer > wrote:
>
>> On Mon, Feb 11, 2013 at 12:47 PM, Pavel Stehule
>> wrote:
>>
>>> 2013/2/11 Tom Lane :
>>> > David Clymer writes:
>>> >> I've been seeing the following error in one database of ours:
>>> >> "cache lookup fail
David Clymer 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
and later REPEATABLE READ
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 t
On Feb 11, 2013, at 2:17 PM, "Daniel Verite" 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 databa
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'::hst
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 the
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 d
On Mon, Feb 11, 2013 at 12:35 PM, Andrew Satori wrote:
>
> On Feb 11, 2013, at 2:17 PM, "Daniel Verite" 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 inde
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 Postgr
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 experien
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 point
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
ad
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, Feb
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
ver
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 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.
>
I've done this before, and I reall
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 Danışm
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 wrote:
> On 2/1
Wait I think it was 8.2 wasn't it?
On Mon, Feb 11, 2013 at 7:58 PM, Tom Lane wrote:
> Scott Marlowe 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
--
To unde
Scott Marlowe 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 to your subscription:
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 supplied
On Mon, Feb 11, 2013 at 5: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 co
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 on
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 wrote:
> Does somone know the object overlap likely betwe
On Mon, Feb 11, 2013 at 6:36 AM, Andrew Taylor 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 array of ways logg
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"
To: "Wan Hashim"
Cc: "Adrian Klaver" ,
Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12
Date
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 an
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 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 source. HOWEVER, bui
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"
To: "whas...@gmail.com"
Cc: "Adrian Klaver" , "pgsql-general@postgresql.org"
Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12
Date: Tue, Feb 12, 2013 3:27 pm
second line should be
sudo apt-get install
Thank you Scot. I will try
Sent from my HTC
- Reply message -
From: "Scott Marlowe"
To: "whas...@gmail.com"
Cc: "Adrian Klaver" , "pgsql-general@postgresql.org"
Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12
Date: Tue, Feb 12, 2013 3:27 pm
second line should be
sudo
56 matches
Mail list logo
