On Wed, May 23, 2001 at 11:39:15AM -0600, Chris Jones wrote:
> No, it could be any number of other things. The first that comes to
> mind is EINTR. How about something closer to:
Hmm. Actually, write(2) shouldn't return EINTR; it should return a
short read count. But other errno values inclu
Chris Jones <[EMAIL PROTECTED]> writes:
> No, it could be any number of other things. The first that comes to
> mind is EINTR. How about something closer to:
Writes to disk files don't suffer EINTR as far as I've ever heard
(if they do, there are an awful lot of broken programs out there).
Mor
On Wed, May 23, 2001 at 12:50:46PM -0400, Tom Lane wrote:
> errno = 0;
> if (write(...) != expectedbytecount)
> {
> int save_errno = errno;
>
> unlink(tmp);
>
> errno = save_errno ? save_errno : ENOSPC;
>
> elog(...)
"Oliver Elphick" <[EMAIL PROTECTED]> writes:
> I found the answer to this: the partition had filled up, and so the problem
> was lack of disk space.
> Could we have a more helpful error message?
Indeed. I don't like your solution however, since it's just papering
over the real problem which is
Gabriel Fernandez <[EMAIL PROTECTED]> writes:
> We have some db's in our server. When executing a vacuumdb, ONLY FOR
> SOME of them, the following message is shown:
> AbortTransaction and not in in-progress state
What postgres version?
> After this, the vacuum process is aborted, so we cannot v
Except for Oct 28th if you live in a timezone that does daylight savings.
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: [EMAIL PROTECTED]
>>> Bruno Wolff III <[EMAIL PROTECTED]> 05/23/01 06:59AM >>>
On Fri, May 18, 2001 at 12:17:47PM -0500,
"Karen Ellrick" <[EMAIL PROTECTED]> writes:
> But this time (never before on two other machines) I get the following error
> during PHP's make:
>In file included from pgsql.c:29:
>php_pgsql.h:32: postgres.h: No such file or directory
Remove the unnecessary include of postgres.h in php_pgs
Joakim Bomelin wrote:
> In Solaris 8, I get "IpcMemoryCreate: shmget(key=5432001, size=1236992,
> 03600) failed: Invalid argument" when I try to start postmaster. I can
> see that I don't have enough shared memory, and that I should change the
> SHMMAX parameter in the kernel.
> I'm not really up
Hi,
I believe this is a dumb question, and I have a sneaky feeling that I've
seen something about this on the list before, but I can't find it in the
archives.
I am used to using PostgreSQL on Linux, but we have moved some of our
work onto Solaris multiprocessor boxes. Now, I see multiple insta
Feite Brekeveld wrote:
> If you have databases that large that they don't fit on a single disk
> (nowdays 75 Gb !) you definitely should consider to look for a RAID level 5
> solution. For instance using 7 disks of which 2 hot-spares. With the 75 G
> disks you would get to about 350 G diskspace w
Scott Holmes <[EMAIL PROTECTED]> writes:
> First, I believe I probably have some orphan blobs in one of my
> databases. I have updated some records, replacing one image oid with
> another before I knew about lo_unlink. Is there a method for finding
> such stranded objects?
I think contrib/vacu
On Monday 21 May 2001 01:27, Johnny_ wrote:
> I want to use an aggregate function in the WHERE clause and SQL Server 7
> won't let me? Specifically, I need to find a customer ID where the budget
> is equal to MAX(budget). Is my logic wrong? How can I display the the
> customer ID with the b
And I have 7.0 installed and yesterday I couldn't find COPY.
I had to use the \copy command in psql instead.
I've installed postgres from the source.
Any ideas why COPY isn't there, in the bin directory?
Ah, "man copy" works fine.
TIA,
Carlos Felipe Zirbes
DBServer Assessoria em Sistemas de In
On Fri, May 18, 2001 at 12:17:47PM -0500,
DC <[EMAIL PROTECTED]> wrote:
> I have an event that is three days long. In a table I want to be able to
> enter Friday date and have Saturdays and Sundays fill in automatically. It
> also has to check for the month/# of days in...
You can add intervals
Joakim Bomelin wrote:
> In Solaris 8, I get "IpcMemoryCreate: shmget(key=5432001, size=1236992,
> 03600) failed: Invalid argument" when I try to start postmaster. I can
> see that I don't have enough shared memory, and that I should change the
> SHMMAX parameter in the kernel.
> I'm not really up
Hi Karen,
It wouldn't hurt to update to at least PHP 4.0.5, as it fixes a bunch of
bugs, and also knows about the changes in the PostgreSQL naming of
include files, etc.
:-)
Apache 1.3.20 is also available last I checked too.
:-)
Regards and best wishes,
Justin Clift
Karen Ellrick wrote:
>
In Solaris 8, I get "IpcMemoryCreate: shmget(key=5432001, size=1236992,
03600) failed: Invalid argument" when I try to start postmaster. I can
see that I don't have enough shared memory, and that I should change the
SHMMAX parameter in the kernel.
I'm not really up for recompiling the kernel, sinc
On Wed, 23 May 2001, Karen Ellrick wrote:
> I gave up on 7.1.1 for now, although that is not ideal. I looked around the
> web some more, and saw a recommendation to someone who was using RPMs for
> postgresql and had the same problem, saying to install the postgresql-devel
> RPM as well. I don'
Hi,
We have some db's in our server. When executing a vacuumdb, ONLY FOR
SOME of them, the following message is shown:
AbortTransaction and not in in-progress state
After this, the vacuum process is aborted, so we cannot vacuum these
'problematic' db's.
What can we do ?
Gabi :-)
--
I gave up on 7.1.1 for now, although that is not ideal. I looked around the
web some more, and saw a recommendation to someone who was using RPMs for
postgresql and had the same problem, saying to install the postgresql-devel
RPM as well. I don't know how to do that with compiled source, but I t
On Wed, 23 May 2001, Karen Ellrick wrote:
> during PHP's make:
>In file included from pgsql.c:29:
>php_pgsql.h:32: postgres.h: No such file or directory
>
> Anyone done this before, and had this message? I am using the same tarballs
> for PHP and Apache that I used on the previous two i
Update on my problem: I had another machine waiting in the wings, that would
eventually replace the one I am having trouble with regarding the multibyte
complaint. I decided to try installing PostgreSQL 7.1.1 on that one, and it
worked. So if I can get everything else working on the new machine,
Hello,
a new project is located at http://dbdesigner.sourceforge.net/
Dan
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
mess
How can I return RECORD in my function as I get this msg
ERROR: fmgr_info: function 0: cache lookup failed
my function was delcared like this:
create function testfunction() returns record as '
declare
result record;
begin
select into result * from test;
return record;
end;
' language 'plpgsq
24 matches
Mail list logo
