On Thu, 9 Nov 2000, Josh Berkus wrote:
> 2. Stored Procedure functionality, i.e. outputting a full recordset from
> a function (or new structure, if functions are hard to adapt) based on
> the last SELECT statement passed to the function. An alternative would
> be to develop parameterized views,
Josh Berkus wrote:
>
> Tom, Bruce, Jan, etc.:
>
> As a PGSQL developer and business customer, I wanted to make some
> public requests as to the development path of PGSQL. While, obviously,
> you will develop the functionality *you* are interested in, I thought it
> might be valuable to
> I've had no problems really until about 8-12 tables joined when you might
> tickle a bug in some versions of postgres which cause bogus plans to be
> generated.
I've had queries with over 25 joins and self-joins with no problems
whatsoever.
Tom, Bruce, Jan, etc.:
As a PGSQL developer and business customer, I wanted to make some
public requests as to the development path of PGSQL. While, obviously,
you will develop the functionality *you* are interested in, I thought it
might be valuable to you to know what things would be m
Mr. Steinbach,
> I have to create a web interface for an Oracle database. I use MS Internet
> Information Server, ODBC driver (tried one from MS and one from Oracle) and an
> Oracle database (I have no permission to change anything in that database).
You seem to have joined/posted to ou
On Fri, 10 Nov 2000, Najm Hashmi wrote:
> I am facing a dilemma at my work, I am using postgres first time. For
> some reason, my co-workers think that in Postgres joins i.e.
> simple joins of two or three tables are so bad that their cost is
> exponential. They believe that postgres simply ta
I am facing a dilemma at my work, I am using postgres first time. For
some reason, my co-workers think that in Postgres joins i.e.
simple joins of two or three tables are so bad that their cost is
exponential. They believe that postgres simply takes Cartesian product
of joining table in order t
This line will set the maximum shared memory in Linux to 64MB:
echo 67108864 > /proc/sys/kernel/shmmax
You can see your default maximum shared memory with this command:
cat /proc/sys/kernel/shmmax
You should probably set this line in /etc/rd.d/init.d/postgresql or
somewhere else, before PostgreS
Forest Wilkinson <[EMAIL PROTECTED]> writes:
> A coworker told me that the postgres implementation of ALTER TABLE ADD
> COLUMN creates an inefficient database.
Dunno where he got that idea.
There are some problems lurking in ADD COLUMN when used on a table with
inheritance children --- the new c
Hi,
how can I configure my kernel to make it work with shared memory blocks of
8Mb?
I'm using RedHat 6.2
Thank you for your help!
Rocael.
Tom Lane <[EMAIL PROTECTED]> wrote:
<[EMAIL PROTECTED]> writes:
> /usr/local/pgsql/bin/postmaster -B 1000 -o "-S 2000" -S -D
> /usr/local/pgsql/data
> and i
hi. i have database with two tables like this:
database=> \d groups
Table "groups"
Attribute | Type | Modifier
---+-+--
id| integer | not null default nextval('g
A coworker told me that the postgres implementation of ALTER TABLE ADD
COLUMN creates an inefficient database. He said it results in a table
whose new column is stored someplace other than the rest of the columns.
(A hidden auxiliary table?) Is this true in postgres 6.5.3? 7.x? Was it
ever tru
On Thu, 9 Nov 2000, Astrid Hexsel wrote:
> Hello all,
>
> I have a form which has got checkboxes and I am having problems to have their
> values stored in different rows of a table.
>
>
> What I have done is:
>
> # colour_id is the name of my checkboxes in the input tag
>
>
> etc ...
On 8 Nov 2000 [EMAIL PROTECTED] wrote:
> I did this to install postgres in a new machine:
> ./configure --prefix=/usr/local/pgsql --with-tcl --with-perl
>
> and I got this:
> loading cache ./config.cache
> checking host system type... /usr/src/pgsql/postgresql-7.0.2/src/config.guess:
> 13497442:
14 matches
Mail list logo
