Am Montag, den 19.12.2005, 09:39 + schrieb Marian Naghen:
> I want to insert records inside a transaction block (BEGIN -
> COMMIT/ROLLBACK). If the transaction fails,
> the sequence do not rollback and retain the new value.
>
> This is the default behavior of sequences ?
Yes it is (its the
Okay, all clear.
Thanx a lot.
- Original Message -
From: "Tino Wildenhain" <[EMAIL PROTECTED]>
To: "Marian Naghen" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, December 19, 2005 7:50 AM
Subject: Re: [GENERAL] sequences in transaction blocks
> Am Montag, den 19.12.2005, 09:39 + schrieb
Sim Zacks wrote:
I've been having problems with bools in my Access frontend and
PostGreSQL backend. The problem is that Access uses -1 for true and 0
for false and when it does a select it uses those numbers instead of the
true or false values. PostGreSQL does not have an implicit conversion
f
Can anyones suggest some readings about
implementing
sequences w/o holes ?
thanx in advance.
Marian Naghen schrieb:
Can anyones suggest some readings about implementing
sequences w/o holes ?
not w/o a busload of race conditions and/or heavy locking.
Usually you want to avoid this.
So are you really sure you dont just want if for cosmetics?
---(end of broadcast)
On Dec 19, 2005, at 20:14 , Marian Naghen wrote:
Can anyones suggest some readings about implementing
sequences w/o holes ?
Check the mailing list archives. In short, if you want to guarantee
no holes, you don't use sequences. IIRC, the process is:
1. Set up another table (foo) that holds
On 19.12.2005, at 12:14 Uhr, Marian Naghen wrote:
Can anyones suggest some readings about implementing
sequences w/o holes ?
Question: why?
I doubt that this is possible without heavy locking, which kills your
performance.
cug
--
PharmaLine Essen, GERMANY and
Big Nerd Ranch Europe - Pos
Hi,
On Sat, 2005-12-17 at 09:19 -0800, Joshua D. Drake wrote:
> >This patch should be sent to SuSE, not PostgreSQL.
> Actually, I think this should be incoporated into a spec file
> specifically for suse within the PGDG rpms.
Well... PGDG RPM Building Project only aims to build RPMs for Red Hat
[snip]
> Trouble is, you can never guarantee that you're dealing with actual words.
> What of you're comparing someone's password that happens to contain
> combination of letters that act in this way?
Well, in this case why would you care about how passwords are sorted ?
:-)
I think if the st
Hi,
On Mon, 2005-12-19 at 02:25 +0800, David Ang wrote:
> ---
> [EMAIL PROTECTED] tsearch2]# gmake installcheck
> gmake -C ../../src/test/regress pg_regress
> gmake[1]: Entering directory
> `/home/hstudy/postgresql-8.1.1/src/test/regress'
> gmake[1]: `pg_regress' is up to date.
>
On Sat, Dec 17, 2005 at 05:01:15PM -0500, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > I think the real solution is to implement COLLATE support.
>
> Maybe so, but we still need to figure out what we're doing for the back
> branches, and that won't be it ...
To be honest, there are reall
Hello,
I am a PostGreSQL newbie. I work with the 8.1.0 release on AIX 5.3, with
300GB of datas.
Some of the queries launched on this database finish with an "*out of
memory*". The queries which have failed contain a lot of join (between 6
tables), sub-select and aggregate. For these queries, t
Michael Fuhr writes:
On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
Any reason why a database would not get dumped by pg_dumpall?
Always run pg_dumpall as the superuser.
As the operating system superuser or as a database superuser?
There's a difference.
As the database sup
Michael Fuhr writes:
On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
Any reason why a database would not get dumped by pg_dumpall?
Always run pg_dumpall as the superuser.
Researched what was lost. It seems that all databases after a particular
database, called test, were no
Csaba Nagy <[EMAIL PROTECTED]> writes:
>> Trouble is, you can never guarantee that you're dealing with actual words.
>> What of you're comparing someone's password that happens to contain
>> combination of letters that act in this way?
> Well, in this case why would you care about how password
[EMAIL PROTECTED] (DANTE ALEXANDRA) writes:
> I am a PostGreSQL newbie. I work with the 8.1.0 release on AIX 5.3,
> with 300GB of datas.
> Some of the queries launched on this database finish with an "*out of
> memory*". The queries which have failed contain a lot of join (between
> 6 tables), sub-
Martijn van Oosterhout writes:
> On Sat, Dec 17, 2005 at 05:01:15PM -0500, Tom Lane wrote:
>> Maybe so, but we still need to figure out what we're doing for the back
>> branches, and that won't be it ...
> To be honest, there are really only a handful of locales that suffer
> from this issue, so
Chris Browne wrote:
> The problem is probably that the memory model is throttling you to
> *WAY* less than 2GB of memory.
>
> You may want to try a 64 bit build. With GCC, this requires something
> like the following ./configure incantation...
>
> CC="gcc -maix64" LDFLAGS="-Wl,-bbigtoc" ./con
I am trying to install and compile libpq++ i get this error configure: error:Can't find libpq-fe.h in . Are you sure the libpqheaders are installed correctly? They should be in the directory returned by"pg_config --includedir". If you do have libpq (the C-language client library for PostgreS
DANTE ALEXANDRA <[EMAIL PROTECTED]> writes:
> I am a PostGreSQL newbie. I work with the 8.1.0 release on AIX 5.3, with
> 300GB of datas.
> Some of the queries launched on this database finish with an "*out of
> memory*". The queries which have failed contain a lot of join (between 6
> tables), s
Hi,
Can anyone show me a simple way of creating an index
in PostGre like that:
create index indName on someTable(someIntColumn DESC)
?
Thanks In Advance,
Emil
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http:
I am not very good at this but you might wanna try -I (--include) compile option for the path ./postgresql-8.x.x/src/include and try if it works ...thanks,vishOn 12/19/05,
salah jubeh <[EMAIL PROTECTED]> wrote:
I am trying to install and compile libpq++ i get this error configure: error:Ca
So, is there no way i can version the stored procedures or tables.Has anyone done anything similar.Does any system table have a description or any field i could store the version for the tables/stored procedures/views.
thanks jim, but i think, If its just 20% tables changing and that two in a sub-s
CREATE INDEX code_idx ON films(code) TABLESPACE indexspace;http://www.postgresql.org/docs/8.1/interactive/sql-createindex.html
vishOn 12/19/05, Emil Rachovsky <[EMAIL PROTECTED]> wrote:
Hi,Can anyone show me a simple way of creating an indexin PostGre like that:create index indName on someTable(som
Emil Rachovsky wrote:
>
> Hi,
> Can anyone show me a simple way of creating an index
> in PostGre like that:
> create index indName on someTable(someIntColumn DESC)
> ?
Not using that particular syntax, but you can do that if you create the
appropiate operator classes. Note that if you want to u
> You might want to consider setting up a gmail account. It's excellent
> for reading email from the web. About 1,000 times nicer than the one
> I've used that comes with Exchange Server (when accessing it with
> firefox/mozilla)
Scott,
I need to pgsql.general mails in my notebook offline when
Devrim GUNDUZ wrote:
> Well... PGDG RPM Building Project only aims to build RPMs for Red Hat
> and Fedora Core. This has been so before, and personally *I* intend to
> continue with the same policy.
I specifically recall that this was once exactly not the policy, but of
course you are free to do
1. Adjust the description of the pgfoundry project pgsqlrpms to
something like "This project aims to build PostgreSQL RPMS for Red Hat
and Fedora and maintain them."
2. When you put them on the FTP server, put them in a subdirectory
"redhat" (instead of or below "linux") to avoid that users
Hi,
On Mon, 19 Dec 2005, Joshua D. Drake wrote:
Devrim perhaps we should talk with the OpenSuSE guy about getting his RPMS up
there as well?
We once did that; but SuSE could not keep up2date with the new versions. I
don't know the current status, though. We'd be happy to mirror them in
our
Hi,
On Mon, 19 Dec 2005, Peter Eisentraut wrote:
1. Adjust the description of the pgfoundry project pgsqlrpms to
something like "This project aims to build PostgreSQL RPMS for Red Hat
and Fedora and maintain them."
Done.
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
Postgr
On Mon, Dec 19, 2005 at 10:08:12AM -0500, Tom Lane wrote:
> "Let's not fix it" is really not an acceptable answer, because the
> behavior in the affected locales is entirely broken (inconsistent,
> etc). And how do you know which locales are affected, anyway?
I don't know which locales are affect
Each week I have to
update a very large database. Currently I run a commit about every
1000 queries. This vastly increased performance but I am wondering if the
performance can be increased further. I could send all of the queries to a
file but COPY doesn't support plain queries such as
Joshua D. Drake wrote:
> /pub/mirrors/postgresql/binary/v8.1.1/linux/rpms
>
> 227 Entering Passive Mode (128,111,24,43,254,97).
> 150 Opening ASCII mode data connection for file list
> drwxr-xr-x 7 ftp ftp 512 Dec 13 15:35 fedora
> drwxr-xr-x 8 ftp ftp 512 Dec 17
On Sat, Dec 17, 2005 at 03:47:54PM -0500, Tom Lane wrote:
> It'd be a good idea to settle on what we want the installed file layout
> to be --- do we need to create subdirectories under {prefix}/doc to
> forestall name conflicts?
README is probably fine for most of what's in contrib, but for other
On Sun, Dec 18, 2005 at 07:29:45AM +, Karl O. Pinc wrote:
>
> On 12/17/2005 10:21:39 PM, Michael Glaesemann wrote:
> >
> >On Dec 18, 2005, at 13:25 , Karl O. Pinc wrote:
> >>On a related note is there some reason why
> >>interval + int
> >>does not result in the interval plus int number
> >>of
On Sun, Dec 18, 2005 at 08:55:37AM -0500, John DeSoi wrote:
>
> On Dec 18, 2005, at 3:50 AM, Chris Velevitch wrote:
>
> >(for v7.4.5) How do I get the number of rows updated by an update
> >command?
>
> In general, the UPDATE command tells you the number of updated rows:
See also
http://www.p
Peter Eisentraut wrote:
Joshua D. Drake wrote:
/pub/mirrors/postgresql/binary/v8.1.1/linux/rpms
227 Entering Passive Mode (128,111,24,43,254,97).
150 Opening ASCII mode data connection for file list
drwxr-xr-x 7 ftp ftp 512 Dec 13 15:35 fedora
drwxr-xr-x 8 ftp ftp
On Mon, Dec 19, 2005 at 08:35:14AM -0800, vishal saberwal wrote:
> So, is there no way i can version the stored procedures or tables.
> Has anyone done anything similar.
> Does any system table have a description or any field i could store the
> version for the tables/stored procedures/views.
No,
On Mon, Dec 19, 2005 at 11:44:15AM -0800, Benjamin Arai wrote:
> Each week I have to update a very large database. Currently I run a commit
> about every 1000 queries. This vastly increased performance but I am
> wondering if the performance can be increased further. I could send all of
> the q
On 12/19/2005 04:11:09 PM, Jim C. Nasby wrote:
Another option would be creating a set of timestamp math functions;
that
would probably help cut down on the number of questions about this.
I solved it by converting to numeric. Here's my functions. (I haven't
tested the spm (seconds past mid
Joshua D. Drake wrote:
> I don't know about that because I am hoping to start provided .debs as
> well and
> .debs are going to be at a minimum /linux/debs/ubuntu
and /linux/debs/debian
But Debian packages are not only available on Linux. (The same is
reportedly true of RPM, but I don't know o
Hi, Is there a way to send a "show all" to a specific backend? Thanks! Benkendorf!
Yahoo! doce lar. Faça do Yahoo! sua homepage.
(Sorry for the spam but pgsql-announce refuses to recognize my mail..._
PgBrowse ver 1.5 is a generic Postgresql database browser that works on
Windows, Macintosh and Linux platforms that is written in Tcl/Tk.
A Starpack is available for Linux/x86 and an application bundle
is available for MacOSX
There are 3 bool possibilities in the ODBC driver
1) bools as char
2) true = -1
3) default (whatever that is, neither option is chosen)
When it is the default (my current setting) or (True =-1 and not bools
as char), then Access recognizes the data type as Yes/No. However, if
you do a compariso
44 matches
Mail list logo
