On Fri, Dec 12, 2008 at 7:27 AM, Irwan Hadi wrote:
> We are planning to use Postgres for one of our production database
> system. I noticed when I go to http://www.postgresql.org/download/,
> the one click binary package for Linux is actually an enterpriseDB
> package (http://www.enterprisedb.com/
On Fri, Dec 12, 2008 at 7:12 AM, Albe Laurenz wrote:
> paulo matadr wrote:
>> you knowns a tool for automatic converter plsql in pgplsql?
>> this tool exist?
>
> EnterpriseDB claim that they can do something like this,
> but I don't believe that there is any tool which can do
> more than assist yo
Hi,
with Oracle I have the ability to tell the system to log errors during a long transaction into a separate table and proceed with the statement. This is quite handy when updating large tables and the update for one out of a million rows fails.
The syntax is something like this:
UPDATE
LOG
I just noticed something I found "unexpected".
CREATE TABLE LIKE let you specify DEFAULT and Co.
CREATE TABLE AS doesn't.
Is there a one step way to clone a table?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
Hi,
Our database (8.2.6) runs on a separate machine from the web
interface. Each user has their own username/password and row level
security is handled by a set of views on top of the base tables.
I'd like to provide programatic access to my database (I have been
looking at Perl's DBIx::
In response to Ivan Sergio Borgonovo :
> I just noticed something I found "unexpected".
>
> CREATE TABLE LIKE let you specify DEFAULT and Co.
> CREATE TABLE AS doesn't.
>
> Is there a one step way to clone a table?
with or without data?
create table new_table (like old_table)
create table new_t
Andreas K. wrote:
>
> In response to Ivan Sergio Borgonovo :
> > I just noticed something I found "unexpected".
> >
> > CREATE TABLE LIKE let you specify DEFAULT and Co.
> > CREATE TABLE AS doesn't.
> >
> > Is there a one step way to clone a table?
>
> with or without data?
>
> create table ne
On Fri, 12 Dec 2008 13:25:07 +0100
"A. Kretschmer" wrote:
> In response to Ivan Sergio Borgonovo :
> > I just noticed something I found "unexpected".
> >
> > CREATE TABLE LIKE let you specify DEFAULT and Co.
> > CREATE TABLE AS doesn't.
> >
> > Is there a one step way to clone a table?
>
> wit
Rusty Conover writes:
> I'd like to specify a pattern then apply that pattern to match each
> element of an array:
> rconover=# select 'foobar%' ~~ ANY (ARRAY['bar', 'cat', 'foobar:asdf']);
> ?column?
> --
> f
> (1 row)
> I'd like the the pattern would be evaluated against all of t
2008/12/11 TiTo(R)
> I installed the Postgres Database on my work planning replace Oracle on
> the new IT systems. I have noticed some differences (between Oracle and
> Posrgres) that I would like clarify.
>
> On postgres, I create 2 users and their schemas. Schema "User1" owned by
> "User1" and
Hi,
Joshua D. Drake wrote:
>> c) Postgres-R for multi-master data replication, appears to be a code
>> fork of PostgreSQL
>
> Not stable as far as I know.
Correct, it's not meant to be stable at this stage of development.
I'm a bit disturbed by the tag "code fork", which has a rather negative
Hi,
Joshua D. Drake wrote:
> On Wed, 2008-12-10 at 17:18 -0500, Rutherdale, Will wrote:
>> I attempted some searches in various areas and came up with a
>> bewildering array of results but no clear answer.
Let's extend the list even further:
h) If you are up for Java, you might like Sequoia.
Thanks for the additional details. Some people were very helpful, and I
found out all I need to know for now.
-Will
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Markus Wanner
Sent: 12 December 2008 10:44
To: j...@co
(reposted, in case people who could help me have missed my 2-weeks-ago post)
Hello.
I am looking for a Chinese dictionary for TSearch2 Postgresql feature,
with no success yet.
I found a reference on a chinese webpage:
http://code.google.com/p/nlpbamboo/wiki/TSearch2
With the help of transla
On Fri, 2008-12-12 at 16:31 +0100, Markus Wanner wrote:
> Hi,
>
> Let me simply point out and clarify, that I have absolutely no intent to
> fork from Postgres. Quite the opposite, I'm interested in working
> together with other Postgres hackers.
I think the point is that right now Postgres-R (j
Hello Joshua,
Joshua D. Drake wrote:
> I think the point is that right now Postgres-R (just like Replicator)
> keeps its own tree that incorporates the PostgreSQL code.
..as does every other patch for Postgres before possibly it lands on
mainline. But that's neither good nor bad per se, IMO.
> W
On Fri, 2008-12-12 at 18:45 +0100, Markus Wanner wrote:
> Hello Joshua,
> Well, yeah, maybe Postgres-R is going to loose that sale as well. But
> hey, it's not long ago since you've open sourced it. What makes you
> think that you've already "lost that sale"? I for example didn't find
> time to lo
On Dec 12, 2008, at 6:12 AM, Tom Lane wrote:
Rusty Conover writes:
I'd like to specify a pattern then apply that pattern to match each
element of an array:
rconover=# select 'foobar%' ~~ ANY (ARRAY['bar', 'cat',
'foobar:asdf']);
?column?
--
f
(1 row)
I'd like the the pattern
2008/12/12 Filip Rembiałkowski :
>
>
> 2008/12/11 TiTo(R)
>>
>> I installed the Postgres Database on my work planning replace Oracle on
>> the new IT systems. I have noticed some differences (between Oracle and
>> Posrgres) that I would like clarify.
>>
>> On postgres, I create 2 users and their s
Does anyone know of a tool that will convert an OWL ontology into a
PostgreSQL compatible SQL script (with PK/FK relationships)? I'd like
to take an existing ontology , define data type mappings (XSD types to
SQL data types), and then have an automated conversion occur ? I'd
rather not have t
On Friday 12 December 2008 04:16:19 Dave Page wrote:
> On Fri, Dec 12, 2008 at 7:12 AM, Albe Laurenz
wrote:
> > paulo matadr wrote:
> >> you knowns a tool for automatic converter plsql in pgplsql?
> >> this tool exist?
> >
> > EnterpriseDB claim that they can do something like this,
> > but I don
Is there a reason that pg_stat_reset doesn't reset the stats in
pg_stat_bgwriter and pg_stat_database? PG 8.3 (obviously).
The call to pg_stat_reset works, as my other stats tables are clear.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pg
What about managing the script files themselves, keeping in mind that some
scripts could be applied to more than one database version, like a database
which is a branched version of another database, but which have common
elements which can both be updated by a common script. Although sometimes a
On Fri, Dec 12, 2008 at 1:51 PM, Thom Brown wrote:
> What about managing the script files themselves, keeping in mind that some
> scripts could be applied to more than one database version, like a database
> which is a branched version of another database, but which have common
> elements which ca
> Could use a new sure thing now that there's
> no more money for me to make shorting SCO stock.
That really was easy money, wasn't it?
;-)
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgre
Brad Nicholson writes:
> Is there a reason that pg_stat_reset doesn't reset the stats in
> pg_stat_bgwriter and pg_stat_database? PG 8.3 (obviously).
It is only supposed to reset counters associated with the current
database. Those counts are cluster-wide.
regards, tom
On Dec 9, 2008, at 3:50 PM, Tom Lane wrote:
Alvaro Herrera writes:
Well, since CREATE LANGUAGE creates the functions internally, it does
make a certain amount of sense that the functions are also handled
internally when you do stuff to the language.
It *might* create the functions internall
27 matches
Mail list logo
