[GENERAL] Ayuda

Tengo problemas para conseguir una version de postgres para un servidor solaris 9 sparc, donde puedo conseguirlo?? Ademas quiero instalar un driver ODBC para postgres en ese servidor y me tre problemas, supongo porque no tengo postgres ahi.. Agradeciendo de ante mano la respuesta, Me despido

Re: [GENERAL] [pgsql-general] cant find postgres executable after initdb

ok, when i start a new cmd window from runas, and run the pg_ctl command from there, the process will start. btw you also have to change the ownership and permissions on the postgresql.conf, pg_hba.conf and pg_ident.conf files. C:\Program Files\PostgreSQL\8.3\binrunas /user:postgres2 cmd /k Will

Re: [GENERAL] Ayuda

This mailing list is for eglish speakers, [EMAIL PROTECTED] is for spanish community. El día 6 de noviembre de 2008 11:29, Adriana Alfonzo [EMAIL PROTECTED] escribió: Tengo problemas para conseguir una version de postgres para un servidor solaris 9 sparc, donde puedo conseguirlo?? Ademas

[GENERAL] error en createlang

Hola Lista: instale el postgres con el comando ./postgresql-8.3.4-1-linux-x64.bin instale la el postgres en /usr/local/... la base en /base/data como yo uso caracteres en español como los acentos y la ñ Ñ le puse es_ES.utf8 código 231 todo bien hasta que cree una base de datos con: -bash-3.2$

Re: [GENERAL] error en createlang

Eduardo Arévalo wrote: Hola Lista: instale el postgres con el comando ./postgresql-8.3.4-1-linux-x64.bin instale la el postgres en /usr/local/... la base en /base/data como yo uso caracteres en español como los acentos y la ñ Ñ le puse es_ES.utf8 código 231 todo bien hasta que cree una base

Re: [GENERAL] Ayuda

porque no aprovecha JDBC? Saludos Cordiales desde EEUU! Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender

Re: [GENERAL] Equivalent for AUTOINCREMENT?

Michelle Konzack wrote: -- Start of PGP signed section. Hello Michael, Am 2008-10-31 11:15:54, schrieb Michael Hall: I have a table where I have a serialnumber which shuld be increased be each INSERT. I know I can use max() to get the highest number, but how can I use it in a

Re: [GENERAL] Equivalent for AUTOINCREMENT?

On Sat, Nov 1, 2008 at 12:33 PM, Michelle Konzack [EMAIL PROTECTED] wrote: Hello Michael, Am 2008-10-31 11:15:54, schrieb Michael Hall: I have a table where I have a serialnumber which shuld be increased be each INSERT. I know I can use max() to get the highest number, but how can I

[GENERAL] serial data type usage

I have a table where I would like the primary key to be generated during the insert. Here is a simplified example: CREATE TABLE employee_type { tname varchar(10) PRIMARY KEY, id_prefix char(1) ; ... } tname | id_prefix --+-- worker | W manager | M

Re: [GENERAL] I'm no longer puzzled by a foreign key constraint problem

On Wed, 2008-11-05 at 12:14 +0900, Craig Ringer wrote: Jonathan Guthrie wrote: The thing is, the C++ code does this BEGIN transaction 1 INSERT project COMMIT BEGIN transaction 2 SET permissions COMMIT or, at least, it's supposed to. OK, and we know that if it is

Re: [GENERAL] serial data type usage

On Thursday 06 November 2008, EXT-Rothermel, Peter M [EMAIL PROTECTED] wrote: I have thought about using the serial data type for the employee.id but I also want to automate the prepending of the { W, M, E } prefix. You'll need write a before-insert trigger to assign the ID. -- Alan --

Re: [GENERAL] I'm no longer puzzled by a foreign key constraint problem

Jonathan Guthrie wrote: Tom Lane pointed out where to go from here re the server logging. It'll be interesting to see what turns up once you've got new logs that show the backend pid and the involved xid. I'll be keeping Mr. Lane's message for the logging tips. For my own part, since

Re: [GENERAL] serial data type usage

EXT-Rothermel, Peter M wrote: I have a table where I would like the primary key to be generated during the insert. Here is a simplified example: CREATE TABLE employee_type { tname varchar(10) PRIMARY KEY, id_prefix char(1) ; ... } tname | id_prefix --+--