wstrzalka wrote:
I'm using psql mainly in putty window.
I have a problem while resizing the window.
When changing the window size (and those chars per row) psql output
becomes mess, the only rescue is to exit and run the psql again. It
looks like it's initializing the output params at startup
Otto Hirr wrote:
I'm looking for pointers to info on storeing / retreving docbook, or other
document type systems, in sql tables.
Make a column of type xml and store it there. But we don't have schema
validation for xml data yet.
--
Sent via pgsql-general mailing list
On Friday 17 October 2008 22:01:33 Guy Rouillier wrote:
When I use Reply All in Thunderbird, it adds a To: to each of the
individuals in the discussion, and a CC: to the list. Since I
personally don't like receiving multiple copies of emails from this
list, I delete all of the To: addressees
Scott Marlowe wrote:
Since you can check which columns have changed, it's pretty easy to
write a trigger that just skips its logic when none of the trigger
columns have changed.
I think column-level triggers actually fire when one of the columns is
written to, not only when the value there is
Markus Wanner wrote:
So, please, either decide to backport a Postgres major version and
continue to update it even if it gets dropped from testing *or* don't
backport it at all.
I understand how this use case ends up falling through the cracks. But
the backports infrastructure is not set up
Joris Dobbelsteen wrote:
The good question would be for what reason they have removed the
backports package? Maybe shortage on maintainers?
As a matter of policy, backports are made from Debian testing.
Continued maintenance of PG 8.2 packages is not really backporting,
since there is
Gerd König wrote:
a few months ago we started using Postgres on Opensuse10.3-64bit.
We installed Postgres 8.3.1 with the (at that time) latest available rpm's.
But now Postgres' current version is 8.3.4 and I'm wondering why there
are no new rpm's for Opensuse ?!?!
The answer is quite simply
Dave Page wrote:
2008/9/23 Peter Eisentraut [EMAIL PROTECTED]:
Gerd König wrote:
a few months ago we started using Postgres on Opensuse10.3-64bit.
We installed Postgres 8.3.1 with the (at that time) latest available
rpm's.
But now Postgres' current version is 8.3.4 and I'm wondering why
Devrim GÜNDÜZ wrote:
On Tue, 2008-09-23 at 09:49 +0100, Simon Riggs wrote:
I'll look at doing that. We need the SUSE builds also.
I actually built 8.3.4 on SLES 10.2 on..err..Friday, while building
Fedora/RH RPMs. 8.3.1 spec of SLES is broken IMHO, and it requires
special attention from
Alvaro Herrera wrote:
Doesn't say about variable expansion ... And it seems to be in a
different realm, because the point is that the command is going to have
a single destination (either \-processing or sending it to the server).
Is psql being just lazy here and avoiding parsing the command?
Tom Lane wrote:
Jef Peeraer [EMAIL PROTECTED] writes:
i am using the xml add-ons, but the date output format seems to be wrong :
I think the conversion to xml intentionally always uses ISO date format,
because that's required by some spec somewhere.
Yes, it follows XML Schema. Which is why
Jef Peeraer wrote:
On Thu, 11 Sep 2008, Peter Eisentraut wrote:
Tom Lane wrote:
Jef Peeraer [EMAIL PROTECTED] writes:
i am using the xml add-ons, but the date output format seems to be wrong :
I think the conversion to xml intentionally always uses ISO date format,
because that's required
Joao Ferreira gmail wrote:
I need to remove from 100.000 to 1.000.000 records from my table once a
day, and I'dd like to make that removal as fast as possible. This is the
idea:
DELETE FROM tt WHERE time $1;
Would it be considerably faster if I declare that query inside a user
function,
Jef Peeraer wrote:
it would be a flag to indicate no conversion from the datestyle settings
in the database...i think, from a users perspective, the table_to_xml is
completely useless, if you have to reformat everything afterwards
Just write a function that does your formatting
Tom Lane wrote:
The ideas I had involved not considering the cast interpretation when
the actual syntax is table.column and some-set-of-other-conditions.
While this is certainly possible to implement, any variant of it will
break the existing 100% equivalence of foo.bar and bar(foo); which
seems
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Greg Smith [EMAIL PROTECTED] writes:
On Tue, 9 Sep 2008, Artacus wrote:
Can psql access environmental variables or command line params?
$ cat test.sql
select :TEST as input;
$ psql -v TEST=16 -f test.sql
input
---
16
(1 row)
Nice
Matthew Dennis wrote:
Given table T(c1 int) and function F(arg int) create an index on T using
F(c1). It appears that if you execute create or replace function F
and provide a different implementation that the index still contains the
results from the original implementation, thus if you
Bill wrote:
The SQL database servers I have worked with cannot use and index for a
SELECT of the form
SELECT * FROM ATABLE
WHERE AFIELD LIKE ?
because there is no way to know the location of the wild card until the
parameter value is known. InterBase and Firebird allow
SELECT * FROM ATABLE
Chris Sano wrote:
I'm trying to build a SQL script that will create a database if it
doesn't already exist. I've looked everywhere and haven't been able to
find anything. Am I missing something? Thanks.
SELECT * FROM pg_database will tell you what databases exist.
--
Sent via pgsql-general
Albretch Mueller wrote:
PostgreSQL has 60+ types and many look like eachother. How do you propose to
differentiate?
~
Data Types are basically about value ranges (how many bits do you
need to hold the value) and formatting.
That is exactly wrong, at least in the PostgreSQL approach to the
Am Tuesday, 19. August 2008 schrieb Ivan Sergio Borgonovo:
I just learnt that NOT DEFERRABLE is default.
Is it mandated by SQL standard?
Yes.
Is there any shortcut if I've to change to deferrable most of my
constraints?
Probably not, short of writing a little script.
Other than pgfoundry
Am Tuesday, 19. August 2008 schrieb Ivan Sergio Borgonovo:
Is there any reason they put it that way in the standard other than
the mantra stricter is better?
After reflecting a bit I think it is a matter of failing earlier.
Deferrable constraints are an optional feature of SQL, and the
Am Friday, 15. August 2008 schrieb Thomas Finneid:
First question is, what is the rationale behind having a limit on the
table name?
Is is an implementation detail. Fixed-length name fields are more efficient
to process. And when you have fixed-length fields you need to choose some
Am Thursday, 14. August 2008 schrieb Clemens Schwaighofer:
Why is Postgres not using the indexes in the 8.3 installation.
Might have something to do with the removal of some implicit casts. You
should show us your table definitions.
--
Sent via pgsql-general mailing list
Am Thursday, 14. August 2008 schrieb Dmitry Teslenko:
SELECT SUM(...) FROM table1 WHERE field3 = 'ABC' AND field1 1
GROUP BY field2
And planner picks up a sequential scan of a table. Why does he?
Presumably because it thinks it is the best plan, and I see no reason to doubt
that
Am Thursday, 7. February 2008 schrieb Lawrence Oluyede:
PostgreSQL 8.3 instead doesn't allow the insertion of XML with doctype
in its new native data type returning this error message:
ERROR: invalid XML content
DETAIL: Entity: line 2: parser error : StartTag: invalid element name
Am Wednesday, 6. August 2008 schrieb erithema:
SELECT id_autori , xpath ('/Authority/Nome', testo)
FROM autori
WHERE xpath_bool('/Authority[Nome=ABELARDO]', testo) ;
I get this error:
ERROR : the function xpath_bool(unknown , xml) do not exsist at character
69 HINT: no function matches
Am Wednesday, 6. August 2008 schrieb sagswe:
When i run ' \i /usr/local/pgsql/share/pgxml.sql' in postgre , I get error
saying file or directory named 'MODULE_PATHNAME' doesn't exist. How to get
this MODULE_PATHNAME exist?.
This sounds like your installation is botched? How did you install
On Monday 11 August 2008 20:15:37 Mani, Arun wrote:
Is there a configuration setting to increase the error checking level or
any tool available to do the same.
No
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Am Dienstag, 15. Juli 2008 schrieb Morten Barklund:
My problem is, that the lowercase versions of non-ascii characters are
broken. Specifically I found, that when lower() is invoked on a text with
non-ascii characters, the operating system's locale is used for converting
each octet in the
Am Dienstag, 15. Juli 2008 schrieb Morten Barklund:
I can see that lc_collate (sorting) and lc_ctype (lower-upper conversion)
is set to en_DK and I guess that default encoding for en_DK is iso88591 or
maybe windows1252.
It is ISO-8859-1. There is no support for Windows charmaps on Linux.
Am Freitag, 11. Juli 2008 schrieb Gábor Farkas:
is the only solution to create a new database-instance? (initdb, new
port, etc.) ?
You analysis is entirely correct. You have to re-initdb with a correct
locale.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Am Donnerstag, 10. Juli 2008 schrieb Chris Cosner:
Using RHEL 5, with Postgresql 8.1, Apache, mod_perl, mod_auth_pgsql,
DBI, DBD::Pg
Perl cgi scripts that access the database get the following in httpd
error_log:
DBI connect('dbname=db','',...) failed: could not connect to server:
Peter Billen wrote:
I would like to ask a question about outputting data as XML. Say I have two
tables:
team(integer id, text name);
player_of_team(integer id, integer team_id, text name); (team_id is FK to
team.id)
I would like to query both tables to get following example XML output:
Am Sunday, 8. June 2008 schrieb Albe Laurenz:
In short, I've upgraded to 8.3.1 from 8.1 on RHEL 4 (with
some CentOS packages). I have apps with dependencies of
libpq.so.4 but this is no longer available. 8.3.1 provides
libpq.so.5 and the compat-libs provide libpq.so.3.
Strange; does
Brijesh Shrivastav wrote:
For #4 I was looking to be able to index some or all of the tags in the
xml document. Most of our applications query very few tags in a Xml
document
and a smaller index on few tags will help with query performance.
Expression indexes on xpath are probably what you
Am Donnerstag, 22. Mai 2008 schrieb Brijesh Shrivastav:
1) Can xml column be constrained to be DOCUMENT or CONTENT type?
Using a check constraint that does IS [NOT] DOCUMENT on the value.
2) Is there plan in near future to support XML schema validation
i.e to ensure inserted xml
Am Mittwoch, 21. Mai 2008 schrieb Thomas Kellerer:
How would I achieve the same without using the deprecated xml2 module?
xpath_table is probably the major piece that is not directly covered by the
new system. So until we have a replacement, we probably won't remove the old
module.
--
Sent
Am Dienstag, 6. Mai 2008 schrieb Daniel Schuchardt:
so it depends on ? if i need an explicit cast?
A type cast can be attempted in three different contexts (see also CREATE CAST
reference page):
- implicitly
- storage assignment
- explicitly
The explicit case is if you call CAST() or ::.
Am Mittwoch, 23. April 2008 schrieb Ivan Sergio Borgonovo:
I'd like to know if anyone has experience in using postgresql 8.3 for
amd64.
There are probably thousands of people with that experience.
How did you set up your apt config/source.list to just install the
minimum required to install
Am Mittwoch, 23. April 2008 schrieb Tim Tassonis:
My question is: Why then is --locale=C not the default for initdb, as I
do regard it as a rather big annoyance that a default installation on
probably almost any modern linux distribution results in a UTF-8 only
cluster, fixable only by
Am Mittwoch, 23. April 2008 schrieb Tim Tassonis:
If specifying a characterset different from the default locale for a
database is such a bad idea, why is it possible at all?
Because Japanese users need this functionality. Aside from spectacularly
bizarre niche applications, that is really
Zoltan Boszormenyi wrote:
select version();
It will tell you the compiler version and arch as well. You can deduce
from there.
That approach is not reliable. I often build and run a 32-bit build of
PostgreSQL on a machine that claims to be something like
x86_64-unknown-linux-gnu.
--
Sent
Steve Atkins wrote:
What's the psql equivalent of the standard use case of vacuumdb -a?
There isn't a good one. A tool, possibly a psql option, to do run this SQL
command in all databases, would allow us to get rid of clusterdb, reindexdb,
vacuumdb.
--
Sent via pgsql-general mailing list
Joshua D. Drake wrote:
I would note that system utilities can be renamed at the packagers
behest.
./configure --exec-prefix=pg
Yes this would create pgpg_ctl.
No, this would make configure abort with an error message.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
. Just don't add dozens of
implicit casts and then come back here wondering why your application is
behaving strangely. :)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
quasi-official RPMs for SUSE onto the openSUSE build
service. The only thing holding this back at the moment is the lack of time
for the people involved.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9
the makefile and remove the export list,
but there is no simpler or better-defined way available.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
that
PostgreSQL very write-happy and you might have some work to do.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
, but I'm not sure how accessible that is.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
it is proprietary.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Am Mittwoch, 30. Januar 2008 schrieb Ivan Sergio Borgonovo:
How/where is it possible to submit doc patches?
[EMAIL PROTECTED] -- The process is mostly the same as for normal
code. The Developer section of the web site gives you more information.
--
Peter Eisentraut
http
Sigurd Nes wrote:
I noticed the upcoming support for xml in 8.3:
Does anybody know if this allows updates, inserts,removes and renames of
nodes to a XML-document (as for Xindice)?
No, it doesn't support that directly. I guess you could achieve it by using
XSLT.
--
Peter Eisentraut
http
/RELEASE_I386 i386 i386
I think we should address the problem were it happens. Adding this output
will increase the amount of information available for causing confusion,
while it would probably still require expert knowledge to read an endianness
issue out of that.
--
Peter Eisentraut
http
it so.
Nevertheless, I suggest you follow Josh Berkus's blog, which is as close as
you will get to someone important from Postgres having access to someone
important at Sun.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Am Dienstag, 8. Januar 2008 schrieb rihad:
Hi, all! Subj, as is. Any other pitfalls I should be aware of?
Please check the release notes for this information.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Devrim GÜNDÜZ wrote:
I want to announce PostgreSQL RPM Buildfarm today.
Where is it?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
this?
Rerun initdb and either do not specify an encoding explicitly, or choose a
matching combination.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
Am Montag, 3. Dezember 2007 schrieb Josh Harrison:
initdb -E en_CA.utf-8 -D /export/home/sjothirajah/postgres8.3/pgsql/data
gives this error
initdb: en_CA.utf-8 is not a valid server encoding name
The option name you want is --locale, not -E.
--
Peter Eisentraut
http
Am Dienstag, 4. Dezember 2007 schrieb Louis-David Mitterrand:
While upgrading from 8.3-beta3 to beta4, postgres complained that the
database format was not supported. I had to restore from backup.
Was that intended?
Yes
--
Peter Eisentraut
http://developer.postgresql.org/~petere
at the end after the data load.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Tom Hart wrote:
Hey everybody. I have a field that, in my earlier mySQL days would have
been an enum('q','y','m','c'), and I'm wondering what's the best way to
handle this in pgsql.
If it's an option, upgrade to 8.3 and use the new enum support.
--
Peter Eisentraut
http
Am Montag, 19. November 2007 schrieb x asasaxax:
I´m interested in running xml with postgre. I use postgre version 8.2
and windows xp. I would like to know how can i enable the xml in the
postgresql.
That depends on what you want to do with it. XML is quite a broad topic.
--
Peter
Sean Davis wrote:
I meant a schema that
represents a general mapping between XML and a relational schema. In
other words, I am looking for tools that use postgresql as the storage
engine for a native XML database.
There are ideas for that, but nothing to be expected any time soon.
--
Peter
discussion
and coordination of translation activities.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
fields (I told you I
couldn't figure out how to explain it).
I can't tell more without the exact table definitions, but this should work
just fine.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't
madhtr wrote:
Quick question, are there any native functions in PostGreSQL 8.1.4 that
will strip HTML tags, escape chars, etc?
Using an SQL function to circumvent SQL injections probably isn't the wisest
of ideas.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
document. How do you imagine that affecting PostgreSQL database system
operations?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Am Mittwoch, 7. November 2007 schrieb Tommy Flewwelling:
How do I inform the complier to extract the password from the file and not
the prompt the user?
It does that automatically. Just omit the -W option.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
something on your system is probably broken.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
your own
query runs.
2) Notice that two successive SELECT commands can see different data,
even though they
are within a single transaction, if other transactions commit changes
during execution
of the first SELECT
--
Peter Eisentraut
http://developer.postgresql.org/~petere
there is
probably no reason to use a more restricted character set.
Note that some versions of PostgreSQL have various degrees of trouble
with UTF-8 support. Be sure to use the latest version.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
machine to old machine to perform the dump?
The advice remains: Install the newest client package and use that pg_dump.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
psql still try to find the PID
file in /var/run/ postgresql and fail.
You must be mistaken about this. psql shouldn't have a reason to read
the server's PID file.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Cody Pisto wrote:
I'm just looking for the correct workaround.
The canonically correct workaround it to define your own locale.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0
variant of this
involving those parameters.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Am Donnerstag, 16. August 2007 08:40 schrieb bhyuan:
Can I ignore the error message by confiing the config file?
No, there are not provisions for that. Some errors of this type used to be
ignored, but that led to SQL injection-like security issues, so you don't
want that.
--
Peter
Am Donnerstag, 16. August 2007 11:22 schrieb Sergey Moroz:
there is no array for cstring type. I created it manually in pg_type table.
It seems to me that it's working fine. Can this cause any problems?
The cstring type is not for general use. Use varchar or text.
--
Peter Eisentraut
http
behavior, so it won't be changed back
without sufficient cause.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
with a new 8.2 release and send that to the OpenSUSE build service.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Aarni Ruuhimäki wrote:
So, what would be the proper way to convert the dumps to UTF-8 ? Or
any other solution ? Any other tool to work with the problem files ?
Dump them again but set your client encoding to UTF8.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Michael Knudsen wrote:
I can't find a file with that name. I am not using postgreSQL on my
own computer, so the file may be hidden somewhere in a directory
which I haven't got access to. Is there another way to get rid of
'trust'?
No.
--
Peter Eisentraut
http://developer.postgresql.org
To:get a life
and terminates. What I would like to happen is for pg_restore to
ignore this error and continue on. Is there a way to make it do
that?
No, you have to find out which encoding that actually is and then set
your client encoding to that when restoring.
--
Peter Eisentraut
http
is going wrongThanks In advanceWith RegardsAshish...
Check if you have the GZIP environment variable set.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
Am Mittwoch, 1. August 2007 10:07 schrieb Ow Mun Heng:
New to PG, just wondering if there's anyway to say.. I want t Full
backup of DB-Sample and I can just tar up the directory containing that
tablespace, copy it to another PG server and then re-attach it?
No.
--
Peter Eisentraut
http
events, advocacy and other
topics relevant to our work in Europe.
If it's not a general list, why did you name it general? That will
certainly cause confusion. It sounds like -eu-advocacy might have been
better.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
configuration to suply
the max. performance.
That is nonsense.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
Frank van Vugt wrote:
db=# select avg(pg_catalog . pg_stats . avg_width) from
pg_stats;
It seems that all whitespace between schema/table/field references is
ignored?
Sure, this is perfectly valid per SQL and what not.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
in PGSQL? Does the dow result
also depend on the language settings, or will the value 0 ALWAYS be a
Sunday?
It's always that way for this particular function.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP
to be, say, SETOF varchar. Then you can return no
rows by doing something like SELECT '' WHERE false;.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
Am Montag, 14. Mai 2007 15:35 schrieb Paula Ta-Shma:
Is there a way to allow migration of a single table/database/tablespace
from one postgres instance to another (in a system with multiple
tables/databases/tablespaces) ?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Am Dienstag, 8. Mai 2007 18:09 schrieb Andreas:
Do you know where I find PG 8.2.4 and pgAdmin 1.6.3 binaries for Debian
4.0.x ?
Right now you can't, at least not from official or semiofficial sources. I
expect in a few weeks time, backports will show up on backports.org.
--
Peter Eisentraut
the encoding
expected by the server, which is controlled by client_encoding.
I know that I need to set something to my database/table but I dont
know where or how to achieve this,
Set client_encoding to the encoding that your client application is really
producing.
--
Peter Eisentraut
http
Am Dienstag, 8. Mai 2007 13:32 schrieb Felix Kater:
I like to keep my pg interface small: Can I replace foreign keys by
using indexes somehow?
Not while preserving the semantics.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Am Montag, 7. Mai 2007 15:53 schrieb Jonas Henriksen:
while if I add a GROUP BY data_logger the query uses a seq scan and a
lot of time:
explain analyze SELECT max(date_time) FROM data_values GROUP BY
data_logger_id;
I don't think there is anything you can do about this.
--
Peter
.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
, depending on what sort of contexts you want to use the
view in.
Another option would be using prepared statements.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
design, not the frequency of queries. If you are querying columns
other than the primary key, just add another index.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives
Lloyd Mason wrote:
I have also tried the query using the same encoding with both the
8.1.5 and 8.1.8 versions and the query is still coming back with
different results.
He said locale, not encoding.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
only releases = 7.4. The
user could run an arithmetic expression to check for that and = 8.0.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
201 - 300 of 934 matches
Mail list logo
