Hi,
I'm having a problem while dump database (I'm trying
to upgrade from 6.5 to 7.03) . The error message is:
dumpSequence(val_tmp_uid_seq): 0 (!=1) tuples returned by SELECT
Tell me please, what wrong in my database?
Thanks!
Igor.
I'm having trouble getting Postgres 6.5.3 to do what I want. The problem seems
to be fixed in version 7, but I could really do with a workaround for 6.5.3,
since I'm stuck with that for the time being.
journals2=> create table vc(v varchar(9), c char(9));
CREATE
journals2=> insert into vc values(
hello,
i use PostgreSQL on OpenBSD (various systems, including 2.5-2.8 beta)
and like it much. one thing, i have to make hand changes to source
(namely to src/bin/psql/input.h) to make _existing in system_ readline's
history working... the point is that for OpenBSD autconf finds and
defines HAVE_
I have been trying to use the translate function to delete a specific string
from entries in a particular column, as in "translate(, 'string',
'')".
What I find is that "translate" is treating the nominated string as a
character class, and is deleting every instance of every character in that
clas
Peter Haworth <[EMAIL PROTECTED]> writes:
> I'm having trouble getting Postgres 6.5.3 to do what I want. The
> problem seems to be fixed in version 7, but I could really do with a
> workaround for 6.5.3, since I'm stuck with that for the time being.
> journals2=> select * from vc where v::char(9)
Rich Shepard wrote:
> So, can someone please explain to me why the 7.0.3-1 package complains
> that /lib/cpp isn't there when it is? FWIW, I got the same error when I
> tried using the --force switch with rpm. Something's screwy here.
Use --nodeps to override dependencies. It is complaining be
On Wed, 15 Nov 2000 11:19:40 -0500, Tom Lane said:
> Peter Haworth <[EMAIL PROTECTED]> writes:
> > I'm having trouble getting Postgres 6.5.3 to do what I want. The
> > problem seems to be fixed in version 7, but I could really do with a
> > workaround for 6.5.3, since I'm stuck with that for th
On Wed, 15 Nov 2000, Lamar Owen wrote:
> Use --nodeps to override dependencies. It is complaining because RPM
> apparently has no record of /lib/cpp -- rpm --rebuilddb may be needed.
> RPM's dependencies are not checked against the filesystem, but against
> the RPM database. You can verify this
PHP 4 was having problems with persistent connections (not sure if with just
pgsql or all dbs). Maybe that is why they didn't use it.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: <[EMAIL PROTECTED]>
To: "carl garland" <[EMAIL PROTECTED]>
Cc: <[
(My first attempt at posting didn't make it to my mailbox, so I am
reposting. Apologies to any who get this twice.)
I have been trying to use the translate function to delete a specific string
from entries in a particular column, as in "translate(, 'string',
'')".
What I find is that "translate"
Thanks Tom!
I also realized (after I sent this of course :) that I could check the md5
signatures of my tar.gz with the one on the ftp site...
-philip
On Tue, 14 Nov 2000, Tom Lane wrote:
> Philip Hallstrom <[EMAIL PROTECTED]> writes:
> > I downloaded 7.0.3 from ftp.postgresql.org yesterday (
Just a note, I've been using Postgres 7.02 and PHP 4.02 or 4.03 for about a
month in a couple sites, and haven't experienced any problems with
persistent connections. Problem might have been fixed in one of the point
releases, or maybe I just don't have enough different db connections to
trig
Has anyone else got aix 4.3.3 and postgresql 7.0.3 working with respect
to dynamically loaded functions? I'm having all sorts of wierd problems.
For starters, I ended up ripping out the old and outdated dlXXX()
implimentation in backend/port/dynloader/aix.c and have it calling the OS
supplied dl
When I dump a database (creating a script from the pg_dump command), I
can't just put it in any old directory and point psql at it. I have to
put it in the /var/lib/pgsql subdirs before postgresql will accept it.
Is this right? Am I doing something wrong? Is this a bug^H^H^Hfeature?
Paul M. Foste
Due to a dependency problem, which only reared its ugly head if no C
preprocessor was installed, I have rebuilt and re-released RPM's for
PostgreSQL.
If you have not experienced problems with the 7.0.3-1 RPMset, you do not
need to download this set.
Available at:
ftp://ftp.postgresql.org/pub/bin
On Thu, Nov 16, 2000 at 12:22:34AM -0500, some SMTP stream spewed forth:
> When I dump a database (creating a script from the pg_dump command), I
> can't just put it in any old directory and point psql at it. I have to
> put it in the /var/lib/pgsql subdirs before postgresql will accept it.
> Is
Paul M Foster wrote:
>
> When I dump a database (creating a script from the pg_dump command), I
> can't just put it in any old directory and point psql at it. I have to
> put it in the /var/lib/pgsql subdirs before postgresql will accept it.
> Is this right? Am I doing something wrong? Is this a
On Wed, Nov 15, 2000 at 05:44:25PM +0100, Peter Eisentraut wrote:
> Denis A. Doroshenko writes:
> > i use PostgreSQL on OpenBSD (various systems, including 2.5-2.8 beta)
> > and like it much. one thing, i have to make hand changes to source
> > (namely to src/bin/psql/input.h) to make _existing in
18 matches
Mail list logo
