To the PostGresQL mastermind:
Working with postgresql and SQL in general is a blast. However, I need
advice on how best to form the following query. I'm sure there are a dozen
different ways to do it. Please give me your suggestion:
I want to publish a "Link of the Day" on my website, with title
> I looked in the FAQs, lists, docs, etc but couldn't find an answer to my
> question.
> Is there a way to specify an unsigned int, such that it would create an
> ERROR condition if a transaction
> were to attempt to cause a particular value to go negative. This would
> be very useful to me.
> I w
I had the same problem with 6.5.3. It turns out that there is a "known"
(at least to the developers; I haven't seen it documented anywhere) problem
in 6.5:
if your postgresql was compiled with Locale support on, index searches of
the form
LIKE 'foo%' go very, very slow (much slower than deleting t
I looked in the FAQs, lists, docs, etc but couldn't find an answer to my
question.
Is there a way to specify an unsigned int, such that it would create an
ERROR condition if a transaction
were to attempt to cause a particular value to go negative. This would
be very useful to me.
I would like to b
What are the "nl" RPMs and when should I use them?
-=michael=-
*
* Michael S. Kelly
* 4800 SW Griffith Dr., Ste. 202
* Beaverton, OR 97005 USA
* voice: (503)644-6106 x122 fax: (503)643-8425
* <[EMAIL PROTECTED]>
* http://www.axian.com
I see that the code has this coded in using a constant.
Anyone know if I can up the length of this safely?
We have queries that WAY exceed this limit!
It's amazing wha the PHPLIB and session variables can do to make
PostgreSQL's life misery!
Brad
Hello,
When I do (as postgres):
bash$ psql mydb
I get:
Connection to database 'mydb' failed.
FATAL 1: cannot create init file pg_internal.init
I'm not out of disk space. What's wrong? Where is it trying to create these
files? Is it a permissions issue? Is it a libraries problem? Mine are in:
/
"Glerum, Joe - KyEM" wrote:
> Database system in directory /usr/local/pgsql/data is not compatable
> with this version of Postgres, or we are unable to read the PG_VERSION file.
> Explanation from the ValidatePgVersion: Version number in file
> '/usr/local/pgsql/data/PG_VERSION' should be
- Original Message -
From: Michael Black <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 02, 2000 9:17 PM
Subject: [GENERAL] Re: ODBC Interface questions
> I am using the Insight ODBC driver version 6.40.0009 on a Win98 box and
> Access 97.
> I set it up as a System DNS.
that's true but that still assumes you know the pasword.
also someone mentioned that you can just su to any account,
well that's true but it still doesn't negate teh fact that the
user has a passwd on thier database. as i said, i think
the postgres user should have acess to all databases no matte
>> Now if you make pgsql user and postgresql analgous to
>> root and unix, the postgres user shouldn't need a passwd.
>My root users always have passwords. *shrug* But you're right, automated
>backup on password protected databases is next to impossible right now,
>especially when using pg_dump.
Hello,
I would like to proceed to word search in a table.
Use of "[...] attribute~*'string';" in the condition were fine. However,
presence of operators within the string give me an error.
For example :
[...] attribute~*'C++';
To unspecialise the operators could be a way of solving this.
Do you
Hi all,
I am a Postgres novice,so please excuse if my question looks rather dumb.
I need to log all commited transactions externally on a backup server as
soon as they are commited. What would be the best way to do it efficiently?
Originally, in the first design of my 3-tier-system, I planned to
On Fri, 31 Mar 2000 15:20:29 GMT, "anonymous" <[EMAIL PROTECTED]> wrote:
>The default editor when i invoke "\e" in "psql" it is "vi". How can I
>replace the
>editor with something else?
> Thanks,
>Rafael.
Title: RE: [GENERAL] Embedded SQL -- ecpg
You send them through the ecpg pre-compiler first, which replaces all the EXEC SQL statements with C, and then compile. When you compile, make sure that you link to the correct libraries (RTFM).
MikeA
>> -Original Message-
>> From: Nile
Hi, folks.
I'm having some trouble with inheritance in 6.5.3; first off, PRIMARY KEY
attributes don't seem to be inherited.
For example,
CREATE TABLE test (i integer primary key);
CREATE TABLE test2 (j integer) INHERITS(test);
then
INSERT INTO test VALUES (1);
INSERT INTO test VALUES (1);
co
Sorry for my bad english!
Can I use "DECLARE CURSOR" in plpgsql function?
I have :
create table ipacc(ip_from inet,
sourse_ports int2,
ip_to inet,
dist_port,
bytes int4,
On Mon, 3 Apr 2000, Jeff MacDonald wrote:
> SQL-92 - is this an ansi standard ?
Yes. Also ISO and IEC.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
At 04:23 AM 03-04-2000 -0400, Mike Mascari wrote:
>>
>> Does MySQL turn off sync? I don't think it does, but it seems to be able to
>> do updates (and thus syncs) a lot faster. I know postgresql has got
>> transactions and all that, but from the "time" statistics, the CPU isn't
>> really being pu
Lincoln Yeoh wrote:
>
> Hi,
>
> I was doing a few tests to optimize my perl web app, and this is what I got.
>
> without database: 140 hits/sec
> with a rollback/begin and a select: 90 hits/sec
> with a rollback/begin, select and an update (but no commit): 70 hits/sec
> with a rollback/begin, s
At 02:51 PM 3/04/00 +0800, Lincoln Yeoh wrote:
>Hi,
>
>I was doing a few tests to optimize my perl web app, and this is what I got.
A few questions, if you don't do the commit, then you loose your data,
so there isn't much point in doing that is there ...
How much RAM does you machine have?
Whe
Hi,
I was doing a few tests to optimize my perl web app, and this is what I got.
without database: 140 hits/sec
with a rollback/begin and a select: 90 hits/sec
with a rollback/begin, select and an update (but no commit): 70 hits/sec
with a rollback/begin, select + update + commit: 13 hits/sec
A
22 matches
Mail list logo
