On Wed, Mar 07, 2007 at 07:46:16AM +0100, Martijn van Oosterhout wrote:
On Tue, Mar 06, 2007 at 08:38:22PM +0200, andyk wrote:
This error is returned by libpq, as a reaction on WSANOBUFS error
from Windows Socket System. This means, applications tries to send much
data, and system can't
Tom Lane wrote:
Richard Huxton dev@archonet.com writes:
Alexander Elgert wrote:
I found the postgres version VERY slow, so a decided to fetch
Define VERY - it took what, milliseconds to do this? Seconds? Hours?
I think he's complaining that the standards-conformant view in Postgres
is
On Tuesday March 6 2007 11:52 pm, Peter Eisentraut wrote:
Ed L. wrote:
Right. I'm asking if the fix for this problem is in the new
8.1.8 software, or in the new DB structure resulting from
the initdb, or perhaps both.
There is no new DB structure in 8.1.8, which is why you can
update
On Wed, Mar 07, 2007 at 02:29:08AM -0700, Ed L. wrote:
Perhaps my question was not clear enough. Let me rephrase: Does
the fix for this problem comes from a *fresh* DB structure
resulting from the initdb, or from a software fix in 8.1.8, or
both? The answer makes a big difference with a
Richard Huxton schrieb:
Alexander Elgert wrote:
Hello,
I programmed a little script which iterates over all databases in a
DBMS, iterating over all tables and then over all columns.
This skript works for mysql and postgres.
1. Solution overview
foreach database {
Hi,
hubert depesz lubaczewski wrote:
i contacted the company some time ago, and the information i got was
that their product is based on query-replication.
Yes, AFAIK, their solution is two phase commit based, like Sequoia.
Regards
Markus
---(end of
Hi,
On Wed, 2007-03-07 at 12:14 +0100, Markus Schiltknecht wrote:
hubert depesz lubaczewski wrote:
i contacted the company some time ago, and the information i got was
that their product is based on query-replication.
Yes, AFAIK, their solution is two phase commit based, like Sequoia.
I
On Wed, Mar 07, 2007 at 12:12:52PM +0100, Alexander Elgert wrote:
Nope - \d is psql only. That's because what it does changes with the
system catalogues. If you want a stable representation, use the
information_schema. If you want all the PostgreSQL-specific details
you'll have to cope with
Alexander Elgert wrote:
This results in a structure where I can itereate over all keys in the
2-dim array.
You can see I iterate first over the databases and then over table AND
columns!
--- mysql: ~1s (Database X)
--- postgres: ~1s (Database Y)
;)
In contrast:
Hi,
Devrim GÜNDÜZ wrote:
Yes, AFAIK, their solution is two phase commit based, like Sequoia.
I thought it was PGCluster. At least this is what I understood from the
drawings.
Uhm, you're right, it looks very similar to PgCluster, not Sequoia. So
it's not two phase commit based, right?
Am Dienstag, 27. Februar 2007 20:37 schrieb Andreas Kretschmer:
Markus Schulz [EMAIL PROTECTED] schrieb:
You can use pg_restore with -l to generate a listfile for all
objects in the database. Then you can reorder this ($EDITOR) and
then use -L to use this ordered listfile to enforce the
Hello,
how can i choose a default data type for casts?
PG 7.4 has some problems to use an existing index, if the datatype not
match.
For example i have a int8 primary id column and search for this column,
i can't use the index for queries like:
SELECT ... WHERE id = 12345
if i'm use:
SELECT ...
Martijn van Oosterhout kleptog@svana.org writes:
... Your real problem is that
you're using the information_schema which has to do all sorts of extra
work for standards compliance. If you don't need that you're going to
be much better off just using the system catalogs.
To put that in some
Markus Schulz [EMAIL PROTECTED] writes:
Is there a solution for PG 7.4 to choose the default datatype for this
way of casting?
Yeah, it's called update to 8.x ...
regards, tom lane
---(end of broadcast)---
TIP 4: Have
Hi,
My database stopped responding last night (Postgres 8.1.4).
at 2 am, a vacuum began running:
/usr/local/pgsql/bin/vacuumdb -afz
When I came in to work this morning, I could query some tables
but not others. There were many(100) processes like:
postgres 11791 6901 0 02:07 ?00:00:00
Tom Lane schrieb:
Martijn van Oosterhout kleptog@svana.org writes:
... Your real problem is that
you're using the information_schema which has to do all sorts of extra
work for standards compliance. If you don't need that you're going to
be much better off just using the system catalogs.
On Wed, 2007-03-07 at 10:08 -0600, John Gateley wrote:
I'm guessing it's something related to table locks.
...
Any pointers on what I should be looking for to prevent this from
happening again? What information I should be tracking to figure
out what is exactly happening?
Your inserts almost
Env: Windows XP sp2
Version: 8.2.1
I'm attempting to write a function which produces a script. The script
will contain steps necessary to drop/recreate all the functions. I've
got a helper function called 'dropprocsbyname' which takes a schema and
a proc name, finds all matching pg_proc rows
Chris Fischer [EMAIL PROTECTED] writes:
I'm attempting to write a function which produces a script. The script
will contain steps necessary to drop/recreate all the functions.
If you're trying to modify functions that are in live use, don't drop
them. Just apply CREATE OR REPLACE FUNCTION.
On Wednesday February 7 2007 9:01 am, Tom Lane wrote:
Ed L. [EMAIL PROTECTED] writes:
How do I fix this 7.4.6 issue short of initdb?
invalid page header in block 110 of relation pg_statistic
I looked at the block via pg_filedump (included below), and
it does not appear to me to be
Ed L. [EMAIL PROTECTED] writes:
The truncate showed no errors. The vacuum analyze showed the
same error in block 110 of the pg_statistic table.
Really!? Hm, I wonder if you have a reproducible problem. Would it be
possible for you to send me the physical pg_statistic file (off-list)?
I'm
On 06/03/07, Tom Lane [EMAIL PROTECTED] wrote:
Anton Melser [EMAIL PROTECTED] writes:
Thanks for your reply. I am managing a db that has some export scripts
that don't do a drop/create, but rather a delete from at the start of
the proc (6 or 7 tables used for this, and only this). Now given
OK, I modified things to use interpolation. Here's the updated query:
explain UPDATE Transactions
SET previous_value = previous_value(id)
WHERE new_value IS NOT NULL
AND new_value ''
AND node_id IN (351, 169, 664, 240);
And
Any recommendations for vendors that can build custom servers?
Specifically opteron based with scsi raid.
Chris
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
I periodically take snapshots of my current development database to
facilitate recovery from screw-ups. I do so roughly like this:
createdb -EUTF-8 db-snapshot
pg_dump -Fc db | pg_restore -d db-snapshot
For which I get the fairly innocuous error:
pg_restore: WARNING:
[EMAIL PROTECTED] wrote:
Hi,
I have a GiST index on st_geometry type (a user defined type). It looks
like index is not getting hit when I use some geometric operator. Here
is the example of st_contains operator.
snip
How can I force or direct the planner to use the GiST index? Am I
missing
[EMAIL PROTECTED] wrote:
Have you considered using PostGIS (www.postgis.org) to provide OGC
compliant
spatial data management for Postgresql, including projection support,
indexing
a good selection of spatial query functions?
Cheers,
Brent Wood
Hi,
I have a GiST index on st_geometry
On Wednesday March 7 2007 3:13 am, Martijn van Oosterhout wrote:
On Wed, Mar 07, 2007 at 02:29:08AM -0700, Ed L. wrote:
Perhaps my question was not clear enough. Let me rephrase:
Does the fix for this problem comes from a *fresh* DB
structure resulting from the initdb, or from a software
On Fri, 2007-03-02 at 11:09 -0800, David Fetter wrote:
On Fri, Mar 02, 2007 at 10:52:14AM -0800, Joshua D. Drake wrote:
Hello,
Unfortunately we (the community) will not have WITH/RECURSIVE for 8.3.
However I have spoken with a Alexey and Alvaro and Command Prompt has
decided to make
Simon Riggs [EMAIL PROTECTED] writes:
On Fri, 2007-03-02 at 11:09 -0800, David Fetter wrote:
On Fri, Mar 02, 2007 at 10:52:14AM -0800, Joshua D. Drake wrote:
Hello,
Unfortunately we (the community) will not have WITH/RECURSIVE for 8.3.
However I have spoken with a Alexey and Alvaro
Any chance we can get WITH without RECURSIVE? That would be very
handy all by itself.
I thought Greg already did submitted that?
To my knowledge, it is not done. If it is, great!
Joshua D. Drake
---(end of broadcast)---
TIP 9: In
I've purchased a number of systems (a dozen or so) from avadirect.
http://www.avadirect.com
Their prices are excellent, hardware is solid quality, their service is
median. This is a discount shop, so don't expect lightening support. But you
can buy three fast AVA systems of top-notch quality
Hi all,
I've got a query that looks through a table I use for my little
search engine. It's something of a reverse-index but not quite, where a
proper reverse index would have 'word | doc1, doc3, doc4, doc7' showing
all the docs the keyword is in, mine has an entry for eac
I've got a
Hi all,
I am using a postgres database, and want to set a password for the account.
The default user name is 'postgres' and in order to set a password, I did an
alter user as below,
alter user postgres with password 'mypwd';
The command goes through fine, but the next time I
Try
SELECT DISTINCT
rather than SELECT
That should return a result with unique records.
Madison Kelly wrote:
Hi all,
I've got a query that looks through a table I use for my little
search engine. It's something of a reverse-index but not quite, where
a proper reverse index would have
Hi all,
Got this kind of silly question. I'm trying to use pg_resetxlog.
Problem is the path to c:/Program Files//data doesn't get reached,
probably (space in between). How can I resolve this in order to run
this command ?
Regards,
Steven
---(end of
The command goes through fine, but the next time I log into postgres using
the command,
psql mydb postgres
it logs in, and doesnt ask me for a password at all. If I issue a command
like,
This is because you have trust in pg_hba.conf file, change it to md5 so it
asks for password every time you
Thank you very much Shoaib,
that worked fine !
Regards,
Steven
On 3/8/07, Shoaib Mir [EMAIL PROTECTED] wrote:
Try using something like this -- Program Files/PostgreSQL/data (that is
with quotes for using spaces)
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/8/07, Steven De
38 matches
Mail list logo