Hi everyone,
I'm having a strange issue on PostgreSQL 9.0.1 on Windows Server 2003
SP2.
I connect as a superuser and then SET SESSION AUTHORIZATION to user
"X" who is a member of group role "extranet_user" which inherits
membership from group role "user". "X", "extranet_user", and even
"user" ar
On Nov 1, 4:39 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Kevin Field writes:
> > Strange, no? Anybody have any ideas why this might be?
>
> Worksforme:
>
> regression=# create group "user";
> CREATE ROLE
> regression=# create group extranet_user in gro
> My guess is that it has something to do with the join to the table
> 'mandate'. If your view definition includes a CASE WHEN... that would
My new guess is something to do with permissions being cached
somewhere, because this morning when I tried it (SET followed by
SELECT from page_startup) fro
When I use spi_prepare and spi_exec_prepared on a query that selects a
boolean value, it comes back as the text 't' or 'f', which in perl
both evaluate to true, so I have to either use perl to solve that or
cast to integer in the query, both of which options seem less than
elegant. Is this a bug o
On Jun 8, 5:18 am, laurenz.a...@wien.gv.at ("Albe Laurenz") wrote:
> Kev wrote:
> > I came across this curious behaviour today, at least in the 2009-03-24
> > beta (I can't run a newer beta), that I couldn't find in the docs,
> > although maybe I missed it.
>
> [...]
>
> > So while that is the way
This is a cross-post from
http://stackoverflow.com/questions/21238209/info-output-despite-set-client-min-messages-to-warning-just-before
since I'm not getting any answers there yet.
With postgresql-9.0.15 on CentOS 6.5 (accessed via pgAdminIII 1.18.1 on
Win2003), I have a plperlu function that
Why not use NOTICE? INFO is supposed to be used for things the user
*requested* to see (for example, by supplying the "verbose" option to one
of the commands which take that option).
The documentation could be clearer on this, but it seems to suggest that
there is no way to turn off INFO to th
> Kev <[EMAIL PROTECTED]> writes:
> > ...because the case should force it to only evaluate 'old' when
> > TG_OP
> > = 'UPDATE' and otherwise ('INSERT') skip through to 't'. But this
> > causes the same error on insert. I suspect it's because the select
> > query gets parameterized and at that p
On Apr 2, 6:48 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Kev writes:
> > For some reason, which I couldn't see spelled out very well in the
> > docs for GRANT ROLE and SET ROLE,indirectmembership in the group
> > "user" doesn't give one its privileges unless you SET ROLE "user"
> > first, even if
Hi everyone,
I just came across a thread in the pgsql archives from October 2000, and found
this post particularly interesting:
http://archives.postgresql.org/pgsql-sql/2000-10/msg00044.php
...because I had already been designing something similar but on a larger
scale, for an integrated infor
I've run into this issue a bit...
Do you mean, it's in the DB okay, but when it comes back to the client it
breaks your transport mechanism (say, if you use JSON)? So far I've just been
using a replace...if you find another way I'd love to hear it. (Because I also
have to escape quotes and ba
http://archives.postgresql.org/pgsql-hackers/2004-01/msg00861.php
(Just to dredge up another old thread...)
While its true that a post-commit operation cannot modify a database, it
might still for instance propagate the outcome of the transaction to another
resource outside of the database, it
This part...
> repeated roughly once a minute. I've never seen this before. this is
...might mean some connection with autovacuum, maybe? I have no clue beyond
that. Hope things go well for you.
Kev
---(end of broadcast)---
TIP 2: Don't 'kill
> On 22 Mar 2007 14:58:15 -0700, Kev <[EMAIL PROTECTED]> wrote:
> > Hi everyone,
> >
> > I'm still in the design phase of a project. I was just wondering if
> > anyone has any thoughts or experience on the idea of cutting the P out
> > of the LAMP (or in my case, WAMP for now) stack. What I mean
Hi Kenneth,
This is wonderful news. I will definitely be checking into it as soon as I
have a moment. Thanks!
Kev
> Kev, we have a GPL'd product targeting Postgres that has significant
> overlap with what you want, though in other areas we went in another
> direction. The site is www.andro
15 matches
Mail list logo
