Hello John,
Il giorno 22/nov/2011, alle ore 11.04, John R Pierce ha scritto:
> I don't believe that function is immutable, since it depends on the value of
> pg_current_xlog_location() which will change over time.
oops, I'm afraid you are right!
e.
--
Sent via pgsql-general mailing list (pgs
This message has been digitally signed by the sender.
Re___GENERAL__wal_archiving_on_a_hot_standby_server.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
Hello Simon,
Il giorno 21/nov/2011, alle ore 15.47, Simon Riggs ha scritto:
> On Mon, Nov 21, 2011 at 10:58 AM, Enrico Sirola
> wrote:
>
>> is it possible to archive the WAL files received by a hot-standby server? In
>> noticed nothing about this on the pgsql docs. T
Hello,
is it possible to archive the WAL files received by a hot-standby server? In
noticed nothing about this on the pgsql docs. The idea is to archive logs in
two locations, at the primary site and at the replica site (over a wan) in
order to be able to perform a PITR also at the replica site.
Hello Tom,
Il giorno 11/nov/2011, alle ore 22.05, Tom Lane ha scritto:
> Enrico Sirola writes:
>> this morning I experienced a weird problem with our pgsql database (9.0.3):
>> while performing a simple query, I receive the following error:
>> Nov 11 10:24:09 postgre
Hello,
this morning I experienced a weird problem with our pgsql database (9.0.3):
while performing a simple query, I receive the following error:
Nov 11 10:24:09 postgres[23395]: [7-1] ERROR: missing chunk number 0
for toast value 550556127 in pg_toast_2619
so I tried to find which relation
Hello,
I have a pgsql database hosting xml data in xml columns. The data,
have declarations at the beginning, so it is saved with
XMLPARSE (DOCUMENT )
when I try to restore a database from dump, pg_restore complains
because the data it tries to restore is not an xml content
(correctly),
Hello,
I'm having some troubles with the correct use of the execute plpgsql
statement. Where I work, we have a postgresql db hosting a set of
schemas all with the same tables and, from time to time, we upgrade
the schemas to a new version coding a stored procedure like the
following (pseu
Hi Michael,
Il giorno 16/lug/08, alle ore 18:21, Michael Glaesemann ha scritto:
On 2008-07-16, at 7:18 AM, Enrico Sirola wrote:
Hi,
I'm using postgresql version 8.3.1
I have two tables, one has a field with a foreign key pointing to
the primary key of another table. When I to dro
Hello Tom,
Il giorno 16/lug/08, alle ore 16:40, Tom Lane ha scritto:
Enrico Sirola <[EMAIL PROTECTED]> writes:
I have two tables, one has a field with a foreign key pointing to the
primary key of another table. When I to drop the first table, I get
the following error:
test=# drop
Hi,
I'm using postgresql version 8.3.1
I have two tables, one has a field with a foreign key pointing to the
primary key of another table. When I to drop the first table, I get
the following error:
test=# drop table user;
ERROR: "customer_pkey" is an index
test=# select * from pg_constra
Hello,
I'm trying to perform some benchmarks using pgbench. I'm using the
following rpm package:
postgresql-contrib-8.3.0-2PGDG.rhel5
for x86_64, downloaded from the pgsql yum repository for centos5/amd64.
When I init the pgbench database, the scale factor seems to work,
however when perfor
Il giorno 24/feb/08, alle ore 04:53, justin tocci ha scritto:
In its most basic form a great tool would just start as a pl/pgsql
or pl/perl function that could be used to call a table and have it
output a batch of records to an editable html form or a colored pdf
for nice reports. There wo
Il giorno 18/feb/08, alle ore 18:42, Erik Jones ha scritto:
On Feb 18, 2008, at 11:23 AM, Enrico Sirola wrote:
Il giorno 18/feb/08, alle ore 17:37, [EMAIL PROTECTED] ha scritto:
1) PostgreSQL only support partition by inheritance, and rules
have to
be created for each child table, this
Il giorno 18/feb/08, alle ore 17:37, [EMAIL PROTECTED] ha scritto:
1) PostgreSQL only support partition by inheritance, and rules have to
be created for each child table, this will result *a lot of* rules if
the number of child tables is large.
Are there some smart ways to avoid this kind of ma
inheritance + triggers probably. there's an example on the pgsql
documentation
Il giorno 18/feb/08, alle ore 13:18, T.J. Adami ha scritto:
I know that using tablespaces I can create a vertical partition by
creating two tables with the same primary key wich stores different
columns in each tab
I respond myself:
Enrico Sirola ha scritto:
[...]
seems to work). The problem for the code above is that it doesn't work
for vectors longer than 1000 elements or so (try it with 2000 and it
doesn't work). I guess I should manage the "toasting" machinery in some
ways
Hi Webb,
Webb Sprague ha scritto:
I'm quite proud, this is my first C extension function ;-)
I'd gladly post the code if it's ok for the list users. It's more or
less 100 lines of code. This approach seems promising...
I would definitely like to see it.
here it goes:
---
Hi Webb, Joe, Martijn
Webb Sprague ha scritto:
On Feb 1, 2008 2:31 AM, Enrico Sirola <[EMAIL PROTECTED]> wrote:
Hello,
I'd like to perform linear algebra operations on float4/8 arrays
Having avoided a bunch of real work wondering about linear algebra and
PG, did you consi
Hi Joe,
I don't know if the speed will meet your needs, but you might test
to see if PL/R will work for you:
http://www.joeconway.com/plr/
You could use pg.spi.exec() from within the R procedure to grab the
arrays, do all of your processing inside R (which uses whatever BLAS
you've set
Hi Colin,
Il giorno 01/feb/08, alle ore 15:22, Colin Wetherbee ha scritto:
I'm not sure about the internals of PostgreSQL (eg. the Datum
object(?) you mention), but if you're just scaling vectors,
consecutive memory addresses shouldn't be absolutely necessary. Add
and multiply operations
Hello,
I'd like to perform linear algebra operations on float4/8 arrays.
These tasks are tipically carried on using ad hoc optimized libraries
(e.g. BLAS). In order to do this, I studied a bit how arrays are
stored internally by the DB: from what I understood, arrays are
basically a vector
Hi Adam,
Il giorno 31/gen/08, alle ore 16:13, Adam Rich ha scritto:
I'm trying to replicate the use of Oracle's 'lag' and 'over
partition by' analytical functions in my query. I have a table
(all_client_times) such as:
and I would like to create a new view that takes the first table and
calcul
Hi Willem,
Il giorno 30/gen/08, alle ore 22:15, Willem Buitendyk ha scritto:
I'm trying to replicate the use of Oracle's 'lag' and 'over
partition by' analytical functions in my query. I have a table
(all_client_times) such as:
client_id, datetime
122, 2007-05-01 12:00:00
122, 2007-05-01
Hi,
short summary of the problem follows :)
I'm writing an on delete rule for a view and I need to set the status
message (DELETE XXX) for
number of deleted tuples. Is it possible?
A brief, working use case follows:
I have a view restricting the access to a table, as the following:
create
Hi Tom!
Tom Lane ha scritto:
> Enrico Sirola <[EMAIL PROTECTED]> writes:
>> However, I'm facing a problem I'm not able to solve with postgresql:
>> usually updating or deleting time-varying data means to temporary
>> violate a constraint in a transaction b
Hello,
I'm reading "Developing Time-Oriented Database Applications in SQL" by
Richard Snodgrass, and trying to reimplement some of the examples using
postgresql. The book is about temporal tables and applications involving
time-varying data; the one of the main difficulties with such problems
is th
Hello,
I'm thinking about migrating from another DBMS to postgresql. I have an
almost working proof of concept, but still have some doubts about the
following use case.
I have a table like the following
CREATE TABLE test
(
code character varying(32) NOT NULL,
tag integer NOT NULL,
value dou
Dear all,
I'd like to use the upcoming release 8.3 for my next project. When is it
expected to be finalized? My deadline is 2nd quarter 2008, do you think
there is a chance for me to use it?
A second question (more technical). Is it possible to put an index on an
xpath expression of an XML ty
ys of the postgresql system user and you are
done. You can transfer
files without the need for a password, and it's perfectly scriptable
I hope it helps,
Enrico Sirola
[EMAIL PROTECTED]
g. using a
placeholder for the table name) or maybe one could use the
information on Primary/foreign keys
and indexes present also in the system tables so I guess one should
be able to use it to build
the PK/FKs and indexes on the partition tables. Any advice?
Thanks in advance,
Enrico Sir
ts of copy from).
Thanks for the advices,
Enrico Sirola
[EMAIL PROTECTED]
Il giorno 02/giu/07, alle ore 00:53, Jim Nasby ha scritto:
Dropping -hackers; that list is for development of the database
engine itself.
ok, sorry
e.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://w
child_table_name is not a table name.
If, on the other side, I dynamically create the query like in
execute 'insert into ' || child_table_name || ' values (NEW.*)';
it complains because NEW in the execution context is unknown.
This should be a rather common problem... Isn't it? Is there a
canonical way to
solve it? Maybe there's a trivial answer, but I have no plpgsql
programming
experience.
Thanks a lot in advance,
Enrico Sirola
[EMAIL PROTECTED]
34 matches
Mail list logo
