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
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
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 will
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 expected
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
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
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
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,
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
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
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
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 function
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:
nameNone/name
and I wanted to update 'None' to 'John', what's the best way of doing this?
Can
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
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.1
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 support in
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
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 for
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!
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
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,
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
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:
$
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.
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, little
--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
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 probably
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
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
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 tables
too.
[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
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
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
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
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
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
36 matches
Mail list logo
