When I'm trying to make pg_dump on
a data base I have this message:
WARNING: owner of type 'mmm' apperars to be
invalidWARNING: owner of type 'eee' apperars to be invalidWARNING: owner
of type 'refcursor' apperars to be invalid
Where are these object and how can I
destroy its?
The query below is slow because both the lots table and the deficiency_table
table have thousands of records. Can anyone tell me how to do the second
subselect (lot_count) by some method of a join instead of a sub - subselect
OR any other method I can use to optimize this query to make it faster?
Stephan,
Thanks for your reply.
No I don't have indexes on the *_id fields in bus_pc_idc. Now that you
point it out it make perfect sense why this query would
take a while and give the impression it's hanging - it's all those seq
scans.
Thank you kindly, I really appreicate it.
Regards
Rudi.
> Hello,
>
> I have two 4 table with referential constraint's that are hanging when I
> try to delete from them.
>
> I have a,
> users table, ( 3 rows )
> suburbs table ( 16000 rows ),
> regions table ( 54 rows )and
> a bus_pc_idc table ( business type ) ( 3 rows )
>
> Here is my integr
Hello,
I have two 4 table with referential constraint's that are hanging when I
try to delete from them.
I have a,
users table, ( 3 rows )
suburbs table ( 16000 rows ),
regions table ( 54 rows )and
a bus_pc_idc table ( business type ) ( 3 rows )
Here is my integrity rules:
create ta
Ross,
> For the basic interface, we have the user types some words into a textbox,
> then just search 'everything'. I'm weighting the results, so that hits
> on the title count more than on keywords, which count more than on the
> abstract, which count more than in the body.
Before you re-invent
Hey all -
I'm working on the query interface to a system that stores a bunch of
(realtively) small text documents, with titles and keywords, etc.
For the basic interface, we have the user types some words into a textbox,
then just search 'everything'. I'm weighting the results, so that hits
on th
On Mon, 2002-11-04 at 15:00, Patrick Bakker wrote:
> I had gASQL working once but that was awhile ago. gASQL has now been renamed
> as Mergeant and is being developed in conjunction with the gnome-db
> libraries as far as I know. I don't think there has been a stable release of
> it yet, although i
On Mon, 4 Nov 2002, Ben Kassel wrote:
> When I try to create a new row in this table and do not explicitly
> define a unique value for datadefindex I get the following error
> message:
> More information : If I DROP the database, recreate it, and enter
> values into the table manually, the auto
When I try to create a new row in this table and do not explicitly
define a unique value for datadefindex I get the following error
message:
ERROR: Cannot insert a duplicate key into unique index datadef_pkey
Here is the INSERT statement that generated the error:
tmdb=# insert into datadef (
Great
I don't know if my customers can wait until 7.3 official release, but
I'll try to distract them a bit... :-\
Thanks a lot Bruno...
Bruno Wolff III wrote:
>
> On Mon, Nov 04, 2002 at 09:11:30 +0100,
> Terry Yapt <[EMAIL PROTECTED]> wrote:
> >
> > When I compare a numeric(x,0) field
On Mon, Nov 04, 2002 at 09:11:30 +0100,
Terry Yapt <[EMAIL PROTECTED]> wrote:
>
> When I compare a numeric(x,0) field with a float8 field I have an error
> on PostgreSQL what I didn't have with Oracle. I mean:
>
> CREATE test (one numeric(2,0));
>
> SELECT * FROM test WHERE one = 1.0;
W
Hello all,
i DON'T know what is the proper forum to throw this question and I must
to insist in this "feature". Sorry.
I have a lot of tables from Oracle 8i Databases with a lot of columns
with numeric(x,0) definition.
Ok.. I am traslating my oracle tables to PostgreSQL tables. But I am
having
13 matches
Mail list logo
