[GENERAL] default db

Hi, I see that the default encoding for a db is taken from template1. I'm using debian and I don't understand how to create template1 on installation of postgresql with a preferred encoding. Is it safe to just dump/restore template1 with different encoding? TIA *:-) -

[GENERAL] permission in the db or in the application?

he code Some days ago I read an e-mail of somebody that strongly opposed to using a db other than for ACID features. I'd like to hear from this list some thoughts on this subjects. thanks sandro *:-) -- Sandro Dentella *:-) http://www.tksql.orgTkSQ

[GENERAL] FK pointing to a VIEW

relation "mail_view" is not a table -- Sandro Dentella *:-) http://www.tksql.orgTkSQL Home page - My GPL work ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an ind

[GENERAL] Alias for tables/columns?

olumn with different names -sort of a symbolic link? Thanks in advance sandro *:-) -- Sandro Dentella *:-) http://www.tksql.orgTkSQL Home page - My GPL work ---(end of broadcast)--- TIP 5: don't forget to increase your

Re: [GENERAL] Simple OUTER JOIN doubt

On Fri, Oct 27, 2006 at 04:22:36PM -0500, Russ Brown wrote: > Sandro Dentella wrote: > > On Fri, Oct 27, 2006 at 02:42:06PM -0500, Russ Brown wrote: > >> Looks to me like it is because you're referencing vota_punteggio in the > >> WHERE clause. &

Re: [GENERAL] Simple OUTER JOIN doubt

2.03 rows=8 width=0) Index Cond: (user_id = 2) (8 righe) BTW: I'm no able to read explain output, but it's a long time I want to start studying them. I think I should start studying chapter 13, other hints on this subject? -- Sandro Dentella

[GENERAL] Simple OUTER JOIN doubt

x27;::regclass) voto| integer | not null user_id | integer | not null film_id | integer | not null -- Sandro Dentella *:-) e-mail: [EMAIL PROTECTED] http://www.tksql.orgTkSQL Home page - My GPL work ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Form builder?

t does. I'm working at this project at full time now, with the goal of releasing it within July, docs in August. sandro *:-) -- Sandro Dentella *:-) http://www.tksql.orgTkSQL Home page - My GPL work ---(end of broadcast)-

[GENERAL] How to bypass perm pb on information schema. Request of review

WHERE pg_catalog.pg_table_is_visible(c.oid) AND c.relname = :table_name AND c.relkind = 'r' ) AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum -- Sandro Dentella *:-) e-mail: [EMAIL PROTECTED] http://www.tksql.orgTkSQL Home page - My GPL work ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] best way to get PKey and FKey from inside applications (permission pb)

y would prefere to stick to the more standard information_schema. What would you guys suggest in this case? Thanks in advance sandro *:-) -- Sandro Dentella *:-) e-mail: [EMAIL PROTECTED] http://www.tksql.orgTkSQL Home page - My GPL work ---(end of broa