Comments for select * from depesz;

Comment on dziwne ostrzeżenia by maxie

maxie — Fri, 20 Nov 2009 00:49:38 +0000

There is nothing like returning to a place that remains unchanged to find the ways in which you yourself have altered.

Comment on “FATAL: Ident authentication failed”, or how cool ideas get bad usage schemas by Jaap Hoetmer

Jaap Hoetmer — Wed, 18 Nov 2009 21:52:57 +0000

Thanks, this saved me a lot of frustration. Very well explained. I do agree the default settings are not useful, especially since the errors are not clear where to look to solve this.
I also see the point that this is from a security perspective not the best solution, but it at least now makes me understand where it went wrong, and what to do about it. Also agree that setting the default not secure enough makes for more vulnerable systems. Like Windows…

A BIG thank-you.

Comment on Czemu jestem taki ułomny? (wylgaryzmy, polish only) by depesz

depesz — Wed, 18 Nov 2009 12:57:49 +0000

@adek: fajne, nie znałem. a może i skorzystam.

Comment on Waiting for 8.5 – TRIGGERS on columns by Filip

Filip — Wed, 18 Nov 2009 12:38:27 +0000

@Caleb: according to PostgreSQL 8.5devel Docs, no. it won’t fire if you don’t name the column.

in particular, this means that a trigger defined as
CREATE TRIGGER trigger1
BEFORE UPDATE OF column1 ON table1
FOR EACH ROW EXECUTE PROCEDURE trigger1();

will *not* fire when column1 is updated by another trigger.

for me it’s a bit weird but probably it’s standards-compliant, if pg-gods decided this way.

Comment on Czemu jestem taki ułomny? (wylgaryzmy, polish only) by adek

adek — Wed, 18 Nov 2009 09:56:51 +0000

To może http://www.mazdowynajecia.net ?

Comment on Waiting for 8.5 – TRIGGERS on columns by Caleb Cushing ( xenoterracide )

Caleb Cushing ( xenoterracide ) — Wed, 18 Nov 2009 06:08:26 +0000

so maybe I’ve read this too fast and it was answered… (I think your code probably answers but…)

Support SQL-compliant triggers on columns, ie fire only if certain columns
are named in the UPDATE’s SET list.

so it won’t fire if I don’t name the column? or just generally do an insert on that column even if I name it?

Comment on Czemu jestem taki ułomny? (wylgaryzmy, polish only) by levy

levy — Tue, 17 Nov 2009 23:09:52 +0000

Ooo… jak to dobrze, że inni też tak mają. To ja Cie pocieszę… Miałem wywiercić dziurę w ścianie na zawieszenie małego obrazu – wyszła dziura, w której dwa palce się zmieściły (te nowoczesne wiertarki normalnie są za szybkie…). Miałem zainstalować karnisze… czyli z 6 dziur… wiercę pierwsza – z 3 minuty, kolejne dwie jeszcze dłużej (no bo normalnie się zmęczyłem). Przy 4 dziurze przychodzi sąsiad (od którego pożyczyłem wiertarkę) i pyta się: czy Ty włączyłeś udar ? Ups… Kolejne dziury zrobiłem w 10 sekund…

O instalacji wywietrznika na ścianie w ogrodzie nie wspomnę – wywietrznik wisi i owszem, ale w obrębie kilkudziesięciu centymetrów plama po kleju, który jakimś cudem się rozpaćkał po ścianie…

Tak więc głowa do góry. Nie każdy jest “Panem Złota Rączka”.

Comment on Koniec romansu ( polish only ) by levy

levy — Tue, 17 Nov 2009 23:01:21 +0000

Outlander wcale nie jest ohydny… Ja mam i wydaje mi się, że to najładniejsze auto z ich oferty – fakt, że Outlander po facelifcie wygląda beznadziejnie. Jeżeli miałbym dzisiaj kupić coś a’la Outlander to wybrałbym… Citroen’a C-Crossera – wszystko to co w Mitsu, ale… dużo lepszy silnik, za mniejsze pieniądze.

Comment on Waiting for 8.5 – Named function arguments by moltonel

