On 22 Nov 2010, at 4:43, Kent Tong wrote:
> Hi Alban,
>
> Thanks a lot for your useful info!
>
>> I think most companies have ended up at that point just by the progress
>> of time. They have several different databases (often from different
>> vendors even) that they need to aggregate their inf
Dear all,
I am reading about Dialects of different databases. Yet I can't
understand what is the need of dialect in Postgres or any other like
Hibernate uses Dialect of all Databases for ORM.
What is it &
How can we create our own Dialect ?
Thanks in Advance
Adarsh Sharma
--
Sent via pgsql-g
I am dynamically generating a query like below that creates different
combinations of rules by left joining (any number of times) on itself and
avoiding rules with some of the same attributes as part of the joins
conditions e.g.
SELECT count(*)
FROM rules AS t1
LEFT JOIN rules AS t2
On 22/11/10 07:40, Elliot Chance wrote:
> It does surprise me a bit that when I (or someone else) signs up to a mailing
> list (not postgres specifically) that there is no fine print or agreement
> that says something along the lines of "Your email address will be plastered
> all over the inter
On Mon, Nov 22, 2010 at 10:40:34AM +1100, Elliot Chance wrote:
> It does surprise me a bit that when I (or someone else) signs up to
> a mailing list (not postgres specifically) that there is no fine
> print or agreement that says something along the lines of "Your
> email address will be plastered
Hi Alban,
Thanks a lot for your useful info!
> I think most companies have ended up at that point just by the progress
> of time. They have several different databases (often from different
> vendors even) that they need to aggregate their information from.
So, is this the result of lack of cent
On Mon, 2010-11-22 at 10:40 +1100, Elliot Chance wrote:
> > I would argue that if the person wants to use a forum, aren't they
> > saying they don't want to be contacted via email. I think we just throw
> > it only to the forum (that is the user) and leave it that. Forum users
> > don't get the
On 2010-11-21, Tom Lane wrote:
> SYSCONFDIR is only used for global configuration files, like the default
> psqlrc or pg_service.conf.
OK, so it doesn't regard postgresql.conf and friends as conf files in
that sense.
> It would be pretty inappropriate to put postgresql.conf there
> because postg
On Sat, Nov 20, 2010 at 16:54, Bruce Momjian wrote:
> Elliot Chance wrote:
>> > Also, if someone registers on the forum, do they get a major domo
>> > registration email? And if so, would this be set to receive no emails
>> > upon registration? I'm not clear as to how this step would work beca
On 21/11/2010, at 2:59 AM, Bruce Momjian wrote:
> Magnus Hagander wrote:
>> On Sat, Nov 20, 2010 at 14:46, Elliot Chance wrote:
> for...@postgresql.com.au is pointed to a black hole so that email
> disappears but the mailing list gets another copy. When the mailing list
> gets its c
On 21 Nov 2010, at 16:16, Trevor Talbot wrote:
>> I do see a difficulty here; if the forum software is only subscribed with
>> one e-mail address, how is it going to distinguish between a reply-all and a
>> private reply?
>> Maybe it would help to subscribe it using two or three addresses, so tha
Elliot Chance writes:
> On 21/11/2010, at 2:41 AM, Tom Lane wrote:
>> Elliot Chance writes:
>>> Then I can create a catch-all so that when an email is sent to
>>> forums-chan...@postgresql.com.au it finds the user "chancey" gets the real
>>> address and sends it on. If there were a way we could
Alban Hertroys writes:
> I'm not one of the people who've been communicating off-list about this with
> him, so I may be wrong, but to my understanding what Magnus wants (the
> requirement, not a solution to it) is this:
> - Person A is on the forums and sends a message that ends up on the ML (
On Sun, Nov 21, 2010 at 18:12, Tom Lane wrote:
> Alban Hertroys writes:
>> I'm not one of the people who've been communicating off-list about this with
>> him, so I may be wrong, but to my understanding what Magnus wants (the
>> requirement, not a solution to it) is this:
>
>> - Person A is on
On 11/21/2010 06:04 AM, Alban Hertroys wrote:
> On 21 Nov 2010, at 24:17, Trevor Talbot wrote:
>
>>> I can't explain it any clearer, your email response goes to the mailing
>>> list and that mailing list sends a copy to the original person thats how a
>>> mailing list works. It also sends a copy
KM writes:
> On an OpenBSD machine I just compiled and installed 9.0.1. The
> ./configure arguments included '--sysconfdir=/etc'. Running
> 'pg_config --sysconfdir' returns '/etc/postgresql'. The cluster is
> running and I can create a database and connect to it.
> However, initdb put the conf
Hey Sim,
Maybe this helps:
http://blog.tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_2.html
2010/11/21 Sim Zacks
> I am using PG 8.2.17 with UTF8 encoding.
> "PostgreSQL 8.2.17 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.1
> (Gentoo 4.1.1)"
>
> One of my tables somehow has i
On Sun, Nov 21, 2010 at 05:04, Alban Hertroys
wrote:
> On 21 Nov 2010, at 24:17, Trevor Talbot wrote:
>> Elliot, Magnus wants forum->list email to come from a per-user address
>> so that when he replies directly to that address (without sending it
>> to the list), the response is mapped to a PM.
On 21 Nov 2010, at 5:08, Kent Tong wrote:
> Hi,
>
> Let's say that there is some data that should be logically shared by
> many applications in the company, such as some core information about
> its customers (name, address, contact info). In principle, such data
> should be stored in a DB for sh
On 21 Nov 2010, at 24:17, Trevor Talbot wrote:
>> I can't explain it any clearer, your email response goes to the mailing list
>> and that mailing list sends a copy to the original person thats how a
>> mailing list works. It also sends a copy to the forum which is parses you
>> and that person
I am using PG 8.2.17 with UTF8 encoding.
"PostgreSQL 8.2.17 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.1
(Gentoo 4.1.1)"
One of my tables somehow has invalid characters in it:
ERROR: invalid byte sequence for encoding "UTF8": 0xa9
HINT: This error can also happen if the byte sequenc
2010/11/14 Devrim GÜNDÜZ :
>
> I just released PostgreSQL 9.0 RPM for Red Hat Enterprise Linux 6 and
> Fedora 14, on both x86 and x86_64.
>
> Please note that 9.0 packages have a different layout as compared to
> previous ones. You may want to read this blog post about this first:
>
> http://people
22 matches
Mail list logo
