[GENERAL] Table Design: Timestamp vs time/date

I'm currently setting up a table to contain user login/logout information. Just wondered what would be more scalable??better to index,etc... Having a 'timestamp' field 'CCYY-MM-DD HH:MM:SS.SS' or two separate fields one for time 'HH:MM:SS.SS' and one for Date 'CCYY-MM-DD'. most queries will be o

Re: [GENERAL] pg_id: command not found

Thank you Tom, > Is /usr/lib/pgsql/bin in your PATH? Very easy. I mus have been blind... Maentime I found SuSE Linux supplies a package called pg_data???.rpm which includes the database files. Installing this seams to be the same as running initdb. After I installed the package I found the

Re: [GENERAL] foreign keys

> Not to mentions fact that in a few places in docs it's shown as a method > for copying table "SELECT... INTO" which does not "take" keys with it > leading to database knwoledge loss. That is a good point. SELECT INTO doesn't support constraints. Unfortunately, I don't really know a way around

[GENERAL] foreign keys

Could someone explain me some fact about FK handling in postgresql (7.0.2) ? 1. WHen I create table with foreign key to other one ( with ON UPDATE CASCADE), i get two constraints for created table: one for insert one for update. Additionaly there is created constraint (on rows deletion) in refere

Re: [GENERAL] libperl.so

Charles Tassell wrote: > There is also a way to recompile a .a library into a shared > library. Something like: > ar x library.a > ld -shared -o library.so *.o But a shared lib is _supposed_ to be compiled with position-independent code with -fPIC -- otherwise you are just asking for trouble t

Re: [GENERAL] libperl.so

i removed the perl rpm and installed perl 5.6.0 from source on a redhat 6.2 machine without problems. i went through a lot of extra steps to ensure cleanliness, however, which you may or may not be able to do. here's basically what i did: rpm -e mod_perl rpm -qa | grep piranha | xargs rpm -e r

Re: [GENERAL] libperl.so

There is also a way to recompile a .a library into a shared library. Something like: ar x library.a ld -shared -o library.so *.o It's documented somewhere, a web search on "convert shared library" will probably turn up some detailed documentation. At 11:52 PM 8/4/00, Alex Pilosov wrote: >O