I have a postgresql 7.0.2 server running on a linux box. I have a number of
views that I have converted to tables in order to improve performance. I
need these tables to be deleted and re-created daily and using a script
through cron would work beautifully.
Is it possible to require all used to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I just got everyone's favorite error message:
FATAL 1: my bits moved right off the end of the world!
Recreate index pg_attribute_relid_attnum_index.
Except, of course, this is a system index.
The query was:
CREATE TEMP TABLE NextHopTemp (n
Marcin ..
Marcin Inkielman wrote:
> On Sun, 27 Aug 2000, Miles Thompson wrote:
> >
> > Each table you would create for a different type of product can be replaced
> > with a single column, say "product_type", which you could use to broadly
> > classify your items: cars, boats, computers, applian
Andrew,
As I was reading Marcin's reply to my message of earlier today I began to think of
how PGSQL has been extended. My thinking was purely relational, an "objectified"
approach would probably be worth considering.
[EMAIL PROTECTED] wrote:
> On Sun, 27 Aug 2000, Miles Thompson wrote:
>
> > O
On Sun, 27 Aug 2000, Miles Thompson wrote:
> Other columns could simply be labelled "descrip1", "descrip2", "descrip3", as
> many as you need, for the different attributes of each item. So "descrip1" may
Now someone once said to me "If you find your labeling your fields x1, x2,
x3... then your
My background project is to turn postgresql into a ODMG compliant object
database. But more work needs to be done!
Vince Vielhaber wrote:
>
> Forwarded from the webmaster mailbox, please be sure to include
> [EMAIL PROTECTED] in your responses.
>
> -- Forwarded message --
> Dat
Does anyone know of any plans to support aggregates of aggregates in the
future? It would be great to be able to select with an aggregate function
from another select statement with another aggregate function. I have
tried putting the result of an aggregate function in a view and then
performing a
I've been using PHP with PostgreSQL as long as I've been using either, what
is the error message exactly?
Did you install the libraries in something other than the default
directories? You can configure PHP with --with-pgsql=/path/to/pglibs if you
did..
-Mitch
- Original Message -
From
On Sun, 27 Aug 2000, Miles Thompson wrote:
>
> Each table you would create for a different type of product can be replaced
> with a single column, say "product_type", which you could use to broadly
> classify your items: cars, boats, computers, appliances, etc.
don't you think that this is exect
Marcin ... comments below
Marcin Inkielman wrote:
> On Sun, 27 Aug 2000, Jurgen Defurne wrote:
>
> > Any time your design is heading in this direction, take a good hard look
> at
> > it. Proper organization with the appropriate indexes is the way to go.
> >
> > With tens of hundreds of tables,
anuj wrote:
>
> > >>> select count(distinct(row)) from table;
> hi,
> I have also tried but I am geting an error.
>
It's true that you get an error from trying to execute the query above;
'distinct' is not a function but a keyword, count() is a agregate
function. Following this the correct not
On Sun, 27 Aug 2000, Jurgen Defurne wrote:
> Any time your design is heading in this direction, take a good hard look
> at
> it. Proper organization with the appropriate indexes is the way to go.
>
> With tens of hundreds of tables, how will you decide which to use?
> How will you write your que
George Robinson II <[EMAIL PROTECTED]> writes:
> Last night, while my perl script was doing a huge insert operation, I
> got this error...
> DBD::Pg::st execute failed: ERROR: copy: line 4857, pg_atoi: error
> reading "2244904358": Result too large
> Now, I'm not sure if this is rel
13 matches
Mail list logo
