PostgreSQL without extra
permissions.
Markus
--
Markus Bertheau
Blog: http://www.bluetwanger.de/blog/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
2008/2/6, Tom Lane [EMAIL PROTECTED]:
I'm really not seeing the case for user-level documentation of HOT,
when for instance most of the planner's optimization behavior is not
so documented.
Actually that would be very useful information. Questions like how is
cost calculated, how are joins
2008/1/28, A.Burbello [EMAIL PROTECTED]:
Hi people,
I would like to some suggestion to search person name
in a table that has more than 150 milions of rows ...
e.g ... name like 'JOHN%SMITH';
I know there is contrib Tsearch, but I can't for
political reasons.
Is there any way to do with
Hi,
this is from HEAD of a few days ago, it looks suspicious to me.
8.2devel runs on port 5433.
[EMAIL PROTECTED]:~/pgsql$ bin/psql -p 5433 template1 markus
Welcome to psql 8.2devel, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL
2006/3/11, Michael Fuhr [EMAIL PROTECTED]:
Do you have the PGPORT environment variable set to 5432?
No.
Markus
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to
of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Markus Bertheau [EMAIL PROTECTED]
signature.asc
Description: =?koi8-u?Q?=E3=C0?= =?koi8-u?Q?_=DE=C1=D3=D4=C9=CE=D5?= =?koi8-u?Q?_=D0=CF=D7=A6=C4=CF=CD=CC=C5=CE=CE?= =?koi8-u?Q?=D1?= =?koi8-u?Q
sequences.
This is, by the way, a reason why this encoding should be renamed to
SQL_8BIT (or something along these lines) and UNICODE to UTF-8.
--
Markus Bertheau [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
understanding of how the UTF-8 encoding works.
--
Markus Bertheau [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
? What's the error message?
--
Markus Bertheau [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
got
it's Sunday.
Switch on logging by following the instructions in
http://www.redhat.com/archives/fedora-test-list/2004-March/msg01110.html
and look in the log file for the error message.
--
Markus Bertheau [EMAIL PROTECTED]
---(end of broadcast
to a UNICODE because this garbage
chars are invalid in client's encoding , so they are reject (in
translation process as invalid unicode chars).
You can dump the data, convert it with for example iconv and then load
the data again.
--
Markus Bertheau [EMAIL PROTECTED]
---(end
other functions? The second function
will be nowhere in the logs, right?
--
Markus Bertheau [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
couldn't do that job. It's an interesting number.
Is something like that planned in PostgreSQL?
Thanks
--
Markus Bertheau [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
used and therefore compiled successfully during a test run of an
application.
Is something like this planned or already available, but hidden well?
Thanks
--
Markus Bertheau [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9
: duplicate key violates unique constraint student_pkey
Is this scenario possible in standard SQL identity columns? From what I
read here[1], a standard IDENTITY column can guarantee successful
insertion of a unique key. Is there similar support planned for
PostgreSQL?
Thanks.
--
Markus Bertheau
, 07.11.2003, 21:45, Markus Bertheau :
, 07.11.2003, 16:45, Tom Lane :
Markus Bertheau [EMAIL PROTECTED] writes:
It has a unique index on virtual_domain. Every day we do 1 queries
of the form
insert into virtual_domains values (default, 'www.something.de')
So you're
?
Thanks
--
Markus Bertheau [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
, 07.11.2003, 16:45, Tom Lane :
Markus Bertheau [EMAIL PROTECTED] writes:
It has a unique index on virtual_domain. Every day we do 1 queries
of the form
insert into virtual_domains values (default, 'www.something.de')
So you're expecting these inserts to fail because of unique
will have to follow up on blobs, I have never
used them :/
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
to
utf-8 encoded unicode on the fly. Then again I don't know what charset
denmark uses usually, probably some other latin variant.
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---(end of broadcast)---
TIP 2: you can get off all lists at once
), put the encoding thing in front of
the file and load it into your unicode database.
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
-
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
How do I get rid of these huge files and how do I prevent them from
being created again? The dump of the whole database is ~50 Megabytes
gzipped.
Thanks
--
Markus
/postgresql/data/ | grep LC
LC_COLLATE: ru_RU.UTF-8
LC_CTYPE: ru_RU.UTF-8
Why does it not work?
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Good day,
why's that?
(user is postgres, who owns /var/lib/pgsql/data/)
bash-2.05$ bin/pg_upgrade -D /var/lib/pgsql/data/ -1
You must run pg_upgrade in either mode 1 or mode 2.
Usage: pg_upgrade [-D datadir] -1 | -2
bash-2.05$
Markus Bertheau
signature.asc
Description
On Sat, 2002-01-26 at 13:30, Antony Stace wrote:
Hi Folks
I want to log all of the inserts and delete that occur in a postgres database.
Whats the easiest way to do this?
tweak your postgresql.conf
Markus Bertheau
---(end of broadcast
I need to do?
add
debug_print_query = true
Markus Bertheau
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
show_query_stats = false
what is different?
btw: I presume we talk about 7.1.x
Markus Bertheau
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
27 matches
Mail list logo