[SQL] How to check: is some key referenced from sometable

2003-08-10 Thread evl
Please help. Need a boolean function which returns true if given key in table is referensed from another table(s). --- see You again when ... eVl ---(end of broadcast)--- TIP 5: Have you checked our extensiv

[SQL] PostgreSQL and Journaled File Systems

2003-08-10 Thread Roberto Mello
Hi All, What is the word about using PG with journaled file systems? I have heard that it's best to not have the PG journal in a journaled system to avoid double journaling. Can someone that understand the issues involved (performance, reliability) please shed some light on the issue? Thanks in

Re: [SQL] looking for empty fields

2003-08-10 Thread Viorel Dragomir
Title:   - Original Message - From: Jodi Kanter To: Postgres SQL List Sent: Wednesday, August 06, 2003 5:07 PM Subject: [SQL] looking for empty fields We recently upgraded from version 7.2.3 to 7.3.3 and seem to have some

Re: [SQL] JDBC encoding problem

2003-08-10 Thread Kurt Overberg
It seems like I was able to get it to work with UTF-8. I found this nifty little page: http://www.anassina.com/struts/i18n/i18n.html which explained how to handle this within Jakarta Struts. It SEEMS like when reading the data from the database I don't need to explictly convert it to UTF-8, i