Hi All,
I have been trying to increase the shared memory buffers used by
Postgres by using the -B option to postmaster, but postmaster fails to
start up for any value greater than 64 (which is the default in any
case) saying "couldn't get shared memory - permission denied".
So, (I know this shoul
Hi all,
we are using Postgresql 6.4.2 on FreeBSD 2.2.8 and have a lot of
problems with suddenly dying backend processes. We have already
changed kernel parameters to get more shared memory and start the
postmaster with -B 1024. The postmaster's virtual memory limit is
currently 300MByte and our l
Try:
#include
int plus2(int a,int b)
{
return(a+b);
}
cc -c plus2.c /* I get the object file *.o */
gcc -shared -o plus2.so plus2.o /* you need a library file */
from psql:
create function plus2(int4,int4) returns int4 as
Primary, Sorry for my english !!!
Hi,
I ´m developing a several test database, for study. But I can´t create
any function, every time ERROR appears.
I write a C code in a plus2.c file
#include
int4 plus2(int4 a,int4 b)
{
return(a+b);
}
main() /* For getting *.out*/
{
}
, then I compile i
On Wed, 5 May 1999, Bruce Tong wrote:
Someone has a table with a column named row_count.
# This is probably one of those things everyone knows except me, but my
# search of the documentation only turned up it's not a keyword in
# PostgreSQL...
#
# SELECT * FROM foo WHERE ROW_COUNT < 10;
Try:
SELECT * FROM foo WHERE LIMIT 10;
You must have PostgreSQL 6.5 for this to work. It is a new feature.
-Original Message-
From: Bruce Tong [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 05, 1999 8:09 AM
To: PostgreSQL General
> -> set query_limit '10'
set query_limit = '10';
> when you are done with it i think the syntax is
>
> -> set query limit
set query_limit = default;
You got me close enough to where I could find it. It was documented, I
just didn't know what to look for originally.
Thanks a bunch!
Bruce
Hi,
Rigth now I have less than one thousand of gif/jpg around 6 to 15 ko each. I guess I
can
go upper :-))
regards,
Gilles Darold
Chris Bitmead wrote:
> darold wrote:
>
> > I'm using Large Object to store images and displayed them on the fly. I never found
> > any problems and it
> > is very
Bruce Tong wrote:
>
> > > SELECT * FROM foo WHERE ROW_COUNT < 10;
> > > Is there anything like "ROW_COUNT" or "ROWCOUNT" in PostgreSQL?
>
> > If trying to receive 10 rows, try
> >
> > begin;
> > declare thomas cursor for select * from foo;
> > fetch 10 in thomas;
> > end;
>
> Ooo, a cursor. I
>> > SELECT * FROM foo WHERE ROW_COUNT < 10;
>> > Is there anything like "ROW_COUNT" or "ROWCOUNT" in PostgreSQL?
>
Look through the archives with LIMIT.
I believe in postgresql 6.4.2 you can use something like
set QUERY_LIMIT TO '10';
and after you've done:
reset QUERY_LIMIT;
and in 6.5 I
> > SELECT * FROM foo WHERE ROW_COUNT < 10;
> > Is there anything like "ROW_COUNT" or "ROWCOUNT" in PostgreSQL?
> If trying to receive 10 rows, try
>
> begin;
> declare thomas cursor for select * from foo;
> fetch 10 in thomas;
> end;
Ooo, a cursor. I'll have to look into those. I was thinking
Try
"select count(*) from row"
to get a count of the number of rows.
If trying to receive 10 rows, try
begin;
declare thomas cursor for select * from foo;
fetch 10 in thomas;
end;
Bruce Tong wrote:
>
> This is probably one of those things everyone knows except me, but my
> search of the do
Your e-mail did not arrive at its intended destination. You need to
send it to Michael J. Davis, not Michael Davis
From: dustin sallings on 05/05/99 01:57 AM
To: mtony @ iname.com@SMTP@EXCHANGE
cc: pgsql-general @ postgreSQL.org@SMTP@EXCHANGE
S
Your e-mail did not arrive at its intended destination. You need to
send it to Michael J. Davis, not Michael Davis.
From: Mark Fleming on 05/04/99
02:23 PM
To: pgsql-general @ postgreSQL.org@SMTP@EXCHANGE
cc:
Subject:Re: [GENERAL] post
Your e-mail did not arrive at its intended destination. You need to
send it to Michael J. Davis, not Michael Davis.
From: Bruce Momjian on 05/04/99
12:39 PM
To: Chris Bitmead @SMTP@EXCHANGE
cc: pgsql-general @ postgreSQL.org@SMTP@EXCHANGE
Subje
This is probably one of those things everyone knows except me, but my
search of the documentation only turned up it's not a keyword in
PostgreSQL...
SELECT * FROM foo WHERE ROW_COUNT < 10;
Is there anything like "ROW_COUNT" or "ROWCOUNT" in PostgreSQL?
I've been looking through "The Practical S
It works on 6.5beta1.
Sarah Officer ha scritto:
> I have a table with a column of type int8. When I try to create an
> index on it, the
> database protests and gives the following error message:
>
> ERROR: Can't find a default operator class for type 20.
>
> Is there an easy fix for this?
darold wrote:
> I'm using Large Object to store images and displayed them on the fly. I never found
> any problems and it
> is very quiet. "When Postgre starts using large objects it is going to make a lot
> of noise." ???
How many images are you storing?
--
Chris Bitmead
http://www.bigfoot.co
18 matches
Mail list logo
