I don't know if you have received my first message, so I send another one.
Does PostGresql support Compaq Alpha server, which uses openVMS 7.2 O/S?
Regards,
Long
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.pos
I don't see the openVMS O/S in PostGresql list. Does it support Compaq Alpha
server, which uses openVMS O/S?
Thank you for your feedback.
Long
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mp
The Database stop inserting new
records
The Core dump line found in postgres
directory: "FATAL: s_lock(40244634)
at bufmgr.c:1257, stuck spinlock. Aborting."
My Linux: Linux monitor.moebius.com.br 2.2.16-22 #1
Tue Aug 22 16:49:06 EDT 2000 i686 unknow
All my programs and versions (rpm -
Hello PostgreSQL!
I've found several errors in the documentation. The first is
a shortcoming rather than an error, but it cost me hours of
needless effort. You said you welcome bug reports, so here's
what I have:
- - - - -
Programmer's Guide, 8.2.3. Connecting to the Database
According to
I've got the following problem with a plpgsql function. I believe it
denotes a bug with plpgsql.
I'm trying to write a function to either insert a new row, or update
an existing row. However, the test "if not found" is always true, and
I get duplicate rows instead of one updated row.
I've
Hi,
I'm making some code handling several kinds of files as large object. I found the
JDBC driver returned without finish reading the file. I made the test program
named lobtest.java, which is added at the end of this mail.
This test program read a file (default is "tomcat.gif" which is fetched
Hi bugs
I ran 'make check' on Linux S/390 with PostgreSQL 7.1.2
and got a fail on:
abstime ... FAILED
test geometry ... FAILED
Not that I use abstime and geometry but I guess I should report it.
Is there anything I can do? (I'm not an expert in C)
best regards/han
Operating system: SuSE 7.2 Professional with postgres v7.1 installed
manually.
(I prefer to manually set up software)
Directory: /postgres
Data Directory: /var/lib/pgsql/data
Options: ODBC emabled
Server startup line: postmaster -i -D /var/lib/pgsql/data > logfile.txt &
Port: 9427
System:
I am running the precomplied binary of Postgreql 7.1.2 on a Redhat 7.1 (on a Dual
Celeron System with 256MB, kernel 2.4.4 and 2.4.5) System.
(The installation of the new 7.1.3 doesn't seem to solve the problem)
I am connecting to the DB with a Perl Program (using Perl 5.6.0 with DBD-Pg-1.01 and
Pascal Bourguignon <[EMAIL PROTECTED]> writes:
> I'm trying to write a function to either insert a new row, or update
> an existing row. However, the test "if not found" is always true,
I believe you're getting burnt by the fact that lim.login is declared
as char(8) --- so it has trailing blan
The OpenBSD folks seem to know about this one also. The ld (1) manpage says:
BUGS
Shared objects are not properly checked for undefined symbols.
[...]
OpenBSD 2.9 October 14, 1993
snip
In the link you gave, it looked like provisions have been made in the development
version
I have compiled PostgreSQL 7.1.3 on RedHat 7.1.
There seems to be a problem with PL/Perl:
make[3]: Entering directory
`/data/download/postgres/postgresql-7.1.3/src/pl/plperl'
make -f Makefile all
make[4]: Entering directory
`/data/download/postgres/postgresql-7.1.3/src/pl/plperl'
*
* Cannot b
I am running the precomplied binary of Postgreql 7.1.2 on a Redhat 7.1 (on a Dual
Celeron System with 256MB, kernel 2.4.4 and 2.4.5) System.
(The installation of the new 7.1.3 doesn't seem to solve the problem)
I am connecting to the DB with a Perl Program (using Perl 5.6.0 with DBD-Pg-1.01 and
> I don't know if you have received my first message, so I send another one.
> Does PostGresql support Compaq Alpha server, which uses openVMS 7.2 O/S?
We support Alpha, but I don't think we support OpenVMS. I think the
shared memory stuff doesn't work on that OS or something like that.
--
B
(v7.0.3 linux)
we have unicode databases. it seems that some characters cause trouble for
the pg_dump program, (apparently subsequent tabs or newlines in the same
record as the character get ignored, causing problems for the next record).
using the -d option cures everything. the problems are v
> Tom Lane wrote:
> >
> > Mark Stosberg <[EMAIL PROTECTED]> writes:
> > > * Install earthdistance operator from the contrib directory.
> > > * try this:
> > > cascade=> select null <@> '1,1'::point;
> >
> > > ## The result I get:
> > > pqReadData() -- backend closed the channel unexpectedly.
> >
>
Is this running as one transaction, or is it not a transaction? Have you
tried committing every 10,000 or so if it is in one transaction? It could
be a logging problem with the transaction being too big.
Does the file system as a whole get slow, or just Postgres? Is it one
connection, or does
On Fri, 17 Aug 2001, Pascal Bourguignon wrote:
>
> I've got the following problem with a plpgsql function. I believe it
> denotes a bug with plpgsql.
The problem is that you're trying to compare a space padded char
with a non-space padded text so it's not finding the row. I believe
"Erik Luke" <[EMAIL PROTECTED]> writes:
> Upon trying to connect to the postgres backend by psql (with password
> authentication enabled), postgres crashes saying "FATAL 1: Bad abstime
> external representation ' '". I have also gotten '@!' and '/g!' in addition
> to the ' '.
It would seem that t
> Pascal Bourguignon <[EMAIL PROTECTED]> writes:
> > I'm trying to write a function to either insert a new row, or update
> > an existing row. However, the test "if not found" is always true,
>
> I believe you're getting burnt by the fact that lim.login is declared
> as char(8) --- so it ha
It is running on many transactions. At least after 5 inserts a transaction is commited.
The filesystems doesn't get slow (reading a (big) file works still at >20 MBytes/s).
14839 postgres 20 0 19948 19M 18980 R98.5 7.7 477:24 postmaster
14819 postgres 8 0 1856 1856 1700 S 0.0
Charles Obler writes:
> Programmer's Guide, 8.2.3. Connecting to the Database
>
> According to the documentation, the URL includes what is called
> "the database name". I assumed that the fully qualified path
Don't assume. ;-)
> name was intended here, since that is what normally appears in a
On Sunday 19 August 2001 05:40, Hans-Jürgen Schönig wrote:
> I have compiled PostgreSQL 7.1.3 on RedHat 7.1.
> There seems to be a problem with PL/Perl:
The problem is that RedHat's perl installation does not make a 'libperl.so'
with is required for a pl/perl build. As Karl DeBisschop on the HA
Laurent Martelli ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
multicolumn PRIMARY KEY introduces wrong 'not null' fields
Long Description
If you have a primary key on several columns, each of these columns is given the 'not
[EMAIL PROTECTED] writes:
> If you have a primary key on several columns, each of these columns is
> given the 'not null' modifier. I can't see why this is required.
(A) it makes no sense otherwise, and (B) the SQL spec says so:
A unique constraint is satisfied if and only if no two row
25 matches
Mail list logo
