Am Montag, 20. Februar 2006 08:55 schrieb Jan Cruz:
When restoring a dump from sql_ascii encoding to latin9/utf8
This statement is both poorly specified and nonsensical. Please give us a
more precise account of what you are doing.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Jan Cruz wrote:
I believe PostgreSQL treat UTF-8 and LATIN9 Differently.
Certainly, considering that they are different encodings.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9
then you need to figure out what encoding those non-ASCII
characters actually are and set the client encoding to that. Trying
LATIN1 might be a good start, but if you users/applications have
inserted random bytes then you will have to sort it out by hand.
--
Peter Eisentraut
http
don't use xterm so I'll skip the rest.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
locale is certainly faster, but for anything else, there
won't be any noticeable difference I would think.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
), but there isn't.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can
a database between any two
encodings.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Nik wrote:
I noticed that CPU utilization on the server is 100% for past few
100% CPU usage is not a problem. When the number of waiting processes
goes up, then you have a reason to start being concerned.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Am Dienstag, 14. Februar 2006 16:13 schrieb Sebastjan Trepca:
As I understood from books and docs every statement in Postgres takes
O(1) because of it's versioning system, right?
Absolutely not.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
://dev.mysql.com/doc/refman/5.1/en/bdb-storage-engine.html
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Riaan van der Westhuizen wrote:
Where can I get Latest PostgreSQL 8.1.2 64 Bit version for Debian
(Ubuntu Server) with apt-get?
Once you have decided whether you actually mean Debian or Ubuntu, you
should find 8.1 packages in the respective regular apt repository.
--
Peter Eisentraut
http
a view is
probably updatable (the presence of the respective rules would be a
strong hint). And second, if it's not, you get a fine error message
and can move on. So there is really no good reason for client tools to
prevent you from using data entry forms on views.
--
Peter Eisentraut
http
Joachim Wieland wrote:
- other unix daemons reset their values to defaults before
reading conffiles
Examples please?
inetd, Apache, squid, exim, postfix, a famous database starting with
m...
cron, syslog, ntp, ssh
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Stéphane SCHILDKNECHT wrote:
select to_char(1485.12, '9G999D99');
But, surprinsingly, I got 1,1485,12.
The fr_FR locale is broken. You should report this to glibc.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Michelle Konzack wrote:
Is this like the Adabase Add-on of StarOffice 5.2 ?
I don't know what that is.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
for any given version of PostgreSQL as things stand.
I was going to say that you type in 8.1.2 release notes in the search
box, but that actually gives you the 7.1.2 release notes as first hit.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
Michelle Konzack wrote:
Design a Database with OO2? code Functions?
I'm not sure about what kind of function coding support you have in
mind, but certainly you can design a database with it.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
in order to make a dump. If there are
no packages available you will have to compile it by hand.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
Michelle Konzack wrote:
Does anyone know a Frontend for PostgreSQL which I can use to design
and admin a very huge Database
OpenOffice 2?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill
Magnus Hagander wrote:
archives.postgresql.org properly hides the addresses.
If you think that spammers are unable to do s/ (at) /@/ you're living in
a dream world.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Carlos Moreno wrote:
today I notice a phishing e-mail (Your PayPal account), meaning
that it took less than two weeks for my e-mail address to go from
PG's mailing list to a spammers' database of addresses...
Normally you get turnaround times of less than two hours on this, so you
got a good
Am Donnerstag, 5. Januar 2006 17:01 schrieb Scott Marlowe:
The C stands for consistency. Consistency means that only valid data
can be written to the database. MySQL fails this test precisely because
it does / can write inconsistent data to the database. Note that even
the latest version,
Am Donnerstag, 5. Januar 2006 21:15 schrieb Joseph M. Day:
Has anyone been able to get the latest version of Postgres working on
Suse 10.0 ? I just switched form Fedora and realized that this version
is not specifically supported.
Get it here: ftp://ftp.suse.com/pub/people/max/postgresql
Am Donnerstag, 5. Januar 2006 21:58 schrieb Scott Marlowe:
But it's not consistent. Imagine we do the one where we take one from
peter and give it to paul. If paul's account is stored in an int, and
is at 2147483647, and we add one, it does not increment, and it does not
cause an error that
One way to conceptually tackle this count(*) issue would be to create a new
index type for it. The index type would (logically) just need to implement
insert and delete operations and keep a running count with a big lock around
it. Users could then choose to trade off concurrent performance
Am Freitag, 23. Dezember 2005 22:06 schrieb robert mena:
GRANT CREATE,REFERENCES ON DATABASE test TO testadm;
\z
Access privileges for database test
Schema | Name | Type | Access privileges
+--+--+---
How can I specify that the user testadm can perform
Jim C. Nasby wrote:
Some (most?) database's idea of 'creating a type' is actually what we
consider creating a domain,
Which databases do such a thing?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5
Am Mittwoch, 21. Dezember 2005 12:01 schrieb Alexander Scholz:
So - what kind of indexing would speed this up then?
You can't speed up a full-table count using an index.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Am Mittwoch, 21. Dezember 2005 21:27 schrieb Klein Balázs:
Or should I instead create a view that contains only the biodata and select
from that? But will postgres use the indexes than? Would that be a better
approach?
Whether the query is executed by a view or typed in in its full form by
and Fedora and maintain them.
2. When you put them on the FTP server, put them in a subdirectory
redhat (instead of or below linux) to avoid that users fall into
the trap redhat == linux == rpm.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
redhat
OK, but that is still weird. Either it's linux/fedora/rpms or
rpms/linux/fedora. The other way doesn't make sense.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our
of a practical example.) I
think debian, redhat, etc. are the operating system names that parallel
win32. linux should just disappear. And so should rpms or
debs unless it's part of the tree's internal organisation.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
. Therefore, I'm doubtful
that using a binary comparison as tie-breaker is proper behavior.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
to SQL_ASCII, as you suggested in
a later mail, is likely to break much more.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
representations even within the same encoding.
That is what we are discussing.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org
stig erikson wrote:
i would like to ask if there are some plans or if there has been any
discussions about allowing any one query to run on more then one
processor?
It is certainly on most people's wishlists but there is no concrete plan
for it yet.
--
Peter Eisentraut
http
program was:
| /* confdefs.h. */
|
| #define PACKAGE_NAME PostgreSQL
| #define PACKAGE_TARNAME postgresql
This is not the interesting part of config.log. You need to look near
the bottom where it actually says checking test program.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
, but I'm not sure how that works
on Windows.
Rumour has it that some people to accent-insensitive comparisons using
the to_ascii function. Since the notion of accent-sensitivity differs
between languages, it'd probably be best if you wrote your own
conversion function.
--
Peter Eisentraut
http
Ken Winter wrote:
FWIW: At
http://www.postgresql.org/docs/7.4/static/infoschema-triggers.html,
it says there is a column in the information_schema triggers table
named event_object_name. The name actually is
event_object_table.
Fixing...
--
Peter Eisentraut
http
coherency problems that NFS is known for.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Walter Dnes wrote:
2) Although I have an AMD64 cpu. I chickened out and went for a
32-bit install. If/when I do migrate to 64-bit, can I keep my
databases, or will I have to export/import them?
The latter.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
David Pratt wrote:
Hi. Where would I locate information on setting up postgres as a
stand alone db for a gui application.
This is not possible.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9
Leif Jensen wrote:
Anyone using the CMS called Mambo with PostgreSQL ?
Yes.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
Rikard Pavelic wrote:
I find this behaviour of PostgreSQL strange. Seems to me that running
function under owners rights is the way to go.
Then you should define your functions accordingly with the SECURITY
DEFINER clause.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Scott Marlowe wrote:
No, I wouldn't think one to one would be necessary. If you had a
primary key that was case insensitive, for example, it would not map
one to one. It would, in fact, be MORE greedy about matching, so
that you could not have both a Peter Eisentraut and a peter
eisentraut
change the primary key to use a different index.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
the integrity of the primary key
constraint. I cannot think of any useful functions that fulfill this
criterion.
It would certainly be useful for character
type pks in non-C locales.
I don't see how.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
in those lines into psql and found out yourself.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
( bar CHAR(10) PRIMARY KEY );
even on non-C locale ?
It will not use the index no matter what locale. You would in these
cases need to create additional expression indexes on bar::char(1) etc.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
the
percent?
You are dividing an integer by an integer, and if the first integer is 1
then the result is often 0. You need to use numeric for your noreps
variable.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP
the instructions set
out on that page, or contact me directly if you have further questions.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
works (I think). (And
we know that *never* leads to problems... :-/)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index
- case might indeed solve most of the real-world
problem for the Oracle camp as well.
That seems to be the right compromise.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet
for
people moving to PostgreSQL.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Am Donnerstag, 29. September 2005 21:46 schrieb jeff sacksteder:
As an example, I'd like to prevent a a user from being able to get a list
of existing databases.
You can't do that.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
is your friend.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
This could well be because there are still connected clients. Read about the
mode option (-m) on the pg_ctl man page.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet
in the SQL standard.
(The query processor would recognize that the non-primary key columns
functionally depend on the primary key and therefore do not have to be
grouped separately.) This is definitely a valid feature but PostgreSQL does
not implement it yet.
--
Peter Eisentraut
http
up in German.
The server configuration only affects the server. The other programs take the
language from the environment.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
, and the server
wants to recode it to a different encoding because, say, the client runs in
UTF-8, then you will get wrong output. So it's in your interest to fix this.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
a question, but my goal is to show a count of classes
taught by each in instructor. Perhaps there's a better query?
You could probably rewrite it as a join, but as you could see, the planner
rewrote it as a join internally anyway.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
in MySQL, inserting the
value of now() into a table might give different results if a slave
runs in a different time zone. So it's sort of the same from the
outside, but the internals are different and yield different
possibilities and restrictions.
--
Peter Eisentraut
http
or even internal subnets in production systems, so
having a system that hardcoded the list of official TLDs would be
significantly less useful to me.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't
Am Montag, 12. September 2005 13:52 schrieb [EMAIL PROTECTED]:
I currently have a postgresql 8 system which I want to replicate
Look at DRBD.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting
syslog daemon to
redirect (or delete) messages according to that user name.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
makes you think that?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Brad Nicholson wrote:
Does anybody have regular expression handy to verfiy email addresses?
There are Perl modules on CPAN to verify just about anything.
Email::Valid comes to mind here. These can of course be plugged into a
PL/Perl function.
--
Peter Eisentraut
http
for stored
procedures, then don't write them in C in the first place. You may find that
PL/pgSQL gives you a very similar interface to ECPG.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting
are using libpq for writing stored procedures, you're doing something
wrong. libpq is for client-side access.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
object that is loaded into the
backend server which provides the required functions.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
for
exchanging PostgreSQL knowledge, at least in Europe, so consider
attending if you're interested.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
Bernard wrote:
So when we hit the reply button of our email client then we get the
individual sender where in fact we would prefer to get the list
address [EMAIL PROTECTED]
No, we would not prefer that. If you write to me, then my reply goes to
you, no matter by what means your message was
of the encoding that the locale system uses
might differ from the locale name that PostgreSQL uses, so you will
have to be able to see through that.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze
-01' AND righty.day='2005-06-01'
GROUP BY grp;
You need to write ... WHERE (lefty.day = '2005-06-01' OR lefty.day IS NULL)
AND etc.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0
Stephen Frost wrote:
* Richard Hayward ([EMAIL PROTECTED]) wrote:
Is there any way of getting the user?
You might try session_user. 8.1 will hopefully clean this up some.
Why would it? This is SQL standard behavior that should not be changed.
--
Peter Eisentraut
http
Am Sonntag, 12. Juni 2005 05:24 schrieb Tatsuo Ishii:
Thank you for interested in PostgreSQL CE. There is a sample
examination problems page:
http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
Regarding question 3,
Select one incorrect statement regarding the installation of
Am Freitag, 24. Juni 2005 17:06 schrieb Tatsuo Ishii:
Really? I vaguley recall that someone who came from US complained
about the sort order of en locale. I thought English speakers prefer C
locale.
I have never seen an English dictionary or other list that sorts A, ... Z,
a, ... z and
[EMAIL PROTECTED] wrote:
Thanks Oliver for the work you did (I'm assuming) on getting the
Sarge postgreSQL package ready over the various incarnations of
Testing.
Martin Pitt maintains the Debian packages of PostgreSQL these days.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Am Freitag, 3. Juni 2005 00:36 schrieb Peter Eisentraut:
On a particular system, loading 1 million rows (100 bytes, nothing
fancy) into PostgreSQL one transaction at a time takes about 90
minutes. Doing the same in MySQL/InnoDB takes about 3 minutes. InnoDB
is supposed to have a similar
Am Donnerstag, 2. Juni 2005 11:36 schrieb Nageshwar Rao:
Can we write/read a file in postgresql procedure ?
That depends on the language you use. PL/PerlU and PL/sh can do it, for
example, whereas plain PL/Perl or PL/pgSQL cannot.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
autocommit is not relevant.
As you might imagine, it's hard to argue when the customer sees these
kinds of numbers. So I'd take any FUD I can send back at them. :)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP
it.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 8: explain analyze is your friend
that. We
have absolutely nothing to do with that.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
: undefined symbol: get_progname
It seems you are mixing programs and libraries from different
installations. Try with ldd or some analogous program to determine
which libpq library the programs are actually using and check if that
is the right version.
--
Peter Eisentraut
http
how you can organize your scripts differently, though.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 8: explain analyze is your friend
yourself and write out the individual bytes using the octal
escape sequences.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 8: explain analyze is your friend
CSN wrote:
I like Postgres's boolean type - why do you suppose
neither Mysql nor Oracle has bothered to implement it?
Booleans are in the SQL-99 spec.
Fear of breaking old applications
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Ale Raza wrote:
Are we not going to lose some characters if we are putting a UTF-16
to UTF-8 translation in front of libpq?
No, they are just different encodings of the same character set.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
Baldur Norddahl wrote:
Is there a better way to query the status of postgresql? I would
expect it to at least check that the process in the PID is actually
running and that it is a postgresql process.
Maybe try
test $(readlink /proc/$pid/exe) = /usr/bin/postgres
--
Peter Eisentraut
http
Mario Weilguni wrote:
Is it possible to have a database cluster with one database being
UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)?
No, sorry.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
at the same
time.
This is not true. Just don't delete your old libraries and keep using
those.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
.
There is nothing stop'ng a chapter being added now,
Actually there is: We don't ship documentation for software that we
don't ship.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: if posting/reading through
Rod Taylor wrote:
There is nothing stopping additional links to documentation from
being added to the PostgreSQL website in the documentation section.
That is true, but that does not foster consistent documentation, which
is what Thomas Hallgren wanted.
--
Peter Eisentraut
http
, either.
And let's ask him, too.
I'm not convinced that PLs are more tied to the core than say OpenFTS,
and if we can't maintain that kind of thing externally, then this whole
extension thing sounds like a failure to me.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
and checkpoint a lot.
There is no general use only X bytes control, nor a combination of
controls that amount to such.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: the planner will ignore your desire
that was published in Feb 2003? Will such a book be
hopelessly out of date?
That, too, depends on the topic.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
, only you can decide whether you actually need support.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's
it qualifies as a
bug. You press a certain key, and you get exactly the characters that the
key is defined to produce. That differs between operating systems, but so do
a lot of other things.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
[EMAIL PROTECTED] wrote:
currently when you execute a CREATE OR REPLACE FUNCTION there is
virtually no checking of the function body for variable type
compatibility or if the SQL statements are valid.
Only for very small values of no. Please provide an example.
--
Peter Eisentraut
http
Alvaro Herrera wrote:
On Tue, Mar 22, 2005 at 06:09:28PM +0100, Peter Eisentraut wrote:
[EMAIL PROTECTED] wrote:
currently when you execute a CREATE OR REPLACE FUNCTION there is
virtually no checking of the function body for variable type
compatibility or if the SQL statements
401 - 500 of 934 matches
Mail list logo