Hello,Unfortunately, I cannot get PostgreSQL to dump core despite setting ulimit -c to:[root@linux2 otis]# ulimit -acore file size (blocks) unlimitedAnd starting PostgreSQL this way:su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start"The backend doesn't want t
>
>People who have not studied the documentation frequently make that
>claim. *There is no such risk* (unless A and B are interleaving their
>commands on a single database connection, in which case they have lots
>worse risks of conflicts than this one). See
>http://www.ca.postgresql.org/users-l
Joel Stevenson <[EMAIL PROTECTED]> writes:
> Though, if you have multiple clients inserting into the table, there
> is a chance that between client A inserting the record and then
> calling currval(), client B could have performed an insert, in which
> case client A gets the value of client B's
> > "You say nextval() + write, I say write + currval()..."
>
>So long as a given application does not mix the two approaches, everything
>should be fine.
Though, if you have multiple clients inserting into the table, there
is a chance that between client A inserting the record and then
callin
My personal experience is that you MUST operate like:
SELECT nextval...
INSERT ...
I have several web sites that have many simultaneous updates occurring,
based on user interaction with the website and its underlying data
structures. I used to INSERT, then SELECT currval, and depending on
timi
On 6 May 2002 at 12:43, Joel Burton wrote:
> > -Original Message-
> > From: Dan Langille [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 06, 2002 12:41 PM
> > To: Joel Burton
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [ADMIN] SERIAL Field
> >
> > > In any event, inserting then using curr
> -Original Message-
> From: Dan Langille [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 06, 2002 12:41 PM
> To: Joel Burton
> Cc: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] SERIAL Field
>
> > In any event, inserting then using currval() is the standard practice
> > around here, and it works
On 6 May 2002 at 10:51, Joel Burton wrote:
> > But the very idea of inserting the value and then retriving the sequence
> > number sounds fishy to me. Why not get the sequence number first and than
> > insert using that seqnce number (more on the flash tutorial ).
That's pretty standard in a num
> -Original Message-
> From: Joel Burton [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 06, 2002 10:51 AM
> To: Rajesh Kumar Mallah.; Gaetano Mendola; [EMAIL PROTECTED]
> Subject: RE: [ADMIN] SERIAL Field
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PRO
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Rajesh Kumar
> Mallah.
> Sent: Monday, May 06, 2002 9:26 AM
> To: Gaetano Mendola; [EMAIL PROTECTED]
> Subject: Re: [ADMIN] SERIAL Field
> But the very idea of inserting the value and then retriving th
Sorry, this is a duplicate sent before I subscribed to the group--it was
stalled, so I resent after subscribing. This question has been answered.
Thanks,
// mark
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Mark McEahern
> Sent: Friday, May 03
"otisg" <[EMAIL PROTECTED]> writes:
> What gets logged in syslog log file are things like this:
The messages you quoted are no help, because none of them directly
show the crashing backend.
What I'd recommend doing is gdb'ing the core dump file to get a stack
trace; that would give us some clue
Hi Gaetano,
Postgresql implements serial field using sequences.
detailed description of sequences are avaliable at
http://www.postgresql.org/idocs/index.php?functions-sequence.html
a NICE flash tutorial is also available at:
http://techdocs.postgresql.org/college/001_sequences/
the specific a
> Hi all,
>
> having a table with a serial field what is the corrected method
> to retrieve the value after an insert ?
Use currval(_name_of_sequence_):
joel=# create table test ( id serial );
NOTICE: CREATE TABLE will create implicit sequence 'test_id_seq' for SERIAL
column 'test.id'
NOTICE:
Hi, the name datatype, which is used at least here:
pg_database.datname
pg_shadow.usename
is a 31 character field. That seems awfully low. For instance, what if I'm
silly enough to want to make a database named:
customer_GUID
where GUID is something like:
0ff
Hi all,
having a table with a serial field what is the corrected method
to retrieve the value after an insert ?
Ciao
Gaetano
--
#exclude
#include
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");
---(end of broadcast)---
TIP 5: Have
16 matches
Mail list logo
