What do you mean by "what language"? You can use PHP if you want it web
based application.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Enrico Comini" <[EMAIL PROTECTED]>
To: "ML-Postrges-general" <[EMAIL PROTECTED]>
Sent: Friday, November 17,
I was wondering if there is any way to set up a foreign key that is
valid not just if the value exists in one table but if it exists in any
of 3 tables. Here is what I mean. I have a sequence called 'id_number'
that I start at 1 and increment by 1 every time its used. I then have 3
tables each
* Enrico Comini <[EMAIL PROTECTED]> [001117 04:04] wrote:
> I use postgres with php3. Now I have to write some little applications.
> What language I can use ?
> Give me a valid idea.
Perl should work, you just need to install the postgresql module.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EM
On Thu, 16 Nov 2000, Lamar Owen wrote:
> The result of 'rpm -qa|grep postgres' would be educational here.
I actually do understand the differences among -i (install) -U (upgrade)
and -F (freshen). What I don't understand is why what _should_ work _isn't_
working.
For example, as Lamar and o
Rich Shepard wrote:
> On Thu, 16 Nov 2000, Lamar Owen wrote:
> > The result of 'rpm -qa|grep postgres' would be educational here.
> [root@salmo rshepard]# rpm -qa | grep postgres
> postgresql-server-6.5.3-1
> postgresql-test-6.5.3-1
> postgresql-7.0.3-2
> "Aha, I said. The rpm database thinks
On Fri, 17 Nov 2000, Lamar Owen wrote:
> Once you have verified with rpm -qa|grep postgres that there are no more
> postgresql RPM's on your system, then you will need to clean out the old
> 6.5.3 data directory (rm -rf /var/lib/pgsql).
>
> Now you should be able to install the new RPMset.
Tha
> I actually do understand the differences among -i (install) -U (upgrade)
>and -F (freshen). What I don't understand is why what _should_ work _isn't_
>working.
>
> For example, as Lamar and others suggested:
>
>[root@salmo rshepard]# rpm -qa | grep postgres
>postgresql-server-6.5.3-1
>postgres
Rich Shepard wrote:
> Thanks, Lamar. I upgraded the server package, and that appeared to work
> just fine. Then I installed the others. Is 'initdb' the proper way to
> restart everything, and creat a new /var/lib/pgsql? It's been a while since
> I worked with postgres, but I need to really dig i
On Fri, 17 Nov 2000, Robert D. Nelson wrote:
> Try uninstalling everything related to postgres that is now installed. Then
> remove /var/lib/pgsql and any data directories that may exist. Start from
> scratch. Oh, and as to order? I just installed them all together, like "rpm
> -ivh postgresql-7.
On Jue 16 Nov 2000 22:54, Marko Kreen wrote:
> On Thu, Nov 16, 2000 at 01:33:08PM -0400, The Hermit Hacker wrote:
> >
> > I run PHP4 and IMP (http://www.horde.org) and we've gotten then to remove
> > the useof pg_pconnect() since it is broken. Broken how, you might
> > ask? Well, I ran on a stan
hello,
i have following table:
id b_stueckb_name b_preis b_summe
(units) (price) (sum)
i want b_summe automatically be calculated, therefore i use
following trigger:
CREATE RULE summieren AS ON INSERT TO t_bestand DO UPDATE
I don't have a file called postmaster in my pgsql/bin directory so I
thought it must be postgres. And it looks like it is the right file, it
just doesn't work...
At 12:22 17.11.00, John Gray wrote:
> > Unfortunately I'm running into another problem. Now when I try to start up
> > the postmaste
If you do a:
/usr/sbin/lsof |wc
What is the output? First number from wc is the number of lines, which in
this case translates to the number of open file descriptors. If this is
close to your limit, then bump your limit.
> -Original Message-
> From: Warren Vanichuk [SMTP:[EMAIL PR
> On Jue 16 Nov 2000 22:54, Marko Kreen wrote:
> > On Thu, Nov 16, 2000 at 01:33:08PM -0400, The Hermit Hacker wrote:
> > >
> > > I run PHP4 and IMP (http://www.horde.org) and we've gotten then to remove
> > > the useof pg_pconnect() since it is broken. Broken how, you might
> > > ask? Well, I r
On Fri, 17 Nov 2000, Philip Hallstrom wrote:
> What is the value for MinSpareServers in your apache's conf? If that's
> set to 20, then even if you only hit your site 20 times (one for each),
> that many apache processes will continue to live and therefore keep a db
> connection open..??
>
> Wh
I have a table "t" with a timestamp column "s". I am trying to issue a query
to find all rows where s is exactly some number of days old (rounded off).
I have tried this:
select * from t where date_part('day', age('now', s)) = ?
But this only looks at the day of the month; e.g. if my parameter
Whoops, I had a typo in my translation; the second query I quoted should
read as follows:
select * from t where date_part('day', age('now', s)) = ? and
date_part('month', age('now', s)) = 0
Thanks,
Bryan
- Original Message -
From: "Bryan (Mailing Lists)" <[EMAIL PROTECTED]>
To: <[EMAIL
> > Part of this document will be on how to port Oracle PL/SQL to
> > Postgres' PL/SQL and PL/Tcl.
>
> Excellent. Now we need someone to do the MySQL version...
? MySQL doesn't have stored procedures AFAIK.
-Jonathan
Now that I successfully installed the packages for 7.0.3-2, I went to
create a new user. Logged in as 'postgres', I tried to create me as a
postgres user. This is what resulted:
[postgres@salmo rshepard]$ createuser rshepard
Shall the new user be allowed to create databases? (y/n) y
Shall the n
After upgrading from 6.x to 7.x, the following query broke, I lost the
ability to check how many days apart two DATEs are by subtracting
them. What is the correct way to determine the difference between two
dates in 7.x?
Thank you.
Ellen Spertus
At 18:03 17.11.00, Tom Lane wrote:
>Peter Eisentraut <[EMAIL PROTECTED]> writes:
>
>I still don't understand why he's seeing a failure...
I'm not seeing this failure anymore after I have saved the file in a unix
format and using absolute paths. I don't know however which of the two
changes did
Greetings.
We've recently been seeing several database crashes. The last things seen
in the logs are :
postmaster: StreamConnection: accept: Too many open files in system
postmaster: StreamConnection: accept: Too many open files in system
FATAL 1: ReleaseLruFile: No open files available to be
22 matches
Mail list logo
