What's the release date for 7.1 ?
Is it going to have support for the outer joins ?
Are there going to be any performance improvements made (I'm
particularly interested in data selection speed) ?
Is it possible to obtain a list of new features which are coming with
7.1 ?
I'm sure these question
Greetings.
I am writting up a function in PL/pgSQL to automate a couple of multi-table
updates, and I have a question.
I need to check to see if the data is already in the database, and if it is,
perform and update, or if it's not, perform an insert. The lookup is
against a primary key, so I
Greetings,
I've been using Postgres in a Pentium 75Mhz, Linux RedHat 6.2, 32Mb.
Every big query I execute uses too much cpu (more than 90%).
I start postgres with these params: su -l postgres -c
'/usr/bin/postmaster -B 2048 -i -D "/home/postgres/data"' .
What should I do for avoid
Quick easy one:
Could someone please tell me the syntax for adding
a foreign key constraint to an existing row in an existing table.
Thanks.
Never mind..found it.
ALTER TABLE distributors ADD CONSTRAINT distfk
FOREIGN KEY (col_name) REFERENCES table_name(col_name) MATCH
FULL
Sorry to contribute to this list chaos, but I've got a question.
Yes, I know this is not normalized...
I have a table foo with key fookey.
I have a table bar which has as an attribute an array of fookeys called FK.
The number of elements in FK is variable.
I would like to:
select b.fookey,
* Vilson farias [EMAIL PROTECTED] [001027 21:38] wrote:
Greetings,
I've been using Postgres in a Pentium 75Mhz, Linux RedHat 6.2, 32Mb.
Every big query I execute uses too much cpu (more than 90%).
I start postgres with these params: su -l postgres -c
'/usr/bin/postmaster -B
On Fri, Oct 27, 2000 at 03:01:31PM -0400, Tom Lane wrote:
This gives you back an integer number of seconds per Unix conventions,
which you just use atoi() on. For example:
regression=# select date_part('epoch', now());
Thanx
--
Igor Roboul, Unix System Administrator Programmer @
On Fri, 27 Oct 2000, Warren Vanichuk wrote:
Greetings.
I am writting up a function in PL/pgSQL to automate a couple of multi-table
updates, and I have a question.
I need to check to see if the data is already in the database, and if it is,
perform and update, or if it's not, perform
On Fri, Oct 27, 2000 at 07:12:57PM -0200, Vilson farias wrote:
I start postgres with these params: su -l postgres -c
'/usr/bin/postmaster -B 2048 -i -D "/home/postgres/data"' .
Try starting postmaster with 'nice':
nice /usr/bin/postmaster -B 2048 -i -D /home/postgres/data
--
Igor
On Fri, 27 Oct 2000, Vilson farias wrote:
I've been using Postgres in a Pentium 75Mhz, Linux RedHat 6.2, 32Mb.
Every big query I execute uses too much cpu (more than 90%).
I start postgres with these params: su -l postgres -c
'/usr/bin/postmaster -B 2048 -i -D
Awesome, thanx. I thought i was doing something wrong. I suggest that some
sort of warning about this go on the pgsql website (and other places where
us PPC types will notice it) so no one else has to beat their head on the
wall over this.
AP2P
--i
on 10/27/00 10:52 PM, Tom Lane at [EMAIL
[ Blind CC to general added for comment below.]
[Taken off GENERAL, added HACKERS to cc:]
Bruce Momjian wrote:
He's meaning the libpq version for dynamic link loading. Is the
libpq.so lib changing versions (like the change from 6.5.x to 7.0.x
changed from libpq.so.2.0 to
"Oliver Elphick" [EMAIL PROTECTED] writes:
When I got a new message from Tom Lane at 7:30am in England, I wondered
if he was working on PostgreSQL all night as well as all day, so I looked
at the mail headers and found he had posted in mid-evening his time but
the message had taken 6 hours to
OK, here's a situation. One of the programmers at your company runs
the
disk out of space. You're going to go bonk him on the head, but first,
there are more pressing matters. PostgreSQL 6.5 has horked up the
tables,
and needs to be fixed. 7.0 is released, which has a fix for the
15 matches
Mail list logo
