IRC log for #evergreen, 2014-05-31

All times shown according to the server's local time.

Time	Nick	Message
00:00		dbwells joined #evergreen
04:56	pinesol_green	Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
05:31		tfaile_ joined #evergreen
05:37		BigRig_ joined #evergreen
05:40		mtcarlsoz joined #evergreen
05:40		jeff__ joined #evergreen
05:40		Dyrcona1 joined #evergreen
10:39	Dyrcona	Well, that's messed up.
10:41		jwoodard joined #evergreen
10:43	Dyrcona	Nice. Looks like Pg is removing the schema qualification on constraint functions if its in the search path.
13:38		kbeswick joined #evergreen
13:46	jeff__	removing when?
13:46		jeff joined #evergreen
13:53	pastebot	"Dyrcona" at 64.57.241.14 pasted "jeff: I ran this" (6 lines) at http://paste.evergreen-ils.org/57
13:54	Dyrcona	And, the constraint looks like this: "valid_z3950_attr_type" CHECK (z3950_attr_type IS NULL OR z3950_attr_name_is_valid(z3950_attr_type))
13:54	Dyrcona	No evergreen. in there.
14:25	jeff	okay, so we need to not only schema-qualify things, we also need to ensure that the evergreen schema is NOT in the search path, which also means ensuring that your db user isn't named "evergreen"? :P
14:26	jeff	i wonder if that's an intentional change in postgresql (i'm assuming it's a change) or a bug.
14:26	jeff	Dyrcona: what is your postgres version in this case?
14:27	Dyrcona	9.1.11
14:39	Dyrcona	jeff: my db user is named opensrf, btw.
14:40	Dyrcona	I recall reading a blog post a while ago, something about "search_path considered harmful."
14:43	Dyrcona	Ah no, it was an email thread from 2006: http://postgresql.1045698.n5.nabble.com/set-search-path-in-dump-output-considered-harmful-td1947594.html
14:49	jeff	yeah, pretty sure i came across that in my digging on search path also.
15:24		bmills joined #evergreen
17:29	pinesol_green	Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
21:51		DPearl1 joined #evergreen