On Friday 04 May 2007 22:12, Leah Kubik wrote:
> So I failed to copy my last reply to the list, but I did check and the user
> is loggin in as ledgersmb. I have tried creating a new database using this
> one as a template as the ledgersmb user, but I get the same errors with the
> new db. Doe any
On Wednesday 02 May 2007 13:15, Chris Travers wrote:
> Ok, Check the user record (in admin.pl) to see if you are logging in
> as ledgersmb.
So I failed to copy my last reply to the list, but I did check and the user is
loggin in as ledgersmb. I have tried creating a new database using this one
On Wednesday 02 May 2007 00:51, Chris Travers wrote:
> On 5/1/07, Leah Kubik <[EMAIL PROTECTED]> wrote:
> > Ok, so even though ledgersmb was the owner, it turned you you were
> > correct, the admin privs weren't set... I've gotten past that and now
> > I'm getting an error with the relation 'chart
On Tuesday 01 May 2007 17:40, Chris Travers wrote:
> Normally when this happens, the id sequence is listed in the error.
>
> Iirc, PostgreSQL bypasses certain permissions check for superusers,
> but not just based on ownership. So it is entirely possible that the
> ledgersmb owner does not have ap
Normally when this happens, the id sequence is listed in the error.
Iirc, PostgreSQL bypasses certain permissions check for superusers,
but not just based on ownership. So it is entirely possible that the
ledgersmb owner does not have appropriate permissions to the table.
Hence:
grant all on cha
Did you check permission for any of the sequences that may be attached
to the chart table? The only reason I ask is that I ran into a
situation recently where sequence permissions got changed and the error
seemed to point at table permissions as the culprit.
Charley
Leah Kubik wrote:
> On Tue
On Tuesday 01 May 2007 17:21, Chris Travers wrote:
> Check the owner of the table. It may be owned by Postgres while the
> user is ledgersmb.
The table is owned by the 'ledgersmb' user... So that's why I'm stumped...
> On 5/1/07, Leah Kubik <[EMAIL PROTECTED]> wrote:
> > I'm running LedgerSMB 1.
Hi Leah;
Check the owner of the table. It may be owned by Postgres while the
user is ledgersmb.
Best Wishes,
Chris Travers
On 5/1/07, Leah Kubik <[EMAIL PROTECTED]> wrote:
> I'm running LedgerSMB 1.2.2. I'm having trouble with one of my datasets if I
> try to update or create something in the
I'm running LedgerSMB 1.2.2. I'm having trouble with one of my datasets if I
try to update or create something in the chart of accounts:
DBD::Pg::st execute failed: ERROR: permission denied for relation chart
Error!
INSERT INTO chart
(accno, description, charttype,
gifi_accno, category, link, c
