On Sat, Jan 22, 2005 at 12:57:37AM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] (elein) writes:
> > createlang -U postgres 'plpythonu' template1
> > createlang: language installation failed: ERROR: could not load
> > library "/usr/local/pgsql74/lib/plpython.so":
> > /usr/local/pgsql74/lib/plpyth
[EMAIL PROTECTED] (elein) writes:
> createlang -U postgres 'plpythonu' template1
> createlang: language installation failed: ERROR: could not load
> library "/usr/local/pgsql74/lib/plpython.so":
> /usr/local/pgsql74/lib/plpython.so: undefined symbol: PyDict_Copy
I'd bet on a python version is
Is this on fedora or redhat linux? If so a separate rpm must be installed for
plpython to function.
If you built from source the config script must also include building python.
On Fri, Jan 21, 2005 at 10:34:51PM -0700, Michael Fuhr wrote:
> On Fri, Jan 21, 2005 at 09:16:27PM -0800, elein wr
On Fri, Jan 21, 2005 at 09:16:27PM -0800, elein wrote:
> createlang: language installation failed: ERROR: could not load
> library "/usr/local/pgsql74/lib/plpython.so":
> /usr/local/pgsql74/lib/plpython.so: undefined symbol: PyDict_Copy
What does "ldd /usr/local/pgsql74/lib/plpython.so" show?
Stuart Bishop <[EMAIL PROTECTED]> writes:
> Changing this behavior in Python would break backwards compatibility.
Nonsense. It would not affect the behavior of any script that was
accepted before.
> In particular, the exec() function accepts strings that have already been
> unescaped:
> exec('
On a 7.4 installation built --with-python...
Python installed is 2.3.4.
On createlang, I get the following error:
createlang -U postgres 'plpythonu' template1
createlang: language installation failed: ERROR: could not load
library "/usr/local/pgsql74/lib/plpython.so":
/usr/local/pgsql74/lib/
On Friday 21 January 2005 12:55 pm, Chris Green wrote:
> I'm working on an application for my own use and have been using
> knoda as a front end to postgresql but I need a bit more power and
> flexibility.
>
> I'm quite happy to get into relatively serious programming as I am a
> C++/Java programm
Hi,
The SSL section contains this:
If the server demands a client certificate, libpq will send the
certificate stored in file .postgresql/postgresql.crt within the
user's home directory. A matching private key
file .postgresql/postgresql.key must also be present, and must not be
world-readabl
You could try the Mandrake supplied RPMs for PG v8.0 that are included
with cooker already.
ftp://sunsite.uio.no/linux/Mandrakelinux/devel/cooker/i586/media/main/postgres*
Use this URL:
ftp://sunsite.uio.no/linux/Mandrakelinux/devel/cooker/i586/media/main
with URPMI, then it should install it f
Alexander Nolting wrote:
> enabling unlimited row size for system tables ... child process
> exited with exit code 132
This means the process was aborted by the SIGILL signal, which means
that the executable is corrupted or there is a bug in the code or the
compiler. Try to find the core file a
On Fri, 21 Jan 2005 18:55:27 +, Chris Green <[EMAIL PROTECTED]> wrote:
> I'm working on an application for my own use and have been using knoda
> as a front end to postgresql but I need a bit more power and flexibility.
>
> I'm quite happy to get into relatively serious programming as I am a
Dave wrote:
Hi,
When I tried to install postgresql 8.0.0 on my Mandrake 10.1 community
box, it puked. First it told me I was missing readline, so I compiled
that and got over that hump. I tried --with-openssl and again, the
configure stopped when it could not find crypt So, I d'loaded the
l
On Fri, 2005-01-21 at 16:50, Dave wrote:
> Hi,
>
> When I tried to install postgresql 8.0.0 on my Mandrake 10.1 community
> box, it puked. First it told me I was missing readline, so I compiled
> that and got over that hump. I tried --with-openssl and again, the
> configure stopped when it coul
Hello Dave,
You have to install all devel packages you need for all options you want to
use.
In this case openssl-devel or ...-dev.
Regards
Alex
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Dave
> Gesendet: Freitag, 21. Januar 2005 23:51
Hello all,
i'm new to this list and I have some problems with the actual postgresql 8.
I'm decided to setup my new open-xchange box on debian sarge testing with
the postgresql 8.0.0 release. After configuring and make i wanted to check
the build and got the following error:
Running in noclean m
Hi,
When I tried to install postgresql 8.0.0 on my Mandrake 10.1 community
box, it puked. First it told me I was missing readline, so I compiled
that and got over that hump. I tried --with-openssl and again, the
configure stopped when it could not find crypt So, I d'loaded the
latest openss
>> Can I expect that a software developed on Linux will run and compile
>> on FreeBSD (since both use GCC)?
>>
> In general yes. Sometimes they do require some tweaks though.
Specially if they rely heavily on threads (i.e mysql, freeradius, etc)
I have some implementation issues with this (i.e.
I run Postgres on Gentoo and it works fine.
By the way, I have to tell that the best linux is Gentoo.
Mage
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
:oD
On Friday 21 January 2005 03:46 pm, [EMAIL PROTECTED] saith:
> I don't think there are any Amish PostgreSQL users.
>
>
>
> Geoffrey
> <[EMAIL PROTECTED]>To:
> pgsql-general@postgresql.org Sent by: cc:
>
I don't think there are any Amish PostgreSQL users.
Geoffrey
Bruno Almeida do Lago wrote:
Can I expect that a software developed on Linux will run and compile on
FreeBSD (since both use GCC)?
FreeBSD even has support for Linux *binaries.* In general, yes,
software developed on one should work on the other once you satisfy
dependencies.
Especially for
Bruno Almeida do Lago wrote:
Can I expect that a software developed on Linux will run and compile on
FreeBSD (since both use GCC)?
In general yes. Sometimes they do require some tweaks though.
J
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PR
How do i unsubscribe from the list?
thanks
Alex
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Bruno Almeida do Lago wrote:
I'm very interested in testing FreeBSD + PostgreSQL! Is it truth that the
PostgreSQL project was born over BSD? Does the project still being developed
over it?
I know that a couple of the core developers use FreeBSD as their
primary platform... However PostgreSQL is
Can I expect that a software developed on Linux will run and compile on
FreeBSD (since both use GCC)?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, January 21, 2005 4:59 PM
To: pgsql-general@postgresql.org
Subject: Re:
Unless I'm grossly misunderstanding the problem i think that a trigger written
in PL/pgsql would work fine. Something like this:
CREATE TABLE foo (
foo_id SERIAL primary key,
foo TEXT);
CREATE TABLE bar (
foo_id INTEGER references foo,
bar_id SERIAL primary key,
bar DOUBLE PRECISION NOT NULL);
I disagree on number 1, in fact , untar, cd, ./configure, make, make install
is all you have to do on BSD, not RPM nightmares, at least on Freebsd and
OpenBSD, not sure of NetBSD, I agreee on all others comments
---
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Beha
I'm working on an application for my own use and have been using knoda
as a front end to postgresql but I need a bit more power and flexibility.
I'm quite happy to get into relatively serious programming as I am a
C++/Java programmer, this accounting package is rather out of my
normal line of wor
I'm very interested in testing FreeBSD + PostgreSQL! Is it truth that the
PostgreSQL project was born over BSD? Does the project still being developed
over it?
Atenciosamente,
Bruno Almeida do Lago
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Geoff
I didn't see the post asking about NetBSD, but I can answer it a bit:
I think NetBSD is like other BSD in that:
1. untar, cd, ./configure, make, install doesn't usually work. They
put stuff in different places and not everyone in the Linux world cares
enough to account for them.
2. Out of the
On Fri, 21 Jan 2005, Bruno Wolff III wrote:
On Fri, Jan 21, 2005 at 12:02:09 +0100,
If you are going to another system that uses the same floating point
representation, you should get the same number. pg_dump writes out
enough digits that the exact number can be recovered when the dump
has been rel
Patrick Welche wrote:
On Fri, Jan 21, 2005 at 03:23:47PM -0200, Bruno Almeida do Lago wrote:
Any info about NetBSD?
That's all we use - no problems, so never had to do any comparisons..
Hmmm, with that attitude, we'd all still be riding horse and buggies..
--
Until later, Geoffrey
On Fri, Jan 21, 2005 at 03:23:47PM -0200, Bruno Almeida do Lago wrote:
> Any info about NetBSD?
That's all we use - no problems, so never had to do any comparisons..
Patrick
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
On Friday 21 January 2005 11:23 am, Bruno Almeida do Lago wrote:
> Any info about NetBSD?
>
> Bruno
>
Recent OS benchmarks (nothing specific to PostgreSQL) were compared to
FreeBSD 5.3 and posted at:
http://www.feyrer.de/NetBSD/gmcgarry/
I don't know enough to apply the information to the discus
Any info about NetBSD?
Bruno
-Original Message-
From: Matthew Story [mailto:[EMAIL PROTECTED]
Sent: Friday, January 21, 2005 3:16 PM
To: Bruno Almeida do Lago
Subject: Re: [GENERAL] Best Linux Distribution
for the stability of BSD you should look into their development
categories, it
Kristaps Armanis <[EMAIL PROTECTED]> writes:
> Is there any solution?
I think what you have to do is use pg_resetxlog with -x and a value just shy
of 2^32. then pg_dump and restore into a fresh database. I've never done it
though so perhaps you should wait until someone with more experience spea
On Fri, Jan 21, 2005 at 12:02:09 +0100,
Marco Colombo <[EMAIL PROTECTED]> wrote:
> On Fri, 21 Jan 2005, Greg Stark wrote:
>
> Anyway, think of floats. If you want do to FP maths fast, you need to use
> the native format supported by the CPU. When you dump, you get a text
> form of the FP number,
On Thu, 2005-01-20 at 17:42 +, Jackson Pauls wrote:
> On Thu, 2005-01-20 at 14:14 +, Jackson Pauls wrote:
>
> > i'm trying to create a connection from a postgres 8.0.0 client to a
> > remote server running postgres 7.4.6 that requires ssl.
> >
> > this connection worked on the client mach
Hi all,
I'm using Mandrake 10.1 to develop a weblication in PHP5/PostgreSQL 8.
I'm looking for a static pgadmin3-1.2.0, since the shared one requires
2.5.0 versions of some libraries and Mandrake has only 2.4
Tried to compile evrything from scratch, but all i got was a handfull of
errors.
Damn M
Hi all,
I managed to resolve this problem, and wanted to post a note on how
I did it:
following Patrick Sampson's work on TCL (thanks, Patrick):
http://archives.postgresql.org/pgsql-cygwin/2004-01/msg00024.php
I added the System Environment variable TCL_LIBRARY
with value: $TCL_DIR\lib\tcl.8.4
Friday, January 21, 2005, 5:30:07 PM, Jus rakstijat:
MvO> Looks like XID wraparound, you hit the 4 billion transaction mark. This
MvO> was fixed in 7.2 IIRC. Unfortunatly I don't know of an easy way to
MvO> recover, but this should give you something to search the archives for.
Till how sorted th
On Fri, Jan 21, 2005 at 03:33:28PM +0200, Kristaps Armanis wrote:
> Last night no crash, not anything, just @ one moment all records for
> last year where gone, all ros created for last year & tables created
> while this time - and not in only one database, but all 6 DB's on this
> server.
Looks l
"Dann Corbit" <[EMAIL PROTECTED]> writes:
> If someone wanted to put arbitrary aggregates into PostgreSQL, I would
> suggest something akin to the "RED BRICK" API, or better yet, the ATLAS
> API:
I also found a good reference for the DB2's SQL2003 Standard OLAP functions:
http://publib.boulder.i
Hi Michael,
Thanks for that, it looks like it should work fine. I will give it ago :)
Thanks,
Abdul-Wahid
On Fri, 21 Jan 2005 14:59:25 +0100, Michael Kleiser <[EMAIL PROTECTED]> wrote:
> CREATE TABLE cats_items (
> cat_id int4 NOT NULL, item_id int4 NOT NULL, FOREIGN KEY (cat_id)
> REFERENCE
CREATE TABLE cats_items (
cat_id int4 NOT NULL,
item_id int4 NOT NULL,
FOREIGN KEY (cat_id) REFERENCES cats (cat_id),
FOREIGN KEY (item_id) REFERENCES items (item_id),
PRIMARY KEY (cat_id, item_id)
);
CREATE TABLE items_master_cats (
cat_id int4 PRIMARY KEY
item_id int4
Greetings,
Some really strange things happened here. We were using old 7.1
postgres on 2.4 linux and db files living on ext3 partition for some time,
vacuuming regulary and not upgrading only because software didn't worked with
7.2+.
(developers where in progress, but not yet).
Last night no cra
On Fri, 21 Jan 2005, Sean Davis wrote:
Just a clarification: in 8.0.0, tsearch2-containing databases are correctly
dumped and restored without the patch mentioned in the docs?
Yes, it does.
Thanks,
Sean
---(end of broadcast)---
TIP 4: Don't 'kill -9'
Just a clarification: in 8.0.0, tsearch2-containing databases are
correctly dumped and restored without the patch mentioned in the docs?
Thanks,
Sean
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Am Freitag, 21. Januar 2005 12:58 schrieb Abdul-Wahid Paterson:
> I have the following table as a link table between my 'cats' table and
> my 'items' table. Every item must have at least one cat and exactly
> one 'master' cat.
>
> How can I create an integrity check to make sure that each item has
On Fri, Jan 21, 2005 at 12:02:09PM +0100, Marco Colombo wrote:
> On Fri, 21 Jan 2005, Greg Stark wrote:
> >I don't think it's reasonable for pg_dump to think about converting
> >data from one language to another. It's important for pg_dump to
> >restore an identical database. Having it start with s
On 1/21/05 1:50 AM, "Jonel Rienton" <[EMAIL PROTECTED]> wrote:
> I have found this at the docs of Postgres:
Yes, I knew about that. My email was in regards to an earlier discussion on
why you had to update /etc/rc as of 10.3 (probably should have dug that one
up and replied to it). The previous
On Fri, 21 Jan 2005, Stuart Bishop wrote:
This is currently being discussed on python-dev:
http://mail.python.org/pipermail/python-dev/2005-January/051203.html
It looks like my earlier concerns were unwarrented - current consensus seems
to be to transform line endings in the string to the one-true
Hi,
I have the following table as a link table between my 'cats' table and
my 'items' table. Every item must have at least one cat and exactly
one 'master' cat.
How can I create an integrity check to make sure that each item has
exactly one 'master' cat.
CREATE TABLE cats_items (
cat_id
On Fri, 21 Jan 2005, Greg Stark wrote:
Marco Colombo <[EMAIL PROTECTED]> writes:
Exaclty. Or, one could say: the "standard" text format is the one the
platform you are running on dictates. Which is what python does.
Egads. So the set of valid Python programs is different depending on what
platform
On Fri, 2005-01-21 at 01:30 -0500, Tom Lane wrote:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > Egads. So the set of valid Python programs is different depending on what
> > platform you're on? That's just, uhm, insane.
>
> No quibble here.
Funny discussion. Did you ever try a shell script writte
55 matches
Mail list logo
