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
(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
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.
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
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
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 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,
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 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
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 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
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
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
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
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
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
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
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
> 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
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
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
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
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
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:
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
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
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
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
[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-
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
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
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
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
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
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.
>
[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 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
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
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
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)
Can anyones suggest some readings about
implementing
sequences w/o holes ?
thanx in advance.
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
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
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
44 matches
Mail list logo
