On 23.04.2011 05:21, Tom Lane wrote:
Erwin Brandstetter writes:
However, I have a database with dozens of schemas and hundreds of
tables. There is a bunch of useless comments on columns I want to get
rid of, scattered all across the db. The fastest& easiest way would
be:
DELETE
FROM pg_description WHERE description = 'My very special
totally useless comment.';
AFAICS, there are no side-effects. Are there any?
TIA!
Erwin Brandstetter
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresq
On Apr 9, 4:31 pm, sfr...@snowman.net (Stephen Frost) wrote:
> Running a database-wide 'vacuum freeze;' will either succeed (and all
> will be well), or it'll generate the errors in the message (in which
> case you'll need to restore the CLOG files, as at the wiki page, and
> then re-run the 'vacuu
Hello!
In connection with the recently discovered bug with pg_upgrade:
http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix
If I an not sure whether pg_upgrade or pg_migrate has been applied on
certain databases in the past:
- How do I know if I am being affected by the bug _before_ errors
occ
Hi!
I want to vacuum analyze a number of tables in a given database (on
port 5432) from a shell script. There is no need to process the whole
database.
Using
vacuumdb -d mydb -t mytab1 -t mytab2 -t mytab3 -fzp 5432;
silently operates on the last tablename given only. 'mytab3' in the
example ab
On Jun 5, 12:13 pm, [EMAIL PROTECTED] (Kristo Kaiv) wrote:
> i guess this what you meant:
> (not a nice solution though) writing a function that returns the set
> would be a better idea
>
> create table testintarr (iarr int[]);
> insert into testintarr values ('5,6,7,8');
>
> test=# select iarr[idx
On Jun 6, 4:59 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Erwin Brandstetter escribió:
> >> If I want to change the default order of two columns of a table, can I
> >> just manipulate the values in
> >> pg
Hi group!
If I want to change the default order of two columns of a table, can I
just manipulate the values in
pg_catalog.pg_attribute.attnum?
I am trying to do this in pg 8.1.9. Works the same in pg 8.2.x I would
assume?
BEGIN;
UPDATE pg_catalog.pg_attribute SET attnum = 4
WHERE attrelid = 12345
[EMAIL PROTECTED] wrote:
Erwin Brandstetter <[EMAIL PROTECTED]> writes:
Wait .. not that great! The system locale is more or less ignored, but
my sort order will approach randomness?
Peter's point is that a given locale setting will expect a particular
encoding, and if you
[EMAIL PROTECTED] wrote:
Erwin Brandstetter wrote:
I've been reading tons of stuff on locale and postgresql. I am still
not in the clear about some details, though: how do system locale and
database locale work together (or not)?
The system locale is more or less ignored.
ED]:~$ locale -a
C
[EMAIL PROTECTED]
en_US.utf8
Does anyone know these details? It would ease my mind. :)
Thanx in advance!
Regards
Erwin Brandstetter
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
will add an SCSI RAID 5
system, while the OS stays on one of the SATA drives. The mainboard
TYAN Thunder K8S Pro provides a PCI X slot ready for a SCSI controller
card.
My sympathy for postgresql has prooved right once more. You gave me
very profound advice. Thanx a lot!
Best Rega
ver use the "interesting"
data, you should go for the "history" version, which would speed your
those queries a lot. As you have distinct id's on both tables (having
fetched from the same sequence initially), u can always do a union
select on both tables in the rare cases th
ller battery-backed still?
RAM:
As much as the motherboard will bear. 4 GB probably. This seems the
easyest point to decide on. Correct? DDR SDRAM PC333 or PC400?
Other:
2 NICs, ??
I appreciate any comments, hints or corrections.
Regards
Erwin Brandstetter
[1] http://www6.tomshardware.com/stora
."400 too many users".. Duh!
So all I achieved this afternoon was to finally make *apt-get update*
read Packages.gz. I hope the update itself will go smoothly.
Regards
Erwin Brandstetter
--
No z in my email.
---(end of broadcast)---
TIP
correct line for /etc/apt/sources.list is:
deb ftp://ftp.postgresql.org/pub/binary/v7.4/debian/ main non-free contrib
I will try to install it tomorrow and report back.
Regards
Erwin Brandstetter
---(end of broadcast)---
TIP 3: if posting/reading th
ackage for debian woody?
TIA
Erwin Brandstetter
--
no z in my mail.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
"Miquel van Smoorenburg" wrote:
> It sure is.
> www.mail-archive.com/[EMAIL PROTECTED]/msg71008.html
Thnax for the hint - but it sure ain't.
people.debian.org has been down since the debian hack.
I am also desperately looking for postgresql 7.4 on debian woody.
Is there a trusted mirror of peop
[EMAIL PROTECTED] (Joe Conway) wrote in
news:[EMAIL PROTECTED]:
> http://developer.postgresql.org/docs/postgres/functions-array.html
Very good!
PostgreSQL 7.4 will provide the functions "array_lower" and "array_upper"
doing exactly what I was looking for.
Unfortunately I have to implement the
urgently needs improvment on array handling. Hopefully new versions take
care of that (haven't tested 7.3+).
BTW: Have been away for some days, so my reply is late, sorry.
Regards
Erwin Brandstetter
--
no z in my mail.
---(end of broadcast)---
TIP 1:
Not that it makes much of a difference, but i guess the following code
might work slightly better:
r[(substring(array_dims(r), strpos(array_dims(r), ':') + 1,
(length(array_dims(r)) - strpos(array_dims(r), ':')) - 1))::int]
Regards
Erwin Brandstetter
data than array_dims
(returning something like '[1:4]')?
Grateful for any hints.
Regards
Erwin Brandstetter
--
no z in my mail.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
j
22 matches
Mail list logo
