Chris Travers wrote: > You are not connected to the right database ;-) The prompt below > suggests you omitted the dbname and connected to the "postgres" > database. > > psql -U postgres [dbname]
psql -U postgres [dataset name] :) J > > Best Wishes, > Chris Travers > > On 3/15/07, Matt Jackson <[EMAIL PROTECTED]> wrote: >> Chris, >> >> Tried it and got: >> >> postgres=# UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans'; >> ERROR: relation "defaults" does not exist >> >> Any idea why? >> >> - Matt >> >> >> >> On 3/15/07, Chris Travers <[EMAIL PROTECTED]> wrote: >>> In 1.2.0rc4, the problem does not appear to occur. It may be a but >>> with saving the appropriate setting (this part of the software got >>> some serious work done on it in 1.2). If you are using the debian >>> package, we expect to have an rc4 package available soon. otherwise, >>> you can upgrade and see if the problem goes away. >>> >>> Otherwise you may try (in psql): >>> UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans'; >>> >>> Best Wishes, >>> Chris Travers >>> >>> >>> On 3/15/07, Matt Jackson <[EMAIL PROTECTED]> wrote: >>>> Will be interested to see what you find. Everything else seems to work >> fine. >>>> So frustrating not being able to delete an invoice lol, especially for >>>> someone learning. :) >>>> >>>> Thanks!! >>>> >>>> - Matt >>>> >>>> >>>> >>>> >>>> On 3/15/07, Chris Travers <[EMAIL PROTECTED]> wrote: >>>>> Ok, testing in 1.2.0rc4 >>>>> >>>>> On 3/15/07, Matt Jackson <[EMAIL PROTECTED]> wrote: >>>>>> Chris, >>>>>> >>>>>> I am running >>>>>> Version 1.2.0 Release Candidate 1 >>>>>> >>>>>> Thanks, >>>>>> Matt >>>>>> >>>>>> >>>>>> >>>>>> On 3/15/07, Chris Travers < [EMAIL PROTECTED]> wrote: >>>>>>> Hi Matt; >>>>>>> Which version are you running? >>>>>>> >>>>>>> Best Wishes, >>>>>>> Chris Travers >>>>>>> >>>>>>> On 3/15/07, Matt Jackson <[EMAIL PROTECTED]> wrote: >>>>>>>> Hmmm! >>>>>>>> >>>>>>>> When I try to set "Enforce Transaction Reversals for all dates" >> to >>>> "No," >>>>>> it >>>>>>>> just pops back to Yes when I check it again...it doesn't stay >> set! >>>>>> However, >>>>>>>> when I switch Activate Audit Trail to Yes or No, those stick! >>>>>>>> >>>>>>>> lol...that seems to be my problem...any idea on how to fix that? >>>>>>>> >>>>>>>> - Matt >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On 3/15/07, Ashley J Gittins < >>>>>>>> [EMAIL PROTECTED]> wrote: >>>>>>>>> On Thu, 15 Mar 2007, Matt Jackson wrote: >>>>>>>>>> All I see on my buttons is "Post as New" which then >> duplicates >>>> it >>>>>>>> modified >>>>>>>>>> in the system. >>>>>>>>>> >>>>>>>>>> Any ideas? >>>>>>>>> Hi Matt, >>>>>>>>> If you have reversal enforced (system menu I think) >> then >>>> there >>>>>>>> will be >>>>>>>>> a "delete" button at the bottom. >>>>>>>>> >>>>>>>>> To do a reversal, open the original invoice, change the qty's >> and >>>>>> invoice >>>>>>>>> number as described, update (always update if in doubt) then >> "post >>>> as >>>>>>>> new". >>>>>>>>> -- >>>>>>>>> Regards, >>>>>>>>> Ashley J Gittins >>>>>>>>> web: >> http://www.purple.dropbear.id.au >>>>>>>>> jabber: [EMAIL PROTECTED] >>>>>>>>> >>>>>>>>> >> ------------------------------------------------------------------------- >>>>>>>>> Take Surveys. Earn Cash. Influence the Future of IT >>>>>>>>> Join SourceForge.net's Techsay panel and you'll get the chance >> to >>>>>> share >>>>>>>> your >>>>>>>>> opinions on IT & business topics through brief surveys-and >> earn >>>> cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ >>>>>>>>> Ledger-smb-users mailing list >>>>>>>>> [email protected] >>>>>>>>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Regards, >>>>>>>> Matt >>>>>>>> >> ------------------------------------------------------------------------- >>>>>>>> Take Surveys. Earn Cash. Influence the Future of IT >>>>>>>> Join SourceForge.net's Techsay panel and you'll get the chance >> to >>>> share >>>>>> your >>>>>>>> opinions on IT & business topics through brief surveys-and earn >> cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>>>>>> _______________________________________________ >>>>>>>> Ledger-smb-users mailing list >>>>>>>> [email protected] >>>>>>>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >>>>>>>> >>>>>>> >> ------------------------------------------------------------------------- >>>>>>> Take Surveys. Earn Cash. Influence the Future of IT >>>>>>> Join SourceForge.net's Techsay panel and you'll get the chance to >>>> share >>>>>> your >>>>>>> opinions on IT & business topics through brief surveys-and earn >> cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>>>>> _______________________________________________ >>>>>>> Ledger-smb-users mailing list >>>>>>> [email protected] >>>>>>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >>>>>> >>>>>> >>>>>> -- >>>>>> Regards, >>>>>> Matt >>>>>> >> ------------------------------------------------------------------------- >>>>>> Take Surveys. Earn Cash. Influence the Future of IT >>>>>> Join SourceForge.net 's Techsay panel and you'll get the chance to >> share >>>> your >>>>>> opinions on IT & business topics through brief surveys-and earn cash >>>>>> >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>>>> _______________________________________________ >>>>>> Ledger-smb-users mailing list >>>>>> [email protected] >>>>>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >>>>>> >>>>> >> ------------------------------------------------------------------------- >>>>> Take Surveys. Earn Cash. Influence the Future of IT >>>>> Join SourceForge.net's Techsay panel and you'll get the chance to >> share >>>> your >>>>> opinions on IT & business topics through brief surveys-and earn cash >>>>> >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>>> _______________________________________________ >>>>> Ledger-smb-users mailing list >>>>> [email protected] >>>>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >>>> >>>> >>>> -- >>>> Regards, >>>> Matt >>>> >> ------------------------------------------------------------------------- >>>> Take Surveys. Earn Cash. Influence the Future of IT >>>> Join SourceForge.net 's Techsay panel and you'll get the chance to share >> your >>>> opinions on IT & business topics through brief surveys-and earn cash >>>> >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>> _______________________________________________ >>>> Ledger-smb-users mailing list >>>> [email protected] >>>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >>>> >>> >> ------------------------------------------------------------------------- >>> Take Surveys. Earn Cash. Influence the Future of IT >>> Join SourceForge.net's Techsay panel and you'll get the chance to share >> your >>> opinions on IT & business topics through brief surveys-and earn cash >>> >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>> _______________________________________________ >>> Ledger-smb-users mailing list >>> [email protected] >>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> >> >> -- >> Regards, >> Matt >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to share your >> opinions on IT & business topics through brief surveys-and earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ >> Ledger-smb-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> >> > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