moltonel — Tue, 17 Nov 2009 10:05:32 +0000

Hey Pavel, stop that ! You’ve just removed another reason to keep code outside of postgres ! How can I keep pretending that RDBMs are just “dumb data stores” now ?

/me is dancing around joyfully

Comment on Czemu jestem taki ułomny? (wylgaryzmy, polish only) by mrman

mrman — Mon, 16 Nov 2009 15:45:02 +0000

Mam dość podobnie jak Ty – i nigdy (z wyjątkiem wiercenia w ścianach) nie bawię się w robienie tego
własnoręcznie. WIem jaką to frustrację u mnie powoduje – więc wole naturalnie to wyoutsource’ować.
Wychodząc z prostego wniosku, że przy braku umiejętności (których nie mam za bardzo ochoty
nabywać) – święty spokój jest najwyższą wartością

Comment on Waiting for 8.5 – GUC per user and database by xor

xor — Mon, 16 Nov 2009 12:20:55 +0000

ALTER ROLE test2 IN database db2 SET search_path = ’something, really, cool’;

I’m waiting for this feature already about 3 years, because many programms does not work correctly with schemas e.g. GIS software etc. I’m using in one database 2 shemas ‘gis’ (PostGIS functions) AND ‘public’ (main database objects).
Thank You for good news

Comment on Czemu jestem taki ułomny? (wylgaryzmy, polish only) by merlin

merlin — Wed, 11 Nov 2009 19:05:28 +0000

Mniej hardcorowym rozwiązaniem są “korytka”
Bardziej hardcore to kucie pod kabelek i gipsowanie.
Wszystko się da zrobić nie takie rzeczy robiłem

Comment on Czemu jestem taki ułomny? (wylgaryzmy, polish only) by Marcin

Marcin — Tue, 10 Nov 2009 21:32:39 +0000

Errata: stary włącznik dał się wstawić przy odpowiednim nacisku.

Comment on Polish TSearch in 8.3 (polski tsearch w postgresie 8.3) by depesz

depesz — Tue, 10 Nov 2009 12:17:04 +0000

@Arpe: nie trzeba.

Comment on Polish TSearch in 8.3 (polski tsearch w postgresie 8.3) by Arpe

Arpe — Tue, 10 Nov 2009 12:15:36 +0000

witam,
czyli nie trzeba już wykonywać tsearch2 z contiba ?

pozdrawiam

Comment on Waiting for 8.4 – hash based DISTINCT by depesz

depesz — Mon, 09 Nov 2009 14:00:54 +0000

@Frank: yes. triggers on insert/update/delete on base table which generate dictionary table.

As for your other question – I have no idea. You can try to ask on pg-hackers list – it never bothered me.

Comment on Is there any good versioning package for database schema and/or data? by Misha

Misha — Mon, 09 Nov 2009 07:35:20 +0000

http://apgdiff.sourceforge.net/ – compares two schema dump files and creates output file that is (after some hand-made modifications) suitable for upgrade of old schema.

Comment on Waiting for 8.4 – hash based DISTINCT by Frank

Frank — Sun, 08 Nov 2009 23:50:40 +0000

Hi, what do you mean with dictionary table to make the distinct-query faster? Some kind of preprocessing?
Another question I´ve got is, how good the hash-function is to avoid collisions, while inserting the groups to the buckets?

Comment on Waiting for 8.5 – “GRANT ALL” by depesz

depesz — Sat, 07 Nov 2009 20:53:49 +0000

@Caleb:
# is just my prompt (actually it’s 2nd line of prompt in psql, which consits of “%# ” only.

as for upper/lower case – sorry, i type those commands by hand, so they usually are mixed case.

Comment on Waiting for 8.5 – “GRANT ALL” by Caleb Cushing ( xenoterracide )

Caleb Cushing ( xenoterracide ) — Sat, 07 Nov 2009 20:43:33 +0000

ah you’re right… yeah it is kinda misleading as # is usually a comment and SQL is usually caps. plus in other box’s the sql is capped making it inconsistent.

Comment on Waiting for 8.5 – “GRANT ALL” by Adrian Klaver

