Re: [GENERAL] Random not so random

2004-10-05 Thread D. Stimits
Vivek Khera wrote: "DS" == D Stimits <[EMAIL PROTECTED]> writes: DS> If it uses the same seed from the connection, then all randoms within DS> a connect that has not reconnected will use the same seed. Which means DS> the same sequence will be generated each time, whic

Re: [GENERAL] Random not so random

2004-10-04 Thread D. Stimits
of query and not at the moment of connect. A pseudo-random generator using the same seed will generate the same sequence. D. Stimits, stimits AT comcast DOT net ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] import/export or moving data between databases

2004-09-19 Thread D. Stimits
Iavor Raytchev wrote: Dear Tom, We kind of read all documentation we could find, but that was the only way we could get - - export db structure into sql file - export the records we need into another sql file - import structure - turn off triggers - import the records - turn on triggers The main pr

Re: [GENERAL] [INTERFACES] more on undefined reference to 'pg_detoast_datum'

2003-10-13 Thread D. Stimits
Tom Lane wrote: > "D. Stimits" writes: > > >... My question is, where the heck is > >CurrentMemoryContext and MemoryContextAlloc provided as an > >implementation which I can link with? > > > They're inside the backend, and you don't --- you a

Re: [GENERAL] undefined reference to 'pg_detoast_datum'

2003-10-09 Thread D. Stimits
Joe Conway wrote: D. Stimits wrote: > A google search shows very little concerning the pg_detoast_datum > undefined reference link error. It is looking more like the V1 has to > be skipped and I'll have to go back to V0 if I can't get this to work. You haven't shown us

[GENERAL] undefined reference to 'pg_detoast_datum'

2003-10-09 Thread D. Stimits
nge to a newer version of PostgreSQL, then a newer version can't be used] D. Stimits ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] PL/PGSQL for permutations?

2003-10-09 Thread D. Stimits
Joe Conway wrote: D. Stimits wrote: > table field pair. E.G., if I had in table 'one': > left right > = > a b > a c > b d > > ...then I'd need a list of a, b, c, d, and produce a new table: > left right > = > a

Re: [GENERAL] C API, PQconnectdb and options Q.

2003-09-10 Thread D. Stimits
D. Stimits wrote: I'm using a Redhat version of PostgreSQL 7.2.3 with the C API. Mostly things work right, but I need more debug output, as I have a query that works fine from psql, but fails with the C API (perhaps this is because I use PQescapeString). The only way to know there is an err