On Mon, May 21, 2001 at 01:50:45PM +0200, Iwan van der Kleyn wrote:
Hi there,
PostgreSQL 7.1 now is part of the Cygwin Unix on Win32 Toolkit. A terrific
development, because it takes away lots of fuss trying to get Postgres to
work on Win2000.
However, when running initdb the script
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
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
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
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 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
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 :-)
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't
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, since
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:
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 for
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 to
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
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
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/vacuumlo
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
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
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 for
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_pgsql.h.
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,
DC
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 vacuum
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 lack
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(...);
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).
More
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
25 matches
Mail list logo