On 08/24/2012 10:31 PM, Tom Lane wrote:
Craig Ringer writes:
I didn't find a reasonable way to simply fetch a cursor into a (possibly
temporary) table, like:
INSERT INTO sometable FETCH ALL FROM somecursor;
Why would you bother with a cursor, and not just INSERT ... SELECT
using the original q
On 08/25/2012 04:29 AM, Jeremy Palmer wrote:
Marcus' guide looks great.
So what's the pros/cons of using the Kerberos via GSSAPI method, rather than
going for the SingleSignOn method mentioned by Sunday?
The method on the Ubuntu wiki applies to the host OS as a whole.
Pg will still need to k
And many others errors when xsome user connect to database x, schema
xxx. PG 8.4.
Problems started about same time as search_path has SET.
search_path has reset, but did'nt help.
ALTER DATABASE x SET search_path=some, public;
-- xxx wasn't in that list
ALTER DATABASE x RESET search_path; - has
On Fri, Aug 24, 2012 at 1:29 PM, Jeremy Palmer wrote:
> Marcus' guide looks great.
>
> So what's the pros/cons of using the Kerberos via GSSAPI method, rather
> than going for the SingleSignOn method mentioned by Sunday?
>
> Cons:
More complicated to set up.
There are a few odd things about AD
Em 24/08/2012 00:14, Craig Ringer escreveu:
On 08/24/2012 10:18 AM, Edson Richter wrote:
Dear friends,
Anyone has experienced extreme slowness running PostgreSQL 9.1.4 on
virtualized CentOS 5.8 on VMware ESXi 5.0 (with all Paravirtualized
drivers)?
https://wiki.postgresql.org/wiki/Slow_Query_
Jukka Inkeri writes:
> Only one group has this priviledge problem, xgroup.
> pg_log after tried to connect:
> 2012-08-25 11:39:36 EEST ERROR: permission denied for relation pg_database
> 2012-08-25 11:39:36 EEST STATEMENT: SET DateStyle=ISO;
> SELECT oid, pg_encoding_to_char(encoding) AS e
Le vendredi 24 août 2012 à 09:27 -0400, Sahagian, David a écrit :
> Is there any way for me to control the name of the (unique or primary)
> constraints that get created when doing a “create table like
> parent-table” statement ?
I suppose that you use 'INCLUDING CONSTRAINTS' in your LIKE clause,
On Mon, Aug 20, 2012 at 11:30 PM, Tom Lane wrote:
> Sebastien Boisvert writes:
> > Is this mechanism documented anywhere (besides source code)?
>
> No, not really.
>
> > It looks like PG will only clean it up if there's no other process
> running at all on the pid listed in the postmaster.pid fi
On 08/25/12 9:56 PM, Michael Clark wrote:
PID 8574 is actually iTunes, not PG, and PG was cleanly brought down
on it's last run, there are no children processes running.
when postgres is cleanly brought down, the postgresql.pid file is
supposed to be removed. that file contains the PID that
