James Patterson writes:
I am having a great deal of difficulting installing postgresql 7.03 on
Darwin 1.2.
7.0.3 [sic] doesn't work on Darwin. Try a 7.1 beta.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
/postgres/catalogs.htm
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
a program doesn't require
write permission I assume this is your PGDATA. But PGDATA isn't checked
until after --version/-V has been evaluated. The easiest thing would be
to check what postgres -V would show (in the broken setup).
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org
. The "right
pg_id" is not entirely as trivial as it sounds, because pg_id's from =6.5
have very different behaviour.
An alternative would be to find the right pg_id first based on its (to be
implemented) --version, and then double-checking for the right postgres.
--
Peter Eisentraut
word: psql: Password authentication failed for user 'adam'
Connection to database 'valhalla' failed.
fe_sendauth: no password supplied
Password authentication doesn't work with pg_dumpall. Use something else.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
/documentation/mysql/bychapter/manual_Reference.html#Column_types
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Wade D. Oberpriller writes:
pgconnection.h:46: warning: namespaces are mostly broken in this version of g++
That's probably a good hint to upgrade your compiler.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Harrelson, CulleyX writes:
Is there any difference between varchar and text other than varchar places a
cap on the number of characters?
Varchar is SQL compliant, Text is not. You can use Varchar without a
character limit, but that is not SQL compliant either.
--
Peter Eisentraut
Colin Taylor writes:
Are Synonyms supported on Postgresql?
There is nothing in PostgreSQL that's called a "synonym" per se, so you
have to describe what you mean by it.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
.
This file is new in 7.1.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
I consider it safe for use in a production site?
When it's released, which is probably going to be in a few weeks.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
, and ultimately to some speed issues.
Personally, I wouldn't worry about it too much, especially if you're
running beta and want to track down potential bugs.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Bruce Momjian writes:
I believe debug adds some addition checks in the code, and that is why
he is seeing slowness with debug. It was not the -g flag he used but
--enable-debug. I just looked at configure.in, and saw the
--enable-debug enables assert checking.
I don't think so.
--
Peter
rog_cc_g" = yes; then
CFLAGS="$CFLAGS -g"
fi
this has nothing to do with GCC. $ac_cv_prog_cc_g is set to yes if the
compiler understands -g.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
could
take the code from libpq (it's still in there I think) and do the parsing
before calling PQsetdbLogin().
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Thomas T. Thai writes:
after i ran vacuum analyze, i see that all my database directories with
respect to their database names have changed to all numbers:
is this normal?
Yes, and it surely was like that before the vacuum analyze as well. This
is new with 7.1.
--
Peter Eisentraut
such a column manually.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
:
The reason that there's no "detailed" documentation is that there are no
details. How much can you write about round(), avg(), or current_user?
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Colin Taylor writes:
Hi,
Anyone know where I can get a decent description of the system tables and
their contents?
Thanks in advance,
Colin
http://www.postgresql.org/devel-corner/docs/postgres/catalogs.htm
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Thomas T. Thai writes:
as a pgsql superuser, how can i list all the users and their rights?
SELECT * FROM pg_user;
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
email list is and then allows me
to click on the URLs above. Very nice.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
for an administrator to move libraries around as necessary?
If you move files to a place that is different from the one they are
supposed to be in you're going to have more severe problems than this one.
This is not only true for PostgreSQL.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org
?
No.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
be to find a Unix box.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Fernan Aguero writes:
I am having trouble with large files on a Linux box (RH 6.2). I know there
is a limit of 2 GB on the file size,
...but that doesn't affect table size, database size, or whatever you're
thinking of.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Joe Kislo writes:
First, I was evaluating Postgre for a medium scale application I will
I'm just wondering what this "Postgre" thing is you keep talking about...
;-)
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
John Pilley writes:
Trying to install the RPM for Mandrake, I get a dependency problem:
libreadline.so.4.1 was not found. Could someone let me know where to get
it?
From the readline package, which is on your CD or an ftp mirror near you:
http://www.linux-mandrake.com/en/ftp.php3
--
Peter
Soma Interesting writes:
Documentation on multi-byte and locales support seems to be lacking in the
postgreSQL site - anyone have any information on this?
http://www.postgresql.org/devel-corner/docs/postgres/charset.htm
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Joel Burton writes:
Both PostgreSQL and MySQL say there have been 730485 between 1/1/0
and 1/1/2000. Something we all can agree on? :-)
Which is pretty odd considering the fact that there was no year 0.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Joel Burton writes:
What's nice about PostgreSQL is that, while it hasn't always had
every SQL92 feature (like outer joins, etc.), it seems to have less
legacy, nonstandard stuff wired in. :-)
Oh man, you have n idea. PostgreSQL is legacy headquarters. ;-)
--
Peter Eisentraut
program (from the Jade package) and does something interesting with
them, according to a spec file. One such spec file is
docbook2man-spec.pl.
The whole package is named SGMLSpm and comes with a whole class library of
stuff to this effect. Available on CPAN.
--
Peter Eisentraut [EMAIL
Larry Rosenman writes:
Ok, I found that file, now when I try to make man.tar, I get the following:
$ make
"../../../src/Makefile.global", line 39: Missing dependency operator
"../../../src/Makefile.global", line 42: Need an operator
GNU make
--
Peter Eisentraut
Larry Rosenman writes:
next hurdle, where do I find docbook2man?
Start with reading this:
http://www.postgresql.org/devel-corner/docs/postgres/docguide.htm
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
GH writes:
Either way, any suggestions?
Personally, I don't trust pg_ctl farther than I can throw it. Consider
not using it.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
are under the OpenBSD OS.
Do I need X-client on my server ?
You probably mean X server (since pgaccess would be the "X client"), but
no, you don't need any X on your server host.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
lls in src/backend/parser/scan.l.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
it, but
that still doesn't mean that your data is going to survive this.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
th "Thus ...", perhaps there's a misunderstanding.
By the way, what do I need on the client side to use pgaccess ?
Tcl/Tk
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Steve Ackerman writes:
Has the row limit setting been moved in 7.0.3?
No
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
ould I set them to? Is there any way to
figure it out based on load, etc? Also, are there detrimental effects to
setting them too high?
This may help:
http://www.postgresql.org/devel-corner/docs/admin/kernel-resources.htm
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
this you better redesign your
database schema to make "slots" a separate table.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
do that?
ps ax or ps -e might work on your platform.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
created.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Rick Roberts writes:
What's the trick to getting it to compile?
I'm on Linux 6.2, using JDBC2.
cat src/interfaces/jdbc/README
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
writes out that the password
authentication on postgres failed.
pg_dumpall doesn't work very well at all with password authentication.
You might be better off temporarily using some other mechanism. (E.g.,
use the Unix socket with "trust", but change the permissions on the socket
itself.)
Martin A. Marques writes:
How far are we from seeing the version 7.1 out?
Beta is supposed to be November 1st. Personally, I'm putting my chips on
a February 1st release.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
That has been available for quite a while.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
-linux. To proceed anyway,
use --host=value with configure. But you probably won't get far without
a compiler anyway.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
, and
incidentally, Philip Warner has been doing just that.
But claiming that you can't upgrade is painting over what might rather be
a deficiency in the RPM mechanism, ISTM. Why can't you have a spec file
like this:
%preupgrade
pg_dumpall somewhere
%postupgrade
...
psql -f somewhere
--
Peter Eisentraut
using an explicit cast
CAST(3.5 as numeric)
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Marko Kreen writes:
But now I am only curious: Will PostgreSQL support binary
arithmetics on ordinary integers someday or is the 'bit-string'
only way to go?
AFAIK, there's no one working on the former. Feel free to contribute. :-)
--
Peter Eisentraut [EMAIL PROTECTED] http
the following errors :
ERROR: parser: parse error at or near ","
PostgreSQL doesn't support this syntax (yet). You need to split it into
two INSERT commands.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
hard. You could use shortint fields, or char(1)'s if you are not that
concerned about space.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Wilkinson Charlie E writes:
While we're on the topic, can someone tell me where '\d *' went, and what to
use instead?
That particular command seems to have disappeared in PG7.
Hmm, that must have been me. What did it do? Describe all tables at once?
--
Peter Eisentraut
able, which is certainly
dumb, but legal. But then we still don't comply because we don't execute
the rollback automatically but instead hang in some sort of "invalid"
state.
There is certainly big demand for getting rid of this restriction though,
but the code changes could e
independantly, and see where the error occurs.
P.S. I assume you are using the pg_dump that came with 7.0.2 or earlier.
If it's 7.0.2 you can run psql with -f (instead of ) and with `-V
ON_ERROR_STOP=on' to get error messages with line numbers and immediate
exit if an error occurs.
--
Peter
Denis Perchine writes:
Just a small question: why there is not any quoting routine in libpq.
Can you give an example of what it should do?
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
nforce that restriction;
I'll see about fixing that oversight for 7.1.
Create User does, but initdb doesn't.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
invariably tell that they are using MySQL because it's
easier to install, and that PostgreSQL is difficult ("a pain") to install.
I've studied the MySQL installation instructions, and they don't strike me
as inherently simpler. Is it only perception, or what can we do better?
and what we can't.
Most people in the "business community" have no such interest,
But some do and there's no point in stopping them.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
On Mon, 26 Jun 2000, Andrea Aime wrote:
does postgres support nested transactions?
No.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
e State of XXX" attached to it.
Until they realize that the laws of Virginia don't apply to them. Or to
Canada, where hub.org is located these days.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
ich turned out to be ISO/IEC 9075:1999,
which is what I quoted.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
it's there.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
f Postgres on
their client boxes?
Using RPMs is also popular, if applicable.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
Kari Lempiainen writes:
Are there any monitor programs for administrator to find out what
operations are in progress
`ps' should work on many systems.
and possibly killing deadlocking queries?
Truly "deadlocked" queries kill themselves, btw.
--
Peter
,
defining an index and querying it a bunch of times. At that point I
believe the file system will be at least as much of a problem.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
Louis-David Mitterrand writes:
When creating a child (through CREATE TABLE ... INHERIT (parent)) it
seems the child gets all of the parent's contraints _except_ its PRIMARY
KEY. Is this normal?
It's kind of a bug.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED
ny
other non-privelegded user.
In a fresh installation the database users don't have passwords yet, so
you must give them some first. (ALTER USER xxx WITH PASSWORD 'yyy').
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
re-run initdb, then `gdb /path/to/postgres /path/to/core'. Thanks.
initdb failed.
Removing /home/SQL/sdp.
Removing temp file /tmp/initdb.973.
*********
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
. Not ideal, I know,
but we're working on it.
the last command failed with this error:
"The database path 'PGDATA2' in invalid. This may be due to a character
that is not allowed or because the chosen path isn't permitted for
databases"
--
Peter Eisentraut Sernanders
reported the query parsing error.
You need to write CREATE USER name WITH PASSWORD 'password here'. Note the
single quotes, that has changed. pgaccess hasn't caught up with that yet
but it will be okay in the 7.0.1 release.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL
;`" = x
Are we talking 7.0.1 material, btw?
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
this flag you can't set it again because you
no longer have write access to pg_shadow.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
L3 says it.
That is unfortunately false for the patch in general.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
Louis-David Mitterrand writes:
Is this a known problem?
Yes. Use the final release.
template1= \copy
psql: xstrdup: cannot duplicate null pointer (internal error)
styx:~%
using PG 7.0-beta5 on Linux
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL
ell. (And believe me, there are plenty
of "insane" versions out there that we already had to put up with.)
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
Jeffery Collins writes:
It seems like it would be a whole lot "nicer" if initdb only deleted
the files that it attempted to create OR if the default was not to
delete anything.
Okay, I could go for the former. What do others think?
--
Peter Eisentraut Sernanders
Gen_fmgrtab.sh.in, do I have to
re-configure?)
But we haven't yet figured out Travis' problem: why is the configure
test failing? Useless or not, I don't see why it's falling over...
Unfortunately he cut off the line where it says `checking for tr'.
--
Peter Eisentraut Sernanders
Anand Raman writes:
Is there anything equivalent to the enumerated data types in
postgresql..
You might find that strings with check constraints will do the job, e.g.
create table my_tbl (
...
color text check color in ('blue', 'green', 'white'),
...
);
--
Peter Eisentraut
a couple of places
where small changes to the documentation would have helped. I'd like to
feed this stuff back to the folks doin' the docs as part of my contribution
to the cause, but I don't know who to give it to. Any leads?
-=michael=-
--
Peter Eisentraut
implemented one yet. So
essentially this isn't going to work.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
that Postgres correctly recognizes concurrent updates and aborts one
of the transactions, how difficult would it be to do the same for inserts?
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
e yourself or throwing large amounts of cash at the existing
ones. :) Trying the above and tracing down any arising problems might be a
start though.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
ainly does.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
structures), then "doom" is a feature. :)
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
it. Anything else is destined for
failure some place.
Not tested, but it seems that testing like
psql -c "UPDATE foo SET a = 1 WHERE 5=6"
is sufficient and harmless. (I think psql might also return a non-zero
exit status if this fails.)
--
Peter Eisentraut Sernanders väg 10:
Unix user and the postgres database user are
not really related other than by name. The names must currently be equal
for initdb purposes but in the long run this should be removed as well.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
On Mon, 3 Apr 2000, Jeff MacDonald wrote:
SQL-92 - is this an ansi standard ?
Yes. Also ISO and IEC.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
PGDATA2 ucc2
ERROR: Unable to locate path '/data/ucc2'
This may be due to a missing environment variable in the server
createdb: database creation failed on ucc2.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http
be the way to go but I'd have to go and read the code to
check.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
Chris Gokey writes:
Funny though, I can't figure out what the purpose of CREATE USER from
the psql prompt is used for anymore? It seems all user creation is done
from the unix prompt.
Actually createuser is a script that essentially calls psql -c "CREATE
USER ...".
--
Peter
to provide access?
How about create user xxx with password yyy?
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
also various POSIX nonsense). That begs the question
whether this was done intentionally by vendors so as to hide deficiencies
in their products.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
information.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
eatures once present in Postgres but now fallen to neglect and poorly
understood. You probably don't want to do this but use a foreign key
instead.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
) then you're half way there to implementing your own aggregate
function. See the Programmer's Guide on how that might be done.
Incidentally I couldn't think of a way to do just that. In that case it
will be *hard*.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED
really doesn't know much about all of this. While you might
have a point that
select field1, aggregate(field2) from table
doesn't have any other useful interpretation than an implied group by
field1, it's probably too much work to support such a non-SQL construct.
801 - 900 of 934 matches
Mail list logo