Adrian Klaver — Sat, 07 Nov 2009 20:41:55 +0000

I think the problem is that people are seeing:

# grant all on all tables in schema public to postgres;

as a comment because of the leading #, not as the statement being run.

Comment on Waiting for 8.5 – “GRANT ALL” by Caleb Cushing ( xenoterracide )

Caleb Cushing ( xenoterracide ) — Sat, 07 Nov 2009 20:41:52 +0000

6th box

# grant all on all tables in schema public to postgres;
GRANT

# grant all on all tables in schema public to depesz;
GRANT

# revoke all on table test2 from postgres;
REVOKE

# \z
Access privileges
Schema │ Name │ Type │ Access privileges │ Column access privileges
────────┼───────┼───────┼─────────────────────────┼──────────────────────────
public │ test1 │ table │ depesz=arwdDxt/depesz │
╷ ╷ ╎ postgres=arwdDxt/depesz ╷
public │ test2 │ table │ depesz=arwdDxt/depesz │
public │ test3 │ table │ depesz=arwdDxt/depesz │
╷ ╷ ╎ postgres=arwdDxt/depesz ╷
(3 rows)

Comment on Waiting for 8.5 – “GRANT ALL” by depesz

depesz — Sat, 07 Nov 2009 20:29:18 +0000

@PJMODOS: can’t replicate. I tried with 3 themes, and in all the commands are directly above “GRANT/REVOKE” replies.

could you send me screenshot, browser information, and exact source of page that you had while displaying? Including all external files – like styles.

Comment on Waiting for 8.5 – “GRANT ALL” by Adrian Klaver

Adrian Klaver — Sat, 07 Nov 2009 19:30:24 +0000

The GRANT,GRANT,REVOKE you are seeing is the return value from the command directly above.
As shown below
# grant all on all tables in schema public to postgres;
GRANT

Comment on Waiting for 8.5 – “GRANT ALL” by PJMODOS

PJMODOS — Sat, 07 Nov 2009 17:42:24 +0000

@gregj: Actually I wrote it, Tom commited it (with some polishing). And BTW I had to write it twice too

@Caleb: Nope, that table is only used to get privileges template when you are creating new table (sequence, view, …) so no performace penaly for queries.

@depesz: that code under “OK. Now, let’s grant some things:” contains GRANT, GRANT, REVOKE with nothing after them.

Comment on Waiting for 8.5 – “GRANT ALL” by depesz

depesz — Sat, 07 Nov 2009 17:02:38 +0000

@Caleb:
I don’t think there will be any performance penalty – after all, it just grant some privileges.

As for examples – not sure what you mean. i can see the sqls. which box you mean?

Comment on Waiting for 8.5 – “GRANT ALL” by Caleb Cushing ( xenoterracide )

Caleb Cushing ( xenoterracide ) — Sat, 07 Nov 2009 15:05:21 +0000

was anything added table wise? will this have any negative performance impacts? also aren’t your first examples supposed to include more than the words GRANT an REVOKE?

Comment on Waiting for 8.5 – “GRANT ALL” by gregj

gregj — Sat, 07 Nov 2009 12:44:55 +0000

I attempted to write it, twice – both times, refused by Tom. So finally he took the matter into his own hands. good man,

Comment on Czemu jestem taki ułomny? (wylgaryzmy, polish only) by mati

mati — Sat, 07 Nov 2009 00:34:52 +0000

Oj – więce niż rozumiem. W zasadzie – mógłbym wkleić Twoją notkę do siebie i zmienić podpis, a byłaby w 100% prawdziwa. U mnie szopki zaczynają się już na etapie pakowania prezentów na święta – a kabelki…tia. Albo się trzeba z tym pogodzić, albo ruszyć dupę i do tego też czytac manuale – ale, ja przynajmniej, natychmiast się zniechęcam.

Comment on Czemu jestem taki ułomny? (wylgaryzmy, polish only) by Krzychu

Krzychu — Wed, 04 Nov 2009 10:59:43 +0000

Jesli sciany sa betonowe/cementowe/kamienne polecam uzycie wiertarki i kolkow w ktore sie wkreca wkrety…