good editor:
Usually emacs does a good job, but postgres puts a stored procedure between ' and ' and this turns off any font-lock highlighting for the entire stored procedure. Can I use something other than quotes or fix this somehow? Is there a better editor?
preprocessor:
I saw one reference to people running stuff through the C-preprocessor before importing into their DB. Is this common practice? I don't see a huge benefit for it yet unless I want to support multiple DBs.
file-names:
I know it doesn't matter, but mostly it seems to make sense to put stuff in .sql files. I've seen some reference to people putting stuff in .sp files. What works best for people in terms of organization?
packages:
I saw there was a patch to support oracle-style packages in postgres back in ~2001, but I saw nothing else. Is this planned? I imagine I could use 'schemas', but I don't think this lets me share variables and I think these are more for splitting up table name-spaces than for associating a group of functions.
other: Any other suggestions?
Thanks.
Eric Brown 408-571-6341 www.propel.com
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
