Clay Luther wrote:
> Heh...well, first let me say:
>
> 1) Our database is highly normalized.
Excellent. When faced with the choice of ensuring integrity myself in
the face of redundancy vs. Tom Lane's ability to improve the planner,
optimizer, and executor, I always vote for the latter!
> 2) Al
As the co-author of Practical PostgreSQL: Yes
Pratical PostgreSQL 2E is on the way. It will cover 7.4. It WILL NOT BE
OUT NEXT MONTH. It will probably be out in mid-winter.
Sincerely,
Joshua Drake
Martin Marques wrote:
El Jue 28 Ago 2003 10:26, Benjamin Jury escribió:
The only
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 fast,
On Thu, Aug 28, 2003 at 02:11:26PM -0700, Jenny - wrote:
> 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
After the backend is running, get its
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
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
>> use
"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?
>
"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 another issue besides disk space and performance, which is that
function
On Thursday, August 28, 2003, at 08:58 AM, Dennis Gearon wrote:
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 "sear
> 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),
i
Ivar wrote:
>>I'd suggest looking at the mailing list archives
>
> What I must look for ???
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3D4C4A1D.10100%40joeconway.com&rnum=1&prev=/groups%3Fq%3DFUNC_MAX_ARGS%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den
HTH,
Mike Mascari
[EMAIL PR
Thomas Beutin <[EMAIL PROTECTED]> writes:
> 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 = '1053911054
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 tha
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 hi
Ivar wrote:
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.
Some one else will have to answer that.
---(end of broadcast)---
>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
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
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
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 trigg
if one gives a value for the seirial field, the trigger for the serial
on that table doesn't generate another value?
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(!), b
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 ???
CREAT
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
for raising the limit. I'd suggest looking at the mailing list archives
for the discussion mentioned.
> "Joe Conway" <[EMAIL PROTECTED]> wrote in messa
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 slo
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
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 ('
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 simultan
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
--- Begin Message ---
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 --enable-thread-saf
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
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 ... Chri
>> 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 eith
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
wpr_M_I_MaterialCard_Doc(int
Hi,
is there an easy way to get the Difference between 2 dates in Days... as
an integer?
age('date1','date2') results in x years y days or something similar.
but I would like to
have the result in number of days as an integer.
Thanks for your help
Alex
---(end of br
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
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
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" /usr/lo
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
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 ABC('Rig
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 c
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 wa
Hi,
I tried make in the tablefunc
directory under contrib directory in the Posgresql source
directory.
I am getting compilation errors. Below are the
error messages.
Can you tell me how to solve this problem. I want
to use the crosstab function.
tablefunc.c: In function
`crosstab':ta
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 th
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 filter
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 c
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:~] h
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
> T
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:
http://www.postg
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
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 ge
"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
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
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
Result
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,
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 th
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
semi
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 I
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_datab
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 "javier"does not exist
> ALTER GROUP
> ...
> \co
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 s
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.
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
de
"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 cli
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
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 i
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 cast
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
application
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 som
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 usin
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
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 amo
You don't need to build any function for this, you have them ready:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=functions-conditional.html#AEN9753
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=functions-conditional.html#AEN9698
Cheers,
Csaba.
On Wed, 2003-08-
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 O
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
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
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
subscr
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
dire
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
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 at
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, Christ
> "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
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 f
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 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.
e
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 ch
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) Mo
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 throu
> "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
f
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 broadcast)---
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/
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)
VALUES(9
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
wpr_KA_I_PersonCard_Doc(int,varchar,varchar,varchar,varchar,varc
Natrually right after I sent this post I found the problem. The String was
'[EMAIL PROTECTED]
... which is the old problem with jdbc and embedded 0 charachters. In
what version of the driver was that fixed?
Joseph Shraibman wrote:
I'm having a wierd problem with pg 7.3.3
PostgreSQL 7.3.3 on i6
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 S.staff_
> "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
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 intereste
> "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
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.0
"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
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
>
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 PRO
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 cur
1 - 100 of 101 matches
Mail list logo
