Ok, that is weird.... Try (in the same db): \d And send us the results.
If you want to send it to a file, you can go: \o filename \d \q (to quit) Best wishes, Chris Travers On 3/15/07, Matt Jackson <[EMAIL PROTECTED]> wrote: > I must be cursed: > > [EMAIL PROTECTED]:/home/mythtv$ psql -U ledger-smb ledger-smb > Welcome to psql 8.1.8, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help with psql commands > \g or terminate with semicolon to execute query > \q to quit > > ledger-smb=# UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans'; > ERROR: relation "defaults" does not exist > > > [EMAIL PROTECTED]:/home/mythtv$ psql -U postgres ledger-smb > Welcome to psql 8.1.8, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help with psql commands > \g or terminate with semicolon to execute query > \q to quit > > ledger-smb=# UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans'; > ERROR: relation "defaults" does not exist > > > Any ideas? I thought I named my dataset ledger-smb and my username was > ledger-smb...that is what I used thru the install process... > > - Matt > > > > On 3/15/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > -- > 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
