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 reinst
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 broadcast)---
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?
Hi Jeff,
Maybe because the key is a bigint - you're looking for an int (int4).
Try casting it to a bigint ?
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 newc
Fritz Bayer schrob:
> The problem is that alls the "ü" characters get displayed as "".
>
> Why is that so?
This could happen when your locale isn't properly set up. If, for
example, LC_CTYPE is set to C, your pager thinks this character isn't
printable and tries to do something smart with it. You
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 execu
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 execution planner.
But really, this plan is bizarre! Why
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 p
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 t
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
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
> unio
I see no problem. You get what you want.
Correct query is:
select '"' || foo || '"' as foo
from (select foo from a union select foo from b ) as bar;
Oleg
On Wed, 20 Apr 2005, Aaron Bingham wrote:
Hello all,
We noticed some very odd behavior today with Postgres 7.4.5
Running the following SQL:
c
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
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 f
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
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 spa
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 Cont
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
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 tha
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
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, 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 Sp
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
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: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 well to an
> improper shutdown, power loss.
>
> My
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
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 post
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 be
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 "".
Why is that so?
Probably something in your terminal setup. I always have endless t
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
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 an
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
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 8.0.
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 "".
Why is that so?
fritz
BTW: I set client encoding to latin1 and the database stores data in
utf8
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: exec_simple_query, postgres.c:96
> 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
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 archive
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
[
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?
Thanks in advance
Regards Santharam A.B.
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
[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 ov
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 g
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/
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: Hav
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
Please Unsubcribe My Mail Id
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 update
-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?
Update:
Reinhard has fixed the problem and uploaded the new binaries. They are
now available from:
ftp://ft
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
Peter Eisentraut wrote:
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) = /
50 matches
Mail list logo
