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
--+--
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, si
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
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 w
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
exec
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
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 i
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
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 de
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$ .
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
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
A
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\bin>runas /user:postgres2 "cmd /k"
Wil
13 matches
Mail list logo