stion...
--
Peter Eisentraut
PathWay Computing
to it anyway.
PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3
--
Peter Eisentraut
PathWay Computing, Inc.
distro?
Dirk
--
Peter Eisentraut - [EMAIL PROTECTED]
http://yi.org/peter-e
been able to figure out is how to do a select where one of
the ageids = a particular number.
I'd like to do something like
select * from tablename where ( any ageids = 3 )
just don't know the syntax.. if this is even possible. Any suggestions
would be appreciated.
--
Peter
the first place.
I find the bundled scripts and their associated documentation make things
very nonintuitive when one switches from a blind trust postgres to an
authenticated postgres.
So that would put your vote in the "drop altogether" column? Voting is
still in progress!
cept needs overhaul anyway, but I don't see it
happening anytime soon.
-Peter
--
Peter Eisentraut Sernanders vaeg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
from
the same machine.
I know I can set up the different db's so that table security only gives
any access to the user I want, but that is fiddly. Being able to do the
above and prevent connections to the database will resolve that issue.
Any ideas?
Regards,
Mark.
--
Peter
pg_shadow and redirects it to a file. Don't even have the table anymore.
Sort of like /dev/* devices are handled by the kernel.
I was going about looking into this a little, but since I have never
played with the backend I cannot promise a result in finite time.
-Peter
--
Peter
could fail
to optimize properly. But that could even be a problem in the regex
library, which is not any of the PostgreSQL developers' domain and which
is used in other products as well.
-Peter
--
Peter Eisentraut Sernanders vaeg 10:115
[EMAIL PROTECTED] 752
I am confused about the NT version of PGS. Does it exists natively or
does it requires support DLLs and libraries to work.
Requires Cygnus porting library.
--
Peter Eisentraut Sernanders vaeg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
if there is a chance of cleaning that up in finite time,
after all many C libraries are not very thread-safe either.
Perhaps this CORBA stuff that has been thrown around lately can help
there, but that's merely in the proposal stage right now.
--
Peter Eisentraut Sernanders vaeg 10
that could be taken care of anyway.
-Peter
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
on this distribution?.
Are there RPMs for SuSE 6.1?
Any help is appreciated.
Thanks,
Vegeta
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
for performance, and the locale/mb version for features. Please
note that SQL_ASCII doesn't mean that the db cannot support any other
encoding, it's just the default encoding initdb uses.
The questioner could then use this RPM and initialize with initdb -e
LATIN2, if he chooses.
--
Peter Eisentraut
)
might help. If that doesn't work, look if your libcrypt.a or libshadow.a
library really exists and is findable or let us know what kind of C
library you have (ls /lib/libc.*). If that helps then we'd need to fix up
configure a little.
--
Peter Eisentraut Sernanders väg 10:115
attempt to do before 7.0 is write our own
license or at least our own copyright in addition to the BSD license,
since none of us (?) actually work at UCB.
--
Peter Eisentraut Sernanders vaeg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e
,
the message is now just after the offending query.
Alain
__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED
es anybody know how to make it faster?
Cheers,
Rob
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
On 2000-01-14, The Hermit Hacker mentioned:
Side point ... why isn't the apache conf file secure? Only user root
needs to be able to read it, no?
Huh? You run apache as root?
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http
allow this either. You'd have to do some scripting
magic.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
, they can get the name of the file
from the web, and copy it.
how about sourcing a conf file that's in a 700 dir?
Security through obscurity is little security indeed.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter
using oids for unique values. The serial
type is guaranteed to be supported for this but oids just happen to work.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
use ~* operator, because i don't
create queries, MS Access generates queries and it creates queries
with 'like' operator.
The way I read the SQL standard, LIKE matches are always case-sensitive,
so Access would be in violation.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL
) ?
Yes. You can try that pretty easily. Start up two psqls, in the first one
enter:
BEGIN TRANSACTION;
LOCK pg_class IN ACCESS EXCLUSIVE MODE;
In the second one enter:
SELECT * FROM pg_class;
The latter will hang.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED
as returned results in your function.
regards.
Omid Omoomi
From: Peter Eisentraut [EMAIL PROTECTED]
To: Dale Anderson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [GENERAL] PSQL Function() help
Date: Wed, 12 Jan 2000 04:58:53 +0100
On 2000-01-12, Dale Anderson mentioned
int4 numbers, but I would be happy
to have a larger range without using the twice as large int8 type.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
On 2000-01-24, Jose Soares mentioned:
We need also aggregates for data type TIME
MAX(time)
MIN(time)
Thomas, do you think this could be done?
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e
[EMAIL PROTECTED]
On 2000-01-24, Yury Don mentioned:
Hello All,
Does anybody knows where to send bugreport for postgresql? I can't
find this information on postgres site.
Best regards,
Yury ICQ 11831432
mailto:[EMAIL PROTECTED]
--
Peter Eisentraut
,
Joost Roeleveld
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
d when I added rules. Do rules make a table a view?
The behaviour you observed is a bug. (But views still do exists, see
above.)
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
r bringing up psql.
Not to mention the fact that every time you start it up psql does a whole
bunch of initializing, and every line of input you pass it is first parsed
before deciding what to do with it.
--
Peter Eisentraut Sernanders vaeg 10:115
[EMAIL PROTECTED]
ULTY
-----
2355 student Jim | 23455 | Science
5655 student Chris| 45666 | Arts
--
Peter Eisentraut Sernanders vaeg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
On 2000-02-23, Diego Schvartzman mentioned:
Is it possible to return a row or a set of rows from a user defined funcion?
Can I use user defined functions as "stored procedures"?
No. Several workarounds, such as using arrays or views are known, but none
really suffice.
--
Peter
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.
Mark Jewiss writes:
What I want to be able to do is store details of every transaction that is
made against a database to a log file.
This is planned for 7.1. Right now there's no easy way.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262
information.
--
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
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
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
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
structures), then "doom" is a feature. :)
--
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
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
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
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
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
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
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
;`" = 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
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
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
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
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
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
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
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
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?
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
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
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
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/
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/
using an explicit cast
CAST(3.5 as numeric)
--
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
.
--
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/
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/
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.)
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/
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/
this you better redesign your
database schema to make "slots" a separate table.
--
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/
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/
it, but
that still doesn't mean that your data is going to survive this.
--
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/
Steve Ackerman writes:
Has the row limit setting been moved in 7.0.3?
No
--
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/
1 - 100 of 934 matches
Mail list logo
