Hello, I'm searching for a solution for the following problem for several hours. But I can't find any example which corresponds to my Problem. With...

Volker Boehm

Today 04:09 AM
Laurenz Albe

Assuming I want to build a web based data repository to store, serve and provide interaction for all different kinds of datasets, possibly holding up...

André

Yesterday 02:28 PM
Mladen Gogala

Assuming I want to build a web based data repository to store and serve all different kinds of datasets, possibly holding up to 1 million different...

André

Yesterday 10:50 AM
André

I'm trying to combind a cascading delete and a constraint deferal. The hope is to have a cascading delete to clean up data, but only after a commit. ...

Paul

03-04-2010 10:37 AM
Laurenz Albe

Does anybody here know what is the definition of the DB block format and in which source file can I find it? Also, where in the source can I find the...

Mladen Gogala

03-01-2010 08:23 AM
Laurenz Albe

Hi,here: http://www.postgresql.org/docs/8.3/static/plpgsql-statements.html I can read that the FOUND variable it is set by any plain sql...

news

02-22-2010 01:58 PM
Mladen Gogala

Can I somehow force PogSQL to do direct I/O on Ext3 file system? All those FS buffers are messing up free memory and swap...

Mladen Gogala

02-18-2010 05:30 PM
Mario Splivalo

Hi, does date_trunc return values related to current timezone? see this: db_atm=# select extract('epoch' from date_trunc('day', 'epoch'::timestamp...

news

02-18-2010 08:11 AM
news

Does anybody here has any experience with that? Any remarks, praises or words of caution? Postgres search engine seems to be unable to cope...

Mladen Gogala

02-12-2010 05:12 PM
Mladen Gogala

Where can I find the list of separator characters for the configuration named "english"? In other words, I need the list of characters which delimit...

Mladen Gogala

02-11-2010 09:30 AM
Laurenz Albe

I have a huge table, containing a text column and having text indexes, with 22 million rows. The table is partitioned into 4 tables. Is...

Mladen Gogala

02-04-2010 04:43 AM
Laurenz Albe

Hi, is this a bug or am I misunderstanding something? db_atm=# select length(to_char(552020, '000000000')); length -------- 10 (1 row) in my...

Anselmo Canfora

02-04-2010 03:49 AM
Anselmo Canfora

I am stuck to Postgres 8.3 because there is no pljava for the version 8.4, at least not in the RPM form. There are significant changes in 8.4.2 with...

Mladen Gogala

02-01-2010 02:34 PM
Mladen Gogala

I am looking into the PostgreSQL dictionary. The view pg_stat_activity is the PgSQL version of v$session. There are interesting views...

Mladen Gogala

01-28-2010 11:12 AM
Mladen Gogala

Hi, is it possible to join a table/view with table function, which has parameters? Something like select u.*, func_result.* from users u left join...

Pavel Chudnovskyy

01-28-2010 08:32 AM
Laurenz Albe

I created a trigger on a table and pg_trigger table will not show it as enabled. Here is the illustration. news_archive=# create trigger...

Mladen Gogala

01-27-2010 05:14 AM
Laurenz Albe

Hi every body, If : create table T(id int, x int, ..., ... ); alter table T alter id set default nextval('my_sequence'); alter table T alter x set...

LoZ

01-26-2010 01:54 AM
Laurenz Albe

Hi, just a curiosity, how does PG manage PL/Perl? Is it loaded on the same process space of PG (a la mod_perl) or is it called via IPC? This question...

Anselmo Canfora

01-25-2010 09:46 AM
Laurenz Albe

Hi, is there a way to have a default index name for columns? for example, instead of writing: create index foo on bar (foo); write only: create...

Anselmo Canfora

01-25-2010 07:56 AM
Anselmo Canfora

Hi, in PG 8.3 I have the following issue: db_atm=# select substring('1.3.6.1.4.1.9.1.182', E'(1\.3\.6\.1\.4\.1\.9\.1\.\d*)',...

Anselmo Canfora

01-24-2010 07:24 AM
Anselmo Canfora

Hi, I created a crosstab function (query_sql, query_category) and it works, but my query is dynamic and extracts a number of columns varies according...

Peca's

01-24-2010 04:32 AM
Jasen Betts

Hi all, i am a master's student. I have to do a keyword search for spatial database. I have the data set of a particular district in India. I have a...

Kavita

01-07-2010 05:23 AM
Laurenz Albe

After an insert statement, I need a the members of a user group to get the recently inserted statement's primary key that was created from a...

Ivan K.

01-04-2010 04:38 AM
Laurenz Albe

Hello, today I ran into the "encoding problem". Migrating from Postgres 8 to Postgres 8.3 on a new Debian on another server, psql refused to...

Hadanite Marasek

12-31-2009 04:03 PM
M. Strobel

This is not a Postgres specific question. Given two simple tables tracking the marriages between people: The simple query:

Ivan K.

12-28-2009 03:40 PM
Ivan K.

