Christopher Murtagh wrote:
On Tue, 2003-11-11 at 00:07, Joe Conway wrote:
Write a Pl/Perl function that just does the syscall, and call it from
PL/pgSQL. Similarly for complex string parsing, etc.
That would work if I could get the Pl/Perl function to return an array
or set of results, but this b
Christopher Murtagh wrote:
On Mon, 2003-11-10 at 23:05, Joshua D. Drake wrote:
Hello,
If you can code in Perl then pl/C wouldn't be a deep jump.
That might not be a bad idea. Haven't done much C programming since my
CS days, but I really loved it then.
Other than here:
http://www.pos
On Tuesday 11 November 2003 02:16, Robert Creager wrote:
> When grilled further on (Mon, 10 Nov 2003 09:39:32 -0500),
>
> Tom Lane <[EMAIL PROTECTED]> confessed:
> > We recently decided we had to forbid foreign-key references from temp
> > tables to permanent tables because of this effect. I wonde
Tom,
On Mon, 10 Nov 2003 09:39:32 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> >> select * from a; # You can get both global and temporary values.
>
> I don't think it's actually reliable. B was meant to be a temp table,
> right?
Ugh Yes.
create *temp* table b() inherits (a);
--
TANIDA
According to my test (pg 7.2.4), the owner of the table will be null
after the user PIPPO is dropped.
test=# \dt aa
List of relations
Name | Type | Owner
--+---+---
aa | table | pippo
test=# drop user PIPPO;
DROP USER
test=# \dt aa
List of relations
Name | Type | Owner
Christopher Murtagh wrote:
On Mon, 2003-11-10 at 21:11, Joshua D. Drake wrote:
The fact that it is pl/pgSQL? Seriously though, I think that pl/pgSQL is
counter intuitive to some people and those of us who are coming from say a Perl
background are going to be much more proficient in using pl/Perl
On Mon, Nov 10, 2003 at 03:00:34PM -0800, Joshua D. Drake wrote:
> >>Better start learning Tcl ...
> What are we torturing people now? Can plPython do this?
Well, aparently Tcl is not up to the task either, nor is plPython. At
least I can find no mention on the docs nor the source code. Can yo
On Mon, 2003-11-10 at 23:05, Joshua D. Drake wrote:
> Hello,
>
>If you can code in Perl then pl/C wouldn't be a deep jump.
That might not be a bad idea. Haven't done much C programming since my
CS days, but I really loved it then.
Other than here:
http://www.postgres.org/docs/7.3/static
Christopher Murtagh wrote:
On Mon, 2003-11-10 at 16:52, Alvaro Herrera wrote:
Better start learning Tcl ...
Thanks for the info. I'm ok with that, I like Perl, but I can live
without it too. :-) Two questions:
1) Can Tcl return multiple rows?
3) ok, 3 questions... Any word on pl/php and a release
Hello,
If you can code in Perl then pl/C wouldn't be a deep jump.
J
Christopher Murtagh wrote:
On Mon, 2003-11-10 at 21:11, Joshua D. Drake wrote:
The fact that it is pl/pgSQL? Seriously though, I think that pl/pgSQL is
counter intuitive to some people and those of us who are coming from
On Mon, 2003-11-10 at 21:11, Joshua D. Drake wrote:
> The fact that it is pl/pgSQL? Seriously though, I think that pl/pgSQL is
> counter intuitive to some people and those of us who are coming from say a Perl
> background are going to be much more proficient in using pl/Perl then having
> to learn
We have just packaged up our second Release Candidate for v7.4, with the
hopes of producing a full release next week.
A full ChangeLog is available at:
ftp://ftp.postgresql.org/pub/sources/v7.4/ChangeLog.RC1.to.RC2
But, one of the highlights is that support for tcl8.0.x has been
re-int
Hello Bruce,
Monday, November 10, 2003, 11:08:47 AM, you wrote:
BM> Tom Lane wrote:
>> Bruce Momjian <[EMAIL PROTECTED]> writes:
>> > Tom Lane wrote:
>> >> We recently decided we had to forbid foreign-key references from temp
>> >> tables to permanent tables because of this effect. I wonder whet
El Lun 10 Nov 2003 16:14, MaRcElO PeReIrA escribió:
> Hi guys,
>
> Do you know any web based bug tracker software that
> use PostgreSQL???
>
> Somebody has told me about Mantis, but it use MySQL...
> and I resign to use that! :(
>
> Which is the best bug tracker you
> know???(PHP+PostgreSQL)
Wa
MaRcElO PeReIrA wrote:
Hi guys,
Do you know any web based bug tracker software that
use PostgreSQL???
Somebody has told me about Mantis, but it use MySQL...
and I resign to use that! :(
Which is the best bug tracker you
know???(PHP+PostgreSQL)
We use TUTOS ( www.tutos.org ) but the bugs trackin
Hi guys,
Do you know any web based bug tracker software that
use PostgreSQL???
Somebody has told me about Mantis, but it use MySQL...
and I resign to use that! :(
Which is the best bug tracker you
know???(PHP+PostgreSQL)
Thanks in advance and
Best Regards,
Marcelo Pereira
Yahoo! Mail - 6MB, a
I am using Postgres 7.3.4 through JDBC, and turning auto-commit off. My
application needs to insert a row or, if a row with the same primary key
already exists, update the existing row. I was hoping to implement this
by just trying the insert, and doing the update only in case of a PK
violatio
Adam Ruth wrote:
The optimizer is looking at the statistics and figuring that the second
query could be done better with a sequential scan (perhaps there aren't
many rows). Have you analyzed the table to get the statistics up to
date? It could also be that the seq scan is faster with the si
Christopher Murtagh writes:
> checking openssl/ssl.h usability... no
> checking openssl/ssl.h presence... no
> checking for openssl/ssl.h... no
> configure: error: header file is required for OpenSSL
Check the config.log file.
> [EMAIL PROTECTED] postgres]$ /usr/local/pgsql/bin/createlang plper
Greetings,
I'm trying to build 7.3.4 and I've come across two problems, one during
the configure and the other afterward.
Problem 1)
Trying to build with openssl support gives this:
./configure --with-openssl --enable-odbc --with-perl --enable-multibyte
...
checking openssl/ssl.h usability.
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> We recently decided we had to forbid foreign-key references from temp
>> tables to permanent tables because of this effect. I wonder whether
>> we won't end up forbidding temp tables as children of permanent tables
>> too.
> Yep, I th
I am trying to set up a project in Visual C++ to use libpq.dll
from Postgres. Are there instructions on how and where to build the
libpq.dll and then insert libpq.dll and libpq-fe.h into a project.
Thanks, I am trying to get a quick start back into coding after not doing it
for a while…
Hi if you take a look at the following
query's you can see that the third query should logically
return 043219but instead it's not returning any rows ?? What's
happening ??
dragon=> SELECT cod_etu from parcours_v where
cod_etu = '043219'; cod_etu-(0 rows)
dragon=> S
I saw this method of Statement class in jdbc.
Will the return int contain the autogenerated key value ??
public int executeUpdate(String sql,
int autoGeneratedKeys)
throws SQLException
thanks,
kathy
Scott Chapman wrote:
> On Monday 10 November 2003 08
On my windows/cygwin/PG 7.3.1 box, results are sorted
with lowercase appearing after uppercase. On my
redhat/PG 7.3.3 boxes results are sorted without
regard to case. Is there some locale (or other)
setting that controls this? If so, which locales do
which?
Or is this due to something else entirel
Tom Lane wrote:
> "Mattias Kregert" <[EMAIL PROTECTED]> writes:
> > This is great!
>
> >> create table a(...);
> >> insert into a(...); # fixed values
> >>
> >> create table b() inherits (a);
> >> insert into b values(...); # temporary values
> >>
> >> select * from a; # You can get both global
On Monday 10 November 2003 08:23, David Green wrote:
> Are X & Y two different connections?
> If you execute 2 statements on the same connection and then get
> currval() it will give the last generated id.
>
> Ex.
> On 1 connection:
> INSERT INTO A (fld) VALUES (val); -- id generated = 1
> INSERT I
On Mon, Nov 10, 2003 at 08:09:29AM -0800, Scott Chapman wrote:
> Chronological events here:
>
> X inserts a new record into A.
> Y inserts a new record into A.
> X fetches currval of the SA. What value does X get in this case, the one
> from X's insert or Y's?
X's.
--
Alvaro Herrera ()
"¿Qué
Hello,
Imagine we have the following kind of table, with two values (a and b), and a varchar
(f) representing an expression.
--
CREATE TABLE public.test
(
id serial NOT NULL,
a int4,
b int4,
f varchar(50),
CONSTRAINT id PRIMARY KEY (id)
) WITHOUT OIDS;
On Mon, Nov 10, 2003 at 16:20:21 +0900,
Alex <[EMAIL PROTECTED]> wrote:
> Bruno,
> thanks. I actually did it that way but having to join two tables each
> 1-2 million records makes this process rather time consuming.
> I was hoping that the ON DELETE options in the constraint could handle
> tha
"Philippe Lang" <[EMAIL PROTECTED]> writes:
> Is there a simple way of doing "kind of" a
> SELECT *, EVAL(f) FROM public.test;
> ... and having f evaluated as an expression, so that we get back:
> --
> id a bfeval
> --
> 1
"Mattias Kregert" <[EMAIL PROTECTED]> writes:
> This is great!
>> create table a(...);
>> insert into a(...); # fixed values
>>
>> create table b() inherits (a);
>> insert into b values(...); # temporary values
>>
>> select * from a; # You can get both global and temporary values.
I don't think
On Mon, 10 Nov 2003, Pavel Stehule wrote:
> Hello,
>
> it isn't problem. You can write
>
> SELECT INTO
> IF FOUND THEN
> ...
> END IF
>
> or
>
> SELECT INTO ..
> GET DIAGNOSTICS variable = ROW_COUNT;
> IF variable > 0 THEN
> ...
> END IF
>
> You can see on
> http://developer.postgr
On Monday 10 November 2003 15:02, javier garcia - CEBAS wrote:
> Hello;
>
> If I add the line:
> ---
> su -c 'pg_ctl start -D /usr/local/pgsql/data/ -l
> /usr/local/pgsql/data/logfile' postgres
> ---
> to /etc/rc.d/rd.local.
> Is there a way this could work when I d
This is great! I have been looking for this too... I think this should go in the
manual as an example of how application sessions can be recorded in the db. Very
useful!
/M
- Original Message -
From: "TANIDA Yutaka" <[EMAIL PROTECTED]>
To: "Boris Popov" <[EMAIL PROTECTED]>
Cc: <[EMAIL
Maybe you can use a for if there is only one row it will do the job just
like if there were many rows:
FOR referrer_keys IN SELECT * FROM cs_referrer_keys ORDER BY try_order
LOOP
a_output := a_output || '' IF v_'' || referrer_keys.kind || '' LIKE
''
|| referrer
Hi,
We need to implement following logic efficiently.
SELECT * from some_table where [ Query 1 ]
IF rows_matched = 1 THEN
use the single row that matched.
ELSIF
loop thru the results of [Query 1]
END IF;
Currently i am doing select count(*) for getting rows_matched
in
Hello;
If I add the line:
---
su -c 'pg_ctl start -D /usr/local/pgsql/data/ -l
/usr/local/pgsql/data/logfile' postgres
---
to /etc/rc.d/rd.local.
Is there a way this could work when I don't boot as root, but as a common
user?
(I should be able to automatically p
I have create user PIPPO:
CREATE USER PIPPO;
I have create a table:
create table aa (id int4);
Change owner of table to user PIPPO.
alter table aa owner pippo;
I drop user PIPPO. Who is the owner of the table?
Thanks.
Bye !!
Frank Lupo (Wolf) !!
/\_ _/\
\ o o /
--ooo-ooo--
Le Samedi 8 Novembre 2003 17:38, monu agrawal a écrit :
> Is there any way in pgsql to measure that how much time a transaction has
> taken & how many disk accesses it has performed.
You can use pgAdmin3 (http://www.pgadmin.org) SQL editor for transaction time.
Now, if you are using WAL with enou
Hello,
it isn't problem. You can write
SELECT INTO
IF FOUND THEN
...
END IF
or
SELECT INTO ..
GET DIAGNOSTICS variable = ROW_COUNT;
IF variable > 0 THEN
...
END IF
You can see on
http://developer.postgresql.org/docs/postgres/plpgsql-statements.html#PLPGSQL-SELECT-INTO
Regards
Pavel
Le Dimanche 9 Novembre 2003 19:39, Rajesh Kumar Mallah a écrit :
> If so what is the process
The advantage of using a Unicode database is that UTF-8 supports/includes all
known encodings at once. Therefore, in the process of development, it can
help you save time.
When using a Unicode database,
Hi
I prepare to write a master thesis about PostgreSQL. I need some
technical information about solution (concrite information about
algorithms, why the postgresql "masters" used exactly this algorithms).
Most information avaliable (s2k-ftp.cs.berkeley.edu:8000/postgre/papers,
http://developer.
Maybe it is a little late to be posting on this thread - but I was doing
pgbench runs with a Raid 0 ATA system and thought the results might be
interesting.
So here they are : pgbench -c 5 -t 1000 -s 5, median of 3 runs on a
Dual PIII 700 512Mb 2x7200 RPM ATA 133 Promise TX200
(same method / Pg
44 matches
Mail list logo
