hi
i wrote to selena and was asked to send this write on windows installation
out here
we installed postgres on our windows 2000 server yesterday and faced a few
problems (related to initdb ). We found that a few initial steps will make
things easy for all. These are not
On Feb 11, 2008 4:28 PM, Tom Lane [EMAIL PROTECTED] wrote:
Dave Page [EMAIL PROTECTED] writes:
If the endianess isn't corrected for the non-native platform at build
time, I've seen initdb leave a cluster with a completely broken
pg_rewrite (iirc).
Hmm, but is pg_rewrite really the most
Bob Pawley wrote:
All of my tables are without oids.
I have an application in which I drop, then recreate a table (to reset
serial numbers) and with an update on the new information I get an error
about a specific oid missing.
This is a known problem. It was fixed in 8.3 -- you may want
On Sat, 2008-02-09 at 09:23 -0500, Venks wrote:
Steve/Jeff,
Thanks for your replies. I am using the latest pg module but I don't
know if there is any way to handle this without SQL. I am manually
taking care of it using SQL functions to convert empty strings to
NULL. It would be nice if
Hi,
I want to convert a TEXT string that I am mangling to TSVECTOR with a cast.
I am using Postgresql 8.1.6 and tsearch2.
According to the documentation this should work although I am getting an
ERROR.
tsearch2 reference on www.sai.msu.su says that
text::TSVECTOR RETURNS TSVECTOR
FWIW, I am
I am receiving a SPI_ERROR_CONNECT error. From what I'm reading I could
fix this in C using SPI_push(). How does one fix this with PL/PGSql?
Return error:
---
NOTICE: current day = 1
ERROR:
On Feb 11, 2008, at 11:39 AM, Marc Munro wrote:
Can someone please tell me how to extract the mix, max, increment
by, etc, values for a sequence from the system catalogs. Is this in
the manual somewhere (I couldn't find it)?
Take a look at information_schema.sequences for a list of
Hey all,
I'm trying to set up an ODBC connection inside Visual Studio 2005 and
getting the error message [Microsoft ODBC Driver Manager] Data source
name not found and no default driver specified
The confusing part about that message is I already have the ODBC drivers
installed and have been
I've started tinkering with the FTS functionality in 8.3 and was
wondering if there was a good way to convert from a language code (like
en-us) to a language name as used in pg_ts_config.cfgname (like
'english'), As far as I know ISO639 language codes are used pretty much
everywhere else in
On Mon, Feb 11, 2008 at 10:38:55AM -0800, Bob Pawley wrote:
All of my tables are without oids.
I have an application in which I drop, then recreate a table (to reset
serial numbers) and with an update on the new information I get an error
about a specific oid missing.
Any thoughts would
All of my tables are without oids.
I have an application in which I drop, then recreate a table (to reset
serial numbers) and with an update on the new information I get an error
about a specific oid missing.
Any thoughts would be appreciated.
Bob
- Original Message -
From: Erik
I'm running Postgresql 8.2 on Windows.
If I create a table 'without oids' are oids still in use behind the scenes??
Bob
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hello,
I'm planning to cluster a few large tables in our database but I'm
unable to find any recommendations/documentation on best practices --
Mainly, whether it's better to use an index which has a higher idx_scan
value, a higher idx_tup_read value, or the higest idx_tup_fetch value.
Can
Mario Lopez wrote:
Hi guys :-), I am working on a personal project in which I am trying to
make sense on a huge (at least for me) amount of data. I have
approximately 150 million rows of unique words (they are not exactly
words it is just for explaining the situation).
The table I am
On Feb 11, 2008, at 9:37 AM, Mario Lopez wrote:
Hi guys :-), I am working on a personal project in which I am
trying to make sense on a huge (at least for me) amount of data. I
have approximately 150 million rows of unique words (they are not
exactly words it is just for explaining the
Hubert,
Your two posts look pretty cool :), I would read them tonight and answer
you back :)
Thanks!
On Mon, Feb 11, 2008 at 04:37:24PM +0100, Mario Lopez wrote:
SELECT * FROM names WHERE name LIKE ‘keyword%’
Or
SELECT * FROM names WHERE name LIKE ‘%keyword%’
check this:
On Mon, Feb 11, 2008 at 04:37:24PM +0100, Mario Lopez wrote:
SELECT * FROM names WHERE name LIKE ‘keyword%’
Or
SELECT * FROM names WHERE name LIKE ‘%keyword%’
check this:
http://www.depesz.com/index.php/2007/07/30/indexable-field-like-something/
and this:
On Feb 9, 2008, at 12:20 PM, Ken Johanson wrote:
But given the recent and dramatic example of 8.3's on-by-default
stricter typing in functions (now not-autocasting), I worry that
kind of change could happen in every minor version (8.4 etc).
You need to *know* your software if you're using
On Mon, Feb 11, 2008 at 03:26:39PM +0100, Ivan Sergio Borgonovo wrote:
On Mon, 11 Feb 2008 08:46:00 -0500
Christopher Browne [EMAIL PROTECTED] wrote:
On Feb 11, 2008 8:04 AM, Ivan Sergio Borgonovo
[EMAIL PROTECTED] wrote:
I did manage to find an announcement about the support of pg for
On Mon, Feb 11, 2008 at 08:46:00AM -0500, Christopher Browne wrote:
On Feb 11, 2008 8:04 AM, Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote:
I did manage to find an announcement about the support of pg for
windows... but I wasn't able to see anything you'd have a summary of
scheduled and
On Mon, 11 Feb 2008 08:46:00 -0500
Christopher Browne [EMAIL PROTECTED] wrote:
On Feb 11, 2008 8:04 AM, Ivan Sergio Borgonovo
[EMAIL PROTECTED] wrote:
I did manage to find an announcement about the support of pg for
windows... but I wasn't able to see anything you'd have a summary
of
Dawid Kuroczko escribió:
Dawid Kuroczko escribió:
I'm using 8.3.0 and I see that autovacuum processes in
pg_stat_activity have xact_start.
As far as I know, since at least 8.2.x the VACUUM does not start a new
transaction.
I am referrring to the E.8.3.5 Release 8.2 Release
On Feb 11, 2008 3:56 AM, Alban Hertroys
[EMAIL PROTECTED] wrote:
On Feb 11, 2008, at 2:23 AM, Willem Buitendyk wrote:
As others have suggested my big problem with the function I wrote
was that I had made it Volatile instead of Immutable (it is no
doubt suffering from code bloat as well).
Willem Buitendyk [EMAIL PROTECTED] writes:
ERROR: SPI_connect failed: SPI_ERROR_CONNECT
CONTEXT: PL/pgSQL function pop_tag_day_over line 17 at FOR over
SELECT rows
Hm, what PG version is this? And could we have a complete test case
not just the function? (I don't feel like trying to
Hello,
you have to use switch -lpq
http://www.postgresql.org/docs/8.3/static/libpq-build.html
Regards
Pavel Stehule
On 12/02/2008, Shwe Yee Than [EMAIL PROTECTED] wrote:
Hello,
I´ve got a problem when trying to access Postgresql through C language. I've
included libpq-fe.h as a header
Including the header is not enough you must also link your binary
against the library.
On Feb 11, 2008, at 9:52 PM, Shwe Yee Than wrote:
Hello,
I´ve got a problem when trying to access Postgresql through C
language. I've included libpq-fe.h as a header file in the C
program.
When I
Dear All,
I got error message 'ERROR: column "ctid" does not exist; Error while executing the query' when I try to query SELECT on my VIEW as 'rsSystem.Open "SELECT * FROM v_memocatlist ORDER BY memocategory", connSystem, adOpenStatic, adLockOptimistic'.
I found some information on internet
Hello,
I´ve got a problem when trying to access Postgresql through C language. I've
included libpq-fe.h as a header file in the C program.
When I compile it, I got the following errors:
[EMAIL PROTECTED] src]$ gmake
alpha1.o(.text+0x297c6):/home/srb/SRB3_4_2/mySRB/src/alpha1.c:12726:
On Feb 11, 3:15 am, ${spencer} [EMAIL PROTECTED] wrote:
I just literally ran my first search of the day and got the same
error.
i changed my query so that the integer was cast into text and then it
worked fine.
[EMAIL PROTECTED] wrote:
All,
I'm getting the following (new) (php?) error
James Reynolds [EMAIL PROTECTED] writes:
I want to convert a TEXT string that I am mangling to TSVECTOR with a cast.
I am using Postgresql 8.1.6 and tsearch2.
According to the documentation this should work although I am getting an
ERROR.
tsearch2 reference on www.sai.msu.su says that
Tom Lane wrote:
That's a fairly bad workaround (assuming that the function is a
legitimate candidate to be IMMUTABLE) because it defeats potential
optimizations.
What I'd suggest you do instead is rethink your apparently widespread
habit of whacking your view definitions around
On Mon, 2008-02-11 at 09:09 +0100, Peter Eisentraut wrote:
Ken Johanson wrote:
Is there anything now, or in the works, for compatibility emulation? For
example to setup my session to act like 8.2 and allow less-strict
typing.
The best way to ensure 8.2 compatibility is to use 8.2. But
Josh Hayes-Sheen [EMAIL PROTECTED] writes:
I've started tinkering with the FTS functionality in 8.3 and was
wondering if there was a good way to convert from a language code (like
en-us) to a language name as used in pg_ts_config.cfgname (like
'english'), As far as I know ISO639 language codes
we installed postgres on our windows 2000 server yesterday and faced a few
problems (related to initdb ). We found that a few initial steps will make
things easy for all. These are not listed out in the forums or postgres
docs. if it is ok you can post these in the postgres windows faq.
we have
On Feb 11, 2008, at 12:15 PM, Bob Pawley wrote:
I'm running Postgresql 8.2 on Windows.
If I create a table 'without oids' are oids still in use behind the
scenes??
Yes and no. WITHOUT OIDS specifies that you don't want each row to
get its own oid. You will often here of a table's oid
On Feb 11, 2008, at 9:33 AM, Ivan Sergio Borgonovo wrote:
On Mon, 11 Feb 2008 15:36:21 +0100
Magnus Hagander [EMAIL PROTECTED] wrote:
http://www.postgresql.org/support/security
that's probably the best one you can find. Or that in combination
with the news archive
On Feb 11, 2008, at 8:14 AM, Alvaro Herrera wrote:
Actually it's not just autovacuum; it's any lazy vacuum. It's hard to
tell those processes apart in pg_stat_activity. Perhaps we could have
added a column in pg_stat_activity indicating processes that don't
hold
old tuples, but I feel that
You should start a project for this on pgFoundry. It looks very useful!
On Feb 6, 2008, at 1:15 PM, Sergey Konoplev wrote:
Hello everybody.
I've written a script (see attachment) which creates operators
@ - ascending ordering
@ - descending ordering
that allows you to replace code like this
On Feb 11, 2008, at 10:37 AM, Mario Lopez wrote:
SELECT * FROM names WHERE name LIKE ‘keyword%’
If you use the C locale, PG can use an index for this query
Or
SELECT * FROM names WHERE name LIKE ‘%keyword%’
But not this one - substring searches are painful.
However, there is some hope -
Erik,
Thanks for your answers, actually this is a workable solution because my
data does not get updated so frequently (every 24 hours). The problem
is that I would like a more advanced version of this, there must be
something I can do, I am going to try what Hubert Despez explained in
his
On Feb 11, 2008, at 10:37 AM, Mario Lopez wrote:
The problem arises with the second type of queries, where there are
no possible partitions and that the search keywords are not known, I
have tried making indexes on the letter it ends with, or indexes
that specify that it contains the
The problem was with the following:
FOR current_row IN SELECT * from temp_tags_18_counted
The select from the [temp_tags_18_counted] view is made up of 3 cross
joins. When I simplify and remove the joins everything works. I tried
this with some test data with only a few rows
On Mon, 11 Feb 2008 15:36:21 +0100
Magnus Hagander [EMAIL PROTECTED] wrote:
http://www.postgresql.org/support/security
that's probably the best one you can find. Or that in combination
with the news archive (http://www.postgresql.org/about/newsarchive)
Really... without making it too
On Feb 11, 2008, at 5:50 PM, Greg Smith wrote:
On Tue, 5 Feb 2008, Joshua D. Drake wrote:
On Tue, 5 Feb 2008 23:07:37 -0500 (EST)
Greg Smith [EMAIL PROTECTED] wrote:
Can anyone think of another place a community docs wiki could go at?
CMD will host anything you need.
Basically all it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 11 Feb 2008 18:50:41 -0500 (EST)
Greg Smith [EMAIL PROTECTED] wrote:
I could help out with the initial setup, you could just have somebody
internally do the install and let me have an account when it's ready,
whatever makes sense for
On Tue, 5 Feb 2008, Joshua D. Drake wrote:
On Tue, 5 Feb 2008 23:07:37 -0500 (EST)
Greg Smith [EMAIL PROTECTED] wrote:
Can anyone think of another place a community docs wiki could go at?
CMD will host anything you need.
Basically all it would take to get this off the ground is a host
On Feb 11, 2008 2:27 PM, Alvaro Herrera [EMAIL PROTECTED] wrote:
Dawid Kuroczko escribió:
I'm using 8.3.0 and I see that autovacuum processes in
pg_stat_activity have xact_start.
As far as I know, since at least 8.2.x the VACUUM does not start a new
transaction.
If that statement is
On Feb 11, 2008 8:04 AM, Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote:
I did manage to find an announcement about the support of pg for
windows... but I wasn't able to see anything you'd have a summary of
scheduled and planned EOL for various pg versions (on different
platform).
There have
Dawid Kuroczko escribió:
I'm using 8.3.0 and I see that autovacuum processes in
pg_stat_activity have xact_start.
As far as I know, since at least 8.2.x the VACUUM does not start a new
transaction.
If that statement is correct, the xact_start column in
pg_stat_activity should be NULL...
In response to Alban Hertroys [EMAIL PROTECTED]:
On Feb 11, 2008, at 12:43 AM, brian wrote:
Try:
CREATE OR REPLACE FUNCTION first_day_next_month(inputdate date)
RETURNS date AS
$BODY$
DECLARE
resultdate date;
BEGIN
SELECT INTO resultdate to_date(to_char((inputdate +
On Feb 10, 2008 10:51 PM, Tom Lane [EMAIL PROTECTED] wrote:
If these are universal (Intel+PPC) binaries, that could be an issue
too. There's been some discussion recently about how to build universal
binaries for PG, but I don't think anyone's figured out a really nice
way to do it.
If the
On febr. 2, 15:15, [EMAIL PROTECTED] (Lewis Cunningham) wrote:
--- vladimir konrad [EMAIL PROTECTED] wrote:
I think that I understand basic relational theory but
then I had an
idea.
Basically, instead of adding field to a table every time
there is a
need for it, have a
Ken Johanson [EMAIL PROTECTED] writes:
For sake of interoperability (and using an API that requires String-type
hashtable keys), I'm trying to find a single CAST (int - var/char)
syntax that works between the most databases. Only char seems to be a
candidate, but in 8.3 casting from an
Could you please tell me how to do so? Thanks.
Ben [EMAIL PROTECTED] wrote: Including the header is not enough you must
also link your binary against the library.
On Feb 11, 2008, at 9:52 PM, Shwe Yee Than wrote:
Hello,
I´ve got a problem when trying to access Postgresql through C
For sake of interoperability (and using an API that requires String-type
hashtable keys), I'm trying to find a single CAST (int - var/char)
syntax that works between the most databases. Only char seems to be a
candidate, but in 8.3 casting from an integer outputs only the first char...
Is
Dave Page [EMAIL PROTECTED] writes:
On Feb 11, 2008 4:28 PM, Tom Lane [EMAIL PROTECTED] wrote:
Dave Page [EMAIL PROTECTED] writes:
If the endianess isn't corrected for the non-native platform at build
time, I've seen initdb leave a cluster with a completely broken
pg_rewrite (iirc).
Hmm,
On Sat, 2008-02-09 at 19:27 -0500, Tom Lane wrote:
Benjamin Arai [EMAIL PROTECTED] writes:
We are thinking of modifying our system to use COPY to replace these
large INSERT transactions but we are concerned that it will greatly
impact the user experience (i.e., exclusively lock the table
Tom Lane wrote:
SQL92 section 6.1 data type quoth
character string type ::=
CHARACTER [ left paren length right paren ]
| CHAR [ left paren length right paren ]
...
4) If length is omitted, then a length of 1 is implicit.
Therefore,
Thanks Tom,
I sent you a test case. The problem has since been resolved by changing
one of my functions to VOLATILE instead of IMMUTABLE. This has caught
me twice now in the last few days. I hope my learning of this will be a
little more IMMUTABLE :)
cheers,
willem
PG 8.3
Tom Lane
Willem Buitendyk [EMAIL PROTECTED] writes:
The problem was with the following:
FOR current_row IN SELECT * from temp_tags_18_counted
The select from the [temp_tags_18_counted] view is made up of 3 cross
joins. When I simplify and remove the joins everything works. I tried
Hi guys :-), I am working on a personal project in which I am trying to
make sense on a huge (at least for me) amount of data. I have
approximately 150 million rows of unique words (they are not exactly
words it is just for explaining the situation).
The table I am inserting this is a quite
Can someone please tell me how to extract the mix, max, increment by,
etc, values for a sequence from the system catalogs. Is this in the
manual somewhere (I couldn't find it)?
Thanks
__
Marc
---(end of broadcast)---
TIP 1: if posting/reading
I did manage to find an announcement about the support of pg for
windows... but I wasn't able to see anything you'd have a summary of
scheduled and planned EOL for various pg versions (on different
platform).
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end
Hello.
I'm using 8.3.0 and I see that autovacuum processes in
pg_stat_activity have xact_start.
As far as I know, since at least 8.2.x the VACUUM does not start a new
transaction.
If that statement is correct, the xact_start column in
pg_stat_activity should be NULL...
Why does it matter?
Willy-Bas Loos wrote:
Hi,
How, using psql, can i connect to a PostgreSQL server that has
sslhost in the pg_hba.conf file?
I can't find the SSL option in the manpage.
thx,
WBL
Make sure both your server and client have ssl support compiled in. I'm
not sure if that's there by default with
Le lundi 11 février 2008, Klint Gore a écrit :
Is there any way to make copy work with fixed width files?
I'll try to see about implementing this in pgloader, shouldn't be complex. But
we have some other things on the TODO (which could get formalized by now...).
So at the moment the
Ken Johanson wrote:
Is there anything now, or in the works, for compatibility emulation? For
example to setup my session to act like 8.2 and allow less-strict
typing.
The best way to ensure 8.2 compatibility is to use 8.2. But as casts are user
definable, you can add back any casts you want.
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Version 2.0.0 of DBD::Pg, the Perl DBI interface to Postgres, has
been released. Find it at your favorite CPAN mirror.
This is a major release, so agrressive testing and feedback is
much appreciated.
Please report any bugs here:
Hi,
How, using psql, can i connect to a PostgreSQL server that has sslhost in
the pg_hba.conf file?
I can't find the SSL option in the manpage.
thx,
WBL
On Feb 11, 2008, at 2:23 AM, Willem Buitendyk wrote:
As others have suggested my big problem with the function I wrote
was that I had made it Volatile instead of Immutable (it is no
doubt suffering from code bloat as well). That made all the
difference. Curiously though - I tried it just
Dave Page [EMAIL PROTECTED] writes:
If the endianess isn't corrected for the non-native platform at build
time, I've seen initdb leave a cluster with a completely broken
pg_rewrite (iirc).
Hmm, but is pg_rewrite really the most obvious symptom? In 8.3 I would
expect massive breakage all over,
On Monday 11 February 2008 14:49, Jeff Davis wrote:
On Mon, 2008-02-11 at 09:09 +0100, Peter Eisentraut wrote:
Ken Johanson wrote:
Is there anything now, or in the works, for compatibility emulation?
For example to setup my session to act like 8.2 and allow less-strict
typing.
The
Willem Buitendyk [EMAIL PROTECTED] writes:
I sent you a test case.
Thanks for the test case --- I've committed a patch:
http://archives.postgresql.org/pgsql-committers/2008-02/msg00108.php
The problem has since been resolved by changing
one of my functions to VOLATILE instead of IMMUTABLE.
On Mon, Feb 11, 2008 at 10:15:40AM -0800, Bob Pawley wrote:
I'm running Postgresql 8.2 on Windows.
If I create a table 'without oids' are oids still in use behind the scenes??
Nope.
Have a nice day,
--
Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/
Those who make
74 matches
Mail list logo
