I would need to do a mild change to pg_dump, working against a 9.4
server on linux.
Which source tree do I need? Have gcc 4.9.2 in my Lubuntu installation.
TIA
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/
using that same
data, of course, encripted to the common users).
Thank you, Scott.
On 17/11/17 10:49, Scott Mead wrote:
On Fri, Nov 17, 2017 at 7:51 AM, marcelo <mailto:marcelo.nico...@gmail.com>> wrote:
I would need to do a mild change to pg_dump, working against a 9.4
s
I need to "emulate" the pg_dump code because the password prompt. Years
ago I write a program (for the QnX environment) that catched some prompt
and emulates the standard input. I don't like to do that again.
On 17/11/17 17:23, John R Pierce wrote:
On 11/17/2017 12:19 PM
I will give expect a try. But the source code embedded in my daemon.
On 17/11/17 17:49, Ron Johnson wrote:
On 11/17/2017 02:23 PM, John R Pierce wrote:
On 11/17/2017 12:19 PM, marcelo wrote:
Sorry, I was not exact.
I don't need nor like to change pg_dump. Rather, based on pg_dump
co
Thank you, Scott.
That's happening me because incomplete docs reading.
Truly, I'm catched in a very big app, so I have no time to read all the
docs.
On 17/11/17 18:31, Scott Mead wrote:
On Fri, Nov 17, 2017 at 4:06 PM, marcelo <mailto:marcelo.nico...@gmail.com>> wro
Again: knowing of .pgpass (thank you Scott) this is what I will do.
On 17/11/17 17:49, Ron Johnson wrote:
On 11/17/2017 02:23 PM, John R Pierce wrote:
On 11/17/2017 12:19 PM, marcelo wrote:
Sorry, I was not exact.
I don't need nor like to change pg_dump. Rather, based on pg_dump
code, I
s Environment=PGDATA=/opt/PostgreSQL/9.4/data
What is going wrong?
TIA
Marcelo
On 28/06/17 10:17, Adrian Klaver wrote:
On 06/28/2017 05:06 AM, marcelo wrote:
Hi
Today I installed postgresql 9.4 on Lubuntu 15.04 from the
EnterpriseDB's package.
I modified pg_hba.conf to accept connections from the local network,
and tried to start the backend. It do not; lookin
The question is not trivial. Could I maintain two or three
separate/distinct "versions" of same database using one schema for every
of them?
Could some tables (in the public schema) be shared among all the schemas?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
o I cannot
set the search path immediately after the connection.
If the first example is possible, I will replace the schema name on the
fly, before connection attempt.
TIA
On 14/07/17 07:58, Berend Tober wrote:
marcelo wrote:
The question is not trivial. Could I maintain two or three
separat
/07/17 09:19, Bill Moran wrote:
On Fri, 14 Jul 2017 08:59:13 -0300
marcelo wrote:
Thank you.
Now I have a related question.
Could I select a specific schema in the connection string? Say, by
example database=mydb.schemanumbertwo ?
I'm asking this because I will be using Devart's dotC
erer wrote:
marcelo schrieb am 14.07.2017 um 13:59:
Could I select a specific schema in the connection string? Say, by example
database=mydb.schemanumbertwo ?
The JDBC driver does indeed support that:
jdbc:postgresql://localhost/somedatabase?currentSchema=some_schema
I think in the backrou
e.
So, I will close this thread.
Thanks to all who answered. I acquired some new knowledge.
On 14/07/17 13:50, John R Pierce wrote:
On 7/14/2017 4:59 AM, marcelo wrote:
Now I have a related question.
Could I select a specific schema in the connection string? Say, by
example database=mydb.
what about foreign keys? At least, I will have foreign keys from the
tables in the specified schema to the tables in "public", because I'm
thinking that the tables in "public" would be references, while the
tables residing in the specified schema will be the transactional one
Thank you, Andreas.
Your answer closes this thread.
On 21/07/17 11:07, Andreas Kretschmer wrote:
Am 21.07.2017 um 14:58 schrieb marcelo:
Recently I asked regarding schemas, and received very useful answers.
I conclude that I can put some tables in one schema and left others
in the public
You can try SQL Manager for PostgreSql. The Lite edition is enough ans
it's free.
It's fast, secure and very friendly.
On 26/07/17 19:41, Tiffany Thang wrote:
Hi,
I'm new to PostgreSQL. I'm looking for a developer tool that works
similarly to TOAD or SQL Developer for Oracle/MySQL which would
copy the tables definitions to production.
It will automatically create the sequences in the new schema, starting
at zero?
TIA
Marcelo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Sequences, tables, etc.. belong to the schema where was created.
Roberto.
Em sáb, 29 de jul de 2017 às 16:17, marcelo
mailto:marcelo.nico...@gmail.com>>
escreveu:
Some days ago I asked regarding tables located in different
schemas.
Now, my questi
must go to another transactional one. The example would
be "order" and "order_detail": customer, product, etc must be referenced
from public, but the FK from order_detail must point to season.order.
So, the question is solved, at least using some "postgresql complaint
The database has UTF8 encoding. The Windows machine's locale where the
string was created is set to es_AR.utf8.
When sending the data (thru Devart's Devart.Data.PostgreSql module) the
server returned the error in the subject.
I don't know how exactly the offending string was encoded.
Any help wi
Solved. I recreated the database with LATIN9 encoding.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
In some table, I have a bigint column which at the app level can be
null. Call it "DocumentNumber", and of course is not the PK.
In most cases, the applications give some value to the column.
But sometimes, the value remains null, expecting the backend or someone
assign it a unique value.
Cou
ing this because the schema to use will not be the
"current user" nor "public".
Any help will be appreciated.
TIA
Marcelo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thank you Jerry.
I read about "server parameters" as options, but forgotten search_path.
On 20/08/17 20:11, Jerry Sievers wrote:
marcelo writes:
The system I'm building needs to connect some QNX 4.x machines to the
Postgres' server (by the way, a Linux machine).
Of cou
Is there a libpq porting to QNX 4.25? I just tried to compile one of the
modules, but was rejected because the QNX's standard library have not an
Int64 type.
TIA
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
I'm pretty sure that Watcom 9.6 libraries lacks long long or any such
variants.
And, of course, I don' t have another tool chain.
Thank you
On 21/08/17 22:20, George Neuner wrote:
On Mon, 21 Aug 2017 13:27:56 -0300, marcelo
wrote:
Is there a libpq porting to QNX 4.25? I jus
Thank you, Tom.
We'll replace those QNX machines with WIndows XP ones (via dual boot),
so we can use our Devart's ORM the same as the most "user oriented"
applications.
On 22/08/17 12:39, Tom Lane wrote:
marcelo writes:
Is there a libpq porting to QNX 4.25? I just tri
refer to do all the
development
using only one paradigm.
My best regards
Marcelo
On 25/08/17 15:26, Peter J. Holzer wrote:
On 2017-08-22 12:57:15 -0300, marcelo wrote:
We'll replace those QNX machines with WIndows XP ones
The future is already here — it's just not very eve
s it
done, and how to get the result?
TIA
Marcelo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ta is actually being rewritten.
Thank you,
Marcelo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
Using Postgres 7.4, I am trying to perform an "alter table temptable add
column "myCol" serial"
It gives the following msg
ERROR: adding columns with defaults is not
implemented
You cannot add a column that is serial in a table
which already has data in postgres 7.
Is there a w
?
Thanks again for your help.
Marcelo
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Marcelo" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, June 02, 2005 4:43 PM
Subject: Re: [GENERAL] adding columns with defaults is not implemented
> O
Folks
I am confused ,
way planer it does not use the partial index?
query:
SELECT cliente_base.* FROM cliente_base
WHERE (cliente_base.inst_class_ = 'Cliente' ) ORDER
BY cliente_base.nombre ASC
plan:
QUERY PLAN
Folks
I am confused ,
way planer it does not use the partial index?
any help be appreciated
pd: sorry for my english.
data:
table definition:
-- Table: cliente_base
CREATE TABLE cliente_base
(
id_ integer NOT NULL,
activo boolean,
numero integer,
categ character vary
Hi Jhon
Diferent distros put file in diferent path
try
/usr/local/pgsql/initdb bla bla bla
or
/var/lib/postgres/bin/initdb bla bla bla
or
locate initdb
for locate that file
best regards
mdc
--- John K Masters <[EMAIL PROTECTED]>
escribió:
> I feel somewhat embarrassed to post this
folks
i need help with libpq program ,i made on C program
for
wrapper libpq.dll program , the routine failing is
copy from stdin interface.
PQputCopyData return 1 (AKA ok)
PQputCopyEnd return 1 (AKA ok)
but nothing is append to database.
tailing log file
invalid input syntax for integer:
u have posted that the delimiter
> you supplied does not match the delimiter from your
> copy statement.
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> [mailto:pgsql-general-
> > [EMAIL PROTECTED] On Behalf Of marcelo Cortez
> > Sent: Saturday, Jun
Magnus , folks
The only caveat i found in winxp64 is with psqlODBC
my application dont work very well on it into xp64
platform, the work around was change odbc profile in
favor of dns file , with dns file my application
return to work, ok.
BTW i using linux server without problems, but my
c
hi all
i downloaded postgres8.2.4 sources , expand and
./configure and install with success.
Now i need one module from contrib directory ,
fuzzystrmatch
cd /postgres/contrib/fuzzymatchstr [ ok ]
make
throws
make
Makefile:15: ../../src/Makefile.global: No such file
or directory
Make
Tom
Thanks works fine!
best regards
mdc
--- Tom Lane <[EMAIL PROTECTED]> escribió:
> marcelo Cortez <[EMAIL PROTECTED]> writes:
> > i downloaded postgres8.2.4 sources , expand and
> > ./configure and install with success.
> > Now i need
Hi all
has anybody created using Gendict generate
dictionary in spanish successful ?.
__
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yaho
hi all
i'm using postgresql 8.2.4 and install tsearch2 , but
i need spanish idiom.
following
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/README.gendict
and downloading
http://snowball.tartarus.org/algorithms/spanish/stemmer.html
stem.c and stem.h
./config.sh -n pt -s -p spanish
Felipe
--- Felipe de Jesús Molina Bravo
<[EMAIL PROTECTED]> escribió:
> Hi
>
> You are rigth, the output of "show lc_ctype;" is C.
>
> Then I did is:
>
> prueba1=# show lc_ctype;
> lc_ctype
> -
> es_MX.ISO8859-1
> (1 row)
>
> and do it
>
> % initdb -D /YOUR/PATH -
folks
i've installed 8.3beta but at start up receive
FATAL: invalid value for parameter
"timezone_abbreviations": "Default"
any clue?
best regards.
MDC
info:
Linux richelet-internet 2.6.21.6 #9 SMP Sun Dec 2
17:52:20 ART 2007 i686 Pentium III (Coppermine)
GenuineIntel GNU/Linux
gp_confi
Alvaro ,folks
--- Alvaro Herrera <[EMAIL PROTECTED]> escribió:
> marcelo Cortez escribió:
> > folks
> >
> >
> > i've installed 8.3beta but at start up receive
> >
> > FATAL: invalid value for parameter
> > "timezone_abbreviatio
Folks
select chr(165);
ERROR: requested character too large for encoding:
165
it's one old scrip if not remember wrong works
postgres in 8.2.4
any clue?
best regars
mdc
info:
select version().
"PostgreSQL 8.3beta3 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.1)"
Folks
i received the follow message from backend ,it's this
a bug?
best regards
and happy new year
MDC
pd: any clue are welcomed.
*** glibc detected *** postgres: postgres richelet
201.235.11.133(2504) SELECT: double free or corruption
(!prev): 0x0845d7e8 ***
=== Backtrace: =
n:
"PostgreSQL 8.3beta3 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.1)"
i'ts correct GCC version?
best regards.
MDC
pd: gdb can help? ( for debugging my own code)
links about howto debug?
--- Tom Lane <[EMAIL PROTECTED]> escribió:
> ma
folks
the follow queries work in postgres 8.2 but
in 8.3beta don't work
SELECT c.* FROM c WHERE c.numero LIKE '1%';
i think automatic conversion of numeber to text is
the problem , in 8.3beta don't work
numero field is integer type
any ideas?
best regards
mdc
ps:"PostgreSQL 8.3
pper ,explicit cast is not an option ( not
manual code here).
there any way simulate previous behavior? (automatic
conversion), create cast can help?
best regards.
mdc
>
> Regards
> Pavel Stehule
>
>
> On 10/01/2008, marcelo Cortez
> <[EMAIL PROTECTED]> wrote:
> &
Alvaro
--- Alvaro Herrera <[EMAIL PROTECTED]>
escribió:
> marcelo Cortez escribió:
> > Pavel
> >
> >
> > --- Pavel Stehule <[EMAIL PROTECTED]>
> escribió:
> >
> > > Hello,
> > >
> > > it isn't bug. You have
Alvaro
--- Alvaro Herrera <[EMAIL PROTECTED]>
escribió:
> marcelo Cortez escribió:
> > Pavel
> >
> >
> > --- Pavel Stehule <[EMAIL PROTECTED]>
> escribió:
> >
> > > Hello,
> > >
> > > it isn't bug. You have
hi folks
i've tried to install ispell for
CREATE TEXT SEARCH DICTIONARY spanish_ispell (
TEMPLATE = ispell,
DictFile = spanish,
AffFile = spanish,
StopWords = spanish
);
sentence, but, one error ocurrs
ERROR: syntax error at line 432 of affix file
"/usr/local/pgsql/share/ts
Teodor
i've tried with openoffice.org but whitout success,
:)
ERROR: invalid byte sequence for encoding "UTF8":
0xe16261
HINT: This error can also happen if the byte sequence
does not match the encoding expected by the server,
i've tried too with
convmv -f iso-8859-1 --notest -t utf-8
Thanks Teodor
for quick response,and your work
> That's right, but you should convert dictionary and
> affix file in UTF8 encoding.
how to i can do it?
best regards
MDC
Yahoo! Encuentros.
Ahora encontrar pareja es mucho más fácil, probá el nuevo Yahoo! Encuentros
http://y
Thanks Alvaro
iconv -f iso-8859-1 -t utf-8 es_ES.dict > es.dict
works!!
--- Alvaro Herrera <[EMAIL PROTECTED]>
escribió:
> marcelo Cortez escribió:
>
> > i've tried too with
> > convmv -f iso-8859-1 --notest -t utf-8
> es_ES.dic
> > whitout
Louis
what if you create one "wrapper" function immutable?
some thing like this.
CREATE OR REPLACE FUNCTION myextract(timestamp )
RETURNS date AS
$BODY$
BEGIN
return extract(date from $1) ;
END;
$BODY$
LANGUAGE 'plpgsql' IMMUTABLE
best regards
mdc
--- Louis-David Mitterrand
Sorry forgot to mention
later try
CREATE UNIQUE INDEX visit_idx ON visit_buffer(
id_session, id_story ,myextract(created_on));
best regards
> Louis
>
> what if you create one "wrapper" function
> immutable?
> some thing like this.
>
> CREATE OR REPLACE FUNCTION myextract(timestamp )
>
x27;t want to take
any chances of filling up the disk due to a pg_dump you know.
thanks,
Marcelo
Linux/Solaris System Administrator
[EMAIL PROTECTED]
http://www.zeroaccess.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Please, remove me from the list!
Marcelo Giovane
É possível alterar o database corrente para criar um schema nele sem uso do \c
do psql?
Obrigado
MarceloG
hello to all
I have the following problem, when making massive
update of a table, I received the message
"segmentation fault" without no other data of the
error in log.
Some idea of because it gives east message?
I am using
gentoo
postgres 7.4.6
dual processor HP proliant
5 gigabyte of
Lonni , folks
>
> You're doing this from within psql or elsewhere?
from putty terminal from windows statiom
> What logging level
default i' guest
> are you using? How 'massive' is this update?
full , the update statement not have filter clause.
> kind of parameters
the update statemen
Lonni , folks
configuration data: sorry for long response ;)
Linux sume 2.6.9-gentoo-r1 #1 SMP Mon Feb 21 10:46:46
Local time zone
must
be set--see zic i686 Intel(R) Xeon(TM) CPU 2.80GHz
GenuineIntel
GNU/Linux
postgres:
"PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 3.3.4
Lonni , folks
> Full meaning all the rows are being updated? What
> kind of data is
> this that you're updating?
the fts engine using one tsvector field indexing with
gist index
the statement is something like this
update from veryLargeTable
set field = to_tsvector( coleace(field1) );
an
hi folks
the postgres fail with follow mwssage
pg_dump: dumpClasses(): SQL command failed
pg_dump: Error message from server: ERROR: xlog flush
request 190/3F08779C is not satisfied --- flushed only
to 190/3FD0
CONTEXT: writing block 268606 of relation 17142/17501
any clue?
best reg
folks
the server log message is
LOG: invalid message length
any clue?
best regards
mdc
pd: where to found the foot print header messages for
bki protocol?
___
A tu celular ¿no le falta algo?
Usá Yahoo! Messenger y Correo Yahoo! en tu telé
folks
the server log message is
LOG: invalid message length
any clue?
best regards
mdc
pd: where can i find header format messages for
bki protocol?
___
A tu celular ¿no le falta algo?
Usá Yahoo! Messenger y Correo Yahoo! en
Folks
I am a little confused, I am trying to implement md5
autentication protocol,
as the field is used salt?
is hash of md5 algorithm?
how build the key?
the server log say:
'Password authentication failed for user'
is algun example of as it is the protocol?
best regards
mdc
__
hi
any pointer's to install xml on debian be
appreciated.
best regards
mdc
___
A tu celular ¿no le falta algo?
Usá Yahoo! Messenger y Correo Yahoo! en tu teléfono celular.
Más información en http://movil.yahoo.com.ar
-
Hi guys,
Is there a data type to store data extracted from a
GPS? The only thing I need is store latitude and
longitude.
Thanks in advance,
Regards,
Marcelo P
Campinas/SP/Brazil
___
Yahoo! Acesso Grátis
hi folks
the follow script fail
select to_tsquery('hello world ');
-> ERROR: syntax error
how to catch this error, any clue?
best regards
mdc
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu
hi folks
the query:
SELECT P.ACT_INCORPORADA, P.FECHA_INICIO,
P.OBSERVACIONES1
FROM PASEST AS P
WHERE
P.FECHA_INICIO between '1999-08-22
00:00:00.00'::timestamp AND '1999-12-22
23:59:00.00'::timestamp
ORDER BY P.ACT_INCORPORADA
make table scan , t
folks
what is preferible value for
stats_reset_on_server_start ?
what is default value?
best regards
MDC
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
-
hi guys
i need advice for query optimization,take too long
time.
any coments are welcomed :).
best
MDC
SELECT c.actuacion_car AS c_actuacion,
c.comentario1 || ' ' || c.comentario2 || ' ' ||
c.comentario3 AS c_comentario
FROM caratult AS c INNER JOIN extractt AS t1 ON
hi guys , Richad
you are right!, my apologies
profile data:
postgres: "PostgreSQL 7.4.3 on i386-pc-linux-gnu,
compiled by GCC 2.95.4"
HP proliant
processor: Dual Xeon 3.40 Ghz.
HD:250 Gigabytes hard disk storage.
responses:
> Comment 4 - you apply a LIMIT without an ORDER BY.
> Are
hi all
I have a lock problem, one select query freeze my
application, the query in question is on complex
select , with many join's, but select all of them.
The select * from pg_catalog.pg_locks show many rows
while the query freeze my aplication.
the aplication use ODBC .
any ideas?.
any help
dc
pd: other information
"PostgreSQL 7.4.3 on i386-pc-linux-gnu, compiled by
GCC 2.95.4"
kernel: Linux serverf 2.4.26-1-686-smp #1 SMP Fri Aug
20 19:39:10 CEST 2004 i686 unknown
Distro: Debian
--- Richard Huxton escribió:
> marcelo Cortez wrote:
> > hi all
> >
>
Hello all,
does anyone know, whether there is a
Debian Package for postgresql 8.x for stable version?
Thanks in advance.
MDC
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yaho
t;AccessShareLock"|t
53054|52800||30186|"AccessShareLock"|t
73726|52800||30186|"AccessShareLock"|t
53074|52800||30186|"AccessShareLock"|t
53049|52800||30186|"AccessShareLock"|t
53127|52800||30186|"AccessShareLock"|t
9567503|52800||30186|&qu
--- Richard Huxton escribió:
> marcelo Cortez wrote:
> > Hi Richard , folks
> >
> > the query is:
> >
> > SELECT c.actuacion_car AS c_actuacion,
> > c.comentario1 || ' ' || c.comentario2 || ' ' ||
> > c.comentario3 AS
hi Richard ,folks
Question: is normal this locks ?
which is the reason of this?
thanks for your time
best regards
MDC
--- Richard Huxton escribió:
> marcelo Cortez wrote:
> > Richard
> >
> > Sorry for a delay
> >
> > question t
hi folks
the lastest postgres odbc driver don't work into
winxp64 ( AKA Windows Vista) Operative System.
The installer fail, i'm try to register dll manually
but still fail at add conection time into control
panel
any ideas
best regards
mdc
___
folks
help me ,i cant read bytea type field's.
how to convert bytea to text or varchar ?
when using bytea types?
any clue be appreciated
best regards
mdc
__
Preguntá. Respondé. Descubrí.
Todo lo que
b Mir <[EMAIL PROTECTED]> escribió:
> This might help you:
>
> select encode(col1,'escape') from tblBytea;
>
> where col1 is of type bytea...
>
> -
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 1/24/07, marcelo Cortez
>
hi Markus ,folks
> Are you sure you tested with a real bytea field?
Yeah , i store bytea using encode function , how you
say .
The field of my table is bytea type , and store real
bytea data in this field.
My problem is , i can't convert this field to text
anymore, not function receiving
folks
my table
CREATE TABLE pblfield
(
id_ integer NOT NULL,
value_field bytea,
name character varying(128),
osset integer,
length integer,
version_ integer,
inst_class_ character varying(128),
CONSTRAINT pblfield_pkey PRIMARY KEY (id_)
)
insert into pblfield( id_ , value_f
ok my mistake ,
insert into pblfield( id_ , value_field )
values(1 ,encode(E'\\000\\001', 'escape') ::bytea
) ;
best regards
mdc
__
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo q
Richard
H i'm understood now!,
sorry for the noise.
thanks very, very much
best regards
mdc
--- Richard Huxton escribió:
> marcelo Cortez wrote:
> > ok my mistake ,
> >
> > insert into pblfield( id_ , value_field )
> >values(1 ,encode(E&
People
In my experience work very well con tables with
172.000.000 of records ( 172 millions).
In fact is not too large number of records for
postgresql.
important aspect of this installation is your .conf
file, take care of this, check old email with config
subject.
Best regards
mdc
--- R
oblfolks
I can't install postgresql on winxp profesional
Installer fail ( creating cluster)
Installer with out cluster . ok
creating cluster on hand .fail
initdb
The files belonging to this database system will be
owned by user "postgres".
This user must also own the server process.
T
Hi there
--- Peter Eisentraut <[EMAIL PROTECTED]> escribió:
> dfx wrote:
> > I have some fiel name with character with accent
> (à, ò...) but when I
> > make a plain backup of schema (file.sql) that
> characters are
> > converted to strange sequence of two (or more?)
> characters.
This sounds
folks
I can't install postgresql on winxp profesional
Installer fail ( creating cluster)
Installer with out cluster . ok
creating cluster on hand .fail
initdb
The files belonging to this database system will be
owned by user "postgres".
This user must also own the server process.
The
till there!!
Thanks in advance,
Marcelo Pereira
__
Fale com seus amigos de graça com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/
---(end of broadcast)---
TIP 4: Have you searched our lis
Hi guys,
(1) I change postgresql.conf:
add_missing_from = off
(2) pg_ctl stop
(3) pg_ctl start
Without success!! The warning is still there!! :(
Any ideas
Thanks in advance,
Marcelo Pereira
__
Fale com seus amigos de graça com o novo
hi there
same things occurs to me.
Any body install win32 version with success???
best regards
MDC
--- RPK <[EMAIL PROTECTED]> escribió:
>
> When I run the setup of PGSQL 8.2.3, it displays
> error while initializing
> database cluster. Error displayed is: "Failed to
> execute initdb. Unab
gt; Sent: 2-14-'07, 5:14
>
> >
> > Paul,
> >
> > I installed on a Fat32 partition and gave the data
> directory path to an NTFS
> > partition. I have not set any file permissions.
> Installing as a default
> > "postgres" user.
> >
> >
rectory
"C:/Archivos de programa/PostgreSQL/8.2/data"
note path is truncated in message ???
file not exists i delete directory
one more time thanks
best regardsd
mdc
--- Paul Lambert <[EMAIL PROTECTED]>
escribió:
> marcelo Cortez wrote:
> > Magnus
> >
Hi folks
I Agree with Stephen ,before update to 8.2.3 version
i can see "vacuum database xx "
tailing the file log, off course log statements i'ts
in 'all' .
After update don't see anymore, plus pgAdmin reclaim
to me for vacuum databases.
best regards
MDC
--- "Schwenker, Stephen" <[EMAIL
Folks
I need to save data on rtf format but , postgres
refuses to storage for backslah or character's
problem's any idea or vice are welcomed best
regards
mdc
pd: sample off data to save ( from postgres log)
"
UPDATE plbrecord SET documentation =
'{\rtf1\ansi\deff0{\fonttbl{\f
1 - 100 of 181 matches
Mail list logo