my data directory is just 1.7G
On Tuesday 10 May 2005 14:33, Frank Finner wrote:
> On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <[EMAIL PROTECTED]>
thought long, then sat down and wrote:
> > im using RH9
> >
> > postgres 7.3.4
>
> Maybe you ran into the same problem I had about a year ag
Hi,
what fix did you do? go for 7.4?
tia,
On Tuesday 10 May 2005 14:33, Frank Finner wrote:
> On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <[EMAIL PROTECTED]>
thought long, then sat down and wrote:
> > im using RH9
> >
> > postgres 7.3.4
>
> Maybe you ran into the same problem I had abou
On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <[EMAIL PROTECTED]> thought
long, then sat down and wrote:
> im using RH9
>
> postgres 7.3.4
Maybe you ran into the same problem I had about a year ago. See
http://archives.postgresql.org/pgsql-general/2004-03/msg00810.php and thread.
My dat
Tom Lane <[EMAIL PROTECTED]> writes:
> However: what about storing the things in hashcode order? Ordering uint32s
> doesn't seem like any big conceptual problem.
>
> I think that efficient implementation of this would require explicitly
> storing the hash code for each index entry, which we don'
Wolfgang, thanks! I am very persuaded by your arguments regarding
Python. What you have written makes me look at Python in a different
light.
I happened to find a download of Python2.2 which I installed at work but
have not tried out. I wish I could find detailed instructions on WHICH
py
Christopher Kings-Lynne napisaÅ(a):
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions
Tom Lane wrote:
I have a gut reaction against that: it makes hash indexes fundamentally
subservient to btrees.
I wouldn't say "subservient" -- if there is no ordering defined for the
index key, we just do a linear scan.
However: what about storing the things in hashcode order? Ordering uint32s
d
Case Studio doesn't generate alter statements.
It does have a database comparison tool, which I have found to be very cool.
""Joshua D. Drake"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Mark Borins wrote:
> > -->
> >
> > Postgres Newsgroup,
> >
> >
> >
> > My company has been
Neil Conway <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> On the other hand, once you reach the target index page, a hash index
>> has no better method than linear scan through all the page's index
>> entries to find the actually wanted key(s)
> I wonder if it would be possible to store the key
i didnt set fsm... the config i paste is all that i put into place...
is there a way to look at the query that's eating too much process
without starting the DB and redirect stdout out to a file?
process ID 32082..
32082 pts/3S 0:08 postgres: mydbuser mydb 10.10.10.1 SELECT
if i do top
On Monday 09 May 2005 23:28, Scott Marlowe wrote:
> On Mon, 2005-05-09 at 08:55, JM wrote:
> > Hi ALL,
> >
> > we have a site that uses postgres as a backend for a forum. this forum
> > does a lot of deletes, selects and inserts. just recently for some
> > reason postgres eats a lot of proces
Tom Lane wrote:
On the other hand, once you reach the target index page, a hash index
has no better method than linear scan through all the page's index
entries to find the actually wanted key(s)
I wonder if it would be possible to store the keys in a hash bucket in
sorted order, provided that the
Neil Conway <[EMAIL PROTECTED]> writes:
> Jim C. Nasby wrote:
>>> No, hash joins and hash indexes are unrelated.
>> I know they are now, but does that have to be the case?
> I mean, the algorithms are fundamentally unrelated. They share a bit of
> code such as the hash functions themselves, but t
Christopher Kings-Lynne wrote:
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions for P
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?
Try pgpool.
Chris
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> On Mon, 2005-05-09 at 17:07 -0400, Tom Lane wrote:
>> ... not to mention it would avoid the risk of propagating
>> not-yet-committed changes.
> How's that? If I can notify a daemon that the change is committed, then
> why couldn't I write a forkin
Hi,
I'm running Postgres 8 and need a log analyzer to report connection stats.
I've installed pganalyzer which doesn't seem to work with 8.0.
I've also installed Pratical Query Analyzer however this doesn't report
on connections.
Can anyone recommend another log analyzer like pg-analyzer?
Your
Jim C. Nasby wrote:
> On Tue, May 10, 2005 at 02:38:41AM +1000, Neil Conway wrote:
> > Jim C. Nasby wrote:
> > >Having indexes that people shouldn't be using does add confusion for
> > >users, and presents the opportunity for foot-shooting.
> >
> > Emitting a warning/notice on hash-index creation
On Mon, May 09, 2005 at 07:05:18PM -0400, Bart Grantham wrote:
> Hello again. I had a problem a few weeks ago with using IN ( some_array
> ) having really rough performance. Special thanks to Ron Mayer for the
> suggestion of using int_array_enum(some_array) to join against. I had
> to upgrad
On Mon, May 09, 2005 at 07:05:18PM -0400, Bart Grantham wrote:
>
> Let me put it this way... how do I do this:
>
> -- my_array is an INT[]
>
> _my_array := select some_column from some_table;
In PostgreSQL 7.4 and later you can use an array constructor:
my_array := ARRAY(SELECT some_column FR
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> On Mon, 2005-05-09 at 17:01 -0400, Douglas McNaught wrote:
>> Why not have a client connection LISTENing and doing the
>> synchronization, and have the trigger use NOTIFY?
>>
>> Or, you could have the trigger write to a table, and have another
>>
On Mon, 2005-05-09 at 17:07 -0400, Tom Lane wrote:
> Douglas McNaught <[EMAIL PROTECTED]> writes:
> > Why not have a client connection LISTENing and doing the
> > synchronization, and have the trigger use NOTIFY?
> > Or, you could have the trigger write to a table, and have another
> > client perio
On Mon, 2005-05-09 at 17:01 -0400, Douglas McNaught wrote:
> Why not have a client connection LISTENing and doing the
> synchronization, and have the trigger use NOTIFY?
>
> Or, you could have the trigger write to a table, and have another
> client periodically scanning the table for new sync even
Jim C. Nasby wrote:
>> No, hash joins and hash indexes are unrelated.
I know they are now, but does that have to be the case?
I mean, the algorithms are fundamentally unrelated. They share a bit of
code such as the hash functions themselves, but they are really solving
two different problems (dis
[note: it is better to create a new thread than to hijack an
unrelated one]
On Mon, 2005-05-09 at 18:45 +0200, Zlatko Matic wrote:
> Can someone explain me the following options while using pgAdimn III for
> backup:
>
my guess is...
> blobs
include blobs in backup. blobs are not included
Hello again. I had a problem a few weeks ago with using IN ( some_array
) having really rough performance. Special thanks to Ron Mayer for the
suggestion of using int_array_enum(some_array) to join against. I had
to upgrade to PG8 but that technique works really well. Now I have a
question
I have to say that ERwin is pretty much the bomb. It indirectly
supports postgresql through ODBC, which I've used with much success.
It will also port your schema to another RDBMS system if you wish. It
can build a model from either a running database or DDL or by
construction, and will also out
This is my favits just awesome...
http://www.sqlmanager.net/
On 5/9/05, Mark Borins <[EMAIL PROTECTED]> wrote:
>
>
>
> Postgres Newsgroup,
>
>
>
> My company has been looking for a good database modelling tool for postgres
> and have yet to find something that completely satisfies
Other possibilities:
http://www.datanamic.com/dezign/factsheet.html
http://www.visual-paradigm.com/product/dbva/
From: Dann Corbit
Sent: Monday, May 09, 2005 3:24 PM
To: 'Mark Borins'
Subject: RE: [GENERAL] Data
Modelling Tools
Free trial:
http://www.dds-pro.com/main
Sorry, I should have also specified that we are looking for a tool where we
can save the schema externally. Then take that schema and have the tool
compare it to a database and generate a change script.
So the process would be to maintain database structure in a tool.
Be able to save the schema.
Mark Borins wrote:
-->
Postgres Newsgroup,
My company has been looking for a good database modelling tool for
postgres and have yet to find something that completely satisfies our
needs. We are currently using a product called DBWrench which is pretty
good and has all the features we are loo
Postgres Newsgroup,
My company has been looking for a good database
modelling tool for postgres and have yet to find something that completely
satisfies our needs. We are currently using a product called DBWrench which is
pretty good and has all the features we are looking for but is f
Jonathan Lam wrote:
> HI all,
>
> I am new to PostGreSQL and I need some help. We received a database
> in PostGreSQL from another group within the company, and we are
> planning to use ERWIN to Forward/Engineer it into a SQL Server
> because one of our tool can only use SQL Server.
Have you inv
Excellent, I got it working...Thanks ;)
Abdul-Wahid
On 5/9/05, Mike Nolan <[EMAIL PROTECTED]> wrote:
> > So how can I create a trigger to automatically update the hash fields
> > on updates and inserts?
>
> Something like the following works for me:
>
> create or replace function public.my_trig
Douglas McNaught <[EMAIL PROTECTED]> writes:
> Why not have a client connection LISTENing and doing the
> synchronization, and have the trigger use NOTIFY?
> Or, you could have the trigger write to a table, and have another
> client periodically scanning the table for new sync events.
> Either one
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> No, I don't want the trigger to do any db stuff at all. Basically, I've
> got a content management system that is going to be split across a
> cluster. Upon an update submission from one of them, I want to replicate
> across the others (which can
On 5/9/05, Hrishikesh Deshmukh <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have two tables with genes and its annotation and a bunch of
> parameters, i wanted to know what are the genes common to these two
> tables, so i wrote this query
>
> create table temp as select gene from dataTable1 intersect
>
On Mon, 2005-05-09 at 15:38 -0400, Tom Lane wrote:
> Christopher Murtagh <[EMAIL PROTECTED]> writes:
> > I would like to write a trigger or function that spawns a forked
> > process so that the transaction is considered 'complete' to the client,
> > but continues to perform more work.
>
> It's no
If I understand correctly, you are not creating a temp table, but
(rather) a table called 'temp.'
What you want to accomplish is still not entirely clear to me.
Do you wish to "embellish" or "enhance" the 'temp' table data with
description data? If so, then you want an outer join.
Do you want t
Hi,
I have two tables with genes and its annotation and a bunch of
parameters, i wanted to know what are the genes common to these two
tables, so i wrote this query
create table temp as select gene from dataTable1 intersect
select gene from dataTable2;
The resulting table has only genes list (on
Temp tables go away after the transaction completes.
Perhaps you want a permanent table, dropped later with "drop table".
Either that, or you may want to bracket the entire sequence in
begin/end.
I imagine that what you want to accomplish can be done.
But your pseudo-code is very vague.
Give the
Hello,
> But I know from past experience that I am not going to make a lot of
> progress teaching myself any form of C language.
I had to learn programming with Pascal at university first. It worked
for me.
Then I had to learn Fortran. Didn't like some things about it, but
still managed to
Hi All,
How can one use a table created for saving the results for a query be
used in WHERE for subsequent query!!!
Step 1) create table temp as select gene from dataTable1 intersect
select gene from dataTable2;
Now temp has been created, temp has only one column which has list of
genes and noth
On Mon, 2005-05-09 at 13:41, Craig Bryden wrote:
> Hi
>
> In MS SQL there is a concept of Clustering database servers. This allows for
> load balancing.
> Does PostgreSQL have a similar concept?
This really kinda depends on what you are tring to load balance. I/O,
parallel users, CPU intensive
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> I would like to write a trigger or function that spawns a forked
> process so that the transaction is considered 'complete' to the client,
> but continues to perform more work.
It's not very clear what you are hoping to have the forked process do,
I would like to write a trigger or function that spawns a forked
process so that the transaction is considered 'complete' to the client,
but continues to perform more work. I've been looking for examples to
steal^H^H^H^H^H learn from but have only found someone asking pretty
much the same question
Slony is the master-slave (not multi-master IIRC) replication environment.
I haven't used it, but apparently there are cognoscenti among us who have.
I would think, a bit, about what kind of "load" (e.g. CPU, network, disk
queues, disk allocation, et cetera) you want to balance before picking u
> So how can I create a trigger to automatically update the hash fields
> on updates and inserts?
Something like the following works for me:
create or replace function public.my_trigger()
returns trigger as '
NEW.hashfield = hashfunction(NEW.data1,NEW.data2);
RETURN NEW;
END;
' language 'plpgsq
On Mon, May 09, 2005 at 10:13:12AM -0700, Jonathan Lam wrote:
> HI all,
>
> I am new to PostGreSQL and I need some help. We received a database
> in PostGreSQL from another group within the company, and we are
> planning to use ERWIN to Forward/Engineer it into a SQL Server
> because one of our
Hi
In MS SQL there is a concept of Clustering database servers. This allows for
load balancing.
Does PostgreSQL have a similar concept?
Thanks
Craig
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
On 05/09/05 11:21 AM CDT, Peter Fein <[EMAIL PROTECTED]> said:
> Hiya-
>
> I'm looking for a function to return the number of words in a string,
> split on whitespace. I'm coming from python, so I may just write it
> in that but I wanted to check first. In python, one would write:
>
> s="some s
> I'm guessing now that we're just talking about a regular index on a
> column that happens to have a foreign key reference to another column.
> Is that the case?
>
That's true, but just as the query planner can use an index for WHERE
conditions, it can use an index for a join condition. So if y
On Mon, 2005-05-09 at 12:40, John D. Burger wrote:
> >> By the way, I presume foreign key indices are used to check for
> >> referential integrity on insert. Can the query planner also use then
> >> somehow?
> >
> > It can use them the same way it can use any other index.
>
> Hmm, I guess I thoug
By the way, I presume foreign key indices are used to check for
referential integrity on insert. Can the query planner also use then
somehow?
It can use them the same way it can use any other index.
Hmm, I guess I thought that "foreign key indices" were some special
kind of index. For instance,
For the sake of the archives, I just found out that my problem was that:
echo -e "Content-type: image/png\n\n";
...actually throws in 3 newlines, not two. (Doh!) Fixing that means I now
have a CGI that generates gnuplots from postgres entirely in the pipeline,
withouut any annoying temp files. p
HI all,
I am new to PostGreSQL and I need some help. We received a database in PostGreSQL from
another group within the company, and we are planning to use ERWIN to
Forward/Engineer it into a SQL Server because one of our tool
can only use SQL Server. Don’t
know if anyone had done thi
On Mon, May 09, 2005 at 11:49:41AM -0500, Jim C. Nasby wrote:
> You can use a combination of regex
> (http://www.postgresql.org/docs/8.0/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
> and strpos inside a plpgsql function to do this, but using plpython or
> plperl might be faster. A C func
On Tue, May 10, 2005 at 02:38:41AM +1000, Neil Conway wrote:
> Jim C. Nasby wrote:
> >Having indexes that people shouldn't be using does add confusion for
> >users, and presents the opportunity for foot-shooting.
>
> Emitting a warning/notice on hash-index creation is something I've
> suggested i
You can use a combination of regex
(http://www.postgresql.org/docs/8.0/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
and strpos inside a plpgsql function to do this, but using plpython or
plperl might be faster. A C function would possibly be faster still.
On Mon, May 09, 2005 at 11:21:28
Jim C. Nasby wrote:
Having indexes that people shouldn't be using does add confusion for
users, and presents the opportunity for foot-shooting.
Emitting a warning/notice on hash-index creation is something I've
suggested in the past -- that would be fine with me.
Even if there is some kind of adv
Can someone explain me the following options while using pgAdimn III for
backup:
blobs
insert commands
verbose messages
Thanks.
- Original Message -
From: "Sean Davis" <[EMAIL PROTECTED]>
To: "Hrishikesh Deshmukh" <[EMAIL PROTECTED]>; "Ben"
<[EMAIL PROTECTED]>
Cc: "Postgresql-General"
On Tue, May 10, 2005 at 01:34:57AM +1000, Neil Conway wrote:
> Christopher Petrilli wrote:
> >This being the case, is there ever ANY reason for someone to use it?
>
> Well, someone might fix it up at some point in the future. I don't think
> there's anything fundamentally wrong with hash indexes,
On Mon, May 09, 2005 at 09:04:49AM -0400, John D. Burger wrote:
> >I know that it was decided a fair few releases ago to stop creating an
> >implicit index for each foreign key,
>
> By the way, I presume foreign key indices are used to check for
> referential integrity on insert. Can the query p
thanks.
- Original Message -
From: "Michael Glaesemann" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 09, 2005 11:30 AM
Subject: Re: [GENERAL] = or := ?
On May 9, 2005, at 18:00, Zlatko Matic wrote:
This is a newbie question: what is the difference be
Well, there is this:
http://www.varlena.com/varlena/GeneralBits/Tidbits/bernier/art_66/graphingWithR.html
I thought it was overkill for me, so I went with the gnuplot method.
On Mon, 9 May 2005, Hrishikesh Deshmukh wrote:
> H..looks like i simply can't send the query results to gnuplot
Hiya-
I'm looking for a function to return the number of words in a string,
split on whitespace. I'm coming from python, so I may just write it in
that but I wanted to check first. In python, one would write:
s="some string or other"
len(s.split())
Thanks!
--
Peter Fein [EMAI
En français, il vaudrait mieux poster sur : [EMAIL PROTECTED]
Allez voir CREATE SEQUENCE INCREMENT BY ...
Voir la doc : le type serial equivaut à
CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename (
colname integer DEFAULT nextval('tablename_colname_seq') NOT NULL);
Jacques Mass
As an alternative, be sure to check out pl/R. Everything happens inside the
server except for the actual plot which goes to a file.
Sean
- Original Message -
From: "Hrishikesh Deshmukh" <[EMAIL PROTECTED]>
To: "Ben" <[EMAIL PROTECTED]>
Cc: "Postgresql-General"
Sent: Monday, May 09, 200
Bonjour,
je me tourne vers vous car je n'arrive pas à solutionner mon probleme
qui est le suivant :
Je dois créer une Bd Postgres avec une table qui doit utiliser un
champ auto incrémental d'un pas de 6.
J'ai trouvé le type auto incrémental qui est SERIAL , mais je n'arrive
pas à voir comment
Today I stumbled upon a very strange error. I was getting tired of
getting errors when I tried using function round(double
precision,integer) so I decided to build one of my own. I did*, then I
issued
select round(1.::double precision,2)
To this the connection to the postgres serv
Has anybody tried using gnuplot to plot results from queries; there
are some suggestions given in PostgreSQL Developer's Handbook but i
have not any luck so far!
Any pointers as how to send results from queries straight to a simple
plotting utility (ex:gnuplot)!
I use a text file as an intermed
> Has anybody tried using gnuplot to plot results from queries; there
> are some suggestions given in PostgreSQL Developer's Handbook but i
> have not any luck so far!
> Any pointers as how to send results from queries straight to a simple
> plotting utility (ex:gnuplot)!
I use a text file as an i
H..looks like i simply can't send the query results to gnuplot
without an intermediary!! So far my search results have not yielded
anythingi guess intermediary is the only way to !! :(((
Hrishi
On 5/9/05, Ben <[EMAIL PROTECTED]> wrote:
> Heh. Funny you should ask; I spent a fair amoun
Heh. Funny you should ask; I spent a fair amount of time yesterday
doing precisely this.
Here's my gnuplot file:
set terminal png small color picsize 1000 400
set style fill solid 1.0 border
set title "Concurrent listeners"
set xdata time
set xlabel "Time"
set ylabel "Cuncurrent Logged In Listen
Christopher Petrilli wrote:
This being the case, is there ever ANY reason for someone to use it?
Well, someone might fix it up at some point in the future. I don't think
there's anything fundamentally wrong with hash indexes, it is just that
the current implementation is a bit lacking.
If not, t
On 5/9/05, Neil Conway <[EMAIL PROTECTED]> wrote:
> I don't think we've found a case in which the hash index code
> outperforms B+-tree indexes, even for "=". The hash index code also has
> a number of additional issues: for example, it isn't WAL safe, it has
> relatively poor concurrency, and crea
On Mon, 2005-05-09 at 08:55, JM wrote:
> Hi ALL,
>
> we have a site that uses postgres as a backend for a forum. this forum
> does a lot of deletes, selects and inserts. just recently for some reason
> postgres eats a lot of processing power..
>
> here are some tech-details:
>
>
Hi All,
Has anybody tried using gnuplot to plot results from queries; there
are some suggestions given in PostgreSQL Developer's Handbook but i
have not any luck so far!
Any pointers as how to send results from queries straight to a simple
plotting utility (ex:gnuplot)!
Thanks,
Hrishi
--
Hi,
I have created a simple plpgsql function as follows as included below.
The function works fine but I need to have this done automatically on
updates and inserts. So I have a table
CREATE TABLE addresses (
address_id serial PRIMARY KEY,
companyvarchar(250),
fnamevarchar
Hi:
My OS is RHL9. I installed postgresql-8.0.2. There are the
alterations I remembered. (1) in /etc/init.d/postgresql change " su
-l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster -o "-i" '-p ${PGPORT}' start > /dev/null 2>&1" <
/dev/null" to
" su -l postgr
Ying Lu wrote:
May I know for simple "=" operation query, for "Hash index" vs. "B-tree"
index, which can provide better performance please?
I don't think we've found a case in which the hash index code
outperforms B+-tree indexes, even for "=". The hash index code also has
a number of additional
it is about null problem
declare
res numeric(15,2);
_pida integer[4]; < Problem is here must be ---> pida
integer[4]='{}';
_pid integer;
_rec record;
..
"ALÝ ÇELÝK" <[EMAIL PROTECTED]>, haber iletisinde þunlarý
yazdý:[EMAIL PROTECTED]
>
> I have a
Hi ALL,
we have a site that uses postgres as a backend for a forum. this forum
does a lot of deletes, selects and inserts. just recently for some reason
postgres eats a lot of processing power..
here are some tech-details:
tcpip_socket = true
max_connections = 260
superuser_
On Thu, 2005-05-05 at 15:28, CSN wrote:
>
> --- Dann Corbit <[EMAIL PROTECTED]> wrote:
> > > why do you suppose
> > > neither Mysql nor Oracle has bothered to implement
> > it?
> >
> > Probably they just create a domain using a char
> > which can take on two
> > values (e.g. 't'/'f' or 1/0). Ora
Michael Glaesemann <[EMAIL PROTECTED]> writes:
> On May 9, 2005, at 18:00, Zlatko Matic wrote:
>> This is a newbie question: what is the difference between using = and
>> := in plpgsql function ?
> In pl/pgsql,
> := is assignment
> = is a logical comparison for equality
It looks like the code w
Vidya,
Array_append is a function and is called - select
array_append(array,val).
You left out the select.
Sim
"Vidya" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]...
Hi
I have the following functions , the functions are created but when it is
invoked it errors
For the second function you called select getmatch
without specifying the columns you want.
try select * from getmatch()
"Vidya" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]...
Hi
I have the following functions , the functions are created but when it is
invoked it e
Greetings,
We are working on speeding up the queries by creating indexes. We have
queries with searching criteria such as "select ... where *col1='...'*".
This is a simple query with only "=" operation. As a result I setup hash
index on column "col1". While, in postgreSQL 8 doc, it is wirttern:
I know that it was decided a fair few releases ago to stop creating an
implicit index for each foreign key,
By the way, I presume foreign key indices are used to check for
referential integrity on insert. Can the query planner also use then
somehow?
Thanks.
- John D. Burger
MITRE
---
Not with Postgres, but i'm using it with PHP/Oracle (easier to install
sqlrelay than oracle lient :) )
Anyway, it works ok and judging on comments on sqlrelay list, lots of
people find it good solution for connection pooling.
When I get some spare time, i'll probably rewrite postgres applications
Hi
I have the following functions , the functions are created but when it is invoked it errors out /
SampleDB=# create or replace function getmatch(anyarray) returns anyarray as $$SampleDB$# declareSampleDB$# sys_cursor cursor(key integer) is select sys_id from
Hi,
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?
Thanks in advance.
ML
On Mon, 9 May 2005 08:09 pm, ElayaRaja S wrote:
> Hi,
Wrong Mailing list maybe? This is a PostgreSQL mailing list.
Regards
Russell Smith
> I am using Redhat Linux 9 and I configure the samba server with
> workgoup of my local
> area network. when i tried to connect it was getting the error
Hi,
The company I work for actually uses the Zeos lib/Postgres extensively
to track the shipping and sales side for almost 3 years.
We're still running on a 7.2/7.4 Postgres database, because I haven't
been convinced yet to either update or upgrade to 8.x.x. I'm curious
if others have successfull
Hi,
I'm testing Delphi 2005 at the moment, with ZEOS Lib (libpq), and I have to say
it work fine, as Tony mentioned. I have a few questions:
1) I'm curious: are there a lot of big projects using ZEOS with PG or is that
technology still relatively new? I would like to use it a replacement for OD
Hi,
I am using Redhat Linux 9 and I configure the samba server with
workgoup of my local
area network. when i tried to connect it was getting the error message as
"\\myserver is not accessible. You might not have permission to use
this netowrk resource.
Contact the administrator of th
Could I invite java (and may be other languages) and the Eclipse Visual Editor
as a new wrestler in the tournament?
http://www.eclipse.org/vep/
Jacques Massé
Diadfish: http://www.diadfish.org
PostgreSQL : http://www.postgresqlfr.org
> -Message d'o
On May 9, 2005, at 18:00, Zlatko Matic wrote:
This is a newbie question: what is the difference between using = and
:= in plpgsql function ?
In pl/pgsql,
:= is assignment
= is a logical comparison for equality
Some languages, such as perl, use = for assignment and == for logical
comparison.
x =
Hello.
This is a newbie question: what is the difference between using = and := in
plpgsql function ?
I tried with both and in both cases my function works...
Thanks.
Zlatko
---(end of broadcast)---
TIP 2: you can get off all lists at once with th
99 matches
Mail list logo
