Re: Ugh...deleting a Vendor Invoice

["Chris Travers" <..hidden..>]

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