[EMAIL PROTECTED] (Chris Fonnesbeck) writes:
> I'm trying to run the latest Postgresql on OSX 10.3, but am receiving
> a version mismatch error when I try and run the database:
> dyld: psql version mismatch for library:
> /usr/local/lib/libreadline.4.dylib (compatibility version of user:
> 4.2.0 g
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> We recently decided we had to forbid foreign-key references from temp
> >> tables to permanent tables because of this effect. I wonder whether
> >> we won't end up forbidding temp tables as children of permanent t
On Tue, Nov 11, 2003 at 07:22:50PM -0700, Ed L. wrote:
> $ createlang plperl template1
> ERROR: Load of file /opt/pgsql/installs/postgresql-7.3.4/lib/plperl.so
> failed: libperl.so: cannot open shared object file: No such file or
> directory
> createlang: language installation failed
> This is
Well, we've got 50 or so customer boxes that we need to upgrade, so we
need the package management. I used to build my own from source, too,
and still do on my Solaris box, but I like being able to add and remove
things reliable. But to each their own.
apt and fedora.
'
--
Command P
"Ed L." <[EMAIL PROTECTED]> writes:
> No matter what I try, I keep getting this error:
> $ createlang plperl template1
> ERROR: Load of file /opt/pgsql/installs/postgresql-7.3.4/lib/plperl.so
> failed: libperl.so: cannot open shared object file: No such file or
> directory
The error message pro
On Nov 11, 2003, at 9:17 PM, Bruce Momjian wrote:
Please try 7.4RC2. We have that fixed there.
---
Barry C.Hawkins wrote:
List,
Hello. I am trying to get PostgreSQL 7.3.4 installed after moving to
Mac OS 10.3, kn
--On Tuesday, November 11, 2003 19:22:50 -0700 "Ed L."
<[EMAIL PROTECTED]> wrote:
I'm trying to load plperl to experiment with it in 7.3.4 with perl
v5.8.0. I've basically tried the following:
configure --with-perl, then
initdb, then
start postmaster, then
crea
I'm trying to load plperl to experiment with it in 7.3.4 with perl v5.8.0.
I've basically tried the following:
configure --with-perl, then
initdb, then
start postmaster, then
createlang plplerl template1
No matter what I try, I keep getting this error:
$ create
Please try 7.4RC2. We have that fixed there.
---
Barry C.Hawkins wrote:
> List,
> Hello. I am trying to get PostgreSQL 7.3.4 installed after moving to
> Mac OS 10.3, known as Panther. I am using the following confi
On Tue, 11 Nov 2003, Adam Haberlach wrote:
> On that note, does anyone have suggestions for which version of the
> server I should run? I see that there are seperate binary RPMS for
> different Linux versions, but nothing for version 3 -- should I spend some
> time doing a full install, bui
List,
Hello. I am trying to get PostgreSQL 7.3.4 installed after moving to
Mac OS 10.3, known as Panther. I am using the following configure
statement:
pbg417:/usr/local/src/postgresql-7.3.4 barryh$ ./configure
--prefix=/usr/local/pgsql
--enable-locale --enable-multibyte=UNICODE --with-opens
More praise for 7.4RC2:
I've installed 7.4RC2 and restored a fairly complex 20GB database (from 7.3.4) with ~75M rows in 30 tables and 4 schemas, numerous triggers and constraints, procs in plpgsql and plperl. To say that it all works great hugely underestimates the improvements. Thank you! Gr
On Tue, Nov 11, 2003 at 04:03:44PM -0800, Rich Shepard wrote:
> On Tue, 11 Nov 2003, Adam Haberlach wrote:
>
> > On that note, does anyone have suggestions for which version of the
> > server I should run? I see that there are seperate binary RPMS for
> > different Linux versions, but nothing
Why not place the pid of the process into your session and set up a
cronjob to look at pg_listner and delete any pid's from the session
file that have gone away? Only down side is if you recycle pid's
really quickly.
Alvaro Herrera wrote:
On Fri, Nov 07, 2003 at 07:33:47PM -0800, Boris Pop
On Tue, 11 Nov 2003 11:02:51 +, C G wrote:
> Dear All,
>
> I have installed the contrib xml package and have it working, but I would
> like some advice on the best way to use it. In particular, how should I
> alter xml files? For instance, if I have:
>
There's no way at present. The suppo
On Tue, Nov 11, 2003 at 08:56:29AM -0600, Darryl W. DeLao Jr wrote:
> Im currently on red hat 7.3 running postgres. Everything is running fine.
> Obviously, Im going to have to upgrade to RHEL 3 in order to receive
> updates, etc. Does anyone know of any problems with postgres running on
> RHEL 2
On Tuesday 11 November 2003 20:55, Josué Maldonado wrote:
> Hi Richard,
>
> Here are both ways:
Excellent - OK, here's a crash course in understanding the output of EXPLAIN
ANALYSE...
> dbmund=# EXPLAIN ANALYSE update estprod set
> dbmund-# epr_costo=(select tcos from cost2est2003 where code=pro
Jan Wieck wrote:
If you mean to configure the system to replicate rows to different
destinations (slaves) based on arbitrary qualifications, no. I had
thought about it, but it does not really fit into the "datacenter and
failover" picture, so it is not required to meet the goals and adds
unnece
Joe Conway wrote:
Jan Wieck wrote:
http://developer.postgresql.org/~wieck/slony1.html
Very interesting read. Nice work!
We want to build this system as a community project. The plan was from
the beginning to release the product under the BSD license. And we think
it is best to start it as such an
Jan Wieck wrote:
http://developer.postgresql.org/~wieck/slony1.html
Very interesting read. Nice work!
We want to build this system as a community project. The plan was from
the beginning to release the product under the BSD license. And we think
it is best to start it as such and to ask for sugges
On Nov 11, 2003, at 12:11 PM, Joe Conway wrote:
Jan Wieck wrote:
http://developer.postgresql.org/~wieck/slony1.html
Very interesting read. Nice work!
Ditto. I'll read it a bit closer later, but after a quick read it
seems quite complete and well thought out. I especially like
that sequences are
HISTORY
On Tue, 11 Nov 2003, Ericson Smith wrote:
> Is the some kind of document available that outlines the changes between
> ver 7.3 and ver 7.4
>
> Best regards,
> Ericson Smith
> Web Developer
> +---+---+
> | http://www.did-it.com | Money lost, lit
Is the some kind of document available that outlines the changes between
ver 7.3 and ver 7.4
Best regards,
Ericson Smith
Web Developer
+---+---+
| http://www.did-it.com | Money lost, little lost. |
| [EMAIL PROTECTED] | Honor lost, much lost.
Dear community,
for some reason the post I sent yesterday night still did not show up on
the mailing lists. I have set up some links on the developers side under
http://developer.postgresql.org/~wieck/slony1.html
The concept will be the base for some of my work as a Software Engineer
here at Af
Dear All,
I have installed the contrib xml package and have it working, but I would
like some advice on the best way to use it. In particular, how should I
alter xml files? For instance, if I have:
None
and I wanted to update 'None' to 'John', what's the best way of doing this?
Can xml contri
On Tuesday 11 Nov 2003 2:00 pm, Stephan Szabo wrote:
> On Tue, 11 Nov 2003, Rajesh Kumar Mallah wrote:
> > Hmmm... am i doing anything really silly?
>
> Functional indexes on 7.3 and earlier only allow a function over one or
> more columns (which would disallow the below as a function over a functi
On Tue, 11 Nov 2003, Rajesh Kumar Mallah wrote:
> Hmmm... am i doing anything really silly?
Functional indexes on 7.3 and earlier only allow a function over one or
more columns (which would disallow the below as a function over a function
over a column). The usual workaround would be to make an
Hmmm... am i doing anything really silly?
tradein_clients=# CREATE INDEX profile_master2 on profile_master (lower( btrim(email)
) );
ERROR: parser: parse error at or near "(" at character 61
tradein_clients=#
Regds
mallah.
---(end of broadcast)---
> > On Mon, Nov 10, 2003 at 04:45:10PM -0800, Rob Storrs wrote:
> > > According to my test (pg 7.2.4), the owner of the table will be null
> > > after the user PIPPO is dropped.
> >
> > That's what it seems, but in reality the owner is the ID the PIPPO had.
> > If you create another user with the
Hi fuzzy,
fuzzy schrieb:
How cvan i install the postgresql ODBC Driver for Windows if i have only a
DLL ?
Thanx in Advance
You first move the DLL into the trashcan and then download
the installer from http://odbc.postgresql.org/
or ftp://ftp.postgresql.org/pub/odbc/versions/msi/
Alternatively, yo
Running postgresql-7.3.2-3 which came with Red Hat 9.0.
Created a database with unicode encoding (in psql) as below:
create database leatherlink with encoding='unicode' template=leatherlinkdb;
leatherlinkdb is an existing database with the default encoding SQL_ASCII.
When I insert Chinsese st
Hi ,
Looks like ADD UNIQUE( some_fuc( some_feild) ) is not supported with add constraint.
the only way is to add the constriant is using UNIQUE INDEX .
Is it a bug or intended behaviour?
Regds
Mallah.
in 7.3.4
tradein_clients=# ALTER TABLE general.email_master ADD CONSTRAINT
e
On Tue, 2003-11-11 at 00:07, Joe Conway wrote:
> Write a Pl/Perl function that just does the syscall, and call it from
> PL/pgSQL. Similarly for complex string parsing, etc.
That would work if I could get the Pl/Perl function to return an array
or set of results, but this brings me back to the o
thanx this was the problem : the null values
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Najib Abi Fadel" <[EMAIL PROTECTED]>
Cc: "generalpost" <[EMAIL PROTECTED]>
Sent: Monday, November 10, 2003 07:58 PM
Subject: Re: [GENERAL] SQL query not returning the value
> On Mon, Nov 10, 2003 at 04:45:10PM -0800, Rob Storrs wrote:
> > According to my test (pg 7.2.4), the owner of the table will be null
> > after the user PIPPO is dropped.
>
> That's what it seems, but in reality the owner is the ID the PIPPO had.
> If you create another user with the same ID, he
Alvaro Herrera wrote:
Well, I wasn't the OP ;-). I thought Tcl had the capability, as it is
sometimes said to be the most advanced PL.
Nah, that would be PL/R ;-)
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
Joe Conway wrote:
Christopher Murtagh wrote:
That would work if I could get the Pl/Perl function to return an array
or set of results, but this brings me back to the original problem
(unless I'm missing something obvious).
Sorry, I guess I didn't sufficiently understand the issue. I don't
reall
37 matches
Mail list logo
