"Poul L. Christiansen" wrote:
>
> H, don't you mean /var/lib/pgsql/data/postmaster.opts ?
Yes, I do. Monday morning. :-) GUC is much nicer in 7.1..one
file.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP
On 19 Mar 2001 11:25:10 +1100, Gavin Sherry wrote:
> On Fri, 16 Mar 2001, Terry Fielder wrote:
>
> > Can anyone recommend any Iintegrated Development Environment or Rapid
> > Application Development tools for hooking upto a PostgrSQL database?
> >
> > In particular, I am looking for something t
3/17/2001 1:32:53 PM, "Moishe Groger" <[EMAIL PROTECTED]> wrote:
> I just finished compiling and installing the newest versions of cygwin,
> cygipc, and postgresql 7.1 beta 6. When I attempt to run "postmaster -D
> /usr/local/pgsql/data", however, I receive the following error message:
>
>
[snip junk]
> [snipped code that looked simple enough to a non tcl-er]
> >
> > they both produces sometimes correct results, sometimes under what the
> > result should be and sometimes over it.
> > But 5 or 6 concurrent requests always produce the correct results, any
> > more than that things go
H, don't you mean /var/lib/pgsql/data/postmaster.opts ?
My pg_options file contains:
verbose=2
query=2
syslog=0
I'm running PostgreSQL 7.0.2 on Redhat 7.0.
Poul L. Christiansen
Lamar Owen wrote:
>
> "Poul L. Christiansen" wrote:
> > On Mon, 19 Mar 2001, Vilson farias wrote:
> > > I chan
we are now going to develop a
system using PostgreSQL on Linux.
this is the first time for us to use PostgreSQL , as well as
Linux.
many things we would like to ask...
this time, the question is about SIGNALS.
I know there are some signals used for the interactions
between
postmaste
Hi David,
I had the same problem, and here is my solution (I posted it on Pg-Novice
quite a while back):
Q: How do I have an interval displayed only in 'hours:minutes' instead of
the default 'days hours:minutes'
A: My solution is a function like this:
CREATE FUNCTION "to_hours" (interval )
Hi there
For testing, I have a Microsoft Windows NT Server with IIS 4.0 running in
my DMZ. Currently it is not possible to migrate this server to LinuX. Is
there a way to move an existing postgreSQL 7.0.3 db (with views/sequences)
from a Linux Server to this NT Web server. I have coldfusion on NT
"Poul L. Christiansen" wrote:
> On Mon, 19 Mar 2001, Vilson farias wrote:
> > I changed my /etc/rc.d/init.d/postgresql. The postmaster line now is :
> > su -l postgres -c "/usr/bin/pg_ctl -o '-B 1024' -D $PGDATA -p
> > /usr/bin/postmaster start >/dev/null 2>&1" < /dev/null
> I remember having
[EMAIL PROTECTED] writes:
> Im using aolserver - but its Im writing it in php later too.
> code is below
> set sql "BEGIN WORK"
> ns_db exec $db $sql
> set sql "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE"
> ns_db exec $db $sql
> set sql "UPDATE threads set views = views + 1 WHERE forum_id = $
>> I have on a web application
>> update threads set views = views + 1 where forum_id = 1 and thread_id = 1
It should work to do
begin;
select * from threads where forum_id = 1 and thread_id = 1 FOR UPDATE;
update threads set views = views + 1 where forum_id = 1 and thread_id = 1;
end;
Note the
[EMAIL PROTECTED] wrote:
>
> Richard Huxton wrote:
> >
> > From: <[EMAIL PROTECTED]>
> >
> > > I have on a web application
> > > update threads set views = views + 1 where forum_id = 1 and thread_id =
> > > 1
> Im using aolserver - but its Im writing it in php later too.
> code is below
[snippe
Hello all,
I am having problems with the setup of postgres on NT. I do have MSVisual
C++ I have done:
copy include\config.h.win32 include\config.h
nmake /f win32.mak
And I get
NMake : fatal error u1077: 'cd' : return code '0x1'
Stop
Can any one help.
I am using Version 1.62.7022 of NMake
an
Great! Now it's ok. Thanks.
- Original Message -
From: Poul L. Christiansen <[EMAIL PROTECTED]>
To: Vilson farias <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; SIMONE Carla MOSENA
<[EMAIL PROTECTED]>
Sent: Segunda-feira, 19 de Março de 2001 11:23
Subject: Re: [GENERAL] Cant connect if -B 1
I remember having this problem. You need to pass the '-i' switch.
Try: '-B 1024 -i'
I don't know if this behavior is an error or not.
Poul L. Christiansen
On Mon, 19 Mar 2001, Vilson farias wrote:
> Greetings,
>
> There are a very weird problem here.
>
> I changed my /etc/rc.d/init.d
Greetings,
There are a very weird problem here.
I changed my /etc/rc.d/init.d/postgresql. The postmaster line now is :
su -l postgres -c "/usr/bin/pg_ctl -o '-B 1024' -D $PGDATA -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null
That mean now are 8Mb (1024 buffers of 8Kb) availab
Hi Michelle,
Check out phpPgAdmin - see http://www.greatbridge.org/project/phppgadmin/
Regards,
Ned
Michelle Murrain wrote:
> On Sunday 18 March 2001 07:50 pm, Doug McNaught wrote:
>
Can anyone recommend any Iintegrated Development Environment or Rapid
Application Development tools
Hi,
I created a Tables : Create Table address (contry
varchar(20), city varchar(20), zip_code integer),
Create
Table person (Name varchar(20), addr address);
I would know how I can Insert Values in person
table.
note that Po
On Sunday 18 March 2001 07:50 pm, Doug McNaught wrote:
>
> > > Can anyone recommend any Iintegrated Development Environment or Rapid
> > > Application Development tools for hooking upto a PostgrSQL database?
> > >
> > > In particular, I am looking for something that develops for Linux,
> > > becau
Richard Huxton wrote:
>
> From: <[EMAIL PROTECTED]>
>
> > I have on a web application
> > update threads set views = views + 1 where forum_id = 1 and thread_id =
> > 1
> > just to record view for that page - stupid I know but people want it.
> > Problem comes when I use apache's ab to test it.
>
From: <[EMAIL PROTECTED]>
> I have on a web application
> update threads set views = views + 1 where forum_id = 1 and thread_id =
> 1
> just to record view for that page - stupid I know but people want it.
> Problem comes when I use apache's ab to test it.
>
> It just doesnt produce the correct r
You should not be experiencing this if you are using transactions.
Gavin
On Mon, 19 Mar 2001 [EMAIL PROTECTED] wrote:
> I have on a web application
> update threads set views = views + 1 where forum_id = 1 and thread_id =
> 1
> just to record view for that page - stupid I know but people want
On Fri, Mar 16, 2001 at 09:51:20PM +0100, Feite Brekeveld wrote:
> If I do that ( tried that already ) I get an eror message:
>
> pmr is not a pointer
>
> at the point where I reference to it in the query:
> ...
Please read my mail completely:
> > This should work. But be sure to
23 matches
Mail list logo
