| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | 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 | 1 | 5 |
|  | 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 | 1 | 9 |
|  | 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é | 0 | 3 |
|  | 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 | 3 | 30 |
|  | 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 | 1 | 33 |
|  | 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 | 2 | 33 |
|  | 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 | 29 | 126 |
|  | 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 | 2 | 23 |
|  | 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 | 9 | 64 |
|  | 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 | 2 | 22 |
|  | 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 | 1 | 58 |
|  | 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 | 6 | 28 |
|  | 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 | 2 | 28 |
|  | 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 | 1 | 13 |
|  | 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 | 1 | 26 |
|  | 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 | 3 | 24 |
|  | 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 | 9 | 88 |
|  | 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 | 11 | 76 |
|  | 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 | 13 | 42 |
|  | 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 | 6 | 42 |
|  | 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 | 3 | 26 |
|  | 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 | 2 | 50 |
|  | 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 | 6 | 67 |
|  | 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 | 6 | 56 |
|  | 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. | 6 | 74 |
|  | Hi,
Is there an option in PG to do it?
Coniglio Sgabbiato
|
12-22-2009 01:32 PM
Mladen Gogala | 21 | 94 |
|  | 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 | 19 | 91 |
|  | 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 | 1 | 49 |
|  | 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 | 3 | 64 |
|  | 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 | 1 | 43 |
|  | 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 | 9 | 54 |
|  | 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 | 9 | 48 |
|  | 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 | 4 | 62 |
|  | 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 | 0 | 29 |
|  | 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 | 0 | 43 |
|  | 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 | 3 | 231 |
|  | 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 | 0 | 128 |
|  | 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 | 2 | 50 |
|  | 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 | 3 | 56 |
|  | 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 | 4 | 193 |
|  | 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 | 2 | 50 |
|  | 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 | 10 | 83 |
|  | 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 | 2 | 39 |
|  | 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 | 1 | 54 |
|  | 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 | 2 | 139 |
|  | 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 | 5 | 54 |
|  | 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 | 3 | 51 |
|  | 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 | 5 | 52 |
|  | 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 | 2 | 47 |
|  | 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 | 0 | 47 |