I have been informed that at present (postgres 7.3.2) using IN is not
advised, and I should replace it with EXISTS. I can't seem to get it to
work.
I've tried replacing (example):
SELECT
name
FROM
people
WHERE
state IN (
SELECT
id
You should use something like:
SELECT
name
FROM
people p
WHERE
exists (
SELECT
1
FROM
states
WHERE
name = p.state
)
AND state ~* 'r';
On Tue,
If I'm doing a reasonably sized COPY e.g. a few hundred megabytes, would
WAL segment size and number be relevant? If so any pointers on how I should
tweak stuff?
How about for speeding up many inserts?
At 12:13 AM 7/22/2003 -0400, Tom Lane wrote:
AFAIR you cannot force the system to have only
Rory Campbell-Lange wrote:
I have been informed that at present (postgres 7.3.2) using IN is not
advised, and I should replace it with EXISTS. I can't seem to get it to
work.
I've tried replacing (example):
SELECT
name
FROM
people
WHERE
state IN (
SELECT
Rory Campbell-Lange wrote:
I have been informed that at present (postgres 7.3.2) using IN is not
advised, and I should replace it with EXISTS. I can't seem to get it to
work.
...
SELECT
name
FROM
people
WHERE
exists (
SELECT
Why using IN is not advisable???
On 22 Jul 2003 18:36:10 +0200
Csaba Nagy [EMAIL PROTECTED] wrote:
You should use something like:
SELECT
name
FROM
people p
WHERE
exists (
SELECT
1
FROM
Actually, even better:
select name
from people p, states s
where p.state = s.name
and p.state ~* 'r';
Cheers,
Csaba.
On Tue, 2003-07-22 at 18:36, Csaba Nagy wrote:
You should use something like:
SELECT
name
FROM
people p
WHERE
exists (
Felipe Schnack wrote:
Why using IN is not advisable???
http://www.postgresql.org/docs/faqs/FAQ.html#4.22
But I believe Tom has fixed this for the upcoming 7.4.
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and
Hello,
what is the latest version of tsearch working in postgresql 7.2.4
(unfortunately i cannot upgrade at this time) and how can i add
support for the german language to this version?
Are german files (stopwords etc.) ready for download out there?
Can i use german and english support of this
Hello everybody,
I am new to this list as to PostgreSQL as well. I am glad to make
part of this and to have the chance of using this RDBMS ( and get paid
in doing so :).
I got an eMac G4 and bought the dbexperts professional package.
Installed the Mac OS X package following instructions
Sorry if this is a repost, but codewalkers have a poll up for php
developers for their database of choice. I'm not affiliated with the
site in any way, I just want to see PgSQL at more than 8% :( It's right
on the homepage.
http://codewalkers.com/
Gavin
---(end of
Latest version of tsearch which works with 7.2.4 is in contrib directory.
German stemmer and stop words could be downloaded from
http://snowball.tartarus.org/german/stemmer.html
I'm afraid this version of tsearch requires a lot of work :)
New version is available from
so i have two databases 'A' and 'B'. B is alot like A except i've
added alot of stuff to B like cascade on delete. Now 'A' is populated
with data and i want to add the triggers to it. I tried inserting the
contents of A into the schema of B, but it gave me alot of errors
because it was trying to
16%
On Tue, 22 Jul 2003, Gavin M. Roy wrote:
Sorry if this is a repost, but codewalkers have a poll up for php
developers for their database of choice. I'm not affiliated with the
site in any way, I just want to see PgSQL at more than 8% :( It's right
on the homepage.
Let's be nice and only vote once, also. I don't know if they use cookies to prevent that, but
Gavin M. Roy wrote:
Sorry if this is a repost, but codewalkers have a poll up for php
developers for their database of choice. I'm not affiliated with the
site in any way, I just want to see
now 18%
The Hermit Hacker wrote:
16%
On Tue, 22 Jul 2003, Gavin M. Roy wrote:
Sorry if this is a repost, but codewalkers have a poll up for php
developers for their database of choice. I'm not affiliated with the
site in any way, I just want to see PgSQL at more than 8% :( It's right
on the
--- John Harrold [EMAIL PROTECTED] wrote:
so i have two databases 'A' and 'B'. B is alot like
A except i've
added alot of stuff to B like cascade on delete. Now
'A' is populated
with data and i want to add the triggers to it. I
tried inserting the
contents of A into the schema of B, but
I just wandered through their database forum, and it's chock full of
people doing things the wrong way. I've already spent enough time on
PHPBuilder trying to get people to understand fks, constraints, sequences
etc... Now I've got another site to check for people giving really bad
solutions
I wrote a utility once at a company where I worked previously that did this.
It did compared the meta data tables of the the two schemas. This was in
Oracle though. I think it took me less than a week to do. It might be a nice
utility to build for postgres.
It started with code as
SELECT
Tom Lane wrote:
DeJuan Jackson [EMAIL PROTECTED] writes:
Or is it simply any conditional rule using UNION/EXCEPT/INTERSECT/...?
Yeah, that's about the size of it :-(. Note though that you could
probably work around the problem by pushing the UNION etc. down into a
sub-select:
Bruce Momjian [EMAIL PROTECTED] writes:
What does the code do now after you changed it? Fail on the UNION
query?
Yeah. You get something about union can't be conditionally executed
(I forget the exact wording, but it's comparable to what we say about
NOTIFY under similar circumstances).
pool of what?
Nailah Ogeer wrote:
Hello,
I have written code to support multiple buffer pools in postgres 7.3.2.
Now i am looking at changing the sizes of these buffer pools, but first i
need to write all pages to disk.
I also need to incorporate this code into the backend instead of it being
a
I mean, what is getting buffered? What performance effects is it supposed allow?
Nailah Ogeer wrote:
Hello,
I have written code to support multiple buffer pools in postgres 7.3.2.
Now i am looking at changing the sizes of these buffer pools, but first i
need to write all pages to disk.
I also
There used to be a .wav file of how to pronounce postgresql but I can't
find it on the site anymore. Anyone know what happened to it?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Tue, 2003-07-22 at 13:56, Dennis Gearon wrote:
now 18%
26% at 2003-07-23 01:40UTC.
The Hermit Hacker wrote:
16%
On Tue, 22 Jul 2003, Gavin M. Roy wrote:
Sorry if this is a repost, but codewalkers have a poll up for php
developers for their database of choice. I'm not
On Tue, 2003-07-22 at 19:27, VanL wrote:
I have three queries that are essentially identical. Two of them run in
fractions of a second; one of them takes longer than 15 minutes to
return. (Not sure how long it totally takes, that has been the limit of
my patience.)
The only difference
Hello,
I have three queries that are essentially identical. Two of them run in
fractions of a second; one of them takes longer than 15 minutes to
return. (Not sure how long it totally takes, that has been the limit of
my patience.)
The only difference between these queries is the use of
Does the PostgreSQL string comparison operator remove embedded spaces in
a string before comparing? Here is a query I'm issuing (notice the
space between A and C in the first string):
select version();
select ('A C' 'AB') as result;
the result that comes back is:
version
hi..
We are using postgresql for storing Chinese,japanese,czech and Polish
characters
But while retrieving it is not displaying properly.
Can you help us in solving the problem.
We have enbled UTF-8 also
OS:Windows2000
Postgresql 7.2.1
Thanks
Ram
---(end of
Title: pg_dump problem
I am trying to get pg_dump to work. I suspect that I am doing something wrong - Here's my command, and the resulting message.
postgres owns the database and the tables; all tables were created under postgres.
postgres has no password.
The database is named demo.
It seems the serial datatype is a frequently asked questions for novices
introduced to PostgreSQL. It appears that the competing RDBMSes are simpler
to handle in that respect, when you want to insert data and have a column
autoincremented, then fetch the value that was inserted to use in the
31 matches
Mail list logo