Re: [GENERAL] 7.4 -> 7.4.1 upgrade with customization on freebsd

En un mensaje anterior, scott.marlowe escribió: > > 2) I would like to upgrade to 7.4.1 without having to re-edit any config > > files or change any paths. > > Just backup the config files in $PGDATA to another directory, and toss > them back into $PGDATA after the initdb > > > 3) I would like t

Re: [GENERAL] 7.4 -> 7.4.1 upgrade with customization on freebsd

e backuped up versions and pg_restore your DB. Regards. Fernando. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] pg_autovacuum won't make on FreeBSD

Try gmake. Regards. En un mensaje anterior, David Wheeler escribió: > 4.8-STABLE FreeBSD 4.8-STABLE i386 > > sahlins# cd postgresql-7.4.2/contrib/pg_autovacuum > sahlins# make > "../../src/Makefile.global", line 38: Missing dependency operator ---(end of broadcast)-

Re: [GENERAL] Looking for help building 'rhdb-explain' Visual Explain

Please try: echo $JAVA_HOME and which javac Regards, Fernando ---(end of broadcast)--- TIP 3: 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 list cleanly

Re: [GENERAL] Looking for help building 'rhdb-explain' Visual Explain

Jeff Boes wrote: Fernando Nasser wrote: Jeff, have tou set the environment variable JAVA_HOME to where your SDK is installed? Please try: echo $JAVA_HOME It was undefined ... I set it to "/usr/java/j2sdk1.4.2_04". and which javac Nothing found in my path. However, with or without

[GENERAL] TCL and encoding

e shown in hexa). I've seen similar questions in the archive but haven't found a workable solution. Any ideas? Thanks and regards! Fernando P. Schapachnik Planificación de red y tecnología VIA NET.WORKS ARGENTINA S.A. [EMAIL PROTECTED

Re: [GENERAL] TCL and encoding

r psql. The others are from PgAccess and TCL 8.3 I will send you the dump off-list. Thanks! Fernando P. Schapachnik Planificación de red y tecnología VIA NET.WORKS ARGENTINA S.A. [EMAIL PROTECTED] Tel.: (54-11) 4323-3381 ---(end of broadcast)--

Re: [GENERAL] Visual Basic and PostgreSQL ODBC

not know how many records satisfied a given query until you try to fetch them all. Personally I've seen this kind of erros against Oracle and DB2, but I've seen many programmers used to it because of Access databases. []s, Fernando Lozano -

[GENERAL] [INTERFACES] libpgtcl.dll (fwd)

h the necessary patches for pgtclCmds.c to solve the problem. Now I need to use PgAccess from Windows, but don't know how to compile the patched libpgtcl.dll. Do I need MSVC? Or I can build it via Cygwin+gcc? Thanks for your help! Fernando P. Schapachnik Planificación de

[GENERAL] tables in tables

Hi! I have a problem with tables, i think it is a problem for experienced newbies, so i thought it would not fit with the newbies mailing list, sorry if it was for the newbie mailing list: I want to create a table in a table, that means, if i have a row, in that row are many columns, where on

[GENERAL] New RPMS ?

Hi there! Are there plans for 7.1.3 RPMS for Red Hat 6.2 and other systems using the older glibc and rpm format? []s, Fernando Lozano ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] WAL

with a SQL command. Any help on this subject will be greatly appreciated!! :). Thanks in advance and sorry for the long post. -- Fernando Ipar - [EMAIL PROTECTED] --- ---(end of broadcast)---

Re: [GENERAL] New RPMS ?

alone, but getting 20 to 50 of them to make a working school lab is another entirelly different story. []s, Fernando Lozano ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] Views in PgAccess

En un mensaje anterior, Tom Lane escribió: > Fernando Schapachnik <[EMAIL PROTECTED]> writes: > > Any idea why Views do not show up in PgAccess Views tab > > (Postgres 7.1.2, PgAccess 0.98.7)? Any idea on how to solve it? > > Are you *sure* you are using the up-to

Re: [GENERAL] Views in PgAccess

