leaf_yxj wrote:
> My bosses ask me to list
>
> 1)all the users and the roles associated with the users.
This will list all roles in the cluster, whether they can login
(are users) or not, and the array of all roles they are directly
or indirectly members of:
WITH RECURSIVE is_member_of(member, r
On 02/04/2012 01:52, Martin Gregorie wrote:
> BTW, why use document_chunks when a text field can hold megabytes,
> especially if they will be concatenated to form a complete document
> which is then edited as a whole item and before being split into chunks
> and saved back to the database?
... b
:) yah that makes sense no big deal. i'll probably just push this head
buiild of pg_dump onto the production machines till it comes out.
Thanks again!
On Sat, Mar 31, 2012 at 3:44 PM, Tom Lane wrote:
> Mike Roest writes:
> > Any idea when 9.1.4 with this change will be out so we can pull the
On 04/01/2012 10:10 PM, Albert wrote:
*i get:*
Syntax error at or near 'WHEN'
LINE 1: ... check_update AFTER UPDATE ON accounts FOR EACH ROW WHEN
(OLD.balance IS DISTINCT FROM NEW.balance)
Hmmm. So two questions:
What happens if you copy the example in the docs exactly and use NEW.*
and
I've installed PostgreSQL using one click installer on Mac OS X Lion.
I'd like to query this server from the net.
How to allow specific IPV6 addresses to connect to the databases
'addressbook', 'cli', 'landp' and 'landp_public' ?
I've tested a simple solution using ssh port forwarding :
$ ssh -
Albert writes:
> *i get:*
> Syntax error at or near 'WHEN'
> LINE 1: ... check_update AFTER UPDATE ON accounts FOR EACH ROW WHEN
> (OLD.balance IS DISTINCT FROM NEW.balance)
Does the BEFORE case work for you either? I'm suspicious that you
are using a PG version that predates WHEN-clause su
Hello.
I've tried asking this on the irc channel, without much success.
I'm trying to define a "weighted mean" aggregate using postgresql create
aggregate feature.
I've been able to quickly write the required pgsql code to get it
working, but after testing it on a sample 1 rows table, it see
In Windows PostgreSQL spawns numerous postgres.exe processes. When you
look at the actual command line you see the command that started the
process. For example: "c:/PostgreSQL/8.4/bin/postgres.exe" "--forkbackend"
"1372"
My questions
1. In the example above does 1372 represent a port?
2. If
Ronan Dunklau writes:
> I'm trying to define a "weighted mean" aggregate using postgresql create
> aggregate feature.
> I've been able to quickly write the required pgsql code to get it
> working, but after testing it on a sample 1 rows table, it seems to
> be approximately 6 to 10 times slow
Moving from hackers
Begin forwarded message:
> From: Jay Levitt
> Date: April 2, 2012 5:17:07 MST
> To: Dave Page
> Cc: PG Hackers
> Subject: Re: [HACKERS] Switching to Homebrew as recommended Mac install?
>
>
> This goes back to the "marketing challenge, not technical challenge" threads.
>
Moving from Hackers as well...
Begin forwarded message:
> From: Jay Levitt
> Date: April 2, 2012 9:02:49 MST
> To: David Johnston
> Cc: Tom Lane , PG Hackers
> Subject: Re: [HACKERS] Switching to Homebrew as recommended Mac install? /
> apology
>
>
>
> Nothing at this point. I was thinkin
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of br...@concena.com
Sent: Monday, April 02, 2012 8:39 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgres.exe on windows format on command line that
starts the process
In Windows Postg
Hello. What is the difference between Sequential Scans and Sequential Tuples
Read?.
Thank you.
On Mon, Apr 2, 2012 at 12:30 PM, Efraín Déctor
wrote:
> Hello. What is the difference between Sequential Scans and Sequential
> Tuples Read?.
A sequential scan is what happens when the table is read sequentially.
One sequential scan can result in MANY tuples being read
sequentially. I.e. a tab
Thank you.
-Mensaje original-
From: Scott Marlowe
Sent: Monday, April 02, 2012 1:33 PM
To: Efraín Déctor
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sequential Scans
On Mon, Apr 2, 2012 at 12:30 PM, Efraín Déctor
wrote:
Hello. What is the difference between Sequential Sc
Hi,
what about this:
SELECT p.rolname, m.rolname as member, g.rolname as grantor
FROM pg_authid p
INNER JOIN pg_auth_members am ON (p.oid = am.roleid)
INNER JOIN pg_authid m ON (am.member = m.oid)
INNER JOIN pg_authid g ON (am.grantor = g.oid)
You can use proper WHERE to filter results.
Regard
I tried to create function to truncate table
1) when the user call the function just specify the tablename
2) the user can use the function owner privilege to execute the function.
But I got the errors as follows. Please help me to take a look.
Thanks.
Regards.
Grace
-- function :
CREA
Hello
" IF stmt IN statements then " is nonsense.
use trapping exceptions instead
BEGIN
EXECUTE 'TRUNCATE TABLE ' || quote_ident(_tablename) || ' CASCADE';
EXCEPTION WHEN undefined_table THEN
RAISE EXCEPTION 'your own exception, when you like';
END;
Regards
Pavel
2012/4/2 leaf_yxj :
> I
That is right, there is no sense to use cursors here...
CREATE OR REPLACE FUNCTION truncate_t (IN tablename text)
RETURNS VOID
AS
$$
BEGIN
EXECUTE 'TRUNCATE TABLE ' || quote_ident(tablename) || 'CASCADE;';
EXCEPTION
WHEN undefined_table THEN
RAISE EXCEPTION 'Table "%" does not exists', tablename
i have a server in the ec2 cloud which in theory is set up as a master; it
starts and runs. i've got an amazon s3 bucket mounted using s3fs on both the
master and the standby (the standby is also set up in the ec2 cloud.)
i followed the steps here: http://wiki.postgresql.org/wiki/Streaming_Repli
I have this query:
SELECT ST_Distance(transform(geometryfromtext('POINT(-97.096667
18.858611)',4326),32614),C.point_geomutm)
AS DIST ,nombre FROM ciudad AS C ORDER BY DIST ASC limit 1;
It runs a secuential query on the table “ciudad” wich is a big table. I want to
create an index but I don’t k
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Efraín Déctor
Sent: Monday, April 02, 2012 5:40 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Where to create an Index
I have this query:
SELECT ST_Distance(transform(geometryfromt
Hello. Thanks for your answer.
I have the following Index:
CREATE INDEX index_pointgeomutm_ciudad
ON ciudad
USING btree_gist
(point_geomutm);
But the query is not using it.
From: David Johnston
Sent: Monday, April 02, 2012 5:04 PM
To: 'Efraín Déctor' ; pgsql-general@postgresql.org
Subject: RE: [
On Mon, Apr 2, 2012 at 4:21 PM, Welty, Richard wrote:
I got similar messages the first few times I tried to start up my slave
server, I never did figure out exactly what caused it.
You can either delete all the files on the slave and try again, or do what
I did, write a script that handles trans
On Mon, Apr 2, 2012 at 6:19 PM, Michael Nolan wrote:
>
>
>
> I got similar messages the first few times I tried to start up my slave
> server, I never did figure out exactly what caused it.
>
>
One possibility is that I may not have restarted the master server after
changing the postgresql.conf f
On 2 Apr 2012, at 22:28, Bartosz Dmytrak wrote:
> That is right, there is no sense to use cursors here...
I think you're wrong there: The OP is querying a system table for tables of a
certain name, which I expect can contain multiple rows for tables of the same
name in different schema's.
Of c
On 2 Apr 2012, at 22:02, leaf_yxj wrote:
> CREATE OR REPLACE FUNCTION truncate_t(tablename IN VARCHAR) RETURNS void AS
> $$
> DECLARE
> stmt RECORD;
> statements CURSOR FOR SELECT tablename FROM pg_catalog.pg_tables;
> BEGIN
> IF stmt IN statements then
> EXECUTE 'TRUNCAT
On 03/29/2012 06:57 AM, Maxim Boguk wrote:
Is there any real reason why checkpoint_timeout limited to 1hour?
Just to keep people from accidentally setting a value that's dangerously
high. There can be some pretty bad drops in performance if you let
writes pile up for too long, once the check
28 matches
Mail list logo
