On Monday, February 28, 2011 9:15:27 am Tom Lane wrote:
> Adrian Klaver writes:
> > I understand, yet I don't:) Seems I have a misconception of the the
> > FOREIGN KEY process. The error was on the query below, which I am
> > taking is the query you refer to above. To me it looks like a look up
>
Adrian Klaver writes:
> I understand, yet I don't:) Seems I have a misconception of the the
> FOREIGN KEY process. The error was on the query below, which I am
> taking is the query you refer to above. To me it looks like a look up
> from the referencing(permout) table to the referenced(out2cp) on
On Monday, February 28, 2011 8:17:07 am Tom Lane wrote:
> Adrian Klaver writes:
> > On Monday, February 28, 2011 8:02:53 am Tom Lane wrote:
> >> Right. But actually, that query will be run with the permissions of the
> >> owner of the table, so it's that user (not necessarily the one doing the
>
On 28.2.2011 17:02, Tom Lane wrote:
you don't have permissions to verify the FK constraint. the query you
see in the error is exactly this test.
Right. But actually, that query will be run with the permissions of the
owner of the table, so it's that user (not necessarily the one doing the
INS
Adrian Klaver writes:
> On Monday, February 28, 2011 8:02:53 am Tom Lane wrote:
>> Right. But actually, that query will be run with the permissions of the
>> owner of the table, so it's that user (not necessarily the one doing the
>> INSERT) who lacks permissions.
> The OP listed the permissions
On Monday, February 28, 2011 8:02:53 am Tom Lane wrote:
> Vick Khera writes:
> > On Mon, Feb 28, 2011 at 9:37 AM, Borek Lupomesky wrote:
> >>"permout_site_fkey" FOREIGN KEY (site, cp) REFERENCES out2cp(site,
> >> cp) ON DELETE CASCADE
> >
> > you don't have permissions to verify the FK const
Vick Khera writes:
> On Mon, Feb 28, 2011 at 9:37 AM, Borek Lupomesky wrote:
>> "permout_site_fkey" FOREIGN KEY (site, cp) REFERENCES out2cp(site, cp) ON
>> DELETE CASCADE
> you don't have permissions to verify the FK constraint. the query you
> see in the error is exactly this test.
Right.
On Monday, February 28, 2011 6:37:51 am Borek Lupomesky wrote:
> Hello,
>
> I have a database app that worked fine until we reinstalled the
> server with the related DB dump and restore. Most of the stuff works
> fine after the reinstall, but one particular insert gives very cryptic
> (for me)
On Feb 28, 2011, at 8:07 PM, Borek Lupomesky wrote:
> spam=> INSERT INTO permout ( site, cp, owner, descr, creat_who ) VALUES (
> 'vin', '3035.1', 'borelupo', 'test', 'borelupo' );
> ERROR: permission denied for relation out2cp
> CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."out2cp" x W
In response to Rob Sargent :
> On 02/28/2011 07:37 AM, Borek Lupomesky wrote:
> > Hello,
> >
> >I have a database app that worked fine until we reinstalled the
> > server with the related DB dump and restore. Most of the stuff works
> > fine after the reinstall, but one particular insert give
On Mon, Feb 28, 2011 at 9:37 AM, Borek Lupomesky wrote:
> "permout_site_fkey" FOREIGN KEY (site, cp) REFERENCES out2cp(site, cp) ON
> DELETE CASCADE
>
you don't have permissions to verify the FK constraint. the query you
see in the error is exactly this test.
--
Sent via pgsql-general mailin
On 02/28/2011 07:37 AM, Borek Lupomesky wrote:
> Hello,
>
>I have a database app that worked fine until we reinstalled the
> server with the related DB dump and restore. Most of the stuff works
> fine after the reinstall, but one particular insert gives very cryptic
> (for me) message:
>
> sp
Hello,
I have a database app that worked fine until we reinstalled the
server with the related DB dump and restore. Most of the stuff works
fine after the reinstall, but one particular insert gives very cryptic
(for me) message:
spam=> INSERT INTO permout ( site, cp, owner, descr, creat_w
13 matches
Mail list logo
