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 ge
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
>> sc
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:
http://
Clemens Eisserer 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 creating the table. F
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 see
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 bec
On Sun, Jul 26, 2009 at 11:20 AM, Clemens Eisserer 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 auto_increment
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 famil
sibu xolo 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 fo
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
backgro
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 (pgsql-gener
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 jdk-lis
On Sun, Jul 26, 2009 at 3:30 PM, Nick Boutelier 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 (each table can also
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" fro
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 doc
Robert James 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 install directories
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 backgr
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
> 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
23 matches
Mail list logo
