of the database
and then allow you to browse backwards and forwards
through it (FETCH i beleive).
I currently thinking of using this to solve the problem
I'm having with pg_dump dumping a 400,000 row table and
chewing all of system memory doing it.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http
from a" is not
a legal statement. As the message suggests, a is not a
printable type. Maybe you meant a.* ?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
implementation or even a
website where I could read about this?
Look like you need to learn about transactions.
Sorry, can't suggest a good site.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
bly not a problem in newer versions though. What version
are you using?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
on the unique index to fail the insert if
there is a duplicate.
3) Use a sequence to generate unique indicies for you?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
to the "port". Ofcourse, you
just delete it to mix it :)
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
. All I achieves is make any
other client trying to access that record jam up.
If you want to handle multiple people modifying the
same record, maybe you should look into transactions...
More info maybe be needed here...
HTH,
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com
using the backend permissions, which probably can't
write anywhere. Use \copy and be happy...
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
(usually a typo in the query).
Since the query didn't complete sucessfully it must be aborted,
and this it ignores all queries until END.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
to comment on restoring a database from
file backups?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
ha testers for his new version of pg_dump ;-).
Unfortunately I think he's only been talking about it on pghackers
so far.
What versions does it work on?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
Philip Warner wrote:
At 23:34 1/07/00 +1000, Martijn van Oosterhout wrote:
Philip Warner needs alpha testers for his new version of pg_dump ;-).
Unfortunately I think he's only been talking about it on pghackers
so far.
What versions does it work on?
6.5.x and 7.0.x.
Which
so" is a no op.
This may be a documented feature, but it's still confusing.
This is the postgresql debian package 7.0.2-3.
PS. I thought we'd left behind all the US/non-US datestyle
distinction when we all started using ISO format (-mm-dd).
That was somewhat naive of me, huh?
--
Martijn van Oosterhout
or an explicit cast
--
Martijn van Oosterhout
. Restarts the postmaster
6. Delete the old, now replaced external DB.
The whole process takes about 15 minutes but the external DB is only
out for 10 seconds or so. You can run it anytime really.
We've found this quite reliable.
Hope this helps...
--
Martijn van Oosterhout [EMAIL PROTE
On Tue, Jan 09, 2001 at 10:51:35AM -0500, Bruce Momjian wrote:
Well, clustering certainly speeds up index access to multiple heap
values because duplicate values are all on the same heap page. One
thing that is missing is that there is no preference for index scans for
clustered indexes.
think I'm attacking you, I'm just trying to help...
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
the situation please?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
result. Am I
missing anything?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
. That would stop the
discussion problem.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
, but the query planner sounds like one of the trickier
parts of postgres, dunno if I want to look :)
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://cupid.suninternet.com/~kleptog/
On Tue, Feb 20, 2001 at 05:02:22PM -0800, Stephan Szabo wrote:
IIRC, There's something which is effectively :
estimated rows = most common value's frequency*fraction
I think fraction defaults to (is always?) 1/10 for the standard
index type. That's where the 50 comes from. And the
On Thu, Mar 22, 2001 at 06:33:16PM -0500, Jan Wieck wrote:
Einar Karttunen wrote:
How do you put a UNIQUE constraint on the entire inheritance
hierarchie?
Easy. You make a unique index that covers an entire inheritance hierarchy.
If lots of table inherit a field "id" from a single
data.
The only issue is that transactions can't be nested but that shouldn't be a
problem. Also, it's possible that the transaction may block other queries on
the database but someone with more knowledge than me will have to answer
that.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org
.
Oh, and it appears I accidently changed the allowed syntax a bit. You used
to have to qualify each field in the partial index predicate with the name
of the relation. That's no longer required.
Everyone still alive out there?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog
On Sat, Jul 14, 2001 at 12:00:29PM -0400, Tom Lane wrote:
Martijn van Oosterhout [EMAIL PROTECTED] writes:
Whether it's useful for anyone else is a question, but anyway, it makes an
explain type output like:
So the assumption is that you'd actually *do* the query, then report
back
On Sat, Jul 14, 2001 at 10:09:02PM -0400, Tom Lane wrote:
Martijn van Oosterhout [EMAIL PROTECTED] writes:
Yes, you actually do the query and the show what took how long. As for
seperating the parent and child nodes, is that really necessary?
If you're going to label the nodes
as the
pg_get_expr function is defined. To make that an internal function I have
add it to pg_proc.h and initdb again, right?
http://svana.org/kleptog/pgsql/partial-indicies.patch
http://svana.org/kleptog/pgsql/expr.c
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would
On Tue, Jul 10, 2001 at 04:47:49PM +0200, Peter Eisentraut wrote:
Martijn van Oosterhout writes:
Well, getting closer. Maybe I should start version numbering the patches?
For one thing, you might want to post them to pgsql-patches instead. And
you should start generating the patches
will not support the IS NULL predicates, for the
same reason that IS NULL cannot use an index for lookups.
I'd love to fix that but that's going to be hard (or rather, I havn't
thought of an easy way to do it :).
Maybe someone has a better solution.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org
is a
non-starter.
Many people would have great difficulty hitting 4 terabytes.
What the limit on NT?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came up with a certification system that
actually separated those who can barely regurgitate
someone spots a
serious problem.
http://svana.org/kleptog/pgsql/partial-indices-7.2.patch
Anyway, now it's time to think about after. I can think of:
* Complete the removal of EXTEND INDEX
* Allow IS NULL in the predicate
Anything else?
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org
by
default, running losetup then mount doesn't sound like a major issue to me.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came up with a certification system that
actually separated those who can barely regurgitate what they crammed over
rows=1314 loops=1)
I'm still getting a lot of debug messages so there is still some work to do.
Any comments?
(Oops, just thought of one issue: Merge Join will not exhaust it's subnodes
because it can stop early).
http://svana.org/kleptog/pgsql/timing-explain.patch
--
Martijn van Oosterhout [EMAIL
to delete it.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came up with a certification system that
actually separated those who can barely regurgitate what they crammed over
the last few weeks from those who command secret ninja networking
call you sequence
maincompetencies_pseq or whatever you like.
Parsing it out of the system tables might not work in future versions
either. The only guarenteed way is to name them yourself.
HTH,
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came
noticed that query compilation actually took any noticable
time. No, postgres doesn't do that but I'm not convinced it would make a
difference.
HTH,
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came up with a certification system that
actually
sequential scan is faster than 80,000 index scans.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came up with a certification system that
actually separated those who can barely regurgitate what they crammed over
the last few weeks from those
is to minimise the number of
queries, letting the database do the maximum optimisation possible.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came up with a certification system that
actually separated those who can barely regurgitate what
;
alter table data rename to data_archive;
create table data (...);
commit;
I think with the recent decoupling of filenames and table names that should
be possible.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came up with a certification system
mapped into your address space.
I think that for commonly used tables that are under 100K in size (most of
the system tables), this is quite a workable idea. If you don't mind keeping
them mapped the whole time.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would
, internetusage
where date_trunc('month',starttime) = '2001-07-01'
and minute between starttime::time
and starttime::time + (duration || 'seconds')::interval
group by date, starttime, minute;
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone
on the website and
psql has a brief summary when you type \h CREATE TABLE
Unfortunatly my postgres server isn't booting right now (version mismatch)
so I can't paste the result here...
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
It would be nice if someone came up
?
HTH,
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
Magnetism, electricity and motion are like a three-for-two special offer:
if you have two of them, the third one comes free.
---(end of broadcast)---
TIP 5: Have you
: DateStyle is ISO with US (NonEuropean) conventions
That's -dd-mm
What you want is:
# show datestyle;
NOTICE: DateStyle is ISO with European conventions
Which is -mm-dd
HTH,
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
Magnetism, electricity and motion are like
of any right now.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
Magnetism, electricity and motion are like a three-for-two special offer:
if you have two of them, the third one comes free.
---(end of broadcast)---
TIP 1
point.
--
Martijn van Oosterhout [EMAIL PROTECTED]
http://svana.org/kleptog/
Magnetism, electricity and motion are like a three-for-two special offer:
if you have two of them, the third one comes free.
---(end of broadcast)---
TIP 4: Don't 'kill -9
waiting
30183 ?S 0:01 postgres: postgres w2 192.168.5.54 idle
30184 ?S 0:00 postgres: postgres w2 192.168.5.54 idle
30185 ?S 0:00 postgres: postgres w2 192.168.5.54 INSERT waiting
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog
like:
select id,url,title from directory,
(select url from directory group by url having count(*) 1) as list
where list.url = directory.url;
I hope I got the syntax right.
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
the West won the world not by the superiority
:
ERROR: Column reference url is ambiguous
Oh right, try:
select id,directory.url,title from directory,
(select url from directory group by url having count(*) 1) as list
where list.url = directory.url;
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
the West won
can them merrily DROP COLUMN half of them. Until
then...
The original developers didn't really have a concept of storing different
info in different tables.
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
the West won the world not by the superiority of its ideas
://www.postgresql.org/docs/faqs/FAQ.html
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
the West won the world not by the superiority of its ideas or values or
religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non
, Andreas.
-
This mail sent through IMP: http://horde.org/imp/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
--
Martijn van Oosterhout [EMAIL
inserted duplicates in the split second
there was no index?
for safety's sake, I've always reindexed in a transaction:
begin;
drop index bubba;
create index bubba on ...
commit;
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
the West won the world
at this point right now.
Thanks In Advance,
Litso
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
the West won the world not by the superiority of its ideas or values or
religion but rather by its superiority in applying organized violence.
Westerners often forget
the tables in a crash.
Basically, do you care about your data?
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
the West won the world not by the superiority of its ideas or values or
religion but rather by its superiority in applying organized violence.
Westerners often
)---
TIP 8: explain analyze is your friend
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
the West won the world not by the superiority of its ideas or values or
religion but rather by its superiority in applying organized violence.
Westerners often
inserts
- Create a trigger so it overrides any value you put in with the next serial
Note, you can't really avoid holes in the sequence. This is a FAQ somewhere.
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
the West won the world not by the superiority of its ideas
on what the correct answer is, but I beleive the reason it
works in Postgres is because the expression is expanded to:
WHERE (1=1) OR (1=0) OR (1=NULL)
which becomes:
WHERE TRUE OR FALSE OR NULL
which is TRUE. (standard tri-value logic)
--
Martijn van Oosterhout [EMAIL PROTECTED] http
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
the West won the world not by the superiority of its ideas or values or
religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non-Westerners never do.
- Samuel P
! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
---(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
--
Martijn van Oosterhout [EMAIL PROTECTED
tables for
each year by hand and using a view to combine them.
You can create RULEs to automatically move new data to various tables. As
long as you're not doing UPDATEs you can avoid a lot of the complexity.
Similar effects can be acheived using inheritance.
Good luck!
--
Martijn van Oosterhout
to @@identity variable:
insert into organization ('org name', )
insert into contact (@@identity, 'contact name'
.)
Here Identity is the organization's ID that is needed
as a foreign key in contact table.
See currval() and nextval().
--
Martijn van Oosterhout [EMAIL PROTECTED] http
On Fri, Aug 01, 2003 at 10:43:03PM -0500, Ron Johnson wrote:
On Fri, 2003-08-01 at 22:27, Martijn van Oosterhout wrote:
On Fri, Aug 01, 2003 at 04:25:05PM -0700, b b wrote:
Is there an environment variable that returns the
primary key of the last inserted row. This is usefull
to find out what the last record inserted was.
It returns the last record *you* entered. If you want the last record
entered by anyone (committed ofcourse), you'd use order by x desc limit 1.
In general, currval() and nextval() do exactly what you need.
--
Martijn van Oosterhout [EMAIL PROTECTED
a
timestamp if you want actual times to be involved. However, values will only
show up once the transactions they were in commit, so finding the the last
value inserted right now is not possible.
In any case, I beleive currval() is the answer to the original question.
--
Martijn van Oosterhout [EMAIL
for this?
Thanks in advance,
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
All that is needed for the forces of evil to triumph is for enough good
men to do nothing. - Edmond Burke
The penalty good people pay for not being interested in politics is to be
governed by people
Never quote = case-insensetive
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
All that is needed for the forces of evil to triumph is for enough good
men to do nothing. - Edmond Burke
The penalty good people pay for not being interested in politics is to be
governed
to [EMAIL PROTECTED]
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
All that is needed for the forces of evil to triumph is for enough good
men to do nothing. - Edmond Burke
The penalty good people pay for not being interested in politics is to be
governed by people
:
Seq Scan on table_a (cost=0.00..373661.73 rows=12 width=227)
EXPLAIN
Let me guess, field_1 is not an int4 and since you didn't quote the constant
1, it can't use the index.
The second query has matching types, so can you the index.
Hope this helps,
--
Martijn van Oosterhout [EMAIL PROTECTED
. If you mean NULL, then it's
according to the SQL standard. NULL NULL so those rows are not
equal.
If you mean some real value, then yes, that's wierd.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according
is so important, why aren't seeing a rash of installation
reports about it working (or not). Why hasn't someone offered to setup
a buildfarm machine?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according
? Now is the
time to show it.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
.
Int64GetDatum(your_variable)
which then has to be pfree'd, correct?
Possibly, it probably depends on the architechture. The memory is being
allocated in a per-call context IIRC so it'll be freed at the end of
the function anyway. I wouldn't worry about it.
Have a nice day,
--
Martijn van Oosterhout
(). The memory will
all be freed at the right time.
The documentation on C functions and set-returning functions also has
info about when the context is reset.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according
collector, everything in a context goes when the
context is reset or deleted. If you still have a pointer there, it'll
be invalid. If you enable debugging stuff it'll clear freed memory so
the error becomes more obvious.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http
,
...)?
The output is quite verbose, e.g.
Try elog(), but the details are also controlled by the client also,
perhaps you can reduce the verbosity there also?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according
anyway, why split it out?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
, without trying to store it first.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
, ipcrm, or
just delete the file postmaster.pid.
This doesn't make sense to me. A reboot will absolutly kill any
existing shared memory blocks, how can it possibly be complaining about
it?
What does ipcs show after the failure to start postgres?
Have a nice day,
--
Martijn van Oosterhout kleptog
be solvable as long as the transaction
ID on the slave doesn't pass the VACUUM horizon of the server. But it
would require careful studying of the WAL write order to be confident
it would actually work.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From
8.1.3. The following SQL seems
to produce a deadlock while doing an endless reading of a temp table:
SELECT s.sid FROM stud s, stud_vera v WHERE s.sid = v.sid AND v.veraid =
34 AND s.sid NOT IN ( SELECT sid FROM stud_vera WHERE veraid = 2 );
Have a nice day,
--
Martijn van Oosterhout
*/
Perhaps you could indicate in the subselects the type? For example:
insert into temp(a) select NULL::timestamptz union select NULL;
I think as long as the first has the right type, you're set.
BTW, UNION ALL is probably more efficient.
Have a nice day,
--
Martijn van Oosterhout kleptog
to
the table. Similarly, as of 8.2 it will be possible to do:
INSERT INTO table (blah) VALUES (x,y,a),(f,d,g),(s,f,g), etc...
Which will also avoid the issue.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according
(fields) FROM STDIN;
The only restriction is that you can't use expressions.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital
, and you have a backup plan
(if copy/create/update fails for some reason, leave the row in the
table and try again later).
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
to any particular problem. Then again, when you go
stomping around in memory where you don't belong, all bets are probably off.
99% of the time random segmentation faults are memory trouble. Have you
tried memtest86 on the machine in question?
Have a nice day,
--
Martijn van Oosterhout kleptog
at the right numbers? Disk cache should be
counted as part of free memory, for example.
Could you provide some actual output of your tests, so we can see
exactly what you mean?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his
is
then parsed by the point input function.
If you want you can encapsulate this into a function and create the
cast yourself.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
of the return
values?
Yes, you can define a new type:
CREATE TYPE name AS
( attribute_name data_type [, ... ] )
Also, in more recent versions (8.1 I think) you can use OUT parameters
to create anonymous types.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http
The message is slightly wrong, the max length is actually one more. You
can adjust the maximum length by changing the params in
fuzzystrmatch.h and recompiling.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each
.
In that situation your idea may work well, but that's just a surrogate
key in disguise...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital
to store, and with float4 that occurs after about 6
digits.
If you want to remember exact numbers, use numeric.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
you everyone.
Find the locales you're using and make sure they match the encoding
everywhere...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
not busy time for the live application.
The locale is not a global setting. If you set the LANG or LC_ALL
variable, it will change the locale of any program run with that
environment variable. The default is the C locale.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http
is diffrent from the
LANG=zh_CN.GB18030.
You need to do more to change the encoding of a database. The encoding
is fixed at cluster-creation time, so you need to run initdb again to
actually change the locale/encoding.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http
something more reasonable?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
' AT TIME ZONE 'Europe/Moscow';
Including it in the string is only supported from 8.2 beta onward. So
try that out and see how it goes.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability
1 - 100 of 1908 matches
Mail list logo