Ok, we checked our client code to eliminate this problem. Thanks for
the doc patch.
Regards,
Dirk
Simon Riggs wrote:
On Mon, 2006-07-10 at 13:35 +0200, Dirk Lutzebäck wrote:
In any case I would see this as a security problem because you cannot
control sql code injection easily
the minor
8.1 releases.
In any case I would see this as a security problem because you cannot
control sql code injection easily (as with using DBD::Pg) if you have
to pass parameters in the SQL string to use partial indexes.
Regards,
Dirk
Simon Riggs wrote:
On Mon, 2006-07-10 at 12:22 +0200, D
Hi,
we are using postgresql 8.1.4 and found that partial indexes are not
being used when the query is run using parameters, eg. in a function.
When running the same query with arguments passed in the query string
partial indexes are being used.
here is the index:
CREATE INDEX c_6012_index ON
ur system. Thank you for your
cooperation.
Dirk Lutzebäck <[EMAIL PROTECTED]> Tel +49.30.5362.1635
Fax .1638
CTO AEC/communications GmbH,
Berlin, Germany
writes:
Dirk Lutzebäck wrote:
how can one set the global OID counter in 8.1.X? We think it would work
in 8.0.X using the COPY WITH OIDS command but this does not work in
8.1.X anymore.
pg_resetxlog -o
(Postmaster stopped of course)
Possibl
Hi,
how can one set the global OID counter in 8.1.X? We think it would work
in 8.0.X using the COPY WITH OIDS command but this does not work in
8.1.X anymore.
We have the problem that we made a dump using 'pg_dump -o' in 8.0.X,
created a new database in 8.1.X and read back in but the global
Yes, I finally found the reference in pg_type.
Thanks for your help!
Regards,
Dirk
Tom Lane wrote:
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes:
I have now deleted every temp table I know from pg_temp_nnn using your
approach but still can't dump the schema:
pg_dump: schema
e of the individual or
entity to whom they are addressed. If you are not the intended
recipient, you should not copy it, re-transmit it, use it or disclose
its contents, but should return it to the sender immediately and
delete your copy from your system. Thank you for your
cooperation.
Dirk Lutzebäck <
I have found and deleted an entry with pg_class.relnamespace=559701082
but nowhere else. I still cannot dump the schema. Is there something
like a system catalog integrity checker?
The problem I'm facing is the following:
cs1=# select relname from pg_class where relname like 'bm%';
Yes, I think so. What search path do you mean? These tables were all
temporary tables.
Dirk
Tom Lane wrote:
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes:
The problem I'm facing is the following:
cs1=# select relname from pg_class where relname like 'bm%';
r
Hi,
I get the following error when I call:
# pg_dump db
pg_dump: schema with OID 559701082 does not exist
this happens with 8.0.1 on RHEL 3.0. I cannot dump the database neither
with --schema-only or --data-only.
What can I do?
Thanks for help,
Dirk
---(end of bro
11 matches
Mail list logo
