Peter Eisentraut writes:
> > James Pattie ([EMAIL PROTECTED]) reports a bug with a severity of 3
>
> > If I create a database Ex. BUGS it shows up as bugs instead of BUGS.
> > I can drop the database by saying "drop database BUGS;" and it works
> > but I can not do a \c BUGS or psql BUGS. I get
Hi!
Platform: PostgreSQL 7.1.3, Linux 2.4.8, egcs 2.91.66
PostgreSQL forgets to release lock until shutdown in this scenario:
CREATE TABLE dummy (X integer);
session1 session2
BEGIN; |
"Ron Looi" <[EMAIL PROTECTED]> writes:
> find_hba_entry: Unable to open authentication config file
> "/opt/postgresql-7.1.2/data/pg_hba.conf": File table overflow
Looks like you'd better increase your kernel configuration setting
for NFILE (max number of open files the kernel can deal with at onc
[EMAIL PROTECTED] writes:
> The datatype macaddr accepts empty strings as data. I think this is
> not correct; an empty string is no valid mac address.
This is already changed for 7.2.
regression=# select ''::macaddr;
ERROR: macaddr_in: error in parsing ""
regression=#
Marc Prewitt <[EMAIL PROTECTED]> writes:
> PostgreSQL version (example: PostgreSQL-7.1): PostgreSQL-7.1beta4
Why are you still running a beta release?
> Our development server, on occaision, runs out of swap space and
> inevitably when it does, the postmaster process stops.
I think you are
Andreas Wernitznig <[EMAIL PROTECTED]> writes:
> To make it more comparable I have made two additional runs, a slow and
> a fast one with exactly the same number of inserts (about 20500) and
> put it on our ftp server:
>> However, I think what is happening is that some queries are being done
>> a
Andreas Wernitznig <[EMAIL PROTECTED]> writes:
> The only way to make it faster after step 3 is to close that connection (and stop
>that postmaster thread with it) and establish a new one.
> It seems like the planner (at least for pk checking) of an *established* connection
>to a database doesn'
Yes, I understand very clearly what you mean.
Maybe my mails were to confused, that's why I try to explain my problem once more:
step 1. An empty table with a primary key (=index key) where an "explain" tells me,
that a Seq Scan is used to SELECT a special row.
step 2. Then I start to fill dat
John Summerfield <[EMAIL PROTECTED]> writes:
> I attempted to load data amounting to 21 mbytes into a table which has
> a unique key both otherwise doesn't have indexes.
> The WALs consumed 2.9 Gigabytes of disk (and doubtless would have taken
> more if there was more to be had).
That seems li
Stephan Szabo <[EMAIL PROTECTED]> writes:
> This was a mistake in the interpretation of the spec (modification of
> the same key row referenced by a foreign key constraint in the same
> statement more than once is an error is how we believe the spec meant
> it, but there's a case where they mentio
Tomasz Zielonka <[EMAIL PROTECTED]> writes:
> Platform: PostgreSQL 7.1.3, Linux 2.4.8, egcs 2.91.66
> PostgreSQL forgets to release lock until shutdown in this scenario:
This seems to be a real bug, but I don't like your proposed fix...
the problem evidently is that some lock structure is not bei
On Mon, 3 Sep 2001, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > This was a mistake in the interpretation of the spec (modification of
> > the same key row referenced by a foreign key constraint in the same
> > statement more than once is an error is how we believe the spec me
Tomasz Zielonka <[EMAIL PROTECTED]> writes:
> Platform: PostgreSQL 7.1.3, Linux 2.4.8, egcs 2.91.66
> PostgreSQL forgets to release lock until shutdown in this scenario:
Good catch! This has been broken since 7.1 ... surprising that no one
discovered the problem sooner.
I think that rather than
Robert Blyler ([EMAIL PROTECTED]) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
postgresql-python rpm fails on mx dependency
Long Description
Tried to install the postgresql-7.1.3 rpm's. posgtgresql-python fails on a dependency
on mx. I've trie
Not any more:
test=> create table pp (x macaddr);
CREATE
test=> insert into pp values ('');
ERROR: macaddr_in: error in parsing ""
> Daniel Mantione ([EMAIL PROTECTED]) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
15 matches
Mail list logo
