On Sat, Jul 25, 2009 at 9:48 PM, Kevin
Kempterkev...@consistentstate.com wrote:
On Saturday 25 July 2009 20:05:14 Scott Marlowe wrote:
On Sat, Jul 25, 2009 at 1:30 PM, Kevin
Kempterkev...@consistentstate.com wrote:
On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote:
On Sat, Jul 25, 2009
Hi,
I have a query with 20 relations, the GEQO is used to solve this query.
When the value of
pool-data[i].worth
was displayed, from random_init_pool() [geqo_pool.c], exactly the same value
was obtained for all individuals.
Also when the value of pool-data[i].worth was printed from
Greg Smith-12 wrote:
On Thu, 23 Jul 2009, tomrevam wrote:
bgwriter_delay = 20ms # 10-1ms between rounds
bgwriter_lru_maxpages = 1000# 0-1000 max buffers
written/round
bgwriter_lru_multiplier = 5.0 # 0-10.0 multipler on buffers
scanned/round
Hello,
Is it possible to use an implicit sequence with a start value?
Something like: CREATE TABLE foo (key SERIAL START 1000 PRIMARY KEY NOT NULL);
Thank you in advance, Clemens
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Clemens Eisserer linuxhi...@gmail.com writes:
Is it possible to use an implicit sequence with a start value?
Something like: CREATE TABLE foo (key SERIAL START 1000 PRIMARY KEY NOT
NULL);
Well, you can't do it just that way, but you could issue a setval() or
ALTER SEQUENCE command after
Hi Tom,
regression=# alter sequence foo_bar_seq start with 1000;
ALTER SEQUENCE
Completly forgot about that possibility, thanks a lot :)
What still puzzles me is how to get the sequence value applied.
MySQL's auto_increment simply ignores whatever value is supplied to
it, however postgres
On 26/07/2009 18:20, Clemens Eisserer wrote:
What still puzzles me is how to get the sequence value applied.
MySQL's auto_increment simply ignores whatever value is supplied to
it, however postgres seems to insert the value instead of the next
sequence value, if one is supplied:
That's
On Sun, Jul 26, 2009 at 11:20 AM, Clemens Eissererlinuxhi...@gmail.com wrote:
Hi Tom,
regression=# alter sequence foo_bar_seq start with 1000;
ALTER SEQUENCE
Completly forgot about that possibility, thanks a lot :)
What still puzzles me is how to get the sequence value applied.
MySQL's
Greetings,
I am interested in using the PostgreSQL on machines with Renesas
(formerly Hitachi) superH4A-based processors. I checked with the literature
and noted from this URL (
http://developer.postgresql.org/pgdocs/postgres/supported-platforms.html )
that the superH
sibu xolo sib...@btconnect.com writes:
+tas.b @%1\n\t \n
+movt %0\n\t \n
+xor#1,%0\n
Hmm, what is the point of introducing extra blank lines into the asm
output? I would hope those are unnecessary, but one never knows
Suppose I've
create table m1 (
a int primary key,
cm1 int,
cm2 int,
...
);
create r1 (
a int references m1 (a),
cr1 int,
cr2 int,
...
);
and cm1 possible values depends on some function of cr1 for a given
a.
I actually have a plpgsql function that returns the possible choices
for cm1
Is there a transitive closure (or equivalent) operator in Postgres (or
extension)?
Anything like CONNECT BY?
Or any recommended way of querying hiearchial data?
I'm working on improving my background database theory, to aid in practice.
I've found learning relational algebra to be very helpful. One thing which
relational algebra doesn't cover is aggregate functions. Can anyone
recommend any papers or web pages which provide some good theoretical
Robert James wrote on 26.07.2009 21:35:
Anything like CONNECT BY?
Or any recommended way of querying hiearchial data?
Yes, recursive common table expression (since 8.4)
http://www.postgresql.org/docs/current/static/queries-with.html
Thomas
--
Sent via pgsql-general mailing list
Thanks Merlin, do you know what the syntax would be? Can't seem to
find it anywhere and im getting an error using 8.3.7
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
The problem is that I don't have control over the SQL generated, that
happens behind the scenes of the JDBCRowSet/SwingSet toolkt/api.
Fourtunatly it seems to work when I simply don't bind the textfield :)
However now I am facing other, jdbc-driver related problems, however
I'll ask on the
On Sun, Jul 26, 2009 at 3:30 PM, Nick Bouteliernamethis...@gmail.com wrote:
Thanks Merlin, do you know what the syntax would be? Can't seem to
find it anywhere and im getting an error using 8.3.7
You will need to create a type to represent the record contained in
the array, or use a table type
On Sun, Jul 26, 2009 at 03:36:26PM -0400, Robert James wrote:
Can anyone
recommend any papers or web pages which provide some good theoretical
background for aggregate functions?
My knowledge of relational algebra is somewhat non-existent as well;
I tend to just think of them as a fold from
I'm currently running Postgres 8.2 on Windows XP. I would like to use some
8.4 features, but I don't want to migrate my 8.2. Is there any way to run
both instances together? Are there any problems with that?
Alternatively, is the procedure to move from 8.2 to 8.4 without data or
function loss
Robert James srobertja...@gmail.com writes:
I'm currently running Postgres 8.2 on Windows XP. I would like to use some
8.4 features, but I don't want to migrate my 8.2. Is there any way to run
both instances together? Are there any problems with that?
What you need is
* different
tomrevam wrote:
The behavior of the system is the same with bg_writer_lru_maxpages =
0. Can you explain why transactions are sometimes synchronous even
with the synchrounous_commit set to off?
Asynchronous transactions must still be logged to the journal from time
to time. There's a
Thomas Kellerer wrote:
Pavel Stehule, 23.07.2009 14:50:
look on http://wiki.postgresql.org/wiki/Category:Snippets
That page is not accessible from the Wiki's main page (at least I
can't find an easy way to navigate there)
I think there should be a prominent link right at the start page
To be clearer: Do you mean that the folder you backed up is the folder
with the file PG_VERSION in it, and all its contents?
In my case, yes, because I can copy the config files as well. In general, I
was thinking of the folder passed to postmaster via -D. But of course if you
don't want to
Scott Ribe escribió:
To be clearer: Do you mean that the folder you backed up is the folder
with the file PG_VERSION in it, and all its contents?
In my case, yes, because I can copy the config files as well. In general, I
was thinking of the folder passed to postmaster via -D. But of
24 matches
Mail list logo