Tom Lane wrote:
SQL92 section 6.1 quoth
::=
CHARACTER []
| CHAR []
...
4) If is omitted, then a of 1 is implicit.
Therefore, writing just "char" is defined as equivalent to "char(1)".
However when length is not defined I
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-th
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 IMMUTABL
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 o
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 a
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 h
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 langu
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
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: undef
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
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 thi
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 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 (http://www.postgresql.org/a
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 w
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 thi
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
> > > typin
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 t
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 wrote:
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 tr
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 a
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 ru
-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:
http://rt.cpan
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
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
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: SPI_c
"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 th
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
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
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 seque
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
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 t
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
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 co
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 postgre
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
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
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 Jo
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 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 ma
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 a
"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_rewr
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 -
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 listed
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 real
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 insertin
"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
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 a
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 sit
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:
http://www
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:
http://www.depesz.com/index.php/2007
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 lette
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
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 si
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 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 sup
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
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 summar
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
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
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 h
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 NUL
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 of
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_
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? Monit
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
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.
I
> 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
> > > nee
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 w
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 preprocess
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
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 wan
74 matches
Mail list logo
