On 01/11/13 09:31, Gavin Flower wrote:
-- theta in radians
-- for radius = 100
INSERT INTO ranpoint
(id, theta, r)
VALUES
(generate_series(1, 10), pi() * random(), 100 * random());
Shouldn't the value for theta be:
2 * pi() * random()
Bosco.
--
Sent via pgsql-general
On 12/01/13 06:45, Bosco Rama wrote:
On 01/11/13 09:31, Gavin Flower wrote:
-- theta in radians
-- for radius = 100
INSERT INTO ranpoint
(id, theta, r)
VALUES
(generate_series(1, 10), pi() * random(), 100 * random());
Shouldn't the value for theta be:
2 * pi() * random()
Can anyone see what I'm misisng? I am trying to run a psql copy from command
through a bash script to load a buch of cdv files into the same table. I'm
getting an error about the file infile not existing?
#!/bin/sh
for infile in /path_to_files/*.csv
do
cat infile | psql dbname -c \copy
On 11 January 2013 19:13, Kirk Wythers kwyth...@umn.edu wrote:
Can anyone see what I'm misisng? I am trying to run a psql copy from
command through a bash script to load a buch of cdv files into the same
table. I'm getting an error about the file infile not existing?
#!/bin/sh
for infile
On 11 January 2013 19:32, Kirk Wythers wythe...@umn.edu wrote:
On Jan 11, 2013, at 12:18 PM, Szymon Guz mabew...@gmail.com wrote:
On 11 January 2013 19:13, Kirk Wythers kwyth...@umn.edu wrote:
Can anyone see what I'm misisng? I am trying to run a psql copy from
command through a bash
Hello
Once more quickie. It seems that I am going to be asked for my password
every time psql loops through the copy statement.
What is considered best practices to handle authentication? I am
connecting locally, as myself as the user and I'm being asked for my user
password. I added the
Kirk Wythers kwyth...@umn.edu writes:
Can anyone see what I'm misisng? I am trying to run a psql copy from
command through a bash script to load a buch of cdv files into the same
table. I'm getting an error about the file infile not existing?
#!/bin/sh
for infile in /path_to_files/*.csv
In regards to 9.1.x, I would like to learn some details of the nature of
checkpointing
=== Question 1 ===
- page 123 is dirty
- checkpointing starts
- page 123 gets written to disk, as part of this checkpoint
- page 123 gets modified again
? Does it get written to disk again, as part of
On Saturday, January 12, 2013 at 04:49, Gavin Flower wrote:
On 12/01/13 06:45, Bosco Rama wrote:
Shouldn't the value for theta be:
2 * pi() * random()
Bosco.
Very definitely! :-)
One could also ask if the value for theta shouldn't be:
tau() * random()
http://tauday.com/ :-)
Regards
On 12/01/13 10:44, Gavan Schneider wrote:
On Saturday, January 12, 2013 at 04:49, Gavin Flower wrote:
On 12/01/13 06:45, Bosco Rama wrote:
Shouldn't the value for theta be:
2 * pi() * random()
Bosco.
Very definitely! :-)
One could also ask if the value for theta shouldn't be:
tau()
I'm wondering if anyone can point me towards a good method for moving mysql
data into Postgres? I've done some web searching, and found documentation
from various years, but it's not clear what's current and what works best.
Much of what I found seems to be flame war material (why Postgres is
On 01/11/2013 03:54 PM, Ken Tanzer wrote:
but that didn't bring me much success. I figure this has to be a fairly
common need, and hopefully by 2013 there's an easy solution. Thanks in
advance!
Have you looked at Foreign Data Wrappers(FDW):
You can search from google,
https://www.google.com/search?q=mysql2pgie=utf-8oe=utf-8aq=trls=org.mozilla:en-US:officialclient=firefox-a
On Sat, Jan 12, 2013 at 7:54 AM, Ken Tanzer ken.tan...@gmail.com wrote:
I'm wondering if anyone can point me towards a good method for moving
mysql data into
On Fri, 11 Jan 2013, Ken Tanzer wrote:
I'm wondering if anyone can point me towards a good method for moving
mysql data into Postgres?
I had to do this last year with the ITIS (Integrated Taxonomic Information
System) maintained by the US Geological Survey.
Some MySQL key words were
On Jan 11, 2013, at 12:18 PM, Szymon Guz mabew...@gmail.com wrote:
On 11 January 2013 19:13, Kirk Wythers kwyth...@umn.edu wrote:
Can anyone see what I'm misisng? I am trying to run a psql copy from
command through a bash script to load a buch of cdv files into the same
table. I'm
Hello,
I am trying to use libpq in two threads, the issue is that I am getting access
violation after several successful connections.
Each thread connects to different db and disconnects immediately after making a
conenction.
So my question is if this is supported by libpq? Is it possible to
Hi All,
@ Tom
Thank you for your response. While working on your suggestions, we seem to
have found the cause of our problems.
@ Yugo
Thank you for your response. We are running pgpool in replication mode
with load balancing enabled. If you have further questions to aid in
debugging the
On Fri, Jan 11, 2013 at 04:27:42PM +0100, Asia wrote:
Hello,
I am trying to use libpq in two threads, the issue is that I am getting
access violation after several successful connections.
Each thread connects to different db and disconnects immediately after making
a conenction.
So my
Hello,
I have a pretty standard query with two tables:
SELECT table_a.id FROM table_a a, table_b b WHERE ... AND ... AND b.value=...;
With the last AND b.value=... the query is extremely slow (did not wait for
it to end, but more than a minute), because the value column is not indexed
On 01/11/2013 11:32 AM, Kirk Wythers wrote:
On Jan 11, 2013, at 12:18 PM, Szymon Guz mabew...@gmail.com
mailto:mabew...@gmail.com wrote:
On 11 January 2013 19:13, Kirk Wythers kwyth...@umn.edu
mailto:kwyth...@umn.edu wrote:
Can anyone see what I'm misisng? I am trying to run a
On 1/11/2013 3:54 PM, Ken Tanzer wrote:
Here's the fuller description of what I'm trying to do. I've got a
dataset (a UMLS//Metathesaurus subset) that I need to get into a
Postgres database. It's all reference data, and so will be
read-only. There's no functions or logic involved. I
On Saturday, January 12, 2013 7:17 AM T. E. Lawrence wrote:
Hello,
I have a pretty standard query with two tables:
SELECT table_a.id FROM table_a a, table_b b WHERE ... AND ... AND b.value=...;
With the last AND b.value=... the query is extremely slow (did not wait for
it to end, but
22 matches
Mail list logo