Re: Ugh...deleting a Vendor Invoice

["Matt Jackson" <..hidden..>]

Chris,

OK came up with:

ledger-smb=# select u.username, c.dbname from users u, users_conf c where c.id = u.id;
 username |    dbname    
----------+--------------
 admin    | 
 matt     | monshishismb
(2 rows)

So I am guessing that the dataset is "monshishismb" instead of the stuff I was doing before, eh?

I logged in using 

psql -U posgres monshishismb

ran the command and got:

UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans';
UPDATE 1

so it was succesful, I'm guessing.

I checked the "Enforce transaction reversal for all dates" and it came up with NO!

Excellent!!

Thank you so much.

So I guess I was confused...the database is the big "container" and the dataset is a sub-database type of a thing?

Thanks again,
Matt

On 3/15/07, Chris Travers <..hidden..> wrote:

Ok, can you run the following query for me:

select u.username, c.dbname from users u, users_conf c where c.id = u.id;

Best Wishes;
Chris Travers

On 3/15/07, Matt Jackson <..hidden..> wrote:
> (This message bounced due to size, so resending)
>
> First did:
>
> ..hidden.. :/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=# \d
>                     List of relations
>  Schema |          Name          |   Type   |   Owner
> --------+---------------------
> ---+----------+------------
>  public | session                | table    | ledger-smb
>  public | session_session_id_seq | sequence | ledger-smb
>  public | users                  | table    | ledger-smb
>  public | users_conf             | table    | ledger-smb
>  public | users_id_seq           | sequence | ledger-smb
> (5 rows)
>
>
> Then did:
>
> ..hidden..:/home/mythtv$ psql 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=# \d
>                     List of relations
>  Schema |          Name          |   Type   |   Owner
> --------+------------------------+----------+------------
>  public | session                | table    | ledger-smb
>  public | session_session_id_seq | sequence | ledger-smb
>  public | users                  | table    | ledger-smb
>  public | users_conf             | table    | ledger-smb
>  public | users_id_seq           | sequence | ledger-smb
> (5 rows)
>
> ledger-smb=#
>
>
> Regards,
>
> On 3/15/07, Chris Travers <..hidden.. > wrote:
> > 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 <..hidden.. > wrote:
> > > I must be cursed:
> > >
> > > ..hidden..:/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
>
> -------------------------------------------------------------------------
> 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
> ..hidden..
> 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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

-- 
Regards,
Matt