>
>>
>> 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 (
>
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
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
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
Hello Every one,
Is Postgresql providing triggers on DB level, schema level ( in same DB)?
Regards,
Itishree
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
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
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 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/
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
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
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
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
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
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 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
>
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 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
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,
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
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
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 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
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
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
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
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
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, 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
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
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
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
32 matches
Mail list logo
