Sorry for the noise on the list.. It turned out that the internet
connectivity at our place balnked out for the few minutes when i was
trying it out..
Sorry once again..
Anand
On Fri, Mar 16, 2001 at 04:43:43PM +0530, Anand Raman wrote:
>hi guys
>
>I am trying to use pg_dump to get a database du
This is just a guess, but I think the reference to gmake is simply for those
that don't use GNU/Linux systems, such as Solaris. You have gmake if you are
running a GNU/Linux system (which you are, of course, since you've got
Debian). I'm sure all Unix variants have a "make" style program, just the
> -Original Message-
> From: Piotr Kasprzyk
>
> While working through Windows ODBC driver form Postgres 6.4 our
> application
> gets the following error:
>
> No response from backend - socket has been closed.
>
Hmm this seems a pretty unhelpful message. Try running the postmaster
with
> -Original Message-
> From: Ligia M.Pimentel
>
> I'm using Delphi (windows) to develop a database application
> using Postgres
> 7.1 in linux.
> When I use delphi with other databases and I try to insert a record that
> violates referential integrity I get an exception, but with postgres
Wow! Got a lot of reponses. Thanks all.
I must be, however, asking the wrong question.
Running debian 2.2 and make is in the system.
Here's a short list of the last few commands:
$./configure --prefix=/usr/local/pgsql --with-odbc
$make all > make.log 2>&1 &
[1] 8486
$tail -f make.log
On Fri, Mar 16, 2001 at 02:39:20PM -0800, Bill Barnes wrote:
> A google search is a dog-chasing-tail exercise.
gnu make
ftp://ftp.gnu.org/gnu/make
mrc
--
Mike Castle Life is like a clock: You can work constantly
[EMAIL PROTECTED] and be right all the time, or not work at all
w
Hey all,
I have 3 tables - A refers to B and C, and A has ON DELETE CASCADE for
referring columns. I'm trying to delete from B, and through the CASCADE to
A's BEFORE DELETE TRIGGER, SELECT a value from B, and then UPDATE C. The
problem is that through this path, when I SELECT from B, the selec
See http://www.gnu.org/software/software.html
I usually use the GNU mirror at uunet (ftp://ftp.uu.net/packages/gnu/)
but if you're not in the eastern US then another one of the mirrors
shown at gnu.org is probably your best bet.
regards, tom lane
Bill Barnes writes:
> Trying to rebuild v6.5.3 and the procedure calls for
> gmake.
>
> A google search is a dog-chasing-tail exercise.
>
> Can anybody help with a URL or an alternative.
http://www.gnu.org/software/make/
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Bill Barnes <[EMAIL PROTECTED]> writes:
> Trying to rebuild v6.5.3 and the procedure calls for
> gmake.
>
> A google search is a dog-chasing-tail exercise.
Depending on your platform, you may already have it. GNU make is
standard on almost all Linux distributions (usually called just
'make').
> It's not surprising to see software raid outperforming hardware raid (both
> of modern vintage).
That's provided, of course, that you have a good amount of free CPU
cycles. On machines that are otherwise heavily CPU-loaded, software raid
has been (in my experience) horrible.
steve
--
Mont, you have probably gotten an answer on this already, but I haven't
seen one go across the list, so here goes.
Assuming that I understand what you want, the easiest way that I can
see to do it is by using self joins.
ie:
SELECT a.cust_id ,
sum(a.bytes) as peri
Philip Crotwell <[EMAIL PROTECTED]> writes:
> So, 3 questions that basically boil down to "What is the best way to move
> large objects from 7.0 to 7.1."
> 1) Can I use the 7.1 pgdumpall to dump a 7.0.3 database? The docs say no,
> but worth a try.
The docs say no, and they mean no.
There is a
> Trying to rebuild v6.5.3 and the procedure calls for
> gmake.
>
> A google search is a dog-chasing-tail exercise.
>
> Can anybody help with a URL or an alternative.
www.freshmeat.net is a good place to look for sources, but in this case,
searching for "gnu make", which will yield you with:
h
On Fri, Mar 16, 2001 at 02:44:57PM -0800, adb wrote:
> and if raid is being done in hardware or software.
It's not surprising to see software raid outperforming hardware raid (both
of modern vintage).
mrc
--
Mike Castle Life is like a clock: You can work constantly
[EMAIL PROTEC
On Fri, Mar 16, 2001 at 02:39:20PM -0800, Bill Barnes wrote:
> Trying to rebuild v6.5.3 and the procedure calls for
> gmake.
>
> Can anybody help with a URL or an alternative.
ftp://ftp.gnu.org/pub/gnu/make/
Chris
--
[EMAIL PROTECTED] -
Chr
> On Fri, Mar 16, 2001 at 03:53:22PM -0600, Alex Howansky wrote:
> > levels. Still, you'd think that even a "slow" RAID-5 configuration would
be
> > faster than a $98 IDE drive...
>
> I wouldn't.
You'd be wrong. : )
I've also copied large amounts of data from an IDE drive to an old AMI
Mega
Trying to rebuild v6.5.3 and the procedure calls for
gmake.
A google search is a dog-chasing-tail exercise.
Can anybody help with a URL or an alternative.
Thanks,
-Bill
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://per
it all depends on the number of drives, the type of drives
and if raid is being done in hardware or software.
A three drive raid 5 array in software with older drives
is probably going to be slower than a single 7200rpm ata100 drive.
Not that this is what you have, just pointing out that it's po
On Fri, Mar 16, 2001 at 03:53:22PM -0600, Alex Howansky wrote:
> levels. Still, you'd think that even a "slow" RAID-5 configuration would be
> faster than a $98 IDE drive...
I wouldn't.
mrc
--
Mike Castle Life is like a clock: You can work constantly
[EMAIL PROTECTED] and be ri
> Yes, it is RAID-5 on the big box. Unfortunately, I don't have any spare
RAID
> equipped boxes sitting around, so I can't experiment with the different
RAID
> levels. Still, you'd think that even a "slow" RAID-5 configuration would
be
> faster than a $98 IDE drive...
Yes, it certainly should b
Hi
I am having problems with large objects in 7.0.3, high disk usage, slow
access and deletes of large objects and occasional selects that hang with
the background process going to 98% of the CPU and staying there. Having
read that there are alot of large object improvements in 7.1, I was
thinki
> [Interesting stats]
>
> > Wow, does WAL make so much of a difference as to make my
> > two-generations-old, built-from-spare-parts scrap box faster than my
> > latest and greatest production server? Yikes!
>
> What RAID level are you running? RAID-5 isn't always very
> fast on writes. That and
Peter Eisentraut wrote:
> Christian Marschalek writes:
> > well i ment over apache (with php) to a database :o)
> Apache encrypts the connection to the web user, PostgreSQL encrypts the
> connection to the database user, which in this case would be Apache.
> I.e.:
> Web user ---SSL---> Apache ---S
On Fri, Mar 16, 2001 at 10:17:33AM -0800, Barry Lind wrote:
>
> My feeling is that postgres has misinterpreted the SQL92 spec in this
> regards. But I am having problems finding an online copy of the SQL92
> spec so that I can verify.
>
> What I would expect the syntax to be is:
>
> table as
Title: RE: [GENERAL] I wonder why I don't get an exception on delphi?
Have you tried the following components:
http://www.zeos.dn.ua/download/zeosdbo-5.2.3-beta.zip
They seem to work more reliably and much more quickly than the ODBC drivers. They also give the required errors ;-)
Regard
On Fri, Mar 16, 2001 at 12:58:06PM +0100, Feite Brekeveld wrote:
> ...
> Exec sql begin declare section;
>MYREC *pmr = &mr;
>
> exec sql end declare section;
> ...
> I get the message :ERROR: The variable id is not declared
> ...
Yes, this is a known limintation. It's even listed
From: <[EMAIL PROTECTED]>
> Hi all. I have to write a trigger and I have never did it before, so if
> there is someone who could give me a start, I will be very grateful...
>
> I have two tables that I want to keep "partially" synced, i.e.:
[snip]
> I would like that when a record gets changed in
- Original Message -
From: Tom Lane <[EMAIL PROTECTED]>
To: Vilson farias <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; SIMONE Carla MOSENA
<[EMAIL PROTECTED]>
Sent: Quinta-feira, 15 de Março de 2001 18:08
Subject: Re: [GENERAL] Why my vacuum fails?
: "Vilson farias" <[EMAIL PROTECTED]>
Hi
I guess this is because postgresql doesnt yet support the concept of
schemas. Such a select statement will make sense when the database
supports schemas..
Hope this helps
Anand
On Mon, Mar 05, 2001 at 03:01:42PM +0600, Zuev Dmitry wrote:
>Can anybody tell me why i can't specify OWNER then i s
hi guys
I am trying to use pg_dump to get a database dump on a local machine..
However the utility simply hangs without dumping any data. The utitility
(pg_dump) however responds if I send a wrong passwd.
What surprises me is that i am able to connect to the database on the
remote machine thru
Hi,
I have an application using structures say
typedef struct {
int id;
char value[40];
} MYREC;
When passing a record to a function insert_record( MYREC *pmyrec)
how to deal with the sql-statement regarding the fields of the struct ?
When doing this (TESTPROGRAM) :
exec sql whenever
Hi all. I have to write a trigger and I have never did it before, so if
there is someone who could give me a start, I will be very grateful...
I have two tables that I want to keep "partially" synced, i.e.:
table1 (field1,field2,field3)
table2 (field1,field2,field3, ... some other fields).
I'
33 matches
Mail list logo
