On Sun, Feb 14, 2010 at 1:06 PM, Hugh Esco
wrote:
> Hey folks:
>
> cat /usr/local/ledgersmb13/VERSION says I'm using: 1.2.99
>
> At this step, I see:
> postg...@martin:~$ psql -U postgres -d lsmb2 -t -c "INSERT INTO entity (name,
> entity_class, created) VALUES ('hesco', 3, NOW()) RETURNING name,
Hey folks:
cat /usr/local/ledgersmb13/VERSION says I'm using: 1.2.99
At this step, I see:
postg...@martin:~$ psql -U postgres -d lsmb2 -t -c "INSERT INTO entity (name,
entity_class, created) VALUES ('hesco', 3, NOW()) RETURNING name, entity_class,
created;"
ERROR: null value in column "country
Note that creates the Pg user as well, but does not assign roles. If
you want to assign roles, you have to either grant them separately or
use select admin__add_user_to_role(username, rolname);
lsmb13=# \df admin__add_user_to_role
List of functions
Schema
There's a better way than inserting into the tables directly.
select person__save(NULL, 3, 'Chris', 'R', 'Travers', 232);
The second argument is the salutation id.
lsmb13=# select * from salutation;
id | salutation
+
1 | Dr.
2 | Miss.
3 | Mr.
4 | Mrs.
5 | Ms.
6 | Sir
Hello Armaghan,
I ran into the same problem this morning. This is not a fix, but
changing entity_id to 1 allowed me to add a user into the person
table:
psql -U postgres -d mycompany -t -c "INSERT INTO person (entity_id,
first_name, last_name, created) VALUES (1, 'Firstname', 'Lastname',
NOW())
Hi all,
I am encountering following error during 1.3 install:
Running "Insert myuser Person" sql:
ERROR: insert or update on table "person" violates foreign key
constraint "person_entity_id_fkey"
DETAIL: Key (entity_id)=(2) is not present in table "entity".
It seems that I have missed some st
