2009/1/6 Gurjeet Singh :
> As I mentioned, we cannot change the query, so adding casts to the query is
> not an option. I was looking for something external to the query, like a
> CREATE CAST command that'd resolve the issue.
I am sorry, I blind - I tested casting on 8.3.0 and it doesn't work
(but
As I mentioned, we cannot change the query, so adding casts to the query is
not an option. I was looking for something external to the query, like a
CREATE CAST command that'd resolve the issue.
Best regards,
On Tue, Jan 6, 2009 at 12:00 PM, Pavel Stehule wrote:
> Hello
>
> 2009/1/6 Gurjeet Sing
Hello
2009/1/6 Gurjeet Singh :
> Q1: select '' union all select ''
> Q2: select '' union all select * from (select '' ) as s
>
> version: PostgreSQL 8.3.1, compiled by Visual C++ build 1400
>
> Hi All,
>
> Q1 works just fine, but Q2 fails with:
>
> ERROR: failed to find conversion function fr
Q1: select '' union all select ''
Q2: select '' union all select * from (select '' ) as s
version: PostgreSQL 8.3.1, compiled by Visual C++ build 1400
Hi All,
Q1 works just fine, but Q2 fails with:
ERROR: failed to find conversion function from "unknown" to text
Q2 is a generalization
Octavio Alvarez wrote:
> CHECK constraints or FOREIGN keys to secured tables are present so the
> users don't fill up the tables with dummy rows to perform a DoS. This
> can or can not be ultimately desired, though.
Beware here. IIRC PostgreSQL's inheritance support has some major
limitations whe
Is there any postgres replication support windows (not slony because i
want merge replication) ?
Please help me because I must work with postgreSQL on Windows OS :-(
Thanks in advance.
Sorry for my English.
Tuan Hoang Anh
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Sorry, to have very long to handle your problem.
I tried to compress and decompress your WAL segments and found that your
WAL segments are created in 32bit environment, which must be
compressed/decompressed using 32bit binary.
PostgreSQL's WAL segment in 32bit environment is binary incompatib
On Jan 4, 2009, at 3:09 AM, Gerhard Wiesinger wrote:
Hello!
The transaction model is discussed in several areas:
http://www.packtpub.com/article/transaction-model-of-postgresql
The POSTGRES Data Model (1987)
http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.48.8578
The Design of POSTGRES
On Mon, 2009-01-05 at 13:05 +0900, Craig Ringer wrote:
> alvar...@alvarezp.ods.org wrote:
>
> > On user account creation, the schema gets created and the interface
> > tries to do a "CREATE TABLE my_relation () INHERITS
> > (_skel.my_relation);" as the new role, but PostgreSQL returns the error
> >
In the general case, is a subselect that uses union less performant
than a union?
I have a query that looks something like this:
select
from table1,
table2,
table3
where
union
select
fromtable1,
table2,
table3 ref1,
table3 ref2
wher
There has been an error made and messages I have written didn't not end up
here so I will do a repost on couple ... :)
---
Thank you Oleg. I am reading that g
On Mon, Jan 5, 2009 at 12:05 PM, Chris Browne wrote:
> tekion writes:
> > I know that MySQL can only use one index at at time for query. Does
> > Postgres has this same limitation? For example, the following query:
This is false for many cases since MySQL 5.0.
http://dev.mysql.com/doc/refman/
Another strategy to look at is to make autovacuum more aggresive by
putting entries for that one table into the pg_autovacuum table. I
know that table exists in 8.3 but I don't remember if it exists in
older versions or how it works there. But if you have that available
you can make that one rela
On Mon, Jan 5, 2009 at 10:15 AM, Scot Kreienkamp wrote:
> Scott,
>
> Would the "alter user postgres set statement_timeout=0;" be a permanent
> change? I ask because our application is using that for its login to
> the database. (No lectures please, I inherited the system that way. I
> already r
Nothing. I ran a query to see what other queries were running and what
other locks existed at the time. No queries running, no locks. Nothing
running at that time of night except dump, which is finished before the
vacuum job starts.
Thanks,
Scot Kreienkamp
La-Z-Boy Inc.
skre...@la-z-boy.com
"Scot Kreienkamp" writes:
> The nightly vacuums have been working flawlessly, but about three weeks
> ago the vacuum full started failing. It was taking about 5-10 minutes
> normally, but all of a sudden it started hitting the command timeout
> that I have set, which is at 60 minutes. I thought
tekion writes:
> I know that MySQL can only use one index at at time for query. Does
> Postgres has this same limitation? For example, the following query:
>
> select uid,count(uid) from A, B where A.uid = B.uid and date between
> and
>
> MySQL will either use index on uid or the date (Both uid
On Mon, 5 Jan 2009, Mohamed wrote:
Hi!
I have just made the switch from MySql to PostgreSql to be able to take
advantage of TSearch2 and I just arrived to the mailing list :) I am
creating a website in two languages (english, arabic) and would like to have
dictionaries for both for my search. I
I have a table that has multiple partitions (1000+) and I want a trigger
or rule to be able to write data automatically to each partition. One of
the values I am inserting is the table partition name, but I'm not sure
how to use it as a variable in a trigger. All trigger examples have a
series of I
On Mon, Jan 05, 2009 at 02:49:51PM +0100, Mohamed wrote:
> I have just made the switch from MySql to PostgreSql to be able to take
> advantage of TSearch2 and I just arrived to the mailing list :) I am
> creating a website in two languages (english, arabic) and would like to have
> dictionaries for
Scott,
Would the "alter user postgres set statement_timeout=0;" be a permanent
change? I ask because our application is using that for its login to
the database. (No lectures please, I inherited the system that way. I
already read the riot act to our developers about that.) If so I'll
have to
Yes. Yes it is.
On Mon, Jan 5, 2009 at 6:43 AM, Mohamed wrote:
> Mailing list ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jan 5, 2009 at 7:46 AM, Scot Kreienkamp wrote:
> Hi everyone…
>
>
>
> I have a database that is currently about 25 gigs on my primary DB server
> running Postgres 8.2.9, and two others that are less than 1 gig apiece. The
> DB server is a quad proc, quad core, 64 gigs of memory, 5 drive R
Nope, on RHEL5. This is the backend of an application that's not available or
visible to the public.
Thanks,
Scot Kreienkamp
La-Z-Boy Inc.
skre...@la-z-boy.com
734-242-1444 ext 6379
-Original Message-
From: Grzegorz Jaśkiewicz [mailto:gryz...@gmail.com]
Sent: Monday, January 05, 200
btw, is that on windows ? (looking at la-z-boy.com, it uses .net).
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Mailing list ?
well, upgrade to 8.2.11 - even tho, change log doesn't say anything
about vacuum there.
Secondly, I think turn up logging verbosity - and see if postgresql
actually complains about anything there, otherwise it is pretty much
blind guess.
--
Sent via pgsql-general mailing list (pgsql-general@postg
Hi!
I have just made the switch from MySql to PostgreSql to be able to take
advantage of TSearch2 and I just arrived to the mailing list :) I am
creating a website in two languages (english, arabic) and would like to have
dictionaries for both for my search. I noticed that arabic wasn't in as
defau
Hi everyone...
I have a database that is currently about 25 gigs on my primary DB
server running Postgres 8.2.9, and two others that are less than 1 gig
apiece. The DB server is a quad proc, quad core, 64 gigs of memory, 5
drive RAID5 array, so it has plenty of horsepower. Until about three
w
On Monday 05 January 2009 5:29:19 am Jolles, Peter M (GE Infra, Energy) wrote:
> On Saturday, January 03, 2009 6:27 PM, David T Wilson wrote:
> > Those are the dates of daylight savings time kicking in-
> > which happens, not coincidentally, at 2am.
> >
> > What's the type of the field you're tryin
On Saturday, January 03, 2009 6:27 PM, David T Wilson wrote:
> Those are the dates of daylight savings time kicking in-
> which happens, not coincidentally, at 2am.
>
> What's the type of the field you're trying to import into,
> and how are you doing the import?
That makes a lot more sense n
31 matches
Mail list logo