I solved it. Strangenly enough the versions of PgAccess included in Postgress and the one you can download from it homepage both claim to be 0.98.7, although they are different. As you said, the one bundled with Postgres does show the views. Thanks! Fernando Schapachnik writes: > Any idea

Re: [GENERAL] where cannot use alias name of column?

x27;t use alias in ther where part. Good luck! Fernando P. Schapachnik Planificación de red y tecnología VIA NET.WORKS ARGENTINA S.A. [EMAIL PROTECTED] Tel.: (54-11) 4323-3381 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] pg_dump and alter database

-f /tmp/x CREATE DATABASE You are now connected to database db as user pgsql. You are now connected as new user dnsadm. psql:/tmp/x:13: ERROR: db: permission denied Regards. Fernando. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL]

each package will be a 'normal' package, not a relocatable one. -- Fernando Nasser Red Hat Canada Ltd. E-Mail: [EMAIL PROTECTED] 2323 Yonge Street, Suite #300 Toronto, Ontario M4P 2C9 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Multiple database services and multiple versions on Red Hat Linux systems

ation of the other files (i.e., the path from configure is always used, and not some hardcoded value). As you see, these goals can be achieved without any changes in the postgresql community sources. Regards to all, Fernando -- Fernando Nasser Red Hat Canada Ltd. E-Mail: [EMAI

Re: [GENERAL] JDBC DatabaseMetaData problem

Wrong list. Please post this to the [EMAIL PROTECTED] list. I am sure there are people there that can help you with this. Regards, Fernando Aleksey wrote: Hello, I have the following problem working with DatabaseMetaData. There is a database with table and attribute names in Russian

Re: [GENERAL] help from Portugal

Looks like the new DB might have been initialized with a different locale. Read about locales and initdb in the docs. Good luck. Fernando. En un mensaje anterior, Pedro Miguel Guedes escribió: [...] > > The problem seems to be on accent on letters. So I thought maybe some stuff > on

Re: [GENERAL] import CVS file

jobs. Anyone there can pelase pointe to such > > utility? > > Use the COPY command. Someone said this command only accepts TAB delimited files, with no string delimiter. Is it possible to change these settings? []s, Fernando Lozano

Re: [GENERAL] Strage behavior

En un mensaje anterior, Tom Lane escribió: > Fernando Schapachnik <[EMAIL PROTECTED]> writes: > > select * from aliases where alias~'^claudia.gonzalez$' \g > > alias|receptores > > -+-- > > (0 rows) > > > select * from

Re: [GENERAL] Kylix, dbexpress & PostgreSql

stgresql unit from Free Pascal (www.freepascal.org). Also take a look at their FCL (Free Component Library), the development version has a clone of a TDataset and a PostgreSQL-specific subclass. Maybe you can compile it with Kylix and use with CLX data controls. []s, Fernando Lozano --

[GENERAL] Can you write into a view?

Hello, I'm a new into the postgres's world, and I was seeing the User's Guide from V.6.4 and I saw that you can write into a View. In the new versions can you? If not, have any body any idea of when it would be reality? Thanks F

[GENERAL] Neverending query on 6.5.0 over Solaris 2.5.1

ry: SELECT u.nombre_cuenta, per.nombre, pas.clave_cifrada, pas.clave_plana, u.estado FROM usuarios u, perfiles per, passwd pas WHERE (u.perfil=per.id_perfil) and (u.id_usr=pas.id_usr) and (u.activa) ProcessQuery bin/postmaster: dumpstatus: sock 5 bin/postmaster: dumpstatus: sock 5

[GENERAL] monitor stats

hello, I have a question, does not work monitor stats in postgres 8.1.8 I cannot see querys in execution help me please.. DiegoF

Re: [GENERAL] monitor stats

rver_start = off *in 8.1.6 and 8.1.4 it works * On 5/29/07, Shoaib Mir <[EMAIL PROTECTED]> wrote: Did you try doing "log_statements = all" in your postgresql.conf file? -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 5/29/07, Diego Fernando Arce <[EMAIL PROTECTED

Re: [GENERAL] monitor stats

erpriseDB ( www.enterprisedb.com) On 5/29/07, Diego Fernando Arce <[EMAIL PROTECTED]> wrote: > > this is a part of postgrsql.conf > > > log_statement = 'all' # n

Re: [GENERAL] monitor stats

on to log_statement you can also set log_min_duration_statement to 0 and that will also log queries in your log file. -- Shoaib Mir EnterpriseDB (www.enterprisedb.co,) On 5/29/07, Diego Fernando Arce < [EMAIL PROTECTED]> wrote: > > show log_statement; > > log_statement > -

[GENERAL] Strange round behaviour w/ more than 2 decimals

laces parameter + 1 to determine which is the rounding (ROUND(1.8951, 2) returns 1.90). I've tested in 8.1.3 and 8.2.4. Is it expected to work this way? There's a way to "force" the round to consider all the decimal places? Thanks, Fernando Pinheiro

Re: [GENERAL] Strange round behaviour w/ more than 2 decimals

d round-up 9. Reading http://www.ai.com.br/pessoal/indices/2A1A.HTM show the correct way (sorry, the page is in brazilian portuguese). Anyway, the document shows: DO NOT DO RECURSIVE ROUNDS! hehe. Thanks for the answer and sorry for the incorrect question. Regards, Fernando Pinheiro 2007/7/11

[GENERAL] problemas zona horaria

as Gracias Saludos Fernando - Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games.

[GENERAL] dump desde dentro de una base

Estimados, Disculpen por la pregunta pero con postgres puedo sacar un dump desde dentro de la base y obtener lo mismo que con pg_dump Gracias Saludos - Don't be flakey. Get Yahoo! Mail for Mobile and always stay connected to friends.

[GENERAL] Error Starting Back END

.utf8 en_PH en_PH.utf8 en_SG en_SG.utf8 en_US en_US.iso885915 en_US.utf8 en_ZA en_ZA.utf8 en_ZW en_ZW.utf8 I don't see en_US.UTF-8 there why..?? I have tried doing initdb to an empty cluster and copying the data folder but the erros is the same. Could you help me to resolve this.

[GENERAL] Error: Server doesn't listen

Every two days, Postgres 8.1 Server is unconfigured without apparent changes done. The service under windows XP is always stoped. I work under XP SP2. has somebody any idea? Do the list accept messages in spanish? ---(end of broadcast)--- TIP 9

[GENERAL] Adding Functionality

Hello, i'm quite a newbie using postgres 7.2 so this may be an easy question, but how do i add new funtionality? I mean, i wanna add a couple of new functions, and i've found this files, pg_proc.h and fmgrtab.c, but i don't know the meaning of the fields, so i can't add anything. For instance,

Re: [GENERAL] Adding Functionality

eb 18, 2004 at 11:49:39AM -0500, Fernando Alonso Renault wrote: > Hello, > > i'm quite a newbie using postgres 7.2 so this may be an easy question, but how do i > add new funtionality? I mean, i wanna add a couple of new functions, and i've found > this files, pg_proc.h a

[GENERAL] Japanese and PostgreSQL

Hello There , I hope u answer these questions: I have installed postgresql DBMS , with SQL_ASCII encoding, so far, it is working ok, I think I might have probelems when manipulating the strings(substring, lenght), but now I don't do i. Could anyone tell me , with reasons, the best encoding? Also I

[GENERAL] Compiling Perl code

suppose it's a linkedition problem, but I don't have idea how to fix it. Do anyone know what problem it is, and how to fix it? Luiz Fernando

[GENERAL] interval question

lem is that start+duration is an interval, and I can't find the way to cast now to interval or interval to time or tinterval in order to make the comparison. Any ideas? Thanks in advance. Fernando P. Schapachnik [EMAIL PROTECTED] ---(end o

[GENERAL] Re: [pgsql-es-ayuda] Oferta de Entrenamientos en el marco del Cuarto PGDay Latinoamericano.

Podran grabar videos (screencasts) de todas las actividades del pgday? para asi se tenga mas difusion y poder bajar los videos. Saludos Fernando Lopez Bolivia El 11 de enero de 2011 16:30, Ing. Yunior Mesa Reyes escribió: > Para divulgar por todas las vías posibles... > > Durante

[GENERAL] unsubscribe

---(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 list cleanly

<    1   2