On Tue, 2013-06-11 at 14:05 -0700, Joe Van Dyk wrote:
> # select tsrange(null)::tstzrange;
> ERROR: cannot cast type tsrange to tstzrange
> LINE 1: select tsrange(null)::tstzrange;
>
I agree that there should be a cast between tsrange and tstzrange.
Unfortunately, this cant work generally for al
User 'test' is allow to connect to 'postgres' because by default it gets that
permission.
The default is no public access for
tables, columns, schemas, and tablespaces; CONNECT privilege and TEMP
table creation privilege for databases; EXECUTE privilege for functions; USAGE
privilege for l
David Carpio wrote
> Thank you for your time
You're not likely to get too many if any takers who want to try and decipher
that mess you call a query/explain. Especially since you've made it pretty
much impossible to read by removing/obfuscating information. It is not
self-contained and we have n
On Fri, Jun 28, 2013 at 1:16 PM, Kenneth Tilton wrote:
> We want to make sure no two examiners are working on the same case at the
> same time, where the cases are found by searching on certain criteria with
> limit 1 to get the "next case".
>
I've been using this pattern for about 14 years with
On Thu, Jul 4, 2013 at 4:22 PM, Michael Paquier
wrote:
> On Fri, Jul 5, 2013 at 6:10 AM, Joe Van Dyk wrote:
> > Hi,
> >
> > Is refreshing a materialized view in 9.3 basically:
> >
> > delete from mat_view;
> > insert into mat_view select * from base_view;
> Nope. Here is some documentation:
>
On Fri, Jul 5, 2013 at 8:58 AM, Stuart Ford wrote:
> On Fri, Jul 5, 2013 at 7:00 AM, Dennis Jenkins wrpte
>
> No. iSCSI traffic between the VMWare hosts and the SAN uses completely
> separate NICs and different switches to the "production" LAN.
> I've had a look at the task activity in VCEnter a
Just spotted an earlier discussion between Christoph Berg and Joshua
Drake which resolved the problem.
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I always use a community source, compile and use for all those projects.
I have doubt
Assume I am creating a user say 'test' with nosuperuser privilege with just
login
and associate this user with any database using authorization. But I am
able to create a table
for the test user in 'postgre
Hi,
I am trying to install postgresql-9.2 using the instructions in the apt
wiki. I already have 9.1 installed - and would like to keep both for the
moment - but the install of 9.2 fails as below...
sudo apt-get install postgresql-9.2
Reading package lists... Done
Building dependency tree
Re
On Thu 04 Jul 2013 08:10:45 PM PET, Michael Paquier wrote:
On Fri, Jul 5, 2013 at 10:04 AM, bricklen wrote:
On Thu, Jul 4, 2013 at 5:26 PM, David Carpio
wrote:
Also, can you supply the EXPLAIN (ANALYZE, BUFFERS) plan instead of the
simple EXPLAIN plan?
Then it might be interesting that you sc
On Fri, Jul 5, 2013 at 7:00 AM, Dennis Jenkins wrpte
> Before I looked at your pastebin, I was going to ask "What kind of
>storage
> are the VMDKs on? If they are on NFS, iSCSI or FC, could the NAS/SAN be
> experiencing a problem?" But I see in the stack trace that the kernel
>thread
> hung in "
On 07/05/2013 06:48 AM, guxiaobo1982 wrote:
And what about postgres_fdw?
To answer both your questions.
Python3
In the directory you did the configure there should be a config.log.
Open it and see what it shows for the Python build. My suspicion is you
do not have the devel libraries for P
And what about postgres_fdw?
-- Original --
From: "Adrian Klaver";
Date: Jul 5, 2013
To: "guxiaobo1982";
Cc: "pgsql-general";
Subject: Re: [GENERAL] How to build postgresql 9.3 beta2 from source
withplpython3u handler and postgres_fdw extensions.
On 0
Hi Adrian,
I use this configuration
./configure PYTHON='/opt/python32/bin/python3' --prefix=/opt/PostgreSQL/93b2src
--with-python
but the create language plpython3u command failed.
Regards,
Xiaobo Gu
-- Original --
From: "Adrian Klaver";
Date: Jul 5,
On 07/05/2013 03:31 AM, guxiaobo1982 wrote:
Hi,
I use the following commands to build PostgreSQL9.3 from source, but
plpython3u and postgres_fdw are missed in the result, can you help with
this.
http://www.postgresql.org/docs/9.3/static/plpython-python23.html
"Tip: The built variant depends o
On 07/05/2013 12:29 AM, giozh wrote:
so thanks to all for the answers. But i'm going to be frustrated, no one of
your solutions seems to work, and i can't understand why, because i've write
another two functions that works well...
I always obtain error: or unknown function (if i pass args without
On Fri, Jul 5, 2013 at 7:00 AM, Stuart Ford wrote:
> Dear community
>
> Twice today our PG 9.1 server has caused a "soft lockup", with a kernel
> message like this:
>
> [1813775.496127] BUG: soft lockup - CPU#3 stuck for 73s! [postgres:18723]
>
> Full dmesg output - http://pastebin.com/YdWSmNUp
>
Thomas Kellerer, 05.07.2013 13:46:
> Postgres 9.3 will add "event triggers", but they can only be written in SQL
That should have been: "only C and procedural languages like PL/pgSQL"
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
On Fri, Jul 05, 2013 at 08:35:22AM +0200, Luca Ferrari wrote:
> On Fri, Jul 5, 2013 at 5:09 AM, Jayadevan M
> wrote:
>
> >
> > So each student may get counted many times, someone with 99 will be counted
> > 10 times. Possible to do this with a fat query? The table will have many
> > thousands of
Dear community
Twice today our PG 9.1 server has caused a "soft lockup", with a kernel
message like this:
[1813775.496127] BUG: soft lockup - CPU#3 stuck for 73s! [postgres:18723]
Full dmesg output - http://pastebin.com/YdWSmNUp
The incidents were approximately two hours apart and the server wa
itishree sukla, 05.07.2013 10:29:
> Hello Every one,
>
> Is Postgresql providing triggers on DB level, schema level ( in same DB)?
>
You are probably referring to "DDL" triggers and similar things (a trigger when
a table is created or dropped, a user logs in and so on).
The answer is no as far
I didn't get you, you mean trigger is possible on schema level? if yes can
you give example.
Thank you
On Fri, Jul 5, 2013 at 3:56 PM, Jov wrote:
> the later ，in same db
>
> jov
> 在 2013-7-5 下午4:32，"itishree sukla" 写道：
>
> Hello Every one,
>>
>> Is Postgresql providing triggers on DB level, s
Hi All,
I have three tables.
Table: transaction
meter_id | bay_number | trans_date_time | amount
--+++
1078 | 5 | 2013-06-03 09:59:32+10 | 5.00
1078 | 7 | 2013-06-03 09:12:01+10 | 5.00
Hi,
I use the following commands to build PostgreSQL9.3 from source, but plpython3u
and postgres_fdw are missed in the result, can you help with this.
./configure PYTHON='/opt/python32/bin/python3' --prefix=/opt/PostgreSQL/93b2src
--with-python
make
make install
export PATH=/opt/PostgreSQL/
the later ，in same db
jov
在 2013-7-5 下午4:32，"itishree sukla" 写道：
> Hello Every one,
>
> Is Postgresql providing triggers on DB level, schema level ( in same DB)?
>
>
> Regards,
> Itishree
>
Hi,
I installed postgreSQL 9.3 beta 2 from
http://yum.postgresql.org/repopackages.php#pg92 following
http://www.postgresonline.com/journal/archives/203-postgresql90-yum.html
But I cann't find pg_config, is this a bug?
Xiaobo Gu
Hi ,
Python2 works, but how to create the plpython3u language, can we use both
plpython2u and plpython3u in the same database server?
[postgres@lix ~]$ psql
psql (9.3beta2)
Type "help" for help.
postgres=# create language plpython3u;
ERROR: could not access file "$libdir/plpython3": No such f
Hello Every one,
Is Postgresql providing triggers on DB level, schema level ( in same DB)?
Regards,
Itishree
Hello
2013/7/5 Arun P.L :
> Hi friends,
>
> When I try to create a function which is used in user defined type cast I
> get the following error,
>
> CREATE FUNCTION pg_catalog.text1(integer) RETURNS text STRICT IMMUTABLE
> LANGUAGE SQL AS 'SELECT textin(int4out($1));';
> ERROR: permission denied
Hi friends,
When I try to create a function which is used in user defined type cast I get
the following error,
CREATE FUNCTION pg_catalog.text1(integer) RETURNS text STRICT IMMUTABLE
LANGUAGE SQL AS 'SELECT textin(int4out($1));';
ERROR: permission denied for schema pg_catalog
I am not trying
so thanks to all for the answers. But i'm going to be frustrated, no one of
your solutions seems to work, and i can't understand why, because i've write
another two functions that works well...
I always obtain error: or unknown function (if i pass args without ' ') or
"column not exist".
i've notic
>
>>
>> So each student may get counted many times, someone with 99 will be
>> counted
>> 10 times. Possible to do this with a fat query? The table will have
>> many thousands of records.
>>
>
>
>Not sure I got the point, but I guess this is a good candidate for a CTE:
>
>WITH RECURSIVE t(n) AS (
>
32 matches
Mail list logo
