Re: [GENERAL] How to deal with field on the database that stores variable array's?

2011-01-01 Thread Dmitriy Igrishin
2011/1/1 Andre Lopes > Hi, > > I need to develop a database table that will aceept a variable array field. > My doubt is how to deal with updates on the > array field. How can I store the information of the array fields? There any > examples on the Internet on how to deal with > this subject? > >

Re: [GENERAL] How to deal with field on the database that stores variable array's?

2011-01-01 Thread John R Pierce
On 01/01/11 12:35 PM, Andre Lopes wrote: Hi, I need to develop a database table that will aceept a variable array field. My doubt is how to deal with updates on the array field. How can I store the information of the array fields? There any examples on the Internet on how to deal with this su

Re: [GENERAL] How to deal with field on the database that stores variable array's?

2011-01-01 Thread Szymon Guz
On 1 January 2011 21:35, Andre Lopes wrote: > Hi, > > I need to develop a database table that will aceept a variable array field. > My doubt is how to deal with updates on the > array field. How can I store the information of the array fields? There any > examples on the Internet on how to deal w

[GENERAL] How to deal with field on the database that stores variable array's?

2011-01-01 Thread Andre Lopes
Hi, I need to develop a database table that will aceept a variable array field. My doubt is how to deal with updates on the array field. How can I store the information of the array fields? There any examples on the Internet on how to deal with this subject? What I mean with variable array is:

Re: [GENERAL] Issues on Insert Data From Existing Table

2011-01-01 Thread Raymond O'Donnell
On 01/01/2011 19:49, vwu98...@lycos.com wrote: I need to update the database schema to add a new table based on an original table. The existing table is the following: create table shop_image ( idSERIAL UNIQUE primary key, shop_fk int references vsm_shop (id) on dele

[GENERAL] Issues on Insert Data From Existing Table

2011-01-01 Thread vwu98034
I need to update the database schema to add a new table based on an original table. The existing table is the following: create table shop_image ( id SERIAL UNIQUE primary key, shop_fk int references vsm_shop (id) on delete cascade, pa

Re: [GENERAL] query_to_xml function ignores Datestyle?

2011-01-01 Thread Pavel Stehule
Hello 2011/1/1 Esmin Gracic : > It seems that query_to_xml function ignores Datestyle settings? > Is this correct? If yes, is there any workarounf except > to_char(date,'dd.mm.'); > xsd define format for date, so you have to use a to_char function or just cast to text. Regards Pavel Stehule

[GENERAL] query_to_xml function ignores Datestyle?

2011-01-01 Thread Esmin Gracic
It seems that query_to_xml function ignores Datestyle settings? Is this correct? If yes, is there any workarounf except to_char(date,'dd.mm.'); set datestyle = 'German'; select current_date; select QUERY_TO_XML('select current_date',true,false,''); Postgresql 9.0 on Ubuntu 10.04 Server (64-b

Re: [GENERAL] Stream Replication archive command Access is denied question

2011-01-01 Thread tuanhoanganh
Thanks in advance. When I share D:/3SDATABACKUP/PITR on master computer, I set account postgres only read when access \\192.168.5.4\pitr but directory sercurity of D:/3SDATABACKUP/PITR user postgers has been changed to read only. I had changed directory sercurity of D:/3SDATABACKUP/PITR user postge

Re: [GENERAL] Stream Replication archive command Access is denied question

2011-01-01 Thread John R Pierce
On 01/01/11 1:50 AM, tuanhoanganh wrote: Is by any chance D: a network mapped drive in Windows ? No, D is a driver on master computer. I can copy 000100030056 file from postgresql data\pg_xlog to D:/3SDATABACKUP/PITR does the postgres service account have write access to that dire

Re: [GENERAL] Stream Replication archive command Access is denied question

2011-01-01 Thread tuanhoanganh
Is by any chance D: a network mapped drive in Windows ? No, D is a driver on master computer. I can copy 000100030056 file from postgresql data\pg_xlog to D:/3SDATABACKUP/PITR On Sat, Jan 1, 2011 at 4:30 PM, John R Pierce wrote: > On 01/01/11 1:23 AM, tuanhoanganh wrote: > >> archive

Re: [GENERAL] Stream Replication archive command Access is denied question

2011-01-01 Thread John R Pierce
On 01/01/11 1:23 AM, tuanhoanganh wrote: archive_command = 'copy %p D:/3SDATABACKUP/PITR/WAL/%f'# command to use to archive a logfile segment ... 2011-01-01 10:14:19 ICT LOG: archive command failed with exit code 1 2011-01-01 10:14:19 ICT DETAIL: The failed archive command was: copy "

[GENERAL] Stream Replication archive command Access is denied question

2011-01-01 Thread tuanhoanganh
I setup my PostgreSQL 9.0.1 Stream Replication. Here is my config of master database address 192.168.5.4 pg_hba.conf # IPv4 local connections: hostall all 0.0.0.0/0trust # IPv6 local connections: hostall all

Re: [GENERAL] Shit happens

2011-01-01 Thread Andreas Kretschmer
Dick Kniep wrote: > Hi list, > > Happy newyear to all of you. > > We use WAL files for backup purposes. Now we need to restore up to a > certain date in december, we have a base backup from october 24th, but > the WAL files start only at october 28th. Is there a way that we can > use the WAL fi

[GENERAL] Shit happens

2011-01-01 Thread Dick Kniep
Hi list, Happy newyear to all of you. We use WAL files for backup purposes. Now we need to restore up to a certain date in december, we have a base backup from october 24th, but the WAL files start only at october 28th. Is there a way that we can use the WAL files to recover data up to half de