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
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
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
> 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
# 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
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
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
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
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
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
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')
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
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
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
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
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
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.
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
The column is decimal(16,2). Thanks.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
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
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
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
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
> 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)
> 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.
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
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
> 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
No.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
# [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
# 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 "
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
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,
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
---+---+
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
-
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.
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
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 "
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
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 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
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
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
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
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
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'
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
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
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
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
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
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
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
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
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
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 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
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:
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
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
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
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)-
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
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
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
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
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
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
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
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
73 matches
Mail list logo