Hi, Is there an option in PG to do it?

Coniglio Sgabbiato

12-22-2009 01:32 PM
Mladen Gogala

Can I write a stored procedure which does an automonous commit? I saw something on a website that claimed "you can't get there from here" in...

Lee

12-21-2009 04:31 AM
Laurenz Albe

PostgreSQL has hash indexes, very similar to Oracle bitmap indexes. Oracle warns the application designers against using them in the...

Mladen Gogala

12-15-2009 02:31 AM
Thomas Kellerer

I would like to write a single query listing all of the function argument types. I know that I can write a procedure but I would prefer a...

Mladen Gogala

12-11-2009 05:22 PM
Mladen Gogala

Does anybody have an example with spi_prepare, spi_exec_prepared or spi_query_prepared? I managed to get the basic concepts: create function...

Mladen Gogala

12-10-2009 05:36 PM
Mladen Gogala

When I use capital letter(s) in table or view name Hibernate complains it can't find the relation. :( Is this known issue or am I doing something...

Jaroslav Záruba

12-10-2009 03:12 AM
Jaroslav Záruba

Hello, I have several databases. The objects are stored in the public schema of each database. I would like to move them to different schemas in...

Tanguy

12-09-2009 09:14 AM
Tanguy

PostgreSQL has some rather strange indexes, like partial indexes: scott=> create index ename_ind on emp(ename) scott-> where deptno=10; CREATE...

Mladen Gogala

12-03-2009 03:45 PM
Mladen Gogala

I tried the named callable query approach... <sql-something name="..." callable="true"> { ? = call schema.procedure(?,?) } </sql-something> ....but...

Jaroslav Záruba

12-01-2009 12:40 AM
Jaroslav Záruba

so I read great stuff by rob piek about having data not algorithms be cental to programming so if have the data then everything else...

quiet_lad

11-30-2009 04:00 PM
quiet_lad

I have a table defined like this: scott=> \d t Table "public.t" Column | Type |...

Mladen Gogala

11-26-2009 10:00 PM
Mladen Gogala

On Wed, 25 Nov 2009 19:59:10 +0000, Mladen Gogala wrote: It's NOT syntactically supported. Lapsus keyboardi. -- http://mgogala.byethost5.com

Mladen Gogala

11-25-2009 03:11 PM
Mladen Gogala

I am unable to find the necessary package and the source code doesn't compile. Does anybody know more? -- http://mgogala.byethost5.com

Mladen Gogala

11-25-2009 03:44 AM
Laurenz Albe

The following query executes without a problem on 8.4 but fails with syntax error on 8.3. Is there a "new features" document which would tell me the...

Mladen Gogala

11-24-2009 01:15 AM
Mladen Gogala

Don't want to start a long-winded discussion, just seeking some general views. . . I was trained in SQL years ago and was encouraged to use...

gargoyle60

11-23-2009 04:04 AM
Marco Mariani

I asked a simple question and yet my post is not showing, it is pending approval by the list moderators. Is that list intentionally designed to be as...

Mladen Gogala

11-22-2009 04:26 AM
Jasen Betts

Hi, I have create a table with this structur CREATE TABLE import ( id1 integer NOT NULL, id2 integer NOT NULL, dataset oid NOT NULL, CONSTRAINT...

Philipp Kraus

11-19-2009 05:26 AM
Laurenz Albe

Hello, i try to use the setArray method of postgres (8.3) JDBC driver to send data to a function. I hope I'm not off topic here with this...

Philipp Kraus

11-18-2009 08:56 AM
Philipp Kraus

Hi Everyone, Given a table "Items" with a PK "item1" and "Qty" - a numeric column I'd like to define a way in Postgres to insert when item11...

SebiF

11-16-2009 03:53 PM
Andreas Kretschmer

The documentation of this command is extremely unclear and vague? What does the integer argument taken by this command represent? My guess is that it...

Mladen Gogala

11-16-2009 02:45 PM
Mladen Gogala

I have an unusual execution plan below. I am executing a query using the primary key and am getting sequential scan. How can I force the use of the...

Mladen Gogala

11-16-2009 10:48 AM
Mladen Gogala

Hello, i had written a stored procedure that works as trigger for upate and delete statements. The trigger raises an error if there is a not allowd...

Philipp Kraus

11-16-2009 05:50 AM
Philipp Kraus

I am about to start playing with Slony. For one, I have a stupid question: where does one usually install Slony? On the master or on the...

Mladen Gogala

11-13-2009 03:51 PM
Mladen Gogala

I've been looking for something like Oracle's utl_http.request (analagous to the unix curl ) in postresql; but there doesnt seem to be any such...

Lee

11-13-2009 11:06 AM
Lee

Laurenz Albe <invite (AT) spam (DOT) to.invalid> wrote: This ist exactly the use of DBD::PgSPI - and doing so in the usual way you access databases...

Jochen Lutz

11-12-2009 06:35 PM
Jochen Lutz