Félix Beltrán wrote:
> 1) Free distribution even for non free applications (including .Net
> driver).
Totally free license.
> 2) Is there a good graphical database designer for PostgreSQL wich also
> suppors online database synchronization?
PgadminIII is supposed to be good. I haven't used it
Tom Lane wrote:
> Having said that, though, I'm agin back-porting this. We don't
> back-patch feature additions, and this can hardly be described as
> a bug fix.
>
I'm not for or against back porting this feature. I basically want to
know if my plan (appended to this email) was a sane way to wri
Klint Gore wrote:
On Wed, 10 Aug 2005 21:54:45 -0500, Tony Caduto
<[EMAIL PROTECTED]> wrote:
I agree, SCO is vile, but Borland what the heck are they thinking.
It's borland. Every few years they fly off in a bizarre direction. If
kylix is anything to go by, they won't be doing mu
On Wed, 10 Aug 2005 21:54:45 -0500, Tony Caduto
<[EMAIL PROTECTED]> wrote:
> I agree, SCO is vile, but Borland what the heck are they thinking.
It's borland. Every few years they fly off in a bizarre direction. If
kylix is anything to go by, they won't be doing much anyway.
Perhaps someone f
Greg Stark <[EMAIL PROTECTED]> writes:
> What I'm asking about is, are there going to be user applications that were
> working fine in previous versions but suddenly start breaking when this change
> is made? Does that affect your decision in whether to backport this to 8.0.x?
It's worth noting th
Shane <[EMAIL PROTECTED]> writes:
> I am working with a simple table and query abut cannot seem
> to get it to use the index I have created.
> ...
> explain analyze select msgid from seen where msgtime < cast(now() - interval
> '6 months' as timestamp(0) without time zone);
As some other people a
Once again, many many thanks Jeff for taking the time to think
through these issues and provide your well-informed comments & opinions!
On Aug 10, 2005, at 4:09 PM, Jeff Davis wrote:
William Bug wrote:
As you say, both LIKE & INHERIT are a bit anemic and unnecessary,
since
what they provi
Thomas Schoen <[EMAIL PROTECTED]> writes:
> Now, finally, my questions are:
> - Is there any guaranty, that two aggregates in a GROUP BY statement are
> aggregated in the same order?
> - If yes: is there any guaranty the behaviour won't change in future
> versions of PG. (I suppose SQL-standard d
Tony Caduto wrote:
according to the article they "make postgresql" :-)
http://www.eweek.com/article2/0,1895,1846635,00.asp
Worse, they are partnering with SCO. Sorry Denis/Andy I just can't agree
with that one.
Sincerely,
Joshua D. Drake
---(end of broadcast)-
I agree, SCO is vile, but Borland what the heck are they thinking.
Tony
Joshua D. Drake wrote:
Tony Caduto wrote:
according to the article they "make postgresql" :-)
http://www.eweek.com/article2/0,1895,1846635,00.asp
Worse, they are partnering with SCO. Sorry Denis/Andy I just can't
according to the article they "make postgresql" :-)
http://www.eweek.com/article2/0,1895,1846635,00.asp
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Wed, Aug 10, 2005 at 03:42:59PM -0700, Joshua D. Drake wrote:
> Tony Caduto wrote:
> >I saw their announment today and they said they have Oracle
> >compatiblility.
> >
> >What exactly does this mean? They don't go into any details. Did
> >they implement a Oracle compatible proc language or so
On Wed, Aug 10, 2005 at 05:02:46PM -0600, Ed L. wrote:
> I have two identical servers giving abysmal INSERT performance in
> pgsql 7.3.4, 7.4.8, and 8.1devel under no load or I/O contention
> at all (no dumps, no vacuums, no apps, etc). Any suggested
> investigations appreciated...
>
> Metric:
I have two identical servers giving abysmal INSERT performance in
pgsql 7.3.4, 7.4.8, and 8.1devel under no load or I/O contention
at all (no dumps, no vacuums, no apps, etc). Any suggested
investigations appreciated...
Metric: I'm measuring average insert speed on the following
table with
Tony Caduto wrote:
I saw their announment today and they said they have Oracle compatiblility.
What exactly does this mean? They don't go into any details. Did they
implement a Oracle compatible proc language or something?
I don't know the full details but my understanding is they implement
I saw their announment today and they said they have Oracle compatiblility.
What exactly does this mean? They don't go into any details. Did they
implement a Oracle compatible proc language or something?
Tony
---(end of broadcast)---
TIP
On Wed, Aug 10, 2005 at 04:43:50PM +0100, Nigel Horne wrote:
> Has anyone got any pointers to how to define an null indicator
> variable to get over the above cryptic message?
Without more information we can only guess. The only place in the
PostgreSQL source code that contains the string "NULL v
pgman wrote:
> Dan Armbrust wrote:
> > I liked the FAQ entry written up by the original submitter much better,
> > WRT to the long index issue. This write up does not contain the actual
> > error message encountered, so its not going to be found by someone
> > looking for a solution to the problem
Hi,
I would sometimes need a lot of parameters, even 100 or so. These would be
the data access functions for tables. I know the default count limit is 32,
and FUNC_MAX_ARGS compile option should be set to, say, 256.
But I have another option, a bit harder, I could pass the parameters in a
reco
On Wed, Aug 10, 2005 at 03:33:16PM -0400, Bruce Momjian wrote:
> For the batch job and single-CPU issues, they did not fit into existing
> FAQ entries, and I am not sure they are asked enough to be added as
> FAQs. I am interested to hear other's opinions on this.
Maybe, just looking through my e
Greg Stark wrote:
> Bruce Momjian writes:
>
> > > What happens if someone already has a type called "e" ?
> >
> > That would be the same problem as someone having a type 'b' or 'x'. It
> > would still work, but not for casts like text'str'. Those letters are
> > caught in the lexer before gett
Dan Armbrust wrote:
> I liked the FAQ entry written up by the original submitter much better,
> WRT to the long index issue. This write up does not contain the actual
> error message encountered, so its not going to be found by someone
> looking for a solution to the problem. It doesn't contain t
On Wed, 2005-08-10 at 13:31 -0700, Shane wrote:
> On Wed, Aug 10, 2005 at 04:24:51PM -0400, Sven Willenberger wrote:
> > On Wed, 2005-08-10 at 12:58 -0700, Shane wrote:
> > > On Wed, Aug 10, 2005 at 03:31:27PM -0400, Sven Willenberger wrote:
> > > > Right off the bat (if I am interpreting the resul
On Wed, Aug 10, 2005 at 08:01:13PM +0200, Tomek Grzejszczyk wrote:
> I'am trying to create a function in plpgsql that will accept a parameter
> of type rowtype. Here is a little test script I wrote:
> http://62.121.81.182/pub/test_func.sql
>
> It works on Postgres 8.03, but fails on 7.4, where I
Bruce Momjian writes:
> > What happens if someone already has a type called "e" ?
>
> That would be the same problem as someone having a type 'b' or 'x'. It
> would still work, but not for casts like text'str'. Those letters are
> caught in the lexer before getting into to the parser.
What I'
Bruce Momjian wrote:
I have updated the FAQ to handle three of the items you mentioned. In
one case, I added a new FAQ entry (double-quoting identifiers with a
link to our docs), and in two other cases (indexing long columns,
case-insensitive columns) I added to existing FAQ items where
ap
On Wed, 2005-08-10 at 12:58 -0700, Shane wrote:
> On Wed, Aug 10, 2005 at 03:31:27PM -0400, Sven Willenberger wrote:
> > Right off the bat (if I am interpreting the results of your explain
> > analyze correctly) it looks like the planner is basing its decision to
> > seqscan as it thinks that it ne
Hi,
I just did this myself (I'm a Unix/Linux person).
Three steps:
1. Install the PostgreSQL ODBC driver on the Windows box. (download from
http://www.postgresql.org/ftp/odbc/versions/msi/).
2. Configure the DSN on the Windows box: Go to Control Panel / Admin
Tools / Data Sources (ODBC), Und
William Bug wrote:
> As you say, both LIKE & INHERIT are a bit anemic and unnecessary, since
> what they provide can be implemented via VIEWs and RULEs/ TRIGGERs. I'd
I'd like to point out that INHERITS is unique, although I'm not sure all
of the exact differences. The main difference that I see
On Fri, 2005-08-05 at 07:42 -0700, Basith Salman wrote:
>
> Hi All,
>
> I was wondering if there is way to suppress the error messages on the stdout
> from a perl dbi execute command, basically if I do a
> sth->execute() on a command and say the row cannot be updated then
> I get a err msg to
Martijn van Oosterhout wrote:
-- Start of PGP signed section.
> Hi,
>
> After going through pgsql-general a bit I figured there were a few
> important questions missing from the FAQ, so I wrote some.
>
> Comments welcome. I can write more, if people can suggest things to
> write about. I was thin
On Wed, 2005-08-10 at 12:01 -0700, Shane wrote:
> Hello all,
>
> I am working with a simple table and query abut cannot seem
> to get it to use the index I have created. However, if I
> set enable_seqscan=false, the index is used and the query
> is much faster. I have tried a vacuum analyze but
On Wed, 2005-08-10 at 12:01 -0700, Shane wrote:
> Hello all,
>
> I am working with a simple table and query abut cannot seem
> to get it to use the index I have created. However, if I
> set enable_seqscan=false, the index is used and the query
> is much faster. I have tried a vacuum analyze but
Greg Stark wrote:
>
> Bruce Momjian writes:
>
> > E'' is more a marker than a type. I realize making E a type might work,
> > but it seems unusual.
> >
> > What we could do is backpatch E'' to 8.0.X as a no-op like it will be in
> > 8.1.
>
> What happens if someone already has a type called "
So, I've got pg running on a linux box, and I'm informed that a
windows box should be able to access this through ODBC, about
which I am woefully uninformed.
Can somebody loan me a clue as to what I should do to make
this happen?
Many TIA!
Mark
--
Mark Harrison
Pixar Animation Studios
On Wed, Aug 10, 2005 at 07:40:23PM +0200, Roman Neuhauser wrote:
> # kleptog@svana.org / 2005-08-10 11:22:16 +0200:
> > Well, it's not a feature, so I'm not sure why it would be mentioned
> > there. It's PostgreSQL's implementation of the standard.
>
> That page has this heading: "Appendix D.
Bruce Momjian writes:
> E'' is more a marker than a type. I realize making E a type might work,
> but it seems unusual.
>
> What we could do is backpatch E'' to 8.0.X as a no-op like it will be in
> 8.1.
What happens if someone already has a type called "e" ?
--
greg
-
Hi,
my problem is best descibed giving an example:
Assume you wrote a simple aggregate function called "agg_array_append"
wich appends integer values to an array.
Further assume you have a table "foo" with three integer fields "a", "b"
and "c".
test=# select * from foo;
a | b | c
---+---+
Hi,
I'am trying to create a function in plpgsql that will accept a parameter
of type rowtype. Here is a little test script I wrote:
http://62.121.81.182/pub/test_func.sql
It works on Postgres 8.03, but fails on 7.4, where I actually want it to
work. What am I doing wrong? Error message says th
Hi All,
Has anybody used postgresql 7.4.7 on Suse 9.3? If yes how easy or
difficult was it to install?
Any pointers/suggestions are welcome.
Thankyou
Hrishi
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
# kleptog@svana.org / 2005-08-10 11:22:16 +0200:
> On Wed, Aug 10, 2005 at 10:44:14AM +0200, Roman Neuhauser wrote:
> > > +4.22) Why are PostgreSQL table names
> > > case-sensitive?
> >
> > http://www.postgresql.org/docs/current/static/features.html doesn't
> > contain "fold" (as in "
# [EMAIL PROTECTED] / 2005-08-10 13:18:32 +0200:
> 1. Will SELECT WHERE LOWER(colname) = 'a001' use the index, or must I create
> a separate index on LOWER(colname)?
the latter
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you we
No.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
> Hmm, since you are using the Windows version, I'm not really
> sure. If you have the right compiler and environment, it'd
> be just a matter of getting the source for the same version
> you have installed, and then "configure --with-openssl".
>
> It'd surprise me however to learn that the Wi
World-wide Stop Order on PERL,Python,Java::->> Use Ruby instead
Language is the most critical interface to SQL server like MySQL and
Postgresql.
Carefully select the language for interfacing to PostgreSQL!! It is
immensely
importan
On Wed, Aug 10, 2005 at 04:03:02PM +0100, babu wrote:
> Thanks for the reply.
>
> > I am trying to use ssl mode when connecting to pgsql via php.
> > i have used the method pg_conncet with sslmode and require option.
> > But it gets an error "Unable to connect to PostgreSQL server: sslmode
> > va
> Building without ENABLE_THREAD_SAFETY=1 works fine, but when
> i add this option to the win32.mak some compiler error occur.
>
> d:\postgresql-8.0.3\src\interfaces\libpq\libpq-int.h(481) : error
> C2143: syntax error : missing ')' before '*'
> d:\postgresql-8.0.3\src\interfaces\libpq\libpq-int.
> Is the standard libpq.dll distributed by PostgreSQL8.0 for
> windows thread safe by default ?
No.
It is safe as long as you use each PGconn on a separate thread but you
cannot share the same PGconn between threads.
//Magnus
---(end of broadcast)
On Wed, 2005-08-10 at 11:36 -0400, Hugo wrote:
> anybody developing apps with powerbuilder and postgres
Take a look at http://pbpgsql.spiderbark.com/index.php
---(end of broadcast)---
TIP 6: explain analyze is your friend
sorry, forgot to mention that the server is 8.0.3 and is running on a fedora core 3 serverOn 10/08/05, Hugo <[EMAIL PROTECTED]
> wrote:Hi everybody, is there anybody developing apps with powerbuilder and
postgres as the db server ? my problem is that I have a function in
postgres to import data fro
Has anyone got any pointers to how to define an null indicator
variable to get over the above cryptic message?
-Nigel
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi everybody, is there anybody developing apps with powerbuilder and
postgres as the db server ? my problem is that I have a function in
postgres to import data from a csv file that resides in the server, in
pb a declare that function as a store procedure and then I call it with
the PowerBuilder ex
The column is decimal(16,2). Thanks.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Thanks for the reply.
> I am trying to use ssl mode when connecting to pgsql via php.> i have used the method pg_conncet with sslmode and require option.> But it gets an error "Unable to connect to PostgreSQL server: sslmode> value "require" invalid when SSL support is not compiled in ".>You have
Alvaro Herrera <[EMAIL PROTECTED]> writes:
On Tue, Aug 09, 2005 at 04:01:33PM -0400, Tom Lane wrote:
Yeah, you can store the pg_class OID of the table,
Maybe it is possible to use a column of type regclass to store it. Not
sure exactly what advantage that would give, but it's an idea.
Ave!
Tom Lane wrote:
>>trax=# explain select * from pakiety where stid = 234::smallint order by
>>received desc limit 1;
>
> The reason this won't use the (stid, received) index is that the
> requested sort order doesn't match that index. Try
>
> select * from pakiety where stid = 234::smallint
Building without ENABLE_THREAD_SAFETY=1 works fine, but when i add this
option to the win32.mak some compiler error occur.
d:\postgresql-8.0.3\src\interfaces\libpq\libpq-int.h(481) : error
C2143: syntax error : missing ')' before '*'
d:\postgresql-8.0.3\src\interfaces\libpq\libpq-int.h(481) : erro
Is the standard libpq.dll distributed by PostgreSQL8.0 for windows
thread safe by default ?
Pit
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Wed, Aug 10, 2005 at 10:08:20AM -0400, Tim Nelson wrote:
> So the size of SUM("str_sls_totals"."strsl_net_dly") is 20. When we
> change the year to 2004 the size is returned as 30 ! ! ! Is this by
> design or a bug.
What is the type of that column? I'm thinking, if it's numeric, then
it's
We do the following test on the
client site :
A)Using SQLExecDirect with this query
SELECT SUM("str_sls_totals"."strsl_net_dly"),
"dw_trans_type"."trans_type", "flash_dates"."year_number",
"flash_dates"."month_number", "flash_dates"."day"
FROM "dw_trans_type", "str_sls_tot
To handle searching for a row based on a string, I will use
"LOWER(colname)
= 'x'" and "LOWER(colname) LIKE 'x%'". AFAICT, the second one is
equivalent
to "colname ILIKE 'x%'", provided I force 'x' to lowercase first.
I would strongly suggest you do this instead:
LOWER(colname) = LOWER('x')
On Wed, Aug 10, 2005 at 02:09:55PM +0100, babu wrote:
> I am trying to use ssl mode when connecting to pgsql via php.
> i have used the method pg_conncet with sslmode and require option.
> But it gets an error "Unable to connect to PostgreSQL server: sslmode
> value "require" invalid when SSL supp
On Wed, Aug 10, 2005 at 02:09:55PM +0100, babu wrote:
> I am trying to use ssl mode when connecting to pgsql via php.
> i have used the method pg_conncet with sslmode and require option.
> But it gets an error "Unable to connect to PostgreSQL server: sslmode value
> "require" invalid when SSL supp
HI all,
I am trying to use ssl mode when connecting to pgsql via php.
i have used the method pg_conncet with sslmode and require option.
But it gets an error "Unable to connect to PostgreSQL server: sslmode value "require" invalid when SSL support is not compiled in ".
thanks
babu
To help you
Frank Millman wrote:
> 1. Will SELECT WHERE LOWER(colname) = 'a001' use the index, or must I
create a separate index on LOWER(colname)?
Sorry. RTFM. The docs clearly state that this is necessary.
Frank
---(end of broadcast)---
TIP 6: explain ana
Frank Millman wrote:
> Hi all
>
> Is there an LC_COLLATE setting, or any other method, which
allows all
> data in a database to be treated in a case-insensitive manner?
>
Thanks for all the replies, guys, I really appreciate it.
Here is what I have decided to do. If anyone sees any problems w
On Wed, Aug 10, 2005 at 10:44:14AM +0200, Roman Neuhauser wrote:
> > +4.22) Why are PostgreSQL table names
> > case-sensitive?
>
> http://www.postgresql.org/docs/current/static/features.html doesn't
> contain "fold" (as in "case folding") at all, doesn't this topic
> belong rather
# kleptog@svana.org / 2005-08-10 10:02:20 +0200:
> After going through pgsql-general a bit I figured there were a few
> important questions missing from the FAQ, so I wrote some.
>
> Comments welcome. I can write more, if people can suggest things to
> write about. I was thinking something about c
> Comments welcome. I can write more, if people can suggest things to
> write about. I was thinking something about collation and locales but
> I'm sure sure I understand them myself.
>
The following should read "... has no facility to fire jobs ..."
+PostgreSQL itself has no facility fire j
> Comments welcome. I can write more, if people can suggest things to
> write about. I was thinking something about collation and locales but
> I'm sure sure I understand them myself.
>
Missed this on the first pass, but you need to s/seperate/separate here:
+A seperate project has started w
Félix Beltrán wrote:
Hi all,
I'm new to PostgreSQL. I've been working for about two years with mySQL
but i'm evaluating other options (like PostgreSQL) because of lack of
features and a more restrictive licensing model. Right now what i am
looking in PostgreSQL is:
1) Free distribution even
Hi,
After going through pgsql-general a bit I figured there were a few
important questions missing from the FAQ, so I wrote some.
Comments welcome. I can write more, if people can suggest things to
write about. I was thinking something about collation and locales but
I'm sure sure I understand th
Hi all,
I'm new to PostgreSQL. I've been working for about two years with mySQL
but i'm evaluating other options (like PostgreSQL) because of lack of
features and a more restrictive licensing model. Right now what i am
looking in PostgreSQL is:
1) Free distribution even for non free applicatio
73 matches
Mail list logo
