Hi,
I'm new to pgsql (but not databases in general) and I've run into a roadblock
that I'm having difficulty figuring out how to get around. Any help would be
greatly appreciated!
I'm using the database to store the results of calculations over data in some
tables. There are a lot of data re
egs of RAM (assuming
cursor records are all stored in memory)...
Thanks for the help,
Carl
On Saturday, March 07, 2009, Tom Lane wrote:
> Carl Sopchak writes:
> > I have written a PL/pgSQL function that performs these calculations by
> > reading the needed data, calculating, and savi
On Sunday, March 08, 2009, Gregory Stark wrote:
> Carl Sopchak writes:
> > Well, the upgrade to 8.3 seemed to rid me of the command limit, but now
> > I'm running out of memory. I have 2Gb physical and 8Gb swap (after
> > adding 4Gb).
>
> What do you mean you
On Sunday, March 08, 2009, Alvaro Herrera wrote:
> Carl Sopchak wrote:
> > Well, the upgrade to 8.3 seemed to rid me of the command limit, but now
> > I'm running out of memory. I have 2Gb physical and 8Gb swap (after
> > adding 4Gb).
>
> Do you have AFTER trigge
On Sunday, March 08, 2009, Tom Lane wrote:
> Carl Sopchak writes:
> > On Sunday, March 08, 2009, Gregory Stark wrote:
> >> What do you mean you're running out of memory?
> >
> > "ERROR: Out of Memory" is what I meant when I said I was running out of
&g
On Sunday, March 08, 2009, Tom Lane wrote:
> Carl Sopchak writes:
> > Here's what's around the error message in the log:
> >
> > SPI Proc: 3154128080 total in 398 blocks; 13664 free (178 chunks);
> > 3154114416 used
>
> Hmm, so apparently some inter
When I run the following query through psql, it executes successfully.
However, when I run it through ODBC (via OpenOffice Base), I get the error
SQL Status: HY000
Error code: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
Is this some limitation of ODBC? (I do
On Saturday, March 14, 2009, Adrian Klaver wrote:
> On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote:
> > When I run the following query through psql, it executes successfully.
> > However, when I run it through ODBC (via OpenOffice Base), I get the
> > error
>
On Saturday, March 14, 2009, Dann Corbit wrote:
> > -Original Message-
> > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> > ow...@postgresql.org] On Behalf Of Carl Sopchak
> > Sent: Saturday, March 14, 2009 5:41 PM
> > To: pgsql-gene
On Saturday, March 14, 2009, Adrian Klaver wrote:
> On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote:
> > When I run the following query through psql, it executes successfully.
> > However, when I run it through ODBC (via OpenOffice Base), I get the
> > error
>
10 matches
Mail list logo