> Sorry, this makes no sense to me -- EnterpriseDB has no replication
> solution that I know of.
slony is bundled with the database
>> Postgres-r sounds very nice but moving our organisations data onto a
>> system that it work in progress is very scary.
>
> You are already offloading your data to
> What is intended for PostgreSQL is decidedly NOT the "Oracle syntax"
no problem for me
> There have been a couple of abortive starts to this; I seem to recall
> someone having offered to work on it in the 8.4 branch.
that was what I want to say, at least there exists a (non free) working
solutio
> Fie on you evil synthetic key lovers. Long live the Natural Key!
think of an foreign key referencing a primary key with 6 columns *urgs*
never!
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
s
> I saw on the todo list that the "with recursive" option for selects
> (equivalent to oracle's connect by, as far as I know) is on the todo
> list for postgresql, but apparently not for the upcoming 8.3 release.
the postgresql derivate enterprisedb has this feature
(exactly the oracle syntax)
---
> There were other JDBC clients but they never
> lock any tables. They all used transactions with the serializable isolation
> level.
If you have concurrent access and some isolation you have locking.
If two inserts/updates try to change the same data (even via
triggers/rules) you get a failed c
maybe pg_dump | pg_undump could work?
I mean pg_dump with the appropriate parameters and undump directly to
the other database?
This may one of the fastest ways to do it I think.
Abandoned schrieb:
> Hi..
> I want to copy my database..
> I have a database which is name db01 and i want to copy i
if you dump/undump using a pipe there is no temp file ...
Abandoned schrieb:
> On Nov 2, 3:49 pm, Sascha Bohnenkamp <[EMAIL PROTECTED]> wrote:
>> maybe pg_dump | pg_undump could work?
>>
>> I mean pg_dump with the appropriate parameters and undump directly to
>> t
Hi,
I have a table of type timestamp.
I get the following error when I try to insert som edata to it:
PGRES_FATAL_ERROR
column "birthtime" is of type timestamp without time zone but expression
is of type time without time zone You will need to rewrite or cast the
expression.
how can I set the t
> Can I use inheritance? References?
inheritance
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
