[GENERAL] Relation "xxxxx" does not exist

2004-03-17 Thread Valter
hing like that?   All client softwares but pgsql are running on windows2k   Valter

[GENERAL] Relation "xxxxx" does not exist - more info

2004-03-17 Thread Valter
r DTS.   In sum, DTS creates the table but doesn't transfer data.   Is quoted names a matter of postgre config?   Thanks,   Valter - Original Message - From: Valter To: [EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 2:52 PM Subject: [GENERAL] Relation "

Re: [GENERAL] Relation "xxxxx" does not exist - more info

2004-03-17 Thread Valter
to Postgre. First it is necessary create tables with non-quoted identifiers and then tranfer them (Luckly DTS uses quotes just to create tables and not to data transfer). The whole problem is not so bad except for pgAdmin behavior that should work like psql. thanks, Valter - Original Messag

[GENERAL] what is the max postgres db size & table size?

1999-04-15 Thread valter
valter

[GENERAL] what is the MAX postgres db size & table size? NOBODY KNOWS?

1999-04-15 Thread valter
The Hermit Hacker wrote: > there is a max? *raised eyebrow* > i've not understand! in Sysbase the limit is 8 Tera Byte, in Mysql a table cannot be much than 2 or 4 Gb ... what are the postgresql LIMITS?

Re: [GENERAL] Search engine with PostgreSQL

1999-04-28 Thread valter
TED] > Nice Software Solutions - http://www.nice.be > Eglegemweg 3, 2811 Hombeek - Belgium > Tel +32(0)15 412953 - Fax +32(0)15 412954 -- - Valter Mazzola - ITALY - [EMAIL PROTECTED] - --- http://naturalismedicina.com/linswap -- IS THE LINUX & GPL BANNER EXCHANGE PROGRAM --- --JOIN NOW !---

[GENERAL] Dead Locks

2014-07-23 Thread Valter Nogueira
m pg_class where oid in (2662,2663) 2662;"pg_class_oid_index" 2663;"pg_class_relname_nsp_index" Futhermore, this system don't use transactions (I mean it is autocommit) and we don't use triggers, rules or even foreign keys contraints. Thanks for any help. Valter

[GENERAL] eRserver.com Replication Server beta not available !?

2000-11-14 Thread Valter Mazzola
when will be released? valter mazzola, Italy. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

Re: [GENERAL] Running several postmaster using same database in parallel

2000-11-23 Thread Valter Mazzola
many users have asked for this feature (ie load balancing,clustering, of 1 postgresql database) but no answer from mailing-list, and no planning for this important feature, i don't understand why. Why not set-up a site to found this project with donations... on postgresql.org? valter ma

Re: [GENERAL] Database cluster?

2000-12-01 Thread Valter Mazzola
ing. There could be something recyclable in there. Must >look at the specs and some source later... > *** i've compiled it , but with no results. An idea is to get diff to corresponding pure postgresql version (6.4/5?), then study the patch, and grab the secrets to f

[GENERAL] High inserting by syslog

2008-07-03 Thread Valter Douglas Lisbôa Jr.
e the on-line inserting and do a job moving all lines to the main indexed table at midnight. My question is, Does exists a better solution, or this tatic is a good way to do this? -- Valter Douglas Lisbôa Jr. Sócio-Diretor Trenix - IT Solutions "Nossas Idéias, suas Soluções!" www.treni

Re: [GENERAL] High inserting by syslog

2008-07-03 Thread Valter Douglas Lisbôa Jr.
On Thursday 03 July 2008 13:03:49 Joshua D. Drake wrote: > On Thu, 2008-07-03 at 12:05 -0300, Valter Douglas Lisbôa Jr. wrote: > > Hello all, I have a perl script thats load a entire day squid log to a > > postgres table. I run it at midnight by cronjob and turns off the indexes &

Re: [GENERAL] How do I convert a timestamp with time zone to local time?

2008-07-29 Thread Valter Douglas Lisbôa Jr.
SELECT extract (epoch from your_time_field) from your_table; SELECT to_timestamp(your_epoch_field) from your_table; -- Valter Douglas Lisbôa Jr. Sócio-Diretor Trenix - IT Solutions "Nossas Idéias, suas Soluções!" www.trenix.com.br [EMAIL PROTECTED] Tel. +55 19 3402.2957 Cel. +55 19 9183.424