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 h
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 o
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
Hello,
I am trying to figure out how to return more than
one field using "SETOF".
I can concatenate the fields in the select
statement down to one and use SETOF Text to return them, then split them back
apart in my code. This is a bit kludgy though. I
would rather do this the most cor
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, b
"Neil Davis" <[EMAIL PROTECTED]> writes:
> I am trying to figure out how to return more than one field using "SETOF".
> I can concatenate the fields in the select statement down to one and
> use SETOF Text to return them, then split them back apart in my
> code.
SETOF is not for returning multipl
hello,
i have created a trigger that executes a c function, foo(), after something
is inserted into my table. foo() is supposed to simply write a string to
some file. but after i do an INSERT, nothing is written.
i compiled the source file:
gcc -fPIC -g -c a.c
and then made a shared library:
On Fri, 27 Oct 2000, Dmitriy Agafonov wrote:
> What's the release date for 7.1 ?
January 1st, or there abouts ...
> Is it going to have support for the outer joins ?
yes
> Are there going to be any performance improvements made (I'm
> particularly interested in data selection speed) ?
of cou
On Fri, 27 Oct 2000, Neil Davis wrote:
> Hello,
> I am trying to figure out how to return more than one field using "SETOF".
SETOF is to return more than one record, not more than one field. Also,
SETOF is only currently working for SQL language functions.
What you probably need is following:
c
Hi,
Im trying to access a postgres database on a Raq3 through a DSN in
chilisoft asp.
I have created a database called test, in
the ./home/pgsql/base/test directory.
I can log in as 'myuserid', and run queries on the database inside the
psql monitor.
But when i try to make a dsn in chilisoft w
* 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/postma
Hi.
I'm a new member of a group, and have problem , that I cannot solve by mysel
f.
During a work with RULES for SELECT there were no problems, but they started
, when I added one more field to the
VIEV.
...
CREATE RULE "_RETv2" AS ON SELECT TO "v2" DO INSTEAD SELECT "t0"."kod", "t0"
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 @ sana
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, pe
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 Ro
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 "/home/post
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 PROTEC
On Fri, Oct 27, 2000 at 02:32:28PM -0700, 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
[ 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 t
"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 hou
> I could write a C function to turn FK into a text list, I suppose,
> or create some cast of arrays to tables/set of rows.
Sounds like a repetition group to me. Repetition groups are strictly
prohibited in relational systems. Check your design.
--
contaminated fish and microchips
hu
> > 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
24 matches
Mail list logo
