what's the version you're running ? you shouldn't run into that problem too
often with 8.3
just like guys said here, regular vacuum, and reindex once in a while.
On Wed, Oct 22, 2008 at 2:46 AM, Grzegorz Jaśkiewicz [EMAIL PROTECTED] wrote:
what's the version you're running ? you shouldn't run into that problem too
often with 8.3
I'm running 8.3.3 soon to be 8.3.4 or .5 if there's a bug fix due out.
There's only so much the autovacuum daemon can do when
On Tuesday 21 October 2008 Tom Lane's cat, walking on the keyboard, wrote:
AFAICT the matching of .pgpass entries to a connection attempt is
strictly textual. sedeldap != 192.168.1.2 therefore none of
these entries apply.
Thanks, I'm able to make entries work only with the ip address, and
I'm looking for a open source PHP or C#/mod_modo/Apache shopping chart.
PostgreSQL database should contain items and item pictures or pictures
should stored in separate files.
User can pick items, enter quantities and send order which is stored in
database.
Any idea where to find source
On Wed, 22 Oct 2008 12:22:21 +0300
Andrus [EMAIL PROTECTED] wrote:
I'm looking for a open source PHP or C#/mod_modo/Apache shopping
chart.
PostgreSQL database should contain items and item pictures or
pictures should stored in separate files.
User can pick items, enter quantities and
Hi,
http://www.satchmoproject.com/
But it is written in python. Not PHP or C#.
Thomas
Andrus schrieb:
I'm looking for a open source PHP or C#/mod_modo/Apache shopping chart.
PostgreSQL database should contain items and item pictures or pictures
should stored in separate files.
User can
Thomas,
http://www.satchmoproject.com/
But it is written in python. Not PHP or C#.
Thank you.
Unfortunately for me it seems that learning another language, Python +
Django to support shopping cart is too much.
Where to find Visual FoxPro, PHP or C#/mod_mono scripts for this?
Those
you'll have problems finding anything like that, mainly because people
usually write that stuff themselves. So just that python or whatever code as
an example, and write your own lib. You might actually learn something while
doing it too.
Without building up a dynamic query is it possible to:
create or replace function t1(a int[]) as
$$
...
select * from t1 where c in a; // eg in spite of in (1,2,3);
or just obtain a similar effect?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list
Fixed, patch attached.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
diff -c -r src.orig/backend/access/gist/gistget.c
src/backend/access/gist/gistget.c
***
Ivan,
Thank you.
I'm writing one especially based on postgresql but I'm still busy
with the current client to put the source in such a shape that could
be publicly published.
What language are you using ?
The ones I'm aware of are Zen Cart, OSCommerce, Ubercart and
Ecommerce (last 2 for
Hi,
http://www.postgresql.org/docs/current/static/arrays.html
# SELECT 1 = ANY ('{1,2,3}'::integer[]);
?column?
--
t
Ludo
On Wed, Oct 22, 2008 at 2:46 PM, Ivan Sergio Borgonovo
[EMAIL PROTECTED] wrote:
Without building up a dynamic query is it possible to:
create or replace
On Wed, 22 Oct 2008 14:46:35 +0200
Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote:
Without building up a dynamic query is it possible to:
create or replace function t1(a int[]) as
$$
...
select * from t1 where c in a; // eg in spite of in (1,2,3);
or just obtain a similar effect?
tired
20 hours to find the fix Teodor, Kudos !
Due to the importance of the fix, will we see very soon a 8.3.5 ?
Regards,
Laurent.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Scott Marlowe escribió:
Actually this sounds like a TODO to me. I imagine the db knows the
schema and it's just not reporting it in the error message. Bruce?
Tom?
Added -- it should be easy to do, so marked as such.
--
Alvaro Herrera
20 hours to find the fix Teodor, Kudos !
Nothing for the pride :(, my bug.
Due to the importance of the fix, will we see very soon a 8.3.5 ?
Don't known, see discussion. I think, that will make sense.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
Andrus wrote:
Thomas,
http://www.satchmoproject.com/
But it is written in python. Not PHP or C#.
Thank you.
Unfortunately for me it seems that learning another language, Python +
Django to support shopping cart is too much.
Where to find Visual FoxPro, PHP or C#/mod_mono scripts for
On Wed Oct 22 07:01 AM, Andrus wrote:
I have looked some PHP source code archives without success yet.
For PHP, your best option is http://www.magentocommerce.com/ --
http://svn.magentocommerce.com/source/branches/1.1
I've never used it but it's 'clean' code with commercial backing.
--
Alvaro Herrera [EMAIL PROTECTED] writes:
Scott Marlowe escribió:
Actually this sounds like a TODO to me. I imagine the db knows the
schema and it's just not reporting it in the error message. Bruce?
Tom?
Added -- it should be easy to do, so marked as such.
A comprehensive response to this
The type of fix I'd like to see would be to not change message texts at
all, but to add separate error-message fields for the name and schema
name of object(s) involved in an error; which would be details that
psql, for example, would show only in VERBOSE mode. Note that error
report fields
Jonathan,
Thank you.
For PHP, your best option is http://www.magentocommerce.com/ --
http://svn.magentocommerce.com/source/branches/1.1
Magento is only for MySql.
My shopping cart must get products and add orders to existing PostgreSQL
database.
So I must re-write some parts of any
Hi,
Is there any optimal and generally agreed way to store questionnaire
data in a database?
The questionnaire would have to support both of the following:
- different question types (e.g. What is your name? (free form text)
Are you a smoker? (yes/no checkbox) Are you male or female? (radio
On Wed, 22 Oct 2008 15:42:48 +0300
Andrus [EMAIL PROTECTED] wrote:
I think that anyway most of the popular prepackaged solutions
don't support transactions in the DB.
Probably I do'nt need transactions.
You don't need transactions as much as you don't need a database
since you can work on
On Tue, Oct 21, 2008 at 10:00 AM, Brandon Metcalf [EMAIL PROTECTED] wrote:
OK. I'll dig in and can probably figure everything out. I'll contact
David if I can't.
You should try http://www.anysql.net/en/software/refresh_mysql.zip
It's written in Perl and designed to replicate Oracle-MySQL,
On Oct 22, 2008, at 6:50 AM, Tom Lane wrote:
In the
second place, the reason most of our messages don't already contain
schema names is that in the past we've judged it would be mostly
clutter; and given the infrequency of complaints I see no reason to
change that opinion.
Well, FWIW, I
On Wed Oct 22 10:16 AM, Andrus wrote:
Jonathan,
Thank you.
For PHP, your best option is http://www.magentocommerce.com/ --
http://svn.magentocommerce.com/source/branches/1.1
Magento is only for MySql.
Wow that's too bad/sad for the mySQL only. At least they are using innoDB.
My
I've the usual 600K-800K record table a bunch of records (one
coming from another table) are glued to form a tsvector, 3 with the
same weight, the others with different weight.
There is a clustered index on the pk. (is it worth to keep it?)
I wrote a pretty long function that build up a tsquery
Hi,
Any help on the question below? Thanks.
On Oct 15, 6:00 pm, Goboxe [EMAIL PROTECTED] wrote:
Hi,
Let say I created a new type:
CREATE TYPE compfoo AS (f1 int, f2 text);
How can I view its definition?
I tried to view it in pgAdmin but seems cannot fine any node that
display that?
2008/10/14, Rainer Zaiss [EMAIL PROTECTED]:
I would like to aggregate a text array into a multidimensional text array.
Let us say I have one table with two collumns
IDARRAY
A{A1,B1,C1}
A{A2,B2,C2}
B {A3,B3,C3}
If I use a GROUP BY ID, I would like to receive following
I'm not sure / have not used either. Magento seems to use Zend_Db as the
database abstraction so it seems like a matter of porting the schema.
Ubercart does look simpler, go whatever you find more interesting or
faster
to do.
This is interesting.
If it better to modify Magento or Zend Cart
This is minor, but just curious about the reasons for the assymetry
between ALTER and DROP with respect to tables vs. views.
* ALTER TABLE seems to work on both tables and views (even though ALTER
VIEW exists, albeit with a limited operation support).
* DROP TABLE works only on tables, not on
Tom Lane escribió:
A comprehensive response to this type of gripe wouldn't be all that
easy. In the first place, there'd be a lot of code to touch.
Well, that makes it tedious, which is not the same as hard.
In the second place, the reason most of our messages don't already
contain schema
Alvaro Herrera [EMAIL PROTECTED] writes:
Tom Lane escribió:
In the second place, the reason most of our messages don't already
contain schema names is that in the past we've judged it would be
mostly clutter; and given the infrequency of complaints I see no
reason to change that opinion.
I
Well, FWIW, I also would like to be able to see which schema caused the
violation, as I'm in a similar boat of having the same table name in
multiple schemas.
Maybe to report schema name only if it is not public or if same table
exists in different schemas or report it in detail message or
On Wed, Oct 22, 2008 at 11:27 AM, Tom Lane [EMAIL PROTECTED] wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Tom Lane escribió:
In the second place, the reason most of our messages don't already
contain schema names is that in the past we've judged it would be
mostly clutter; and given the
On Wed, Oct 22, 2008 at 11:13 AM, Andrus [EMAIL PROTECTED] wrote:
Well, FWIW, I also would like to be able to see which schema caused the
violation, as I'm in a similar boat of having the same table name in
multiple schemas.
Maybe to report schema name only if it is not public or if same
Goboxe [EMAIL PROTECTED] writes:
Let say I created a new type:
CREATE TYPE compfoo AS (f1 int, f2 text);
How can I view its definition?
In psql, \d works:
regression=# CREATE TYPE compfoo AS (f1 int, f2 text);
CREATE TYPE
regression=# \d compfoo
Composite type public.compfoo
Column | Type
On Wed, Oct 22, 2008 at 12:55 PM, Osvaldo Kussama
[EMAIL PROTECTED] wrote:
2008/10/14, Rainer Zaiss [EMAIL PROTECTED]:
I would like to aggregate a text array into a multidimensional text array.
Let us say I have one table with two collumns
IDARRAY
A{A1,B1,C1}
A{A2,B2,C2}
B
George Pavlov [EMAIL PROTECTED] writes:
Wouldn't it be cleaner if view operations worked only on views and table
ones on tables?
It's not worth the backwards-compatibility issues that would ensue.
regards, tom lane
--
Sent via pgsql-general mailing list
George Pavlov wrote:
I
suspect lack of complaints is largely due to the (small) number of
people using namespaces -- the denominator should be users of the
feature, not all users...
I certainly found it extremely frustrating that errors didn't reference
the involved schema when I was
I want to use a function in to a trigger
This is my
CREATE FUNCTION subradio(integer) RETURNS integer AS 'select cast(count
(claveubica) as integer ) from asradios where ubicacion =0;' LANGUAGE 'sql';
And my ttrigger is
CREATE TRIGGER validaradios AFTER DELETE ON subestacion FOR EACH
In the second place, the reason most of our messages don't already
contain schema names is that in the past we've judged it would be
mostly clutter; and given the infrequency of complaints I see no
reason to change that opinion.
I tend to disagree. We can run a poll in a wider
2008/10/22 Ma. Cristina Peña C. [EMAIL PROTECTED]
I want to use a function in to a trigger
This is my
CREATE FUNCTION subradio(integer) RETURNS integer AS 'select cast(count
(claveubica) as integer ) from asradios where ubicacion =0;' LANGUAGE 'sql';
And my ttrigger is
CREATE
Hi
How to get X and Y coordinates from point(X,Y)?
I need only X from (X,Y)
Thanks in advance
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Alexander Kuprijanov [EMAIL PROTECTED] writes:
How to get X and Y coordinates from point(X,Y)?
Subscript it. See the next-to-last para on
http://www.postgresql.org/docs/8.3/static/functions-geometry.html
regards, tom lane
--
Sent via pgsql-general mailing list
Hey folks,
I am trying to rewrite a query here, that takes 1.5m atm to finish. I got it
down to 20s, and still trying to pin it down.
basically, a query looks something like that atm:
select a.*, b.*
from a
join b on a.id = b.a_id and a.banned true
where
a.start = now()
and
b.end
Fernando Moreno a écrit :
2008/10/22 Ma. Cristina Peña C. [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
I want to use a function in to a trigger
This is my
CREATE FUNCTION subradio(integer) RETURNS integer AS 'select
cast(count (claveubica) as integer ) from asradios where
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= [EMAIL PROTECTED] writes:
that's 20s query, and now I got it down to 10s , by using something - which
in my eyes would be always wrong - and against all logic. So if someone
could please explain to me why is it faster:
[ shrug... ] If you aren't going to
Guillaume Lelarge [EMAIL PROTECTED] writes:
Fernando Moreno a écrit :
A trigger function must have a specific structure, it takes no arguments
It can take arguments.
No, it can't. At least not in the declaration.
regards, tom lane
--
Sent via pgsql-general mailing
Greetings,
I'm looking for pointers to info on storeing / retreving docbook, or other
document type systems, in sql tables.
My searchs on docbook sql etc turn up info on manuals etc for a system in
docbook, which is not at all what I'm looking for. (e.g. postgresql doc are
in docbook form...)
Hi,
I'm trying to make a module allowing Drupal to take advantage of
PostgreSQL's excellent Full Text Search, aka. tsearch.
Since this module will probably not become part of Drupal core right off
the bat, I need to do this without modifying Drupal's own tables, so I've
created a new one for
we're even more in the dark than you are.
:)
so here are the plans, that's the real table run.
QUERY PLAN after
On Thu, 23 Oct 2008 00:10:19 +0200
Mikkel Høgh [EMAIL PROTECTED] wrote:
Hi,
I'm trying to make a module allowing Drupal to take advantage of
PostgreSQL's excellent Full Text Search, aka. tsearch.
Since this module will probably not become part of Drupal core
right off the bat, I need to do
Greetings:
I successfully installed PostgreSQL 8.3.4-1 on Windows 2003 Server.
Additionally, I used the stackbuilder to install Apache 2.2.4 and PHP 5.1.3.
What is the suggested method of updating Apache and PHP?
BTW, I found it interesting that Apache and PHP would live within my
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= [EMAIL PROTECTED] writes:
so here are the plans, that's the real table run.
Hmm, well this rowcount estimate is way off:
- Hash Anti Join (cost=376.60..37791.22 rows=1
width=8) (actual time=15.195..8216.448 rows=2 loops=1)
The
On Thu, Oct 23, 2008 at 12:25 AM, Tom Lane [EMAIL PROTECTED] wrote:
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= [EMAIL PROTECTED] writes:
so here are the plans, that's the real table run.
Hmm, well this rowcount estimate is way off:
- Hash Anti Join (cost=376.60..37791.22
Sort Method: external sort Disk: 1320kB
One simple speedup could be upping Your work_mem to 2M for this query,
so the sorts are in memory.
btw: Last time I used Postgres, it did not show the sort method. Cool.
Greetings
Marcin Mank
--
Sent via pgsql-general mailing list
On Thu, Oct 23, 2008 at 12:25 AM, Tom Lane [EMAIL PROTECTED] wrote:
It looks like you are testing a case where the tables all
fit in memory. Do you expect that to be the reality for your production
use? If so, you might want to reduce random_page_cost to something
close to 1 to reflect it.
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= [EMAIL PROTECTED] writes:
On Thu, Oct 23, 2008 at 12:25 AM, Tom Lane [EMAIL PROTECTED] wrote:
I'm not sure why the rowcount estimate is so far off, but the antijoin
code is all new and probably there's an estimation bug in there
somewhere. (You didn't get
thanks. I shall try it.Also, thanks for putting my name in cvs log ;)
60 matches
Mail list logo