Frank Miles <[EMAIL PROTECTED]> writes:
> The thought suddenly has occurred to me -- the client system that I'm
> using *isn't* missing postgresql. It's got an old version on it!
> *Really* old -- perhaps predating 6.5.x. Oooppss. Client libraries, huh?
> Sounds like it's time to clean that out
On Thu, 14 Jun 2001, Tom Lane wrote:
> Frank Miles <[EMAIL PROTECTED]> writes:
> > The only thing I can imagine might be the problem is that client system
> > doesn't have postgres loaded.
>
> You don't need the server loaded, only the client libraries. If you
> are getting as far as to contact
Frank Miles <[EMAIL PROTECTED]> writes:
> The only thing I can imagine might be the problem is that client system
> doesn't have postgres loaded.
You don't need the server loaded, only the client libraries. If you
are getting as far as to contact the server, then AFAIK your client
libraries are
On Wed, 13 Jun 2001, Tom Lane wrote:
> Frank Miles <[EMAIL PROTECTED]> writes:
> > The error log shows:
>
> > No pg_hba.conf entry for host abc.de.fg.hij, user fpm, database fpm
>
> > while in the pg_hba.conf I have an entry:
>
> > hostfpm abc.de.fg.hij 255.255.255.255
Frank Miles <[EMAIL PROTECTED]> writes:
> The error log shows:
> No pg_hba.conf entry for host abc.de.fg.hij, user fpm, database fpm
> while in the pg_hba.conf I have an entry:
> hostfpm abc.de.fg.hij 255.255.255.255 trust
> (Initially it wasn't "trust", b
With the patch from Alex Pilosov (7.1), I was able to create external functions (6.5)
to cast TEXT type to CIDR.
These function allow things like :
SELECT text_inet(text_field);
SELECT ... FROM ... WHERE text_cidr(text_field) >> '192.168.200.1'::inet;
...which are impossible with
Gary DeSorbo <[EMAIL PROTECTED]> writes:
> I am trying to use the query below:
> SELECT date_worked, hours_worked
> FROM hours
> WHERE date_worked < '8/15/2001'
> INTERSECT
> SELECT date_worked, hours_worked
> FROM hours
> WHERE date_worked > '8/8/2001'
> ORDER BY date_worked
> but Postgres does
Hi Thalis, thank's for the info.
If PostgreSQL has to lock the table, then how can it operate on 24x7 ?
Correct me if I'm wrong :)
* pg_dump seems to able to backup the data, don't care if there's an active
user
* Interbase/IBPhoenix do this on the fly ( vacuum )
* Oracle and many other database
Running 7.1.2 on Debian Linux/potato (Intel): I'm trying to connect to the
Postgresql database on machine P from machine A. I can, of course, use the
'fpm' database just fine from machine P. TCPIP has been turned on, along
with debugging. The error log shows:
No pg_hba.conf entry for h
> > I mean allowing an unlimited amount of connections (as much as the
process
> > table will allow) that are served in a round-robin basis by oracle,
much
> > like an httpd process. I'm tired of having to up the number of user
> > connections just because we get an unprecedented surge in interes
Can anyone tell me whether or not vacuum rebuilds
indexes or do I need to explicitly drop and recreate an index if I suspect its
corrupted?
Tim
Pete Leonard <[EMAIL PROTECTED]> writes:
> No, I haven't applied the patch Tom posted yesterday to 7.1.2 - I'm trying
> to get one of the admins here to take care of that - but I was curious as
> to whether the patch fixed the example below.
It worked for me ...
regards,
I am trying to use the query below:
SELECT date_worked, hours_worked
FROM hours
WHERE date_worked < '8/15/2001'
INTERSECT
SELECT date_worked, hours_worked
FROM hours
WHERE date_worked > '8/8/2001'
ORDER BY date_worked
but Postgres does not seem to like the ORDER BY clause. Does
anyone k
Tom Lane wrote on Tue, 12 Jun 2001 19:28:14 EDT
>Martin Weinberg <[EMAIL PROTECTED]> writes:
>> As long as the input table (in this case, may14_goodsrc) is small
>> enough it works fine. For large input tables, postgres exhausts
>> all swap space and crashes.
>
>What Postgres version?
>
>If it's
I was under the impression that vacuum was multi-user safe. It does table locking so
you don't have to worry about concurrency corrupting your data. It just might take
longer (either to vacuum or for a user to get a response)
cheers,
t.
On Wed, 13 Jun 2001, Andy Samuel wrote:
> Hi
>
> Is th
On Wed, 13 Jun 2001, F. Masselink wrote:
> Hello,
>
> i've stumbled upon a problem with triggers and functions.
>
> this function doesn't work.
> It gives an error when creating the trigger: set_leentype() does not exist.
>
> CREATE FUNCTION set_leentype (int4) RETURNS opaque AS '
> BEGIN
Pete Leonard <[EMAIL PROTECTED]> writes:
> Unfortunately, I'm still not quite there - I'm still experiencing DB
> hangs, and was able to duplicate it with the following simplified schema.
> Is this a 7.1-specific bug? Is it breaking 7.1.2 as well?
> ...
> create rule delete_foobar as on delete to
As a followup -
No, I haven't applied the patch Tom posted yesterday to 7.1.2 - I'm trying
to get one of the admins here to take care of that - but I was curious as
to whether the patch fixed the example below.
thanks,
--pete
On Wed, 13 Jun 2001, Pete Leonard wrote:
>
> I w
Hello all,
We are writing a trigger in C that is somewhat like a replication trigger.
It needs to know if data is inserted, updated, or deleted from a particular
table. When the data changes, it must be able to get these changes and write
them to a file. We have been using SPI to get the tuple i
"Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> writes:
> The truth of the matter is that I have queries that take too long to
> execute and I sometimes interrupt them with ^C. I assume the backend
> dies when the frontend receives this, correct?
If you're using psql, it catches ^C and sends a Quer
20 matches
Mail list logo
