On Fri, 2004-01-30 at 13:04, Alvaro Herrera wrote:
> On Thu, Jan 29, 2004 at 08:50:47PM -0500, Manuel Tejada wrote:
>
> > By the way, what does mean RHEL3?
>
> "Red Hat Entreprise Linux", a commercial Linux distribution (meaning you
> shouldn't use it unless you pay for it).
No, it means you won
"nednieuws | charles" <[EMAIL PROTECTED]> writes:
> The source db is PostgreSQL 7.4 and the target db is 7.3.3
pg_dump is not designed to handle downgrades --- its output is intended
to be loaded into pg_dump's own version or later. You should expect to
have to hand-edit the output to load it int
What does this error mean:
pg_restore: creating TABLE author
pg_restore: creating SEQUENCE author_id
pg_restore: [archiver (db)] could not execute query: ERROR: parser: parse error at or
near "BY" at character 144
pg_restore: *** aborted because of error
The line in question is:
GRANT ALL ON
Unregistered <[EMAIL PROTECTED]> writes:
> So what I did was:
> made an "today_idx", "2_weeks_idx", "1 month_idx" on the attribute
> "sent_date" to speed up the queries using the "sent_date"
> attribute,which 90% of the times is queried on. These indexes are
> rebuild every night.
> When I was t
I have following situation:
one "message" table and 3 other "message_{1,2,3}" tables which inherit
from "message".
Every day +-50 000 "messages" are being inserted.
I needed something extra to speed up the queries instead of only using
indexes, so I thought of doing something like you can do in
Manuel Tejada wrote:
> Thank you very much Gaetano
>
> I edited the pgdb.py file setting "4" instead of "typprtlen".
> Now I am able to connect to PostgreSQL using pgdb.py.
>
> Just for curiosity, Can I set to -1 too as Gerhard Haring told to you?
I think yes, I really didn't dig on it to see the
Thank you very much Gaetano
I edited the pgdb.py file setting "4" instead of "typprtlen".
Now I am able to connect to PostgreSQL using pgdb.py.
Just for curiosity, Can I set to -1 too as Gerhard Haring told to you?
- Original Message -
From: "Gaetano Mendola" <[EMAIL PROTECTED]>
Newsg
> It is found that pg_dump does not dump function referred in CHECK
> constraint definations before dumping the table defination . As a result
> the tables
> do not get restored due to lack of defined functions.
> Is it something that will be worked upon in future ?
This is fixed in CVS tip.
Tom Lane wrote:
"Manuel Tejada" <[EMAIL PROTECTED]> writes:
But now when I input the same sintaxis with the new Installation(PostgreSQL
7.4.1), I get an error when I enter rhe four line:
_pg.error: ERROR: non exist the column "typprtlen"
I believe this indicates you're using an old version of
Manuel Tejada wrote:
import pgdb
dbConnect = pgdb.connect(dsn='localhost:oracle', user='manuel',
password='')
cursor = dbConnect.cursor()
cursor.execute("select * from address")
Traceback (most recent call last):
File "", line 1, in ?
File "/usr/lib/python2.2/site-packages/pgdb.py", line 18
Greetings!
It is found that pg_dump does not dump function referred in CHECK
constraint definations before dumping the table defination . As a result
the tables
do not get restored due to lack of defined functions.
Is it something that will be worked upon in future ?
regds
mallah.
-
> On Sun, 1 Feb 2004, Merrall, Graeme wrote:
>
> >
> > I don't think there's an easy way to do this but I thought
> I better ask just in case. I'm trying to come up with a way
> to search across a number of databases without resorting to
> lots of horrible scripts. In one database I have a lo
Why not use schema and single search table contains indices from
different schemes (use trigger to update search table)
On Sun, 1 Feb 2004, Merrall, Graeme wrote:
>
> I don't think there's an easy way to do this but I thought I better ask just in
> case. I'm trying to come up with a way to sear
Joseph Shraibman <[EMAIL PROTECTED]> writes:
> Does ALTER TABLE ALTER SET STATISTICS 100; lock the
> table? I just tried to do that while a query is running and the ALTER
> is hanging.
Any ALTER TABLE will lock the table.
regards, tom lane
---
14 matches
Mail list logo
