Tom, yes, something like Berkeley DB, but inside PostgreSQL... It may
sounds crazy, but some data just need not all SQL functionality and
overhead, and at the same time I need not second db, so the best
possible solution (in my opinion): two ways of the data access inside
one db.
Regards,
On Apr 19, 2005, at 23:24, Dan Sugalski wrote:
At 9:40 PM +0400 4/19/05, Alexandre wrote:
Lane, thank you, but it is not: PostISAM generates SQL statements on
the fly from traditional ISAM (read, write, start) statements, so it
just add overhead, and is not what I'm looking for.
Speaking from
Baldur Norddahl wrote:
Is there a better way to query the status of postgresql? I would
expect it to at least check that the process in the PID is actually
running and that it is a postgresql process.
Maybe try
test $(readlink /proc/$pid/exe) = /usr/bin/postgres
--
Peter Eisentraut
On Apr 19, 2005, at 22:56, Dann Corbit wrote:
Have you actually seen any problem in simple get/put/delete/update
situations?
Not sure, that I understand your question.
It's a shame when people spend a great deal of effort to invent a cure
for a disease that does not exist.
If you have problems
vinita bansal wrote:
Hi,
There is no particular pattern but it is generally the update queries of
the form update tableName set colName='something' that are taking a
lot of time incase there is a lot of background data.
Well, that query will obviously update the entire table, but if you
can't
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 19 Apr 2005, R WARRINER wrote:
Anyone ran across a broken libpq.so.3 link from the SLES rpm, and if so
found a solution to fix it?
snip
Update:
Reinhard has fixed the problem and uploaded the new binaries. They are
now available from:
Oh Sorry!!
I gave a wrong example for update. It includes where clause as well which
esentially mean that not all the rows will be modified each time. If suppose
I already know (assuming that I can find out which rows will bw accessed) is
there a way to organize the table data such that updates
Please Unsubcribe My Mail Id
At 10:05 AM +0400 4/20/05, Alexandre wrote:
On Apr 19, 2005, at 23:24, Dan Sugalski wrote:
At 9:40 PM +0400 4/19/05, Alexandre wrote:
Lane, thank you, but it is not: PostISAM generates SQL statements
on the fly from traditional ISAM (read, write, start) statements,
so it just add overhead, and
http://archives.postgresql.org/pgsql-general/
Please follow the above link and click the To subscribe or unsubscribe link.
On Wednesday 20 April 2005 09:18 am, K.RajaSekar saith:
Please Unsubcribe My Mail Id
---(end of broadcast)---
TIP 5: Have
Peter Eisentraut [EMAIL PROTECTED] writes:
Baldur Norddahl wrote:
Is there a better way to query the status of postgresql? I would
expect it to at least check that the process in the PID is actually
running and that it is a postgresql process.
Maybe try
test $(readlink /proc/$pid/exe) =
On Apr 20, 2005, at 17:09, Dan Sugalski wrote:
Does your own ISAM interface also convert ISAM calls to the SQL
queries?
Yes of course -- it has to, there's no other way to access Postgres.
Some server specific API?
If so, then it is also add overhead: make a call to the some wrapper,
which will
[EMAIL PROTECTED] (Alexandre) writes:
On Apr 19, 2005, at 23:24, Dan Sugalski wrote:
At 9:40 PM +0400 4/19/05, Alexandre wrote:
Lane, thank you, but it is not: PostISAM generates SQL statements
on the fly from traditional ISAM (read, write, start) statements,
so it just add overhead, and is
hello everybody!
i just subscribed to the list, so hello to all friends of pgsql.
now here is my concrete problem:
i have to exchange data with an other company. they are running a ms sql
2000 serer and want to import our data via xml. so, how do i get it out of
the pgsql database?
i looked in
Hi All,
I am looking for a freedata
migration tool for migrating data from oracle tables to PostgreSQL. Can anybody
help me on this?
Thanks in advance
RegardsSantharam A.B.
In article [EMAIL PROTECTED],
Daniel Schuchardt [EMAIL PROTECTED] wrote:
% but there it is only clear that Postgres is based in Ingres. But i also
% don't know what Ingres means.
Ingres was a Spanish painter. Not every name has to mean something.
--
Patrick TJ McPhee
North York Canada
hello everybody!
i just subscribed to the list, so hello to all friends of pgsql.
Hello here ;-)
now here is my concrete problem:
i have to exchange data with an other company. they are running a ms sql
2000 serer and want to import our data via xml. so, how do i get it out of
the
Hi,
when I enter the following SELECT into psql
select * from mytable where data like '%ü%'
I get a selection of a couple of rows.
The problem is that alls the ü characters get displayed as FC.
Why is that so?
fritz
BTW: I set client encoding to latin1 and the database stores data in
utf8
Alejandro D. Burne wrote:
Hi, I'm installing 8.0.2 on Mandrake and I saw binarys rpms only for RH.
Can someone tell me if is better install a rpm version or compile from
source in this case?
Thanks, Alejandro
the rpm should work fine, even though it's rh.
if not, rpmdrake ( urpmi ) will remove
Hi, I'm installing 8.0.2 on Mandrake and I saw binarys rpms only for RH.
Can someone tell me if is better install a rpm version or compile from
source in this case?
Thanks, Alejandro
---(end of broadcast)---
TIP 6: Have you searched our list
Michael Fuhr [EMAIL PROTECTED] writes:
On Tue, Apr 19, 2005 at 05:39:42PM -0700, Dennis Sacks wrote:
I am Seeing twelve of these messages every five to ten seconds in the
Postgresql serverlog when my java application is running:
2005-04-19 16:43:03 LOG: 0: duration: 0.246 ms
LOCATION:
Hi all,
I have a web interface with offers a search field. This search field
will look for the string X in 12 different columns. If the string is
found anywhere I return the row.
The problem is that the user is eable to put spacial character like : [*
This create invalid regular expression
vinita bansal wrote:
Oh Sorry!!
I gave a wrong example for update. It includes where clause as well
which esentially mean that not all the rows will be modified each time.
If suppose I already know (assuming that I can find out which rows will
bw accessed) is there a way to organize the table
Fritz Bayer wrote:
Hi,
when I enter the following SELECT into psql
select * from mytable where data like '%ü%'
I get a selection of a couple of rows.
The problem is that alls the ü characters get displayed as FC.
Why is that so?
Probably something in your terminal setup. I always have endless
Hello all,
I am in a position where I'm torn between using ext2 vs ext3 to keep the
pg_data, pg_xlog, and pg_clog contents.
The main concern is that switching to ext2 will not respond well to an
improper shutdown, power loss.
My question is what is the prefered filesystem to keep this data to
Santharam wrote:
Hi All,
I am looking for a free data migration tool for migrating
data from oracle tables to PostgreSQL. Can anybody help me on this?
Ora2pg.
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Don't 'kill -9' the
On Wed, 2005-04-20 at 03:03 +, Patrick TJ McPhee wrote:
In article [EMAIL PROTECTED],
Daniel Schuchardt [EMAIL PROTECTED] wrote:
% but there it is only clear that Postgres is based in Ingres. But i also
% don't know what Ingres means.
Ingres was a Spanish painter. Not every name has
Le mercredi 20 avril 2005 à 17:12 +0100, Simon Riggs a écrit :
Ingres was a Spanish painter. Not every name has to mean something.
Spanish? I always thought he was a French painter.
You can't be good in history of art and database systems. Oh wait a
minute... =:-D
Jean Auguste Dominique
On Wed, 2005-04-20 at 11:18, Scott Marlowe wrote:
On Wed, 2005-04-20 at 11:07, Joe Maldonado wrote:
Hello all,
I am in a position where I'm torn between using ext2 vs ext3 to keep the
pg_data, pg_xlog, and pg_clog contents.
The main concern is that switching to ext2 will not respond
On Wed, 20 Apr 2005, Simon Riggs wrote:
On Wed, 2005-04-20 at 03:03 +, Patrick TJ McPhee wrote:
In article [EMAIL PROTECTED],
Daniel Schuchardt [EMAIL PROTECTED] wrote:
% but there it is only clear that Postgres is based in Ingres. But i also
% don't know what Ingres means.
Ingres was a
Michael Fuhr wrote:
On Wed, Apr 20, 2005 at 11:28:28AM -0400, David Gagnon wrote:
I have a web interface with offers a search field. This search field
will look for the string X in 12 different columns. If the string is
found anywhere I return the row.
The problem is that the user is eable
On Wed, 2005-04-20 at 12:36, David Gagnon wrote:
Michael Fuhr wrote:
On Wed, Apr 20, 2005 at 11:28:28AM -0400, David Gagnon wrote:
I have a web interface with offers a search field. This search field
will look for the string X in 12 different columns. If the string is
found
Hi Scott,
I would generally scrub the input before it go to postgresql. Basically
do a simple string_replace type function that replaces anything that
ISN'T alphanum with nothing.
If I change the original string the user may not get what he expects as
result. abc[d] is not the samething
On Wed, 2005-04-20 at 13:05, David Gagnon wrote:
Hi Scott,
I would generally scrub the input before it go to postgresql. Basically
do a simple string_replace type function that replaces anything that
ISN'T alphanum with nothing.
If I change the original string the user may not
hi everyone,
i have several hundred books that were typed using unicode and would
liek to put them into a database so that i can perform searches on
them. how does one design a database for this?
i was planning to make a table with these columns: ID, Title, Authors,
Publishers, Content
the
On Wed, Apr 20, 2005 at 11:28:28AM -0400, David Gagnon wrote:
I have a web interface with offers a search field. This search field
will look for the string X in 12 different columns. If the string is
found anywhere I return the row.
The problem is that the user is eable to put spacial
Hello all,
We noticed some very odd behavior today with Postgres 7.4.5
Running the following SQL:
create table a (foo varchar);
insert into a (foo) values ('baz');
create table b (foo varchar);
insert into b (foo) values ('woof');
select '' || foo || '' as foo
from (select foo from a) as
Kevin Murphy [EMAIL PROTECTED] writes:
On Apr 20, 2005, at 1:24 PM, Aaron Bingham wrote:
create table a (foo varchar);
insert into a (foo) values ('baz');
create table b (foo varchar);
insert into b (foo) values ('woof');
select '' || foo || '' as foo
from (select foo from a) as bar
On 3/23/2005 11:22 AM, Joshua D. Drake wrote:
David Gagnon wrote:
Hi all,
I just created a new db wich userX is owner. I log via pgAdminIII
with the same user but I can't update the pg_class.
You are a datdba but not a superuser :). You have to be a super user
to update pg_class.
and not only a
On Wed, Apr 20, 2005 at 07:24:08PM +0200, Aaron Bingham wrote:
Hi,
create table a (foo varchar);
x insert into a (foo) values ('baz');
create table b (foo varchar);
insert into b (foo) values ('woof');
select '' || foo || '' as foo
from (select foo from a) as bar
union select
On Apr 20, 2005, at 1:24 PM, Aaron Bingham wrote:
create table a (foo varchar);
insert into a (foo) values ('baz');
create table b (foo varchar);
insert into b (foo) values ('woof');
select '' || foo || '' as foo
from (select foo from a) as bar
union select foo from b;
No, it's doing
Hi,
I understand that CURRENT_TIMESTAMP marks the beginning of the current
transaction. I want it to be the actual time. How do I do this?
timeofday() returns a string, how do I convert that into a TIMESTAMP?
Is it possible to create a column with DEFAULT value evaluated to the actual
current
On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
I understand that CURRENT_TIMESTAMP marks the beginning of the current
transaction. I want it to be the actual time. How do I do this?
timeofday() returns a string, how do I convert that into a TIMESTAMP?
timeofday()::timestamp;
Is it
On Wed, 20 Apr 2005, Jeffrey W. Baker wrote:
I always thought I would not be the kind of person who writes to this
list asking why the planner is using a sequential scan. I always looked
upon such people as newcomers who would eventually learn the mysterious
wonders of the Pg query
I just did a windows install of postgresql. I cannot find or edit the
postgresql.conf. This is a new Dell machine running XP Professional
OS.
I chose not to install as a windows service, but as a job which I can start
and stop.
Where should I look for help.
Is it easy to uninstall?
On Apr 21, 2005, at 1:28, Marc G. Fournier wrote:
He was:
http://www.discoverfrance.net/France/Art/Ingres/Ingres.shtml
And its pronounced: {ang'-gruh}
Could we get Bruce to record an MP3 for the site?
Michael Glaesemann
grzm myrealbox com
---(end of
When I did the windows install (NOT as a windows service) but as a task to
be manually started and stopped, it did not creat a DATA directory, nor did it
create a postgresql.conf file.I even used windows explorer search to confirm
that no such file exists. I did the uninstall and then
47 matches
Mail list logo