hi
i recently upgraded to postgresql-7.1.2 but when i start the service, i get the
folllowing error message!
An old version of the database format was found.\nYou need to upgrade the data format
before using PostgreSQL.\nSee /
usr/share/doc/postgresql-7.1.2/README.rpm-dist for more information
Sir:
I was testing my php web content manager yesterday when an error
suddenly popped out as I was trying to save my article to the database. The
error was "PostgreSQL query failed: Error: Tuple is too big: size 8812". My
table schema for the news article:
neid serial
ne
Hi,
Postgres 7.1.2 is runing fine at my site (Solaris 2.6 ans Solaris 2.6).
I used gcc-2.95.3 and make-3.79.1 (both downloaded from
www.sunfreeware.com).
I had just one problem:
during compilation you need the ar - command in your PATH.
Look at the manpages of ar for the proper Path.
CU
Andre
-
Hi Andre,
We have also compiled postgres with gcc.
Our development environment uses Solaris Workshop, and we tried some test
programs, compiled with Sun's Forte compiler, and using the gcc compiled
postgres libraries. This did not work.
We got linker errors like the following
Undefined
Greetings.
In order to build the odbc library, I had to change the GNUMakefile
entry of:
SHLIB_LINK = $(filter -lm, $(LIBS))
To
SHLIB_LINK = $(filter -lm, $(LIBS)) -lz -lresolv -lgen -lnsl -lsocket
-ldl -lm -lxnet -shared
Using , GNU Make version 3.78.1, gcc version 2.95.2 19991024 (release),
these errors *should* be fixed ... we had problems with the database
server this morning, but we think we've exorcised the demons ...
On Fri, 13 Jul 2001 [EMAIL PROTECTED] wrote:
> Jill Gemmill ([EMAIL PROTECTED]) reports a bug with a severity of 2
> The lower the number the more severe it is.
Hi Folks
I've got the built-in OpenSSH (2.2.0) running on FreeBSD 4.2, and I
connect to it from Windows with SSH Security Corp.'s SSH Secure Shell
2.4. As a terminal, it works fine.
I want to use this product to encrypt data between a PostgreSQL
backend and Windows clients. The Windows clients
Hello there!
[Please Cc: me in followups.]
I tried the following:
CREATE TABLE a (
int4 id
);
CREATE TABLE b (
int4 id
CHECK (id = ANY(SELECT a.id FROM a))
);
Tables are created ok, checking with '\d table' confirms it. But when I
try to insert into table b, e.g.:
INSERT INTO b (id)
VA
On Wednesday 11 July 2001 13:57, Kannan The Barbarian wrote:
> i recently upgraded to postgresql-7.1.2 but when i start the service, i get
> the folllowing error message!
> An old version of the database format was found.\nYou need to upgrade the
> data format before using PostgreSQL.\nSee /
> us
Joel G Guevara writes:
> I am using PostgreSQL version 6.5 (included in Red Hat Linux 6.2).
bug report: version is too old
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 3: if posting/re
On Fri, 13 Jul 2001, Alexey V. Neyman wrote:
> Hello there!
>
> [Please Cc: me in followups.]
>
> I tried the following:
>
> CREATE TABLE a (
> int4 id
> );
> CREATE TABLE b (
> int4 id
> CHECK (id = ANY(SELECT a.id FROM a))
> );
>
> Tables are created ok, checking with '\d table' confi
"Alexey V. Neyman" <[EMAIL PROTECTED]> writes:
> CREATE TABLE b (
> int4 id
> CHECK (id = ANY(SELECT a.id FROM a))
> );
> ERROR: ExecEvalExpr: unknown expression type 108
More recent versions say
ERROR: Cannot use subselect in CHECK clause
It seems to me that what you really want here is
> So that raises this from an unimplemented feature to a real bug, or at
> least higher priority in my eyes. You can't do a CREATE/ALTER USER
> followed by an UPDATE on pg_shadow in a single transaction:
I'm glad I could be of some help.
I don't know if the following means anything to you (or t
Hi Tom, thanks for your feedback on this.
On 11 Jul 2001 11:21:35 -0400, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not
found
>
> Hmm, are you trying to create triggers on pg_shadow? It's hard to see
> how that message could co
On 11 Jul 2001 12:07:09 -0400, Tom Lane wrote:
> Kristis Makris <[EMAIL PROTECTED]> writes:
> > On 11 Jul 2001 11:21:35 -0400, Tom Lane wrote:
> >> Hmm, are you trying to create triggers on pg_shadow? It's hard to see
> >> how that message could come from an "UPDATE pg_shadow" otherwise.
>
> > I
Jill Gemmill ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
your web site register is broken, cannot download Win32 distribution needed
Long Description
(1) I went to http://www.ca.postgresql.org/ftpsite/odbc/download.html to
16 matches
Mail list logo
