On Sat, Aug 12, 2000 at 11:24:31PM -0400, Tom Lane wrote:
> Ian West <[EMAIL PROTECTED]> writes:
> > Is there any way to request postgres to immediately fail, or better yet
> > fail after some small time when trying to obtain a conflicting lock ?
>
> Deadlocks should be detected within about a se
Ian West <[EMAIL PROTECTED]> writes:
> Is there any way to request postgres to immediately fail, or better yet
> fail after some small time when trying to obtain a conflicting lock ?
Deadlocks should be detected within about a second. If you have an
example where one is not, let's see it...
Is there any way to request postgres to immediately fail, or better yet
fail after some small time when trying to obtain a conflicting lock ? I
have ported some old code from Informix (mainly esql) and the default
behaviour with the version I was using was to simply return an error.
If not, is it
If you are using pg_dump, you probably should be fine if you're
restoring a full database, because it should place the constraints
in after the data is loaded. If you do a data only dump, there
is code in the dump at the very top and bottom to disable and
reenable the constraints and that should
Hi All,
I am wondering is there any way to turning off referential integrity
without using SET CONSTRAINTS and create table with DEFERRABLE for database
restore purpose?
TIA.
--Mursalin.
Philip Warner <[EMAIL PROTECTED]> writes:
>> Indexscan estimates are supposed to be nonlinear, actually, to account
>> for the effects of caching. I doubt the shapes of the curves are right
>> in detail, but I haven't had time to do any research about it.
> As to the non-linearity, I would have
Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
>> IMPORTANT: changing the backend's locale on-the-fly is an EXTREMELY
>> DANGEROUS thing to do, and I strongly recommend that you find another
>> way to solve your problem.
> The "problem" I am trying to solve is to send e-mail notifications t
I think its "org.postgresql.Driver"
Byron
- Original Message -
From:
Sean
Weissensee
To: [EMAIL PROTECTED]
Sent: Saturday, August 12, 2000 12:51
PM
Subject: [GENERAL]
ClassNotFoundException
Why do I get this above error in my jsp
page
here is
David Steuber <[EMAIL PROTECTED]> writes:
> For perl, using CPAN.pm, what install command will get me the
> interfaces for PostgreSQL? Do I need to have PostgreSQL setup and
> running first?
Before you can use DBI with PostgreSQL, the PostgreSQL database server
must be running on your computer
Why do I get this above error in my jsp
page
here is the connection code
<%@page language="java"
import="java.sql.*"%> <%Driver DriverRecordset1 =
(Driver)Class.forName("PostgreSQL.Driver").newInstance();
On Sat, Aug 12, 2000 at 12:15:26PM -0400, Tom Lane wrote:
> Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> > When "seller_locale" is, for instance, "de_DE", then I get theses
> > errors:
> > ERROR: Bad float8 input format '0.05'
> > Is Postgres expecting the float as 0,05 (notice the com
Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> where "date_part" comes from "date_part('epoch', stopdate)" in a
> previous query. The problem is the value of stop_date is not the number
> of seconds since the epoch but some internal representation of the data.
> So I can't compare stop_date
Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> When "seller_locale" is, for instance, "de_DE", then I get theses
> errors:
> ERROR: Bad float8 input format '0.05'
> Is Postgres expecting the float as 0,05 (notice the comma) because of
> the locale?
I'm sure that's the issue. If you loo
Hi,
Are there any plans to support specifying database in select
statement? Like select * from mydb.mytable while being connected to
another db.
Cheers,
Kari
Eric Spaulding wrote:
>
> Anyone know an easy way to perform multi-database joins in postgres?
>
>
>
I would also like to know how people handle a situation where it is
neccesary to maitain related databases separately.
Right now I have a database which contains geographic data. Yet I want
15 matches
Mail list logo
