On Tue, Jan 8, 2013 at 8:39 PM, Wolf Schwurack wrote:
> I am getting a repeating error and not sure what why.
>
> ** **
>
> 2013-01-08 06:12:08 MSTERROR: absolute path not allowed
>
> 2013-01-08 06:12:08 MSTSTATEMENT: SELECT pg_read_file($1, 0, 1048576)
>
> 2013-01-08 06:42:10 MST
On Tue, Jan 8, 2013 at 8:09 AM, Wolf Schwurack wrote:
> I am getting a repeating error and not sure what why.
>
>
>
> 2013-01-08 06:12:08 MSTERROR: absolute path not allowed
>
> 2013-01-08 06:12:08 MSTSTATEMENT: SELECT pg_read_file($1, 0, 1048576)
>
> 2013-01-08 06:42:10 MSTERROR: absolute path
Hi,
I want to store clickmap points (X, Y and hits value) for website
I currently have table like this
CREATE TABLE clickmap (
page_id integer,
date date,
x smallint,
y smallint,
hits integer
)
But this generated about 1M rows per day.
Can Postgres have better method to store this d
I am getting a repeating error and not sure what why.
2013-01-08 06:12:08 MSTERROR: absolute path not allowed
2013-01-08 06:12:08 MSTSTATEMENT: SELECT pg_read_file($1, 0, 1048576)
2013-01-08 06:42:10 MSTERROR: absolute path not allowed
2013-01-08 06:42:10 MSTSTATEMENT: SELECT pg_read_file($1,
Hi,
I have recently installed PostgreSQL 9.2 on my Windows 7 64bit computer. In
addition I have installed Python 3.3. I am new to PostgreSQL, and wish to
play with its support for Python.
I tried to run the command:
CREATE EXTENSION plpython3u
Only to receive the error:
Could not load library
On Jan 8, 2013, at 6:48 PM, Tom Lane wrote:
> The OP didn't
> suggest how many years his data covers, but it's quite possible that
> pulling a full year's worth of data will read enough of the table that
> there's no point in worrying about whether an index could be used
> anyway.
There are onl
Hello, I was just wondering if it is possible to set the postgresql
default folder to a data drive? I tried to change the default from my
system drive because it was taking up far too much space, but it was
having none of it and continued to install on my system drive. Regards,
James.
--
Sen
Thanks for your reply!
yeath,I quite accept your opinion,once i guess the drive adds savepoint
between the two SQL，but not sure
i want to get the last insert id to ensure the INSERT correctly ,so i called
currval().
as the error occurs seldom,i find it's difficult to trace the problem or the
log
Jerry Sievers writes:
> If I understand correctly how it works, public execute is granted in
> the default case of no rows returned as seen in the first case AND
> when we get a row with grantee=0 and privilege='execute'.
> select (aclexplode(proacl)).* from pg_proc where proname = 'foo';
I don
Todd, there is no auditing that will answer the question *when* (in
terms of when change took place), strictly speaking.
But anyway, have a look at the functions acl* and inparticular
aclexplode as seen below.
If I understand correctly how it works, public execute is granted in
the default case o
Gavan Schneider writes:
> From my perspective there are at least three ways to attack
> this problem:
> (I have not tested these, so apologies for the stupid syntax errors.)
> 1. SELECT ... WHERE 2011 = extract(YEAR FROM col_of_type_timestamp);
> 2. SELECT ... WHERE
> '2011-01-01'::
On Tuesday, January 8, 2013 at 09:26, Raymond O'Donnell wrote:
On 08/01/2013 22:19, Kirk Wythers wrote:
I have a column of type TIMESTAMP, I'd like to query all records from
2011. If it were text I could use a partial such as:
WHERE text ~ '2011'
There must be a simple way to pull the year pa
Todd Kover writes:
> This revocation from public happens in our environment. Trouble is, I
> can not find where an indiciation that execute has been revoked from
> public in pg_catalog.pg_proc (or any other table for that matter). Is
> there a way to find this somewhere in the catalog?
pg_proc.
On 01/08/2013 02:19 PM, Kirk Wythers wrote:
I have a column of type TIMESTAMP, I'd like to query all records from 2011. If
it were text I could use a partial such as:
WHERE
text ~ '2011'
There must be a simple way to pull the year part out of a timestamp format.
Thanks in advance.
On 01/08/2013 03:39 PM, Raymond O'Donnell wrote:
On 08/01/2013 22:26, Raymond O'Donnell wrote:
On 08/01/2013 22:19, Kirk Wythers wrote:
I have a column of type TIMESTAMP, I'd like to query all records from
2011. If it were text I could use a partial such as:
WHERE text ~ '2011'
There must be
On 08/01/2013 22:26, Raymond O'Donnell wrote:
> On 08/01/2013 22:19, Kirk Wythers wrote:
>> I have a column of type TIMESTAMP, I'd like to query all records from
>> 2011. If it were text I could use a partial such as:
>>
>> WHERE text ~ '2011'
>>
>> There must be a simple way to pull the year part
On 08/01/2013 22:19, Kirk Wythers wrote:
> I have a column of type TIMESTAMP, I'd like to query all records from
> 2011. If it were text I could use a partial such as:
>
> WHERE text ~ '2011'
>
> There must be a simple way to pull the year part out of a timestamp
> format. Thanks in advance.
You
I have a column of type TIMESTAMP, I'd like to query all records from 2011. If
it were text I could use a partial such as:
WHERE
text ~ '2011'
There must be a simple way to pull the year part out of a timestamp format.
Thanks in advance.
--
Sent via pgsql-general mailing list (pgsq
I am trying to write something that will enumerate grants/revokes on
functions to make sure they are adjusted properly after said function is
drop/recreated, should that happen. This will also be used to validate
that permissions are what they should be.
According to:
http://www.postgresql.org/
Thank you Tom, you are correct. Adding the line:
OBJS = test_cfunc.o
to the Makefile resolved the problem.
-Dave
On Tue, Jan 8, 2013 at 12:55 PM, Tom Lane wrote:
> David Fuhry writes:
> > Hi, I'm trying to add a C-Language function but getting the following
> error:
> > $ psql -f test_cfunc
James Cowell writes:
> I enabled archive mode (which I didn't care about before as the database only
> holds 36 hours of data) and the indexes seem to replicate over fine. I
> suppose the problem here is lack of documentation, but at least the code is
> well commented :)
> It looks like pg_bu
David Fuhry writes:
> Hi, I'm trying to add a C-Language function but getting the following error:
> $ psql -f test_cfunc.sql
> psql:test_cfunc.sql:3: ERROR: incompatible library
> "/usr/local/pgsql/lib/test_cfunc.so": missing magic block
> HINT: Extension libraries are required to use the PG_MO
Forgot to mention, I am on 9.2.1. "SELECT version();" reports:
PostgreSQL 9.2.1 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.4.5-8) 4.4.5, 64-bit
-Dave
On Tue, Jan 8, 2013 at 12:30 PM, David Fuhry wrote:
> Hi, I'm trying to add a C-Language function but getting the following
> erro
Hi, I'm trying to add a C-Language function but getting the following error:
$ psql -f test_cfunc.sql
psql:test_cfunc.sql:3: ERROR: incompatible library
"/usr/local/pgsql/lib/test_cfunc.so": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
I am callin
Hi,
Thanks a lot to Adrian, Nicolas and Brooks.
"... ORDER BY random() LIMIT 10;" works ok.
But with the following option it gets more tricky assume:
> And as an option the (limited) resultset should be spatially
> distributed (not clustered).
I'm thinking about some radial spatial distribution
Le lundi 31 décembre 2012 à 20:55 -0500, Robert James a écrit :
> On 12/31/12, François Beausoleil wrote:
> >
> > Le 2012-12-31 à 15:38, Robert James a écrit :
> >
> >> DISTINCT is a very simple solution!
> >> But I have one problem: In addition to the FIRST fields, I also do
> >> want some aggreg
I seem to have solved my problem, out of frustration I downloaded the source to
see what I could work out (although it's a good while since I did C) and I
found these comments in nbtsort-9.1.c:
* Formerly the index pages being built were kept in shared buffers, but
* that is of no value (sinc
Tirsdag 8. januar 2013 16.10.03 skrev Graeme Hinchliffe :
> My example code is :
>
> CREATE TYPE testtype AS (
> a INTEGER,
> b INTEGER
> );
>
> CREATE OR REPLACE FUNCTION test() RETURNS INTEGER AS $$
> DECLARE
> x testtype;
> BEGIN
> (x).a:=1;
> RETURN 1;
> END
> $$ LANGUAGE plpgsql;
>
> Thi
On 01/08/2013 07:20 AM, Stefan Keller wrote:
Hi
I have a query like this
SELECT ST_AsText(way) geom, name AS label
FROM osm_point
LIMIT 10;
When I repeatedly do this, the result set will be always the same.
I have observed this only empirically and I know that the ordering of
the resu
Hi
I have a query like this
SELECT ST_AsText(way) geom, name AS label
FROM osm_point
LIMIT 10;
When I repeatedly do this, the result set will be always the same.
I have observed this only empirically and I know that the ordering of
the result set is undefined without ORDER BY.
There are tw
>For several reasons (including operational and legal) once data are
> entered in a table they cannot be changed or deleted without an audit
> trail of the change, when it occurred, who made the change, and the
> reason for it.
Besides the need for storing additional information that the user
Hi,
I am trying to use a composite type within a function, I have
tried SELECT INTO and direct assignment to set the value of a single element
within the composite variable with no joy. I hope this is simply a case of my
not knowing the correct syntax?
My example code is :
CRE
Hi,
In PostgreSQL 9.0.x we must define a constraint as DEFERRABLE on the "create
table", we cannot define DEFERRABLE on "create table as select", how is this
restriction in 9.2 now?
Also, in 9.2 can deferrable uniqueness be mixed with Foreign keys?
Thanks
--
Sent via pgsql-general mailing
Hi all,
I have a large dataset and I have crawled it two and three times; hence
reltuples has increased. So I need some way to find out vacuum is needed on the
system.
Please help me in finding out some parameter or statistics which will tell me
vacuum is required on the database.
Regards,
A
On 8 Jan 2013, at 5:04 PM, Birta Levente wrote:
> The pooler is between client and postgresql server. So, if you want to
> connect through the pooler you need to connect on 6543.
>
> But I think you really need to read some documentation about pgbouncer.
Thanks, I can connect to any testing D
In Java world, for this purpose I tend to use JPA/Hibernate with Envers
http://www.jboss.org/envers - db vendor agnostic solution.
Kind regards,
Stevo Slavic.
On Tue, Jan 8, 2013 at 6:32 AM, Craig Ringer wrote:
> On 4/01/2013 12:09 AM, Adrian Klaver wrote:
> > On 01/03/2013 07:38 AM, Rich Shep
Thanks very much Tom and Adrian.
Solved. I will RTFM better next time.
Thanks again, Joek
Adrian Klaver schreef:
On 01/07/2013 07:56 AM, Tom Lane wrote:
Adrian Klaver writes:
On 01/07/2013 06:45 AM, J. Hondius wrote:
I'm not getting my PostgreSQL 9.2 to return the correct lc_time
openwav
!! Please do not top post !!
On 08/01/2013 10:21, a...@hsk.hk wrote:
Hi,
Thanks for your reply.
Below is the pgbouncer.ini
===
[databases]
; use db:postgres for connection testing
postgres = port=5432 dbname=postgres
As I said before, with this you can only connect database postgres.
Maybe
Hi,
Thanks for your reply.
Below is the pgbouncer.ini
===
[databases]
; use db:postgres for connection testing
postgres = port=5432 dbname=postgres
[pgbouncer]
listen_port = 6543
listen_addr = 127.0.0.1
admin_users = postgres
auth_type = md5
auth_file = users.txt
server_reset_query = DISCARD AL
39 matches
Mail list logo
