I've been using the generate_series function and finding it very useful. It
generates an integer, but I cast to 'day' interval.
Might be useful.
doug
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On
Behalf Of Richard Broersma
Sent: Wednes
On Wed, May 12, 2010 at 10:32 AM, Josh wrote:
> I am trying to create a function that loads 100M test records into a
> database, however I am having a hard time building the function that does
> so.
Here is one idea a function, but is could be wrapped by one:
p2082849b=> INSERT INTO Testtable
On 05/12/2010 01:32 PM, Josh wrote:
Hello, I'm a little new at this so please bear with me.
I am trying to create a function that loads 100M test records into a
database, however I am having a hard time building the function that
does so.
I'm trying to do this in PGAdmin III for Ubuntu. Is
Hello, I'm a little new at this so please bear with me.
I am trying to create a function that loads 100M test records into a
database, however I am having a hard time building the function that
does so.
I'm trying to do this in PGAdmin III for Ubuntu. Is there something
that I have wrong w
oops typos
On 5/12/2010 1:41 AM, Louis-David Mitterrand wrote:
> Hi,
>
> I have a large dataset (page 1 at http://www.cruisefish.net/stat.md) and
> am in the process of developping a pager to let users leaf through it
> (30K rows).
>
That's not that big of a record set.
> Ideally I'd like to know
On 5/12/2010 1:41 AM, Louis-David Mitterrand wrote:
> Hi,
>
> I have a large dataset (page 1 at http://www.cruisefish.net/stat.md) and
> am in the process of developping a pager to let users leaf through it
> (30K rows).
>
That's not that big of a record set.
> Ideally I'd like to know when r
I'm sure most will urge you to move to UTF-8 encoding asap.
Have you tracked down the "offending" insert statement? Perhaps it's a
trigger trying to generate a log message?
On 05/12/2010 04:34 AM, Gnanakumar wrote:
> Hi,
>
> Because there was no response for this question already posted in
> pg
Hi,
Because there was no response for this question already posted in
pgsql-j...@postgresql.org mailing list, I'm posting it here.
I'm using PostgreSQL 8.2 and my production server is based on CentOS release
5.2 (Final).
JDBC Jar: postgresql-8.2-508.jdbc4.jar
I noticed from my server log that s
