Re: Ugh...deleting a Vendor Invoice

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

(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