Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. stoolpigeon

    Advice on upsizing from Access/VBA

    At my previous employer - I wrote a time and attendance system to replace a manual system that involved clocking in - literally - with time cards. I did a postgresql database, a php interface for users, and vb apps for administration and reporting. Postgres ran on linux - the odbc driver...
  2. stoolpigeon

    Separate directories for OpenOffice.org 2.1 apps?

    I think Tony is correct - and maybe he meant this by 'saved anywhere' but the default can be changed, though it will be the same across all components of the suite. Tools -> Options -> Paths And then edit "My Documents
  3. stoolpigeon

    Postgresql won't startup anymore

    when you say you downloaded the binaries and ran them - what exactly did you do. which files did you download - from where - and where did you put them?
  4. stoolpigeon

    Open Office and Microsoft Office 2002 on same machine.

    i've run OO.org next to many ms products including office and i don't think there is anything that would cause an issue. you may want to watch which program windows will default to for various extensions-- but that's not really a problem as much as something you deal with any time you have two...
  5. stoolpigeon

    Setting default 'using' parameters

    This blog entry: http://blogs.msdn.com/ansonh/archive/2006/02/22/537414.aspx is about how to remove default entries for c# classes, but I would think that it would work the other way around as well.
  6. stoolpigeon

    postgresql included in software package

    oh - and if you are really set on postgres- this might be helpful: http://www.macosxguru.net/article.php?story=20041119135924825
  7. stoolpigeon

    postgresql included in software package

    you can do a lot with postgres - and i'm not trying to be unhelpful - but have you considered HSQLDB? http://www.hsqldb.org/
  8. stoolpigeon

    Uninstall MEPIS Lite

    You don't need to uninstall it. You just install something else over it. If your computer is not booting to cd - that doesn't have anything to do with the OS. It should boot off the cd from bios before the OS ever gets loaded.
  9. stoolpigeon

    alter user password does NOT change password

    I would check pg_hba.conf and make sure that it is going to require a password.
  10. stoolpigeon

    distribution for an older computer

    My experience with distros is primarily with Fedora, but I would think that most of them allow you to start the install in text mode. That gets rid of your display issues while you install. Then once you have it running from the command line, take some time to properly set up X and you should...
  11. stoolpigeon

    Audit Schema

    Well, there are a lot of developers, and we want to know who does what. (I'm a junior dba - new to Oracle, in a decent sized shop using Oracle and Peoplesoft.) And if you don't mind while I've got you here. In my local install of 10g on my laptop, I created the following trigger while I was...
  12. stoolpigeon

    Audit Schema

    It looks that is the route I will be going. I set up a log table, and a trigger. The trigger inserts the following into the table. insert into sys.ddl_log (select ora_login_user, sysdate, ora_sysevent, ora_dict_obj_type, ora_dict_obj_owner, ora_dict_obj_name from dual...
  13. stoolpigeon

    Audit Schema

    I would like to know if it is possible to turn on auditing on all the objects in a schema at once. I have tried audit alter table on SCOTT by access whenever succesful; and I get an error, 'SQL command not properly ended' All the examples I find for this show the auditing being turned on for...
  14. stoolpigeon

    Update with select

    I've never done this personally. But I think that the information at: http://www.faqs.org/docs/ppbook/x7050.htm may point you in the right direction. It looks like you want to use FROM which is a non-standard extension of postgres. The example they have is at the very bottom of the page I've...
  15. stoolpigeon

    Python doesn't work

    Are the permissions set so that the file is executable? Here is a tutorial on chmod - the command to change permissions on a file. http://catcode.com/teachmod/
  16. stoolpigeon

    KDE session history is kept where???

    How this is all set up can be found here: http://www.kde.org/areas/sysadmin/startup.php Also- in the control center under kde components there is a session manager item that you can choose. I would imagine you could select the 'start with an empty session' option (and keep it that way if...
  17. stoolpigeon

    fedora postgresql data PGDATA out of the box it does not word. Please

    In Fedora your data directory should be in /var/lib/pgsql/ unless you have installed it somewhere else. I've never used RH9.0 but I'm not sure what that would have to do with this, unless you have copied over the Fedora startup script with the script from redhat 9.0. I'm not positive why you...
  18. stoolpigeon

    psql: FATAL 1: Permissions Denied error

    Normally you would install postgresql and you need to make sure postgres owns the pgsql and data directories. You have to run initdb as postgres and initdb creates the stuff in data- so ownership there should be fine. But in case something happened in between, start from that file, 1262, and...
  19. stoolpigeon

    initdb exists but refuses to run

    If you are used to dos, like me, you think that your current working directory will just work. gets me all the time. enjoy running the best free dbms in the world (i think so anyway)
  20. stoolpigeon

    TIME field with VB6 on a SQL statement

    put single quotes around the time where horav >= '12:25:15 p.m.' and see if that helps.

Part and Inventory Search

Back
Top