Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> In the documentation there is this page about partial indicies:
> http://postgresql.planetmirror.com/devel-corner/docs/user/partial-index.htm
> From my reading of that I would guess they are supported but since they
> aren't mentioned anywhere
Tom Lane <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] (Konstantinos Agouros) writes:
> >> export PGOPTIONS="-F"
> >> psql mydb
>
> > A O thanks for the help I was confused. Does this also work
> > that way, if I use it from DBI::Pg from perl? Like setting
> > $ENV{'PGOPTIONS'}
>
> Ye
Now you know the answer; for some resources of how to do it try taking a
look at:
http://people.freebsd.org/~kevlo/postgres/portNT.html
It is pretty similar to the official windows install docs:
http://www.postgresql.org/docs/faq-mswin
Or, for a more automated install check out: http://208.160.2
Hi,
In the documentation there is this page about partial indicies:
http://postgresql.planetmirror.com/devel-corner/docs/user/partial-index.htm
From my reading of that I would guess they are supported but since they
aren't mentioned anywhere else, I guess they're not.
Can somone clarify the s
HI tom
A few days back i had bugged this list about the seemingly impossible
select queries results..
##RECAP##
select distinct site_section as "distinct site sections" from
exhibit_distributions ;
distinct site sections
ARCHIVED
ARTETC
CALENDAR
GALLERY
POSTCARD
(5 rows
[EMAIL PROTECTED] (Konstantinos Agouros) writes:
>> export PGOPTIONS="-F"
>> psql mydb
> A O thanks for the help I was confused. Does this also work
> that way, if I use it from DBI::Pg from perl? Like setting
> $ENV{'PGOPTIONS'}
Yeah, I think that should work if you do it before opening
In <[EMAIL PROTECTED]> [EMAIL PROTECTED] (Tom Lane) writes:
>[EMAIL PROTECTED] (Konstantinos Agouros) writes:
>> someone gave me the tip to use the -F-flag to improve performance. Since
>> I can't run the postmaster with -F but just postgres how do I do it, if I
>> want to import a big amount of
> I am putting together a web site to display a collection of Chinese
> woodblock prints. I want to be able to store double byte values (that is
> to say Big5, Unicode etc encoded) in a text field for things such as the
> artist's name and the title of the print. I have the following questions:
>
I'm willing to do some writing if someone will explain things to me.
I've pretty much disected all the sql used by Rserv.pm to see what it
does so I've got a decent head start.
The two questions that are holding me up at this point are:
1. which column do you specify for setting up the replicatio
The license agreements of many commercial DBs forbid licensees from
publishing benchmarks of their software.
What is your undergraduate project? More details could help, anyway most of
the popular RDBMS features are in Postgresql.
I'd figure Postgresql is one of the best RDBMSes to use for an
un
> >> ... I wonder whether this is an inbuilt,
> >> unavoidable problem with free software projects once they reach a certain
> >> level of popularity.
>
> > Funny you should mention PHP. I talked to Rasmus about the email volume
> > when I first met him in the fall. He said the volume of email
I believe that first number is oid.
Jie LIANG
St. Bernard Software
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Thu, 15 Feb 2001, Richard Huxton wrote:
> From: "Jean-Arthur Silve" <[
Are you referring to short circuit? That's a language feature, isn't it? I
didn't think it had anything to do with the compiler (I know C and a few
other languages do it). Anyway, I could be wrong.. Seems that could break a
lot of code if the programmer relies on short circuit in some conditional
> > will give a divide by zero error as A=(y>0) and B=(x/y>1) can be
evaluated in
> > any order (A and B = B and A). I obviously would like (y>0) to happen
first,
> > but I don't see how this can be achieved.. Any ideas?
I have one idea that would be nifty to implement. In some compilers, you
You should have a look at the wiki stuff
http://c2.com/cgi/wiki?WikiWikiWeb
Dave
- Original Message -
From: "Richard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 12:40 PM
Subject: [GENERAL] Annotatable on-line documentation
> (This was: "Re: [GENERAL]
Hello!!
I need demostrate that PostgreSQL is a great RDBMS for my undergraduate
project, because this, Does somebody has a bechmark (or similar
document) between Postgres and others DB (commercial DB's, principally)?
Thanks in advance!!
> On Fri, 16 Feb 2001, Bruce Momjian wrote:
>
> > Yes, our CREATE INDEX lower(col) already does that, but you do have to
> > use lower(col) when doing the query.
>
> Right, that's what I'm suggesting a configuration that automates the
> lower(col) bit in CREATE INDEX and that automates the lower
Hello!!
I need demostrate that PostgreSQL is a great RDBMS for my undergraduate
project, because this, Does somebody has a bechmark (or similar
document) between Postgres and others DB (commercial DB's, principally)
Thanks in advance!!
help
Hi,
It would work fine to have a web interface in case the
application could be developed with that... In fact,
we had started working on the project with PG and Java
Servlets et al... However, we ran into problems after
a month of designing and actual implementaiton work
was over only beca
In psql, gethostbyname() is defined as taking a text parameter and return an
inet type value or reference.
However, if you do
psql=# select gethostbyname('www.postgres.org');
gethostbyname
---
(1 row)
the inet address will be unprintable.
Has anyone got any idea?
Phillip Pan
-
Hi.
I have a problem getting postgresql to work on my Debian 2.2 system, and
i hope someone in this group can help me.
I have successfully compiled, installed and used postgresql 7.02 on a
RedHat6.2 system.
The problem is the same for postgresql 7.02 and 7.03 on two different
computers, both run
: SELECT a.x/b.y FROM vals a, (SELECT y FROM vals WHERE y > 0) b WHERE (a.x
: / b.y) > 1;
How much of a performance hit is there when using a select in the FROM
clause? Is it even noticeable? How much better is it to create a static
view?
-Dan
Hello,
I am putting together a web site to display a collection of Chinese
woodblock prints. I want to be able to store double byte values (that is
to say Big5, Unicode etc encoded) in a text field for things such as the
artist's name and the title of the print. I have the following questions:
I
Hi,
What exactly does vacuumdb do? In what way does it 'clean' the db?
Also what are the best ways to optimise a pg databaseThanks,
Jonathan Daniels
Patrick Welche <[EMAIL PROTECTED]> writes:
> select x/y from vals where y>0 and x/y>1;
> will give a divide by zero error as A=(y>0) and B=(x/y>1) can be evaluated in
> any order (A and B = B and A). I obviously would like (y>0) to happen first,
> but I don't see how this can be achieved.. Any id
> On Thu, 15 Feb 2001, Michael Fork wrote:
>
> > Indexes *can* and *will* be used if you create the appropiate
> > functional indexes, i.e:
> >
> > CREATE INDEX idx_table_field_upper ON table(upper(field));
> >
> > SELECT field FROM table WHERE upper(field) LIKE upper('some string');
>
> Hmmm.
> Hmmm...I'd hate to have two indexes on every field I query like this, one
> case-senstive, one case-insensitve (like the one you create here). Is
> there a configuration option or something that will tell pgsql to do
> case-insensitive comparisons (kinda like MS SQL Server has)? That could
> sav
Title: Question
Does this run on Windows NT or 2000.
I have tried the function gethostbyname(text), which should return an inet value
or reference. However, it gave me something like
sql#= select gethostbyname('www.postgres.org');
Anyone got any clue?
Phillip Pan
---
Looking for an open source web development tool that supports commercial as
well as open source databases? Check out http://www.openbedrock.org
Bruce Momjian wrote:
> Interesting. I think GIST itself may be too specific for a talk.
> However, type extensibility would be very interesting.
As it turns out, there are just two am's one will most likely build
new types upon: btree and GiST. A useful tutorial should include
examples of both,
On Thu, 15 Feb 2001, Michael Fork wrote:
> Indexes *can* and *will* be used if you create the appropiate
> functional indexes, i.e:
>
> CREATE INDEX idx_table_field_upper ON table(upper(field));
>
> SELECT field FROM table WHERE upper(field) LIKE upper('some string');
Hmmm...I'd hate to have t
hi. i was wondering how to go about creating an assertion to be used within a
pl/sql function.
do i put
create assertion
check ...
before or after "begin"?
thanks
--
-leon (in the dungeon of EUII @ UC Davis)
> Hello,
>
> I'm a bit new to postgres. Is there anyway to tell the current number of
> connections on a database or server? I'm having a connection closing
> problem and would like to debug it somehow. I know on Sybase you can
check
> a sys table to determine this. Not familiar with how to
You didn't mention what version of Postgres, but in 7.1beta, you could do
the following (pretty sure on the syntax):
SELECT a.x/b.y FROM vals a, (SELECT y FROM vals WHERE y > 0) b WHERE (a.x
/ b.y) > 1;
In anything else, you could try a view:
CREATE VIEW valid_vals AS SELECT y FROM vals WHERE
Sorry for the lack of description, but here goes.
I have a function which runs properly, causes no errors until I call
SPI_Finish(). Upon that call the backend closes (not what I want).
If I remove that line (leaving in the SPI_Connect() statement) it runs
fine, but issues numerous warnings abo
Well, it doesn't solve the ordering question, but you could
use a where something like this I guess:
where y>0 and (x/(case when y=0 then 1 else y end))>1
On Wed, 14 Feb 2001, Patrick Welche wrote:
> create table vals (
> x float,
> y float
> );
> insert into vals values (2,4);
> insert int
Can you EXPLAIN that query and send us the results (the query plan)? That
should tell a whole lot.
-Mitch
- Original Message -
From: "Dave Edmondson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 1:32 PM
Subject: Postgres slowdown on large table joins
> I'
create table vals (
x float,
y float
);
insert into vals values (2,4);
insert into vals values (2,2);
insert into vals values (2,1);
insert into vals values (2,0);
select x/y from vals where y>0 and x/y>1;
will give a divide by zero error as A=(y>0) and B=(x/y>1) can be evaluated in
any order
I'm having a problem here. I'm using Postgres 7.0.3 on a FreeBSD 4.2-RELEASE
machine... it's a Pentium II/450 w/ 128MB of RAM (not nearly enough, but
there'll be an upgrade soon). Anyway, I have a data table, which currently
has around 146,000 entries, though it will grow to a few million eventual
If I create a table like
create table tablename (
aNuminteger not null,
namevarchar(10)
);
If I do select * from tablename;
q1. Is there such thing rowid similar to Oracle in PostgreSQL?
q2. How do I make aNum auto increment by 1? Need to write
a trigger? how to write that?
I want to en
Hi,
is there a way to get statistuics from postgres, like the amount of
requests it handled, or the amount of connections it had the last 10 min.
Just curious so I can link it with Mysql.
May pg_statistics is the solution for my problem, but don;t get it atm.
ys,
--
-- Ramses Smeyers <[EMAIL
Ok, the type your looking for to auto create a sequence and increment by
one is called SERIAL (an int4 field). And yes, pgsql has oid's. Heres
what your table would look like with serial type's:
CREATE TABLE tablename (
item_idSERIAL,
name VARCHAR(10)
);
The serial type will im
On 14 Feb 2001 11:57:47 -0500, Vince Vielhaber wrote:
> On Wed, 14 Feb 2001, Bruce Momjian wrote:
>
> > I am not sure how many people have looked at my book on Amazon.com, but
> > I have received my first negative book review:
> >
> >
>http://www.amazon.com/exec/obidos/ASIN/0201703319/o/qid%3D
Hello,
I'm a bit new to postgres. Is there anyway to tell the current number of
connections on a database or server? I'm having a connection closing
problem and would like to debug it somehow. I know on Sybase you can check
a sys table to determine this. Not familiar with how to do this on
Po
[EMAIL PROTECTED] (Konstantinos Agouros) writes:
> someone gave me the tip to use the -F-flag to improve performance. Since
> I can't run the postmaster with -F but just postgres how do I do it, if I
> want to import a big amount of data?
In 7.0.* (but not prior versions) it is safe to run indivi
(This was: "Re: [GENERAL] Re: PostgreSQL vs Oracle vs
DB2 vs MySQL - Which should I use?", but I think a new
thread has spun off...)
[Tom Lane said ...]
> I agree we need to work harder on making answers
findable
> outside the mailing lists. Improving the docs,
making the mail archives
> more ea
Hi,
someone gave me the tip to use the -F-flag to improve performance. Since
I can't run the postmaster with -F but just postgres how do I do it, if I
want to import a big amount of data?
Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: [EMAIL PROTECTED]
Otkerstr. 28, 8154
48 matches
Mail list logo
