On Apr 17, 6:56 pm, [EMAIL PROTECTED] (Bruce Momjian) wrote:
> CAJ CAJ wrote:
> > Hello,
>
> > What is the ETA of postgresql 6.2.4? Also, will pg_standby make
it to
> > 8.2.xbranch?
>
> pg_standby will not be in 8.2.X. It is a new feature.
As I understand it, though, pg_standby as distributed
Procurando Freelancer PostgreSQL -- Rio de Janeiro
Estamos abrindo a contratação de 1 profissional PostgreSQL:
Projeto: Desenvolvimento de Web Aplicação na área de e-commerce.
Local: Rio de Janeiro (zona sul) -- teria que trabalhar nosso
escritório com a equipe.
Agenda: A partir de agora -- TEMPO
On 4/17/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Seems overly complicated --- why don't you just shut down the postmaster
and take a tarball archive of the PGDATA tree? Then to revert, stop
postmaster and untar.
Thanks for the tip!
cheers
martin
---(end of broadcast)
I've asked russian postgresql users to proceed my deadlock example.
http://sql.ru/forum/actualthread.aspx?tid=418296
Here is the results.
OS, version, build
PG version, build
Status
(Person)
SUSE Linux 10.1
8.1.4 from official SUSE distribution
deadlock between /*1*/ and /*3*/ detected
(Nalbat)
CAJ CAJ wrote:
> Hello,
>
> What is the ETA of postgresql 6.2.4? Also, will pg_standby make it to
> 8.2.xbranch?
pg_standby will not be in 8.2.X. It is a new feature.
--
Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us
EnterpriseDB http://www.ent
On Apr 17, 2007, at 2:51 PM, Tom Lane wrote:
Jonathan Vanasco <[EMAIL PROTECTED]> writes:
i believe i found a bug
psql> create table test_failure ( id integer primary key );
psql> alter table test_failure alter id rename to id_new ; # not
relevant, just illustrating the reason
Hello,
What is the ETA of postgresql 6.2.4? Also, will pg_standby make it to
8.2.xbranch?
Thanks!
Jonathan Vanasco wrote:
> I didn't see anything in the docs.
> I saw something in the FAQ suggesting this was in a TODO.
>
> Any idea when?
TODO has:
o %Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php
--
B
On Sat, 2007-04-14 at 22:01 +0200, Anton Melser wrote:
> On 14/04/07, Alain Roger <[EMAIL PROTECTED]> wrote:
> > After clicking on your link i got "invalid project" page :-(
> > and the whole page is empty...
>
> Ouch Alain...
> Try
> http://pgfoundry.org/projects/pg-migrator/
> :-)
> But ask a si
Jonathan Vanasco <[EMAIL PROTECTED]> writes:
> i believe i found a bug
> psql> create table test_failure ( id integer primary key );
> psql> alter table test_failure alter id rename to id_new ; # not
> relevant, just illustrating the reason how i got to step 2
> psql> alter tabl
i believe i found a bug
psql> create table test_failure ( id integer primary key );
psql> alter table test_failure alter id rename to id_new ; # not
relevant, just illustrating the reason how i got to step 2
psql> alter table test_failure_pkey rename to test_failure_id_new_pke
I didn't see anything in the docs.
I saw something in the FAQ suggesting this was in a TODO.
Any idea when?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Apr 17, 11:19 am, Ketema <[EMAIL PROTECTED]> wrote:
> On Apr 17, 7:35 am, Ketema <[EMAIL PROTECTED]> wrote:
>
>
>
> > On Apr 16, 6:24 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
>
> > > "Ketema" <[EMAIL PROTECTED]> writes:
> > > > I have an example were I have to build a string in the below manner:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Felix Kater wrote:
>> I need a unique ID across all columns I create. Is it o.k. to
>> achive this by combining pg_attribute.attnum of a column together with
>> the OID of the table the column is in?
> Yes, the table OID is unique, and pg_attribute.attn
On Apr 17, 7:35 am, Ketema <[EMAIL PROTECTED]> wrote:
> On Apr 16, 6:24 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
>
>
>
> > "Ketema" <[EMAIL PROTECTED]> writes:
> > > I have an example were I have to build a string in the below manner:
> > > values (' || new.tpv_success_id || ',''' || new.order_date
Felix Kater wrote:
> Hi,
>
> I need a unique ID across all columns I create. Is it o.k. to
> achive this by combining pg_attribute.attnum of a column together with
> the OID of the table the column is in?
>
> While the table's OID should be unique according to the manual, I have
> found no hints
hi everyone,
please any one give any methods to do incremental backups. it is urgent
.. help me
Regards
J Mageshwaran
** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity
Never mind this, the file was mangled when sent non-binary over ftp
(windows ftp servers apparently still send ascii unless set type i is
specified :)
Cheers,
Palle
--On tisdag, april 17, 2007 12.49.46 +0200 Palle Girgensohn
<[EMAIL PROTECTED]> wrote:
Hi,
I get out of memory immediately
Hi,
I need a unique ID across all columns I create. Is it o.k. to
achive this by combining pg_attribute.attnum of a column together with
the OID of the table the column is in?
While the table's OID should be unique according to the manual, I have
found no hints about the uniqueness of attnum -- I
On Apr 16, 6:24 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
> "Ketema" <[EMAIL PROTECTED]> writes:
> > I have an example were I have to build a string in the below manner:
> > values (' || new.tpv_success_id || ',''' || new.order_date || ''',' ||
> > new.tpv_id || ',' || new.ver_code || ',''' || new.ag
Hello All,
I am trying to set up continues archiving of WAL files.
I have some doubt about the archive command %p and %f parameter.
I am havining all 5/6 WAL files in following directory.
usr/local/pgsql/data/pg_xlog
My questions are
1) what will be the value for %p parameter
will it be
/u
On Tue, 2007-04-17 at 10:15 +0100, Richard Huxton wrote:
> garry saddington wrote:
> > On Tue, 2007-04-17 at 09:21 +0100, Richard Huxton wrote:
> >> garry saddington wrote:
> >>> I am trying this syntax which is my interpretation of the docs:
> >>>
> >>> delete from siblings s1 using siblings
garry saddington wrote:
On Tue, 2007-04-17 at 09:21 +0100, Richard Huxton wrote:
garry saddington wrote:
I am trying this syntax which is my interpretation of the docs:
delete from siblings s1 using siblings s2
WHERE s1.principal = s2.principal
and s1.sibling=175
C
On Apr 17, 2007, at 11:07, garry saddington wrote:
I am keeping a record of siblings in a school. The user chooses one
student and there siblings such that id's are entered into a table as
such:
TABLE SIBLINGS:
principal sibling
809 234
809 785
809 345
809
On Tue, 2007-04-17 at 09:21 +0100, Richard Huxton wrote:
> garry saddington wrote:
> > I am trying this syntax which is my interpretation of the docs:
> >
> > delete from siblings s1 using siblings s2
> > WHERE s1.principal = s2.principal
> > and s1.sibling=175
> >
> >
garry saddington wrote:
I am trying this syntax which is my interpretation of the docs:
delete from siblings s1 using siblings s2
WHERE s1.principal = s2.principal
and s1.sibling=175
Can anyone tell me where I am going wrong?
1. What's happening - are you getting a
26 matches
Mail list logo
