-- or say Bytes to MBytes (original column is int8)
> ALTER TABLE tab ALTER col TYPE integer TRANSFORM col / (1024 * 1024);
You can do this using a plain column type change plus an UPDATE. I'd
prefer to keep these operations independent.
--
Peter Eisentraut [EMAIL PROTECTED]
---
x27;t use the term "transform". It is used by the SQL standard for
other purposes. What kind of object would you put in place of the "..."
anyway? A function? What syntax do other databases use?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broa
that would warrant the above step?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
mess
should be fixed.
> The following patch fixes it. I will put it into 7.5 after an
> appropriate delay.
I object to adding unnecessary complications like that.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
T
ssions,
etc., at least not without making the code anything but simpler. There
might even be a situation were you are allowed to delete the directory but
cannot create a new one.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2:
Kris Jurka writes:
> > in psql \h alter schema does not produce the desired help because the sgml
> > doc has the incorrect tag so it does not get picked up by
> > the create_help.pl script.
Thanks for the reminder. Patch installed.
--
Peter Eisentraut
}
>
> compile with cc -O -Kinline
I've installed a test based on this and checked off UnixWare on the
supported platforms list.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Larry Rosenman writes:
> > I'll try and write the patch as you suggest.
> Here's a patch as you suggested:
Isn't there a way to write a test that actually triggers the bug we're
trying to work around?
--
Peter Eisentraut [EMAIL PROTECTED]
---
provide free fixes for broken products?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
y fixed, this isn't a big issue. Think about what would happen
if we had to develop and maintain fixes for every buggy GCC compiler every
released.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubsc
d ones.
2. Make sure you can clean up after yourself even if your code doesn't run
all the way through.
3. Don't execute programs you just compiled.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner
Alvaro Herrera writes:
> One string added and some typos corrected. Please install.
Done.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
to get in).
> Is it possible to get cvs access, with say a promise that I only touch the
> swedish po files.
There are some thoughts about organizing the i18n efforts in a way to make
this possible. More on that later.
--
Peter Eisentraut [EMAIL PROTECTED]
Alvaro Herrera writes:
> The spanish psql message catalog is attached.
Installed as well.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Alvaro Herrera writes:
> I attach the whole spanish PO catalogs again, correcting some typos.
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister comm
Aleksander Kmetec writes:
> new files
> pg_resetxlog.po : src/bin/pg_resetxlog/po/sl.po
> pg_controldata.po : src/bin/pg_controldata/po/sl.po
>
> updated files
> psql.po : src/bin/psql/po/sl.po
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
mirko tebaldi writes:
> italian translation, later version with fuzzy strings fixed
Please run
msgfmt -o /dev/null -c -v postgres.it.po
on this file and fix the errors that it shows you.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadc
Gaetano Mendola writes:
> [EMAIL PROTECTED] wrote:
>
> > Hello,
> >
> > This is a first translation of pg_dump.po. It is not complete but quite a lot has
> > been done.
>
> Corrected some typo error and added missing translations.
Installed.
--
[EMAIL PROTECTED] writes:
> Please commit the changes, file reviewed by Gaetano Mendola. Corrected a couple of
> messages.
Done.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your des
Neil Conway writes:
> Oh? Which platforms are you referring to, and what tests were performed?
http://archives.postgresql.org/pgsql-patches/2002-10/msg00085.php
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if post
significant performance penalty on plenty of different
> platforms.
The last time I did some testing, the builtin memset() was significantly
faster on plenty of different platforms.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
Tom Lane writes:
> Given that gcc is smart enough not to move any code across the memset()
> call,
Is it? If you violate the aliasing rules, all bets are off.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don&#x
but ISTM the latter string doesn't really need any translation and so
> it wouldn't be much of a problem.
The quotation marks need "translation". But indeed it wouldn't be "much"
of a problem. I agree that this is a desirable bug fix.
--
Peter Eisentraut [
Andrew Dunstan writes:
> And looking at it even closer, 2 of the 3 cases of calling MemSet appear
> to be unnecessary, as the zeroed out values are immediately overwritten.
We need to zero out the holes in the structures so that hash functions
work correctly.
--
Peter Eisentraut
Serguei Mokhov writes:
> Pushed to 100%. Please install.
Done.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[EMAIL PROTECTED] writes:
> This is a first translation of the libpq.pot file ..
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(s
Dennis Bjorklund writes:
> I've not had time to translate everything yet, but here is what i've got
> now. I would like it to be commited.
Done.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the pla
og both as per above, or
(b) log only log_min_duration_statement
* If log_duration is on and log_min_duration_statement is triggered, then
we (pick one):
(a) log both as per above, or
(b) log only log_min_duration_statement
--
Peter Eisentraut [EMAIL PROTECTED]
---(e
Installed.
Next time, please run msgfmt -o /dev/null -c -v file.po, or use the
equivalent command in your PO editor, to check your file for errors.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'ki
Bruce Momjian writes:
> I have patched pg_restore to output the script contents if you restore
> with -v:
I don't think it's a good idea to overload the -v switch with it. A
separate switch seems OK, but I don't quite get the point of this
functionality, actually.
--
Pete
Bruce Momjian writes:
> I had a new idea on output format. Instead of converting newline to
> "\n", and double-escaping backslashes, we add a tab after any newline,
Then how would you identify the real tabs in the data?
--
Peter Eisentraut [EMAIL PROTECTED]
---
ee the consistency of both results, you'd have to
log each query twice in this case.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ella
Sinstassi:
DROP TABLE nome [, ...] [ CASCADE | RESTRICT ]
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
, but web is fine, too.
--
Peter Eisentraut [EMAIL PROTECTED]
---(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
Alvaro Herrera writes:
> Attached are pg_controldata, pgscripts and libpq spanish translations.
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
Serguei Mokhov writes:
> Attached please find updated translations of the items
> in the subject.
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
nabled. I guess we'll have to do
without that in this release. So, making the above change does not pose a
problem.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
was wondering, are we kidding ourselves when we display
microsecond precision to the user? What accuracy do these measurements
have in respect to what they are actually supposed to measure?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)--
t log information over several lines.
If you're generating 500 MB of log output a day, it becomes a problem.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Alvaro Herrera writes:
> Did you get this one?
> http://archives.postgresql.org/pgsql-patches/2003-10/msg9.php
> (backend translation)
No, but I've installed it from the archives now.
--
Peter Eisentraut [EMAIL PROTECTED]
---(en
Alvaro Herrera writes:
> Attached are psql and libpq spanish PO files, 100% translated.
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if y
Bruce Momjian writes:
> Thanks Peter. Patch attached. I added "(secs)" to the ouput:
>
> LOG: duration(secs): 0.000257
> LOG: duration(secs): 0.000754
> LOG: duration(secs): 0.008115 select * from pg_class;
I think the units typically go aft
n)
Causes the duration of every completed statement to be logged. To use
this option, enable log_statement and log_pid so you can link the
statement to the duration using the process ID.
This needs more thought.
Also, please put units on all numbers.
--
Peter E
Darko Prenosil writes:
> Croatian translation for libpq (/src/interfaces/libpq/po/hr.po).
> Please apply.
Done.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ldcard feature was removed some time ago on purpose.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
ave matched the original. While that is
noble in intent, I don't think it's particularly effective. First, you'd
never be able to reach the 100% mark in the statistics, and second, this
will actually make gettext() run longer, because it will have to search
the whole file for a s
stalled.
If you want to keep working on Windows, I suggest you read the bottom of
this page: <http://www.pgadmin.org/pgadmin3/translation.php>. It suggests
some tools that you can use for editing PO files on Windows. It will be
much easier than editing them directly, which I assume is what
ull clearer is great. I think we
> should just standardize on 'NUL' for a null byte, or 'nul'.
I don't think someone coming in from the street and seeing a message or
code is going to understand that. If you really want to be clear, call it
&
should be just one "duration: nnn" log entry, printed if
> either condition holds.
Is anyone going to take care of this?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
et of working and reference trees around.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
emantics, namely that the table structure persists but the data is
deleted at the end of the session. That would also help in some other
scenarios, such as creating functions that reference temporary tables.
--
Peter Eisentraut [EMAIL PROTECTED]
---
CREATE TABLE reference page.) Perhaps implementing that would satisfy
your needs.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Mike Mascari writes:
> Out of sheer shame for a stupid remark, I have implemented a pgenv
> contrib module which provides three functions:
>
> set_session_variable (name, value)
> get_session_variable (name)
> reset_session_variables()
How is this better than temporary
Guillaume LELARGE writes:
> Apart some grammar fixes, I also modified the email header. I hope this time
> there will be no mess in the headers :)
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the p
Weiping He writes:
> fixed, updated here:
>
> http://www.pgsqldb.org/pgsql-po-zh_CN.tar.gz
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregiste
s OK.
> - adds a couple of comments for the translator (I had to peek at the
> source code to see what the %s was about, so I guess this is needed).
OK.
> Also, I've noted that psql's \h messages are not translatable. Is there
> a way to make
s.
(I know there are some languages where this is in fact a problem, but none
of them are likely to start a PostgreSQL translation project in the next
few weeks. ;-) )
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don'
ure we need a
better plan.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ut-PACKAGE do not use PACKAGE (same as --with-PACKAGE=no)
Readline is a package, spinlocks are a feature.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://w
Bruce Momjian writes:
> o adds a configure option --without-spinlocks to allow
> non-spinlock compiles
--disable-spinlocks please.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you check
R commands help.
They are long, but not not longer than a few pages, in which case it's
more convenient to use your terminals scrolling functionality. It's a
different story when query output is thousands of lines long, in which
case you usually cannot scroll anymore.
--
Pet
rs will not work correctly. See PostgreSQL
>documentation "Installation on Windows" for details.
If you can detect that they are different, why can't you adjust the code
page in that case only?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)-
`msgstr' does not
match
pg_dump-zh_CN.po:695: format specifications for argument 1 are not the same
scripts-zh_CN.po:369: format specifications for argument 2 are not the same
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP
s
> well).
Please send in a patch. Else, someone else is going to try to fix it with
less guarantees that it will work afterwards.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
5 mins 6 secs
@ 1 year 2 mons 3 days 04:05:06
These are also the supported output formats (the first you get for 'sql',
'postgres', and 'german' formats; the second is 'iso'). A quick check of
ISO 8601 shows, however, that neither of these are close to any
s)?
>
> I don't really care for using that name for it --- for one thing, you
> couldn't do
> set datestyle to iso basic;
> because of syntax limitations. A one-word name is a much better idea.
iso8601
Keep in mind that SQL itself is also a kind of ISO, so being m
r in
configure.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
ines may not access the psql settings.
I think we ought to detect the console type automatically anyway.
Certainly we don't want people to have to set this variables all the time.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)
en without that test, and because no one else has done
> Win32 compiles since it was added, no one saw it.
Interesting, considering that WIN32_CONSOLE isn't being set anywhere.
Anyway, that code needs to be removed/fixed, for the mentioned reasons.
--
Peter Eisentraut [EMAIL PRO
d to the head branch?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
work.
> This is there only so 'configure' sees those include files. Does that
> relate to building outside the tree?
Why does configure need to see those files? Surely you don't need
configure to test the capabilities of our own source tree?
--
Peter Eisentraut [EMAIL PROTEC
consistencies in
the future.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
re all upper case. That is a bit
inconsistent, but I think it's OK, because here they sort of serve as
section titles.) Also note that postgresql.conf, command-line option
equivalents, and SET commands all tend to use them in lower case, so that
seems like the direction to go.
--
Peter
peter=# SELECT * FROM test;
ERROR: relation "test" does not exist
HINT: Perhaps you need to use "CREATE TABLE" to create the table in the
database, or you mistyped the table name.
I think not...
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of br
Neil Conway writes:
> This patch makes a few minor improvements to the docs: make the
> conventions more consistent,
They are consistent: They're all lowercase. Until now.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)--
Robert Treat writes:
> I didn't see it documented anywhere that a 0 in attypid of pg_attribute,
> and given the note on the need to match pg_type lest failure seems to
> warrant the mention.
A column is dropped if and only if attisdropped is true.
--
Peter Eisentraut [E
Mirko Tebaldi writes:
> what about this email ?
Can you send the files in a less unusual archive format?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
h
# French message translation file for psql
#
! # $Header: /cvsroot/pgsql-server/src/bin/psql/po/fr.po,v 1.3 2003/08/20 21:10:01
petere
#
# Use these quotes: «%s»
# Peter Eisentraut <[EMAIL PROTECTED]>, 2001.
--- 1,7
+ # translation of psql-fr.po to FR_fr
# French message t
too stressed about catching up with every single message
change.
--
Peter Eisentraut [EMAIL PROTECTED]
---(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
Alvaro Herrera writes:
> Attached is a (new) spanish PO file for psql:
>
> $ LANG= msgfmt -v -c po/es.po
> 269 translated messages, 2 untranslated messages.
>
> Please install. Don't forget to add to nls.mk...
Done.
--
Peter Eisentraut [EMAIL PROTECTED]
---
Serguei Mokhov writes:
> Got rid of all fuzzy messages; translated a few as well
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
Alvaro Herrera writes:
> One untranslated message ("NOTICE"). Please install.
Done.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
sub
Serguei Mokhov writes:
> psql and libpq: one new/fuzzy message each; recently introduced
> pgscripts: new chunk of translated messages
> all:message tweaking and rudimentary spell check
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
-
Guillaume LELARGE writes:
> Two updated po files. I hope this time they will be 100%... I felt guilty for
> the 99% last days :)
Installed.
Please configure your KBabel so that it does not mess up the header
section of the file next time.
--
Peter Eisentraut [EMAIL PRO
Dennis Björklund writes:
> Someone added a couple of strings so an update was is needed.
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if y
.
Oh, and have you ever tried to contact a kernel expert or kernel vendor?
:-)
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
gt; I have assigned copyright of these translations to
>
> The PostgreSQL Global Development Group.
>
> I hope that's OK with you.
We don't play those games. You can keep your copyright.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
Euler Taveira de Oliveira writes:
> Now I put the files in my machine because it's too large (84K). The file
> *.po are new ones and *_patch are the updates against the REL_7_4_BETA1
> branch.
I repeat: no patches.
--
Peter Eisentraut [EMAIL PROTECTED]
Dennis Björklund writes:
> Lots of tranlated files. This time I hope that all of these except backend
> will be 100% on the statuspage.
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will
Karel Zak writes:
> please, apply attached patch.
Done.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
people might add translations for their
language at the same time, and you're going to provoke patch failures that
way. Just say which files are new. Thanks.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Dennis Björklund writes:
> One more file updated. 5 strings needed changes to get to 100% again.
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
pply.
That is not the right place for it. IS OF is an operator, not an SQL
command.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Dennis Björklund writes:
> Here is an updated translation for the backend.
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
hing).
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Guillaume LELARGE writes:
> Here are three 7.4cvs-updated french po files.
Installed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/f
ched to this message.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Serguei Mokhov writes:
> Attached a complete translation of psql.
> psql-ru.zip
Done. Please use gzip next time, if you have it available.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to in
Serguei Mokhov writes:
> Fixed fuzzy transtlations and translated new strigns
> for 7.4.x.
Done.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Serguei Mokhov writes:
> Update for 7.4.x:
>
> pg_controldata-ru.po;pg_resetxlog-ru.po
Done.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postg
701 - 800 of 821 matches
Mail list logo
