On Thu, 11 Sep 2008, Peter Eisentraut wrote:
> Jef Peeraer wrote:
> >
> > On Thu, 11 Sep 2008, Peter Eisentraut wrote:
> >
> > > Tom Lane wrote:
> > > > Jef Peeraer <[EMAIL PROTECTED]> writes:
> > > > > i am using the xml
On Thu, 11 Sep 2008, Peter Eisentraut wrote:
> Tom Lane wrote:
> > Jef Peeraer <[EMAIL PROTECTED]> writes:
> > > i am using the xml add-ons, but the date output format seems to be wrong :
> >
> > I think the conversion to xml intentionally always uses
i am using the xml add-ons, but the date output format seems to be wrong :
i have
show datestyle;
DateStyle
---
SQL, DMY
select agenda_datum from dossiers where id = 61;
agenda_datum
--
29/07/2008
select table_to_xml('dossiers', false, false, '');
gives (knip )
62
On Tue, 5 Aug 2008, Bill Moran wrote:
> In response to Jef Peeraer <[EMAIL PROTECTED]>:
> >
> > i read about the replication possibilities with postgresql. If i just need
> > some replication ( without failover stuff ) to 1 standby server, what
> > wo
i read about the replication possibilities with postgresql. If i just need
some replication ( without failover stuff ) to 1 standby server, what
would be the best option to go with. Slony i presume, although schema
chanages are not propagated.
thanks
jef peeraer
--
Sent via pgsql-general
On Thu, 22 Nov 2007, Sorin N. Ciolofan wrote:
> Hello all!
>
> I've a small bash script backup.sh for creating dumps on my Postgre db:
>
> #!/bin/bash
> time=`date '+%d'-'%m'-'%y'`
> cd /home/swkm/services/test
> pg_dump mydb > mydb_dump_$time.out
>
> I've edited cron
3 | 0 | f| 1
(7 rows)
The order is completely ignored, although there is an order by in the view
'module_info'
jef peeraer
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Tom Lane schreef:
jef peeraer <[EMAIL PROTECTED]> writes:
Tom Lane schreef:
That's a foreign-key check, which is supposed to be done as the owner of
the table. You did not show us who owns table clienten, but I think
that role must be missing the intended(?) membership in d
Tom Lane schreef:
jef peeraer <[EMAIL PROTECTED]> writes:
i get this when i try to insert a record into a table. all permissions /
privileges seems ok, but probably i missed something. i am running a
8.1.3 on linux.
registratie=> INSERT INTO clienten
(anoniem,geslacht,leeftij
i get this when i try to insert a record into a table. all permissions /
privileges seems ok, but probably i missed something. i am running a
8.1.3 on linux.
registratie=> INSERT INTO clienten
(anoniem,geslacht,leeftijd,origine,team_id,hulpverlener_id) VALUES
('true','45','58','864','30','22
is it possible to copy one template, say X to a new template , called Y ?
Or better, i want a sort of a basic template that can be used to create
a new schema.
jef
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
jef peeraer schreef:
i never thought i would be bblocked by an encoding problem :-(
My database is in LATIN1 , i have entries like this in a table called
gemeenten
Column | Type | Modifiers
r and client ? Or where else could it go wrong.
jef peeraer
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
EW . Now i get a
warning that the table the trigger is written for doesn't has a column
'col_naam'.
jef peeraer
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comm
create the database with
a proper encoding, and restore the dump.
jef peeraer
TIA
-b
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
dump, recreate the database with
a proper encoding, and restore the dump.
jef peeraer
>
> TIA
>
> -b
>
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscri
both tables
3- other solution
jef peeraer
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing
17 matches
Mail list logo