Hi,
I'll try to switch from Oracle to postgres for some small applications.
Is it possible to build functions like Oracle's nvl or decode with
pgplsql?
How can I make a function like nvl that works for every datatype?
Best regards,
Christian
Try coalesce. The syntax is the same as nvl.
Jeff
Look at your output using a binary viewer of some type. The font you
are using in whatever client you are using to connect to the database
may not have the character you are trying to display - a common
default is to use a ? in place of the unrenderable character. In
other words the character
Hi, I've created an index but it's not being used by
postgresql when doing a query. But doing an explain
analyze shows that with index, it's faster. Here's
the output:
This sounds like someone needs to put a big fat link to
this FAQ item at the top of the PostgreSQL frontpage URL ?
Karsten
Michal Adamczakk wrote:
hi,
how to implement mysql's last_insert_id() ?
i know that seqences and oids are great.
the one thing i miss is that they are not session specific.
i mean selecting last_value from seqence can give me a value which was
inserted by a different user.
regards
Michal
The
Can someone list susinctly the points of
failure with using a file system snapshot
solution to replicate a database for failover?
If there is an acceptable time gap (5 minutes?) and
the ability to reapply dropped changes how does
this affect a file system snapshot solution,
or does it?
[EMAIL
On Wednesday 27 August 2003 08:39, Juris Krumins wrote:
Couple a weeks ago (19.08.03 Subject: Temporaty tables) I've posted message
with question about errors I'm getting while using create temporaty table
command.
So I'm start digging in src code as Tom Lane did and found about 4 places
Marc G. Fournier [EMAIL PROTECTED] writes:
On Mon, 25 Aug 2003, Tom Lane wrote:
What makes you say that? My understanding is it's supposed to survive
loss of individual servers.
How does it play 'catch up' went a server comes back online?
The recovered server has to run through the part of
On Sun, 24 Aug 2003, Bupp Phillips wrote:
I'm very new to Postgresql, so don't beat me up to bad if you see a problem,
just Inform me what I've done wrong.
I'm use Postgresql 7.2 (PeerDirect's Windows port) on Win2000 384MB RAM 10GB
of Free space 800 Mhz, using the ODBC driver 7.03.01.00.
AH == Alvaro Herrera [EMAIL PROTECTED] writes:
AH On Wed, Aug 27, 2003 at 12:21:53PM -0400, Vivek Khera wrote:
GS == Greg Stark [EMAIL PROTECTED] writes:
GS Vivek Khera [EMAIL PROTECTED] writes:
GS Oh, it's a really small database. That helps a lot with the backup
GS problems of 24x7
On Wed, Aug 27, 2003 at 12:21:53PM -0400, Vivek Khera wrote:
GS == Greg Stark [EMAIL PROTECTED] writes:
GS Vivek Khera [EMAIL PROTECTED] writes:
GS Oh, it's a really small database. That helps a lot with the backup
GS problems of 24x7 operation. Still I would be interested.
Well,
GS == Greg Stark [EMAIL PROTECTED] writes:
The DB is currently about 27Mb on disk (including indexes) and
processes several million inserts and updates daily, and a few million
deletes once every two weeks.
GS Oh, it's a really small database. That helps a lot with the backup
GS problems of
On Tue, 2003-08-26 at 22:32, Rudy Koento wrote:
Hi, I've created an index but it's not being used by
postgresql when doing a query. But doing an explain
analyze shows that with index, it's faster. Here's
the output:
[snip]
EXPLAIN ANALYZE SELECT S.* FROM sales S, staff ST
WHERE
Hi,
For my supprise I found that functions have 32 parameter limit.
Where to find more info about this limitation or similar limitations ?
I need at least 50, 100 would be ok.
Real life function below:
CREATE OR REPLACE FUNCTION
I'm having a wierd problem with pg 7.3.3
PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
20020903 (Red Hat Linux 8.0 3.2-7)
I have a bunch of inserts being done by JDBC. One of them if causing a
problem.
LOG: query: INSERT INTO mailtextlog (mlid,tlog,cdate)
I've just moved some anti-virus/anti-spam checks a bit closer to the
source, and am now rejecting the following before it even gets to the
anti-virus checking, and/or majordomo:
/^Subject: Thank you!/ REJECT
/^Subject: Re: Thank you!/ REJECT
/^Subject: Re: Wicked screensaver/
G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary
---(end of
DG == Dennis Gearon [EMAIL PROTECTED] writes:
DG With the low cost of disks, it might be a good idea to just copy to
DG disks, that one can put back in.
Your file system copies will be broken, since they only work if
PG is shut down. For this very reason I don't even bother doing a
file system
Hi,
when I run a SELECT INTO and the result is 0 or zero row, then I still
get a positive result if
using IF FOUND THEN
Is there a problem or do we need to use ROW_COUNT instead ?
Alex
---(end of broadcast)---
TIP 3: if posting/reading
You can do HA from the OS level:
Have a SCSI disk array shared between two computers
Use a journalling filesystem on this array
Have a serial kill switch
Have a program that checks if each server is alive.
If the primary goes down, the secondary will:
a) Shut off the power to the primary
b)
Hello;
I've recently installed postgres7.3.4, from the source, (my first time) and
just got a good result with the dumpall, thanks to you.
I have some problems with the client pgAdminII, bu I guess this is not a
proper place to pose those problems.
Well, my doubts are:
1) How could I see and
Hi,
I am having problems in forming a dynamic query that can be used in
Execute statements.
Problem:
I have database fields that are either INT or VARCHAR. Both can have NULL.
If I use variables that hold the db field's values ... how do I need to
quote them to pass them to the query string.
You mean
My queries are slow or don't make use of the indexes. Why?
may be better just fix that stone age requirement?
It just ridicules,
could statistic be build during index build, if no statistic available?
-Original Message-
From: Karsten Hilbert [mailto:[EMAIL PROTECTED]
Sent:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it
on a
RH8.0 server. Which books would you guys recommand?
Well, I'm a little biased because I work at the author's shop :), but I
use Practical PostgreSQL
BM == Bruce Momjian [EMAIL PROTECTED] writes:
Well, did I mention I'm saturating my disk I/O bandwidth at the same
time with other queries? ;-)
BM But six hours. It is my understanding that a sequential scan is roughly
BM the same load as a non-FULL vacuum. Are you saying a sequential
I'll second the usefulness of Bruce's book. I still refer to it
years after buying it.
I'd highly recommend either of the two books out by Sams with by Hans and
Ewald. Both very good good books. One is just purely Postgresql, the
other is a PHP/Postgresql book.
On Wed, 27 Aug 2003,
I just wanted to let the developers know, i'm VERY IMPRESSED with the
7.4b1 release. I've been using it exclusively on my two development
machines since it was released without any problems at all. I was
also using cvs on and off for a while before the beta.
my development machines are an
Vivek Khera wrote:
BM == Bruce Momjian [EMAIL PROTECTED] writes:
BM Hold --- a non-FULL vacuum is taking 6+ hours on two tables? That seems
BM impossible.
Well, did I mention I'm saturating my disk I/O bandwidth at the same
time with other queries? ;-)
But six hours. It is my
Bruno Wolff III wrote:
On Wed, Aug 27, 2003 at 00:09:34 +0200,
Andreas Fromm [EMAIL PROTECTED] wrote:
Bruno Wolff III wrote:
On Tue, Aug 26, 2003 at 18:34:04 +0100,
Richard Huxton [EMAIL PROTECTED] wrote:
I don't think that is what he wants. He seems to want to go in the other
Hi all,
Is it possible to declare a bit array in pgsql procedure.
If so how to read and write values in that array.
regards,
Deepa K.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
my freebsd 4,7 this creating processes big of postgresql.
help me with some information?
PostgreSQL 7.3.1
CPU states: 0.0% user, 0.0% nice, 0.0% system, 0.0% interrupt, 100%
idle
Mem: 221M Active, 1890M Inact, 272M Wired, 118M Cache, 199M Buf, 9256K Free
Swap: 1024M Total, 276K Used, 1024M
I meant,use disks as the medium. Put DUMP's on it.
Vivek Khera wrote:
"DG" == Dennis Gearon [EMAIL PROTECTED] writes:
DG With the low cost of disks, it might be a good idea to just copy to
DG
On Sun, Aug 24, 2003 at 05:19:52PM -0700, Bupp Phillips wrote:
I'm very new to Postgresql, so don't beat me up to bad if you see a problem,
just Inform me what I've done wrong.
I'm use Postgresql 7.2 (PeerDirect's Windows port) on Win2000 384MB RAM 10GB
of Free space 800 Mhz, using the ODBC
You don't need to build any function for this, you have them ready:
http://www.postgresql.org/docs/view.php?version=7.3idoc=0file=functions-conditional.html#AEN9753
http://www.postgresql.org/docs/view.php?version=7.3idoc=0file=functions-conditional.html#AEN9698
Cheers,
Csaba.
On Wed, 2003-08-27
On Tue, 2003-08-26 at 22:37, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
If you can detect if outside transactions conflict with your
transaction, you should be able to determine if the outside transactions
conflict with each other.
Uh ... not necessarily. That amounts to
On Fri, 2003-08-22 at 03:48, yruhn wrote:
Dear anyone,
I wish to update an entire table with just using (PostGre)SQL
(preferably without resorting to C, Python or so). Can I? If
so how?
For example, I want to update/replace table:
a | b | c
---+---+---
1 | 2 | 3
4 | 5 | 6
On Wed, 2003-08-20 at 22:13, G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
As important as the book: what version are you using?
Robert L Mathews wrote:
At 8/26/03 12:56 AM, Bruce Momjian [EMAIL PROTECTED] wrote:
I do often top-post, and I didn't realize it was an issue until this
week. I usually top-post when I need to make a comment on the entire
email, like Is there a TODO here?, patch applied, or something like
You could try postgres documentation at http://www.postgresql.org/docs/
or there is an online book titled 'PostgreSQL: Introduction and Concepts'
at http://candle.pha.pa.us/main/writings/computer.html
G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
If you want to keep the same functions just do as follows
CREATE OR REPLACE FUNCTION nvl(TEXT,TEXT) RETURNS TEXT AS '
BEGIN
RETURN COALESCE($1,$2);
END;' LANGUAGE 'plpgsql';
You will have to do this for all supported data types unless you want to
put in a third parameter that would be the
What operating system and file system? Can I guess Linux/ext2?
---
Christian von Kietzell wrote:
Hi,
I've got a serious problem. After a horrible filesystem crash the only thing
left of my database are some files in
Carmen Gloria Sepulveda Dedes [EMAIL PROTECTED] writes:
Hello. I type \dt as user postgres, but it show only the tables within
public schema.
More accurately, it shows the tables visible in your schema search path.
I need to know all tables
\dt *.*
regards, tom lane
P. Joshua Rovero [EMAIL PROTECTED] writes:
Ran sets of 150 pgbench runs, with clients (1, 2, 4, 8, 16) and
transactions (5 each at 125, 250, 500, 1000, 2000, 4000),
BTW, what was the pgbench scale factor?
1 for these cases.
Hm. You really want scale factor = number of clients, else you
Alex [EMAIL PROTECTED] writes:
when I run a SELECT INTO and the result is 0 or zero row, then I still
get a positive result if
using IF FOUND THEN
I recall Neil Conway fixed some problems with FOUND a version or two
back. If you are not on 7.3.*, update. If you are, let's see the
Tom Lane wrote:
P.J. \Josh\ Rovero [EMAIL PROTECTED] writes:
Ran sets of 150 pgbench runs, with clients (1, 2, 4, 8, 16) and
transactions (5 each at 125, 250, 500, 1000, 2000, 4000),
BTW, what was the pgbench scale factor?
regards, tom lane
1 for these cases.
javier garcia - CEBAS [EMAIL PROTECTED] writes:
./psql -d template1 -f dumpall.backup.26-08-2003
I obtain the messages:
You are now conected to database template1
DELETE 3
CREATE USER
...
CREATE GROUP
ERROR: user javierdoes not exist
ALTER GROUP
...
\connect: FATAL
On Wed, Aug 27, 2003 at 08:09:16 -0500,
Bruno Wolff III [EMAIL PROTECTED] wrote:
On Wed, Aug 27, 2003 at 20:37:14 +1000,
Peter Moscatt [EMAIL PROTECTED] wrote:
Is there a SQL command I can issue which will list all the TABLES within
a database ?
select datname from pg_database;
This
Tom,
I am using 7.3.4
The problem
_tmpRec = RECORD;
_name = VARCHAR;
SELECT INTO _tmpRec * FROM address WHERE name = _name AND status = ''1''
AND last_name NOTNULL
IF FOUND THEN
RETURN ''found'';
ELSE
Above Query does not produce any results. Executed in psql result = 0
rows. However
Alex [EMAIL PROTECTED] writes:
SELECT INTO _tmpRec * FROM address WHERE name = _name AND status = ''1''
AND last_name NOTNULL
IF FOUND THEN
RETURN ''found'';
ELSE
Above Query does not produce any results.
The above query produces a syntax error, because you're missing a
semicolon
On Wed, Aug 27, 2003 at 17:52:34 +0200,
javier garcia - CEBAS [EMAIL PROTECTED] wrote:
2) I'm only able to start the server from the user postgres. Is it possible
to start it from another user? The problem is that I usually work as other
user javier in my computer, which is where the server
On Wed, Aug 27, 2003 at 15:49:26 -0700,
expect [EMAIL PROTECTED] wrote:
Why does this list even use real addresses? Why not have From and To the same?
i.e. [EMAIL PROTECTED]
Is it a social issue or technical? I'd be surprised if it was the latter.
As you have been told previously, not
Hi,
I have some problems with creating a query that will replace values in
one table from another one.
Table 1:
userName : refCode1 : refCode2
--
alex : 12 : 24
Table 2:
refCode : ActualCode
-
12 AA
24 BB
On Wed, 27 Aug 2003 22:35:17 -0500
Bruno Wolff III [EMAIL PROTECTED] wrote:
On Wed, Aug 27, 2003 at 15:49:26 -0700,
expect [EMAIL PROTECTED] wrote:
Why does this list even use real addresses? Why not have From and To the same?
i.e. [EMAIL PROTECTED]
Is it a social issue or
Can anyone point me to comparisions of postgres and mysql?
peter karp
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can
It would be easier to help you with the quoting issues if you provided
an example of the entire query you need to execute and/or the code
you're using to build the query.
Quoting in a function can get pretty hairy sometimes. You might find
this chart helpful, I certainly have:
After a long battle with technology,[EMAIL PROTECTED] (Jan Wieck), an earthling, wrote:
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
What about a little hint to the buffer management that if it has to
evict another buffer to physically read this one (meaning the
buffer pool was full
After a long battle with technology,[EMAIL PROTECTED] (Vivek Khera), an earthling,
wrote:
TL == Tom Lane [EMAIL PROTECTED] writes:
TL Just nice'ing the VACUUM process is likely to be counterproductive
TL because of locking issues (priority inversion). Though if anyone cares
TL to try it on
On Wednesday, August 27, 2003, at 09:17 AM, Carmen Gloria Sepulveda
Dedes wrote:
Hello. I type \dt as user postgres, but it show only the tables within
public schema. I need to know all tables (like v$_ or dba_ or user_
in oracle). How I do that?
Start psql with the echo flag:
[inligo:~]
Not to take anything away from the books on the topic, but my favorite
source is the docs that got installed with postgres
(/usr/local/pgsql/doc/html).
The index isn't great, but easily overcome:
grep -i search phrase /usr/local/pgsql/doc/html/* | less
Try to do that with a book. :-)
When I
expect [EMAIL PROTECTED] writes:
Other lists I subscribe to do not suffer from the spam plague in the way this
list does. I wish I'd known that before signing on rather than after.
[ raised eyebrow ] I subscribe to many mailing lists. On most of the
other lists I have to apply spam filtering
I've created two PL/pgSQL functions with the same name and different
signatures:
CREATE FUNCTION ABC(CHAR) ...
CREATE FUNCTION ABC(TEXT)
I intended to call the CHAR-signature function like this:
SELECT ABC('R');
And the TEXT-signature function like this:
SELECT ABC('Right');
But I found
Hi,
I tried make in the tablefunc
directory under contrib directory in the Posgresql source
directory.
I am getting compilation errors. Beloware the
error messages.
Can you tell me how to solve this problem. I want
to use the crosstab function.
tablefunc.c: In function
El Jue 28 Ago 2003 10:26, Benjamin Jury escribió:
The only problem with 'Practical PostgreSQL' is that it is rather out of
date.
Not exactly. Yesterday a friend told me that a new edition of the book was
coming out this month, which should cover up to 7.3, or even 7.4 features.
Any way, I was
Not to take anything away from the books on the topic, but my favorite
source is the docs that got installed with postgres
(/usr/local/pgsql/doc/html).
The index isn't great, but easily overcome:
grep -i search phrase /usr/local/pgsql/doc/html/* | less
Try to do that with a book. :-)
When I
David Shadovitz wrote:
I've created two PL/pgSQL functions with the same name and different
signatures:
CREATE FUNCTION ABC(CHAR) ...
CREATE FUNCTION ABC(TEXT)
I intended to call the CHAR-signature function like this:
SELECT ABC('R');
And the TEXT-signature function like this:
SELECT
Heath Tanner wrote:
Not to take anything away from the books on the topic, but my favorite
source is the docs that got installed with postgres
(/usr/local/pgsql/doc/html).
The index isn't great, but easily overcome:
grep -i search phrase /usr/local/pgsql/doc/html/* | less
Try to do that with a
On 28 Aug 2003 at 7:55, Chris Webster wrote:
Not to take anything away from the books on the topic, but my favorite
source is the docs that got installed with postgres
(/usr/local/pgsql/doc/html).
The index isn't great, but easily overcome:
grep -i search phrase
Tom Lane wrote:
expect [EMAIL PROTECTED] writes:
Other lists I subscribe to do not suffer from the spam plague in the way this
list does. I wish I'd known that before signing on rather than after.
[ raised eyebrow ] I subscribe to many mailing lists. On most of the
other lists I have
Ivar wrote:
I don't see why default is so small.
Joe Conway [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Ivar wrote:
For my supprise I found that functions have 32 parameter limit.
Where to find more info about this limitation or similar limitations ?
I need at least 50,
It all depends what soft are you doing.
There is for example material card function.
It it designed so bad that it has more than 32 ars.
Why must split this function if behind UI I use it as single function for
adding updateing material ???
CREATE OR REPLACE FUNCTION
How do I do that? I don't know the format of the clog files. The only
information I found was in clog.h and xlog.h.
xlog is fairly easy, I think resetxlog or something can work there. For
clog I just noted from the logs which clog files it was missing and
created them filled with either 0x00
On Thu, 28 Aug 2003, Alvaro Herrera wrote:
Fortunately, Cristoph Dalitz's repeated complaints have finally caused
Marc to reconfigure MHonArc so it won't publish the addresses.
Actually, someone finally providing me with a means to 'mangle' the
addresses caused me to reconfigure it ...
Hello All!
Im suffering an appearantly common problem with psql, although I
haven't been able to locate the proper solution.
Using phpPgAdmin I've created a relation (note: this relation is
grossly simplified but the problem remains the same) :
CREATE TABLE Users
( bid SERIAL,
name
Hi,
As i haven't got any reply on my message, i re-post it, as i think it
can help 7.4 developpers.
Thierry Missimilly
---BeginMessage---
Hi,
I've got the tar ball postgresql-7.4beta1.tar.gz and tried to build
it on i686-pc-linux with a RedHat 7.3.
1) configure --with-tcl
Sune Nielsen [EMAIL PROTECTED] writes:
Now, the problem is that I wish to extract the sequence number from a
newly inserted user, like this:
INSERT INTO Users (name) VALUES ('JohnDoe');
SELECT CURRVAL('users_bid_seq');
This works perfectly(!), but my project involves multiple simultanous
On 28 Aug 2003 at 14:35, Sune Nielsen wrote:
INSERT INTO Users (name) VALUES ('JohnDoe');
SELECT CURRVAL('users_bid_seq');
This works perfectly(!), but my project involves multiple simultanous
users so I have to use transactions like this:
BEGIN;
INSERT INTO Users (name) VALUES
Benjamin Jury wrote:
The only problem with 'Practical PostgreSQL' is that it is rather out of
date.
True, there have been many new features, however you can't say its
beyond usefullness now. A new person to PostgreSQL can look at it
online, check it out at the library, pick it up new/used... and
Hi,
i've a speed problem withe the following statement:
SELECT DISTINCT pz.l1_id, pz.l2_id, pz.l3_id, pz.l4_id
FROM ot_adresse AS a, ot_produkt AS p
LEFT OUTER JOIN ot_kat_prod AS pz ON ( p.p_id = pz.p_id )
WHERE p.a_id = a.id AND a.id = '105391105424941' AND a.m_id = '37';
This is terrible
It might be possible to use an array.
Ivar wrote:
It all depends what soft are you doing.
There is for example material card function.
It it designed so bad that it has more than 32 ars.
Why must split this function if behind UI I use it as single function for
adding updateing material ???
There are different datatypes and does odbc supports arrays ?
Dennis Gearon [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
It might be possible to use an array.
Ivar wrote:
It all depends what soft are you doing.
There is for example material card function.
It it designed so bad
Alex [EMAIL PROTECTED] writes:
is there an easy way to get the Difference between 2 dates in Days... as
an integer?
Subtract 'em ...
regression=# select '2002-01-01'::date - '2001-01-01'::date;
?column?
--
365
(1 row)
regards, tom lane
I'd suggest looking at the mailing list archives
What I must look for ???
Stephan Szabo [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Thu, 28 Aug 2003, Ivar wrote:
I don't see why default is so small.
Re-read Joe's response. There are performance and disk usage tradeoffs
Ivar wrote:
I don't see why default is so small.
Did you even bother to look at the thread I referred to?
There was a lengthy discussion on the pros and cons of various default
settings, and the consensus of the community was 32. If you'd like to
make a cogent argument for why it ought to be
On 28 Aug 2003 at 8:22, Dennis Gearon wrote:
if one gives a value for the seirial field, the trigger for the serial
on that table doesn't generate another value?
If you are going to get sequence value first and insert it later, you can just
declare it int8 rather than serial..:-)
Would that
Ivar wrote:
I'd suggest looking at the mailing list archives
What I must look for ???
http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8threadm=3D4C4A1D.10100%40joeconway.comrnum=1prev=/groups%3Fq%3DFUNC_MAX_ARGS%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den
HTH,
Mike Mascari
[EMAIL PROTECTED]
Did you even bother to look at the thread I referred to?
What thread ?
You just gave some notes how to come over this, but I think I'll never use
modified source
and not standard release server.
If you see my example of my functions (trying to move ms sql to postgre, all
goes well except it),
Tom Lane [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Ivar [EMAIL PROTECTED] writes:
Are there any real pefrormance difference, what are actual
difference(%),
have somebody measured even it ?
You still haven't looked at the thread you were pointed to, have you?
There is
On Thu, 28 Aug 2003 20:24:43 +0530,
[EMAIL PROTECTED] (Shridhar Daithankar) wrote:
On 28 Aug 2003 at 14:35, Sune Nielsen wrote:
INSERT INTO Users (name) VALUES ('JohnDoe');
SELECT CURRVAL('users_bid_seq');
This works perfectly(!), but my project involves multiple simultanous
users so I have
Are these clusters physically together using dedicate LAN lines or
are they synchronizing over the Interwait?
Ron Johnson wrote:
On Thu, 2003-08-28 at 16:00, Jan Wieck wrote:
Ron Johnson wrote:
Notes:
a) this is, of course, not *sufficient* for multi-master
b) yes, you need a
I have a problem with a before trigger raising a heap_mark4update error. It
happens when there are many updates on the same key. OIDs are off
presumably? Am running 7.3.2 on RH 7.3. Have looked around the archives
and found nothing useful - a mention of a known issue and a potential patch?
Or
Marie G. Tuite [EMAIL PROTECTED] writes:
I have a problem with a before trigger raising a heap_mark4update error. It
happens when there are many updates on the same key. OIDs are off
presumably? Am running 7.3.2 on RH 7.3. Have looked around the archives
and found nothing useful - a
Same issue - are there rpms anywhere for 7.3.4?
Thanks.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Tom Lane
Sent: Wednesday, August 27, 2003 10:43 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] Org; [EMAIL PROTECTED]
Subject: Re: [GENERAL] before
hi ,
iam trying to run gdb on postgresql to stack-trace the functions that get
called when a lock is taken.
gdb *program*
what do i pass in place of program inorder to run gdb on postgresqql
thanks
jenny
_
Get MSN 8 and help protect
92 matches
Mail list logo
