Hey all,
I've been playing around with pg_ctl, and noticed that for pg_ctl
restart it doesn't seem to like the -D parameter the way I'm doing it..
What's the correct way? (This is for v7.1B4).
pgsql@elrond:~/bin$ ./pg_ctl restart -D /usr/local/pgsql/data -s -m fast
pg_ctl: cannot find /usr/loca
Thanks a lot. Adding /usr/local/lib to the LD_LIBRARY_PATH solved the problem. But
now Webmin gives this error
"The PostgreSQL database on your system is version , but Webmin only supports
versions 6.5 and above."
Although, it was working with version 7.0.3. Is it Webmin's problem?
Again, thank
Ahmed Moustafa wrote:
> Hi Tom,
>
> I did the test by hand and here is the output:
>
> bash-2.03# echo "int main() { return 0; }" >conftest.c
> bash-2.03# gcc -o conftest conftest.c -lz -lresolv -lgen -lnsl -lsocket -ldl
> -lm
> bash-2.03# ./conftest
> ld.so.1: ./conftest: fatal: libz.so: open f
On Wednesday 04 April 2001 22:52, Alex Howansky wrote:
> > This has been discussed quite a few times recently (in fact, I posted a
> > similar reply yesterday). From Tom Lane:
> >
> > "Change php_pgsql.h to refer to postgres_fe.h not postgres.h."
>
> ... or symlink postgres.h to postgres_fe.h ...
Hi,
I want to do the following:
create function ...
as
...
BEGIN
FOR myrec IN select distinct id from table where condition
LOOP
END LOOP;
END;
Now this doesn't work because the FOR IN statment expects
a complete record. How to deal with this ?
Tried CURSOR but that led to errors too.
"Gregory Wood" <[EMAIL PROTECTED]> writes:
> This has been discussed quite a few times recently (in fact, I posted a
> similar reply yesterday). From Tom Lane:
> "Change php_pgsql.h to refer to postgres_fe.h not postgres.h."
Or just remove that #include entirely, which is what I believe the PHP
> This has been discussed quite a few times recently (in fact, I posted a
> similar reply yesterday). From Tom Lane:
>
> "Change php_pgsql.h to refer to postgres_fe.h not postgres.h."
... or symlink postgres.h to postgres_fe.h ...
--
Alex Howansky
Wankwood Associates
http://www.wankwood.com/
Hi Tom,
I did the test by hand and here is the output:
bash-2.03# echo "int main() { return 0; }" >conftest.c
bash-2.03# gcc -o conftest conftest.c -lz -lresolv -lgen -lnsl -lsocket -ldl
-lm
bash-2.03# ./conftest
ld.so.1: ./conftest: fatal: libz.so: open failed: No such file or directory
Killed
Hi Peter,
Changing line 6846 gave me the same error message.
Ahmed
Peter Eisentraut wrote:
> Ahmed Moustafa writes:
>
> > Hi,
> >
> > I downloaded Postgres 7.1RC1 from
> > ftp://ftp.postgresql.org/pub/dev/postgresql-7.1RC1.tar.gz. When I did
> > ./configure, I got a error with the test program
This has been discussed quite a few times recently (in fact, I posted a
similar reply yesterday). From Tom Lane:
"Change php_pgsql.h to refer to postgres_fe.h not postgres.h."
Greg
- Original Message -
From: "Gordon A. Runkle" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday,
Hi Peter,
I did the test by hand and here is the output:
bash-2.03# echo "int main() { return 0; }" >conftest.c
bash-2.03# gcc -o conftest conftest.c -lz -lresolv -lgen -lnsl -lsocket -ldl
-lm
bash-2.03# ./conftest
ld.so.1: ./conftest: fatal: libz.so: open failed: No such file or directory
Kill
Tom Lane writes:
> (Peter, shouldn't we suggest to the autoconf boys that that output
> ought to go into config.log?)
It seems your request has already been heard. In general, the config.log
files from Autoconf 2.50 are a *lot* better, e.g., they actually include
the result of the test. Should
Ahmed Moustafa writes:
> bash-2.03# echo "int main() { return 0; }" >conftest.c
> bash-2.03# gcc -o conftest conftest.c -lz -lresolv -lgen -lnsl -lsocket -ldl
> -lm
> bash-2.03# ./conftest
> ld.so.1: ./conftest: fatal: libz.so: open failed: No such file or directory
You need to set the LD_LIBRA
In article <[EMAIL PROTECTED]>, "Joseph"
<[EMAIL PROTECTED]> wrote:
> I am switching from rpm install of postgres to the compiled version. I
> have this running fine, but now my php4 quit working.
>
> So I am trying to compile it and have the error that it cannot find
> postgres.h
>
> Does it n
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Ahmed Moustafa writes:
>> I downloaded Postgres 7.1RC1 from
>> ftp://ftp.postgresql.org/pub/dev/postgresql-7.1RC1.tar.gz. When I did
>> ./configure, I got a error with the test program. I could not figure out
>> the problem. Would you take a look at t
Paulo Jan <[EMAIL PROTECTED]> writes:
> I have a problem here, using Postgres 6.5.3 on a Red Hat Linux 6.0.
Upgrade to 7.0.3.
> Any ideas? (Aside of upgrading to 7.x; we can't do that for now).
If you insist on living with 6.5's bugs, this is one of 'em you'll have
to live with...
I am switching from rpm install of postgres to the compiled version.
I have this running fine, but now my php4 quit working.
So I am trying to compile it and have the error that it cannot find
postgres.h
Does it need to look for another file or do I need to tell it where to look
for it?
respec
I'm creating a script which will re-claim sequence numbers in a table by
'packing' the existing sequence numbers. My questions is if I lock the
table in access exclusive mode, and an insert into that table occurs after
the lock, with the insert be blocked before or after the nextval is chosen?
Ahmed Moustafa writes:
> Hi,
>
> I downloaded Postgres 7.1RC1 from
> ftp://ftp.postgresql.org/pub/dev/postgresql-7.1RC1.tar.gz. When I did
> ./configure, I got a error with the test program. I could not figure out
> the problem. Would you take a look at the config.log
> (http://www.photo.net/user
Hi all:
I have a problem here, using Postgres 6.5.3 on a Red Hat Linux 6.0. I
have a table where, each time I do a "vacuum analyze", the database
complains saying "ERROR: Tuple is too big: size 10460"... and the
problem is that there isn't any record as far as I know that goes beyond
the
Hi,
I downloaded Postgres 7.1RC1 from
ftp://ftp.postgresql.org/pub/dev/postgresql-7.1RC1.tar.gz. When I did
./configure, I got a error with the test program. I could not figure out
the problem. Would you take a look at the config.log
(http://www.photo.net/users/ahmed/config.log) and tell me the p
>On Wed, 4 Apr 2001 01:43:25 +0200, Alexander Lohse alluded:
>
>> Am I missing something about "text" columns?
>>
>> I seem not to be able to retrieve them (using php) just like varchar
> > or ... ones.
>
>A simple example:
>
>jeff=# CREATE TABLE test(
>jeff(# idINTEGER,
>jeff(# stuff T
Feite Brekeveld <[EMAIL PROTECTED]> writes:
> Trying to get grip on FOR row IN select clause using this
> testfunction.
"row" should be the name of a row variable; it's not a keyword.
regards, tom lane
---(end of broadcast)--
"Partyka Robert" <[EMAIL PROTECTED]> writes:
> getInherits(): SELECT failed. Explanation from backend: 'ERROR:
> Attribute 'inhrel' not found
IIRC, this is the symptom you get when trying to run a 6.5 pg_dump
against a 7.0 database ... or was it the other way around? Anyway,
check your PATH t
To the best of my knowledge, you can't use parameters for table names. But
if you have 7.1, you can use the EXECUTE command to dynamically generate
(and execute) any SQL statement. Check out:
http://postgresql.readysetnet.com/devel-corner/docs/programmer/plpgsql-descr
iption.html
Specifically: 2
Hi,
Trying to get grip on FOR row IN select clause using this
testfunction.
The FOR row|record in is the one I can't get to work.
CREATE FUNCTION dosomething (varchar)
RETURNS integer
AS '
DECLARE
_conn_id ALIAS FOR $1;
ts integer;
cdrrec record;
BEGIN
ts := 0;
FOR row IN
J.H.M. Dassen (Ray) wrote:
>DaVinci <[EMAIL PROTECTED]> wrote:
>>ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
>
>> I use Debian packages for Pg 7.1 BETA4. I thought plpgsql was integrated b
>y
>> default, but see it is not so.
>
>I have the same p
On Wed, Apr 04, 2001 at 06:45:39PM +1000, Gavin Sherry wrote:
> Main problem with large objects with postgres 7.0 series (and before
> this) is that ext2 does not scale well when number of hard links in a
> given directory grows to anything like what I would expect a database with
> DNA sequences
Hello.
I'd like to implement for my DB a mechanism of backup based in inherited
tables. I explain it in detail:
Idea is simple: table B inherits from table A. Anualy, data from table A is
dumped in B. So, from frontend it is posible to access current data (from
A) or all data (A + B).
Pr
Good day everybody,
My problem is that i can't use a variabile to name a table, like this:
select INTO id,domeniu idp,nume FROM $2 where idc=$1;
^^
I was having the same problem with creating a table:
create table $1(id serial,stuff text);
^^
wa
DaVinci <[EMAIL PROTECTED]> wrote:
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
> I use Debian packages for Pg 7.1 BETA4. I thought plpgsql was integrated by
> default, but see it is not so.
I have the same problem with 7.1RC2 built using Oliver's Debian diff f
Hi all.
I have an application use postgresql-7.02
I'm making an install program and want that this Install Program can
install postgresql directely.
Where can I get more information about this?
Thanks in advance, Gabi.
--
Gabriel López Millán
Facultad de Informática -Univ
32 matches
Mail list logo
