Hello.
It seems that many people fanatically recommend Delphi, while others
fanaticaly despise Delphi. I've sent a question about comparative features
of MS Access/Visual Studio/Delphi for working with databases to a newsgroup
and people started to quarell instead of argumenting anything !
Inte
I have been using system calls like top.. free... vmstat
Are there any better ways by which i monitor the database to get the most out of it in terms of performance
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
CSN wrote:
> I like Postgres's boolean type - why do you suppose
> neither Mysql nor Oracle has bothered to implement it?
> Booleans are in the SQL-99 spec.
Fear of breaking old applications
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcas
Mark Borins wrote:
> My problem is that the values like \342 are for LATIN1 type encoding.
> I have tried and failed to get this working using the what I think
> is the Unicode escaping method \u0032 for example.
There is no Unicode escaping method. You need to encode the characters
into UTF-8
On Wed, May 04, 2005 at 12:08:47PM -0700, Joshua D. Drake wrote:
> Firebird is a nice database but I don't think it can scale as well as
> PostgreSQL. IIRC they just added support for SMP. Also, although their
> community is very active I do not believe it is as large nor does it
> have the comm
On Thu, May 05, 2005 at 15:46:16 -0700,
Daniel Browning <[EMAIL PROTECTED]> wrote:
> [I posted this recently to ports, but I think this is a more proper location]
>
> Is anyone working on an 8.0.2 RPM for x86_64 on Red Hat Enterprise
> Linux 4? There is a i686 version for RHEL4, and a x86_64 ve
On Thu, 5 May 2005, Tony Caduto wrote:
Programmers Paradise has delphi in their catalogs...
I haven't used any Microsoft or Winduhs software for about eight years
now,
but I beleive that you can get -- for free -- Qt for winduhs. If you do this,
you get the Qt Designer included. This is a GUI GU
On Thu, May 05, 2005 at 04:28:43PM -0700, Rich Shepard wrote:
> On Thu, 5 May 2005, Tony Caduto wrote:
>
> >Programmers Paradise has delphi in their catalogs...
>
> I haven't used any Microsoft or Winduhs software for about eight years
> now,
> but I beleive that you can get -- for free -- Q
[I posted this recently to ports, but I think this is a more proper location]
Is anyone working on an 8.0.2 RPM for x86_64 on Red Hat Enterprise
Linux 4? There is a i686 version for RHEL4, and a x86_64 version for RHEL3,
but no combination of the two.
Curious, because I would like to upgrade to
Programmers Paradise has delphi in their catalogs...
If you call borland and tell them you want to do a competive upgrade for the
old VB you are using
they will let you buy the upgrade to Delphi 2005 PRO. You have to ask.
Like I said before you get what you pay for and all this time you have bee
http://www.microolap.com/products/database/mydbacentral/
I was hoping to find a GUI Rapid Application development for Postgresql similar to the above. The above is the only thing I could find, but it seems to support only MySQL and not PostgreSQL. I am so anxious to find such a tool, if it woul
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Scott Marlowe) would
write:
> On Wed, 2005-05-04 at 21:06, Vlad wrote:
>> the number one aim at the moment is to have "always-up-to-date" copy
>> of our main DB with minial performance impact on replication
>
> Have you considered point in
On Thu, 2005-05-05 at 14:16 -0400, Jeff - wrote:
> One of the biggest things for Slony is that you can install slony,
> set things up and it will bring the slave(s) "up to speed". You
> don't need to do an initial data dump (I think you still need to load
> the schema on the slaves, but not
Greetings,
Through java - JDBC, trying to do "select * from Table" using "lock
table IN SHARE MODE"; Always got this error:
"current transaction is aborted, commands ignored until end of
transaction block"
Some clues about it?
Thanks a lot!
Emi
---(end of broadcast)-
No, I don't believe it has anything to do with the time delay. We've done
random spot checks in the past (select count(*) from pg_stat_activity) and
it's reported zero connections (and obviously, we're connected at the time
of the query). This query was issued in a VB app and delivered via ODBC,
I am trying to write an unaccent function because I
need to do some queries comparing data that has accents and data that does not.
The encoding on my DB is Unicode, so far I have found
an unaccent() function by looking in the mail archives it looks like the
following:
CREATE FUNCTI
--- Dann Corbit <[EMAIL PROTECTED]> wrote:
> > why do you suppose
> > neither Mysql nor Oracle has bothered to implement
> it?
>
> Probably they just create a domain using a char
> which can take on two
> values (e.g. 't'/'f' or 1/0). Oracle 10 has a bit
> data type (which is a
> boolean for all
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of CSN
> Sent: Thursday, May 05, 2005 11:57 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Booleans - Why in Postgres and not in Oracle or
Mysql?
>
> I like Postgres's boolean ty
Replication is the only thing that remains, and there appears to be
commercially viable solutions for that, as well, though we've not yet
There are two very popular replication solutions, one of them is OSS
which is Slony-I. The other is commercial which is Mammoth PostgreSQL
Replicator.
imple
I like Postgres's boolean type - why do you suppose
neither Mysql nor Oracle has bothered to implement it?
Booleans are in the SQL-99 spec.
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
On Thu, 5 May 2005, John DeSoi wrote:
Sure. I actually started to write that, but then assumed this would be
known by anyone who created 300 schemas :).
John,
Ah, assumptions! :-)
It is certainly my preference over worrying about the search_path. But if
you are working in 300 schemas with the sam
Based on the extensive feedback here, as well as other information from other
websites found since asking here, I've decided that I'm still, very happily,
a PG user.
No significant issues to date - PG has "just worked" for me for 5 years now,
and the frustrating limitations (EG: alter table dr
On May 5, 2005, at 11:27 AM, Rich Shepard wrote:
Pardon my ignorance, but why wouldn't it work to specify the schema
with
the table; e.g., update myschema.table1?
Sure. I actually started to write that, but then assumed this would be
known by anyone who created 300 schemas :).
It is certainly
template1=# \d bar
Table "public.bar"
Column |Type | Modifiers
--+-+---
happened | timestamp without time zone |
template1=# select happened::varchar from bar;
happened
-
2005-
On May 5, 2005, at 10:35 AM, Peter Wilson wrote:
I couldn't get it to work - and having tried another couple of
solutions I settled on DBMirror which comes with Postgres in the
'contrib' directory.
I've had no issues setting up slony. I've even had it running in a 6
node cluster with no i
We are currently transitioning to Postgresql 7.4 from Informix. IN ECPG,
is there a Postgresql function which will convert the timestamp data
type to a string equivalent. INFORMIX has the dtcvasc function but I
prefer not to use the -C compatibility option. I rather have a complete
port and get aw
"A. Mous" <[EMAIL PROTECTED]> writes:
> I've been using 8.0 ever since beta 1, and am currently on 8.0.1. I have
> noticed (in each version) that the number of records in the pg_stat_activity
> table is not always representative of the number of connections to the
> server. That is, we have an in
I've been using 8.0 ever since beta 1, and am currently on 8.0.1. I have
noticed (in each version) that the number of records in the pg_stat_activity
table is not always representative of the number of connections to the
server. That is, we have an installation at a client's site that runs a
nigh
On Thu, 5 May 2005, John DeSoi wrote:
However when I update the base table in schema MySchema the trigger
tries to insert/update a record in the public schema and not the Current
schema (ie the schema of the original table). Is there a system variable
for Current Schema ? &. If not what is th
John Browne <[EMAIL PROTECTED]> writes:
> I was just curious about what would happen given the following scenario:
> - Unix user has their own tablespace (and corresponding database)
> stored in /home/someuser/mydata
> - Quotas are enabled on /home
> - User reaches their quota, effectively causing
On Wed, 2005-05-04 at 21:06, Vlad wrote:
> the number one aim at the moment is to have "always-up-to-date" copy
> of our main DB with minial performance impact on replication
Have you considered point in time recovery as implemented in 8.0?
While it does require some small amount of work to bring
Vlads thread on Slony against PGcluster made me go back to take another
look at Slony. I'd tried to get it going back in February when I needed
to build some replicated databases. Slony was my first choice because it
seemed to be the current 'hot topic'.
I couldn't get it to work - and having t
On May 5, 2005, at 8:32 AM, Paul Newman wrote:
I have a public schema with all my tables in it.
I also have a schema for each company that uses our system .. so 300
companies = 300 schemas. One of the tables has a trigger that is
trying to insert/update another table that is inside the same sch
Hi guys
I'm trying to figure out a way to make this select work even for a wrong value:
select mean_and_variancepop('golf', 'temperature');
or
select CAST (mean_and_variancepop('golf', 'temperature') AS float(2));
This function return an array
the function is:
CREATE or replace FUNCTION mean_
You could write a trigger like this:
CREATE OR REPLACE FUNCTION checkDate() RETURNS TRIGGER LANGUAGE 'plpgsql' AS '
DECLARE
limitDate DATE DEFAULT current_date-''1 year''::INTERVAL;
BEGIN
IF (OLD.date<=limitDate) THEN
RAISE EXCEPTION ''Cannot change record.'';
END IF;
RETURN NEW;
END;
';
C
Christopher Browne wrote:
Martha Stewart called it a Good Thing when Peter Wilson <[EMAIL PROTECTED]>
wrote:
I looked at Slony, which seems to be a current favourite -but I
couldn't get it working on my database (claimed my tables didn't have
relevant keys - which they do). Slony-I had almost non-
On Wednesday 04 May 2005 09:35 am, Fmiser wrote:
> I'm a newbie to database admin, but I'm not afraid to try - but this one
> has me stumped.
>
> I'm using SQL-Ledger as a front end to postgresql 7.4.2. on (mostly)
> Debian Testing, i386.
>
> My fiscal year is over and I would _like_ to prevent any
I was just curious about what would happen given the following scenario:
- Unix user has their own tablespace (and corresponding database)
stored in /home/someuser/mydata
- Quotas are enabled on /home
- User reaches their quota, effectively causing only this tablespace
to run out of disk space.
"Fmiser" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'm a newbie to database admin, but I'm not afraid to try - but this one
> has me stumped.
>
> I'm using SQL-Ledger as a front end to postgresql 7.4.2. on (mostly)
> Debian Testing, i386.
>
> My fiscal year is over and I would
Martha Stewart called it a Good Thing when Peter Wilson <[EMAIL PROTECTED]>
wrote:
> I looked at Slony, which seems to be a current favourite -but I
> couldn't get it working on my database (claimed my tables didn't have
> relevant keys - which they do). Slony-I had almost non-existent
> documenta
Joshua D. Drake wrote:
Benjamin Smith wrote:
As a long-time user of Postgres, (First started using it at 7.0) I'm
reading recently that Firebird has been taking off as a database.
Perhaps this is not the best place to ask this, but is there any
compelling advantage to using Firebird over Postgres
I'm a newbie to database admin, but I'm not afraid to try - but this one
has me stumped.
I'm using SQL-Ledger as a front end to postgresql 7.4.2. on (mostly)
Debian Testing, i386.
My fiscal year is over and I would _like_ to prevent any changes to the
data from last year.
I looked/searched in th
Vlad wrote:
Hello,
in need to increase reliability of the service (and perhaps eventually
offload main DB server) we are looking to setup replication for the
database server. I found two solutions:
Slony ( http://gborg.postgresql.org/project/slony1/projdisplay.php )
PGCluster ( http://pgfo
Hi,
I have a public schema with all my tables in it.
I also have a schema for each company that uses our
system .. so 300 companies = 300 schemas. One of the tables has a trigger that
is trying to insert/update another table that is inside the same schema. So far
so good. However when I u
On Wed, May 04, 2005 at 10:06:03PM -0400, Vlad wrote:
> so at the point any of slony and pgcluster works for me, but before I
> start messing with any, I wanted to hear real users opninon about
> those (or different) packages :)
Well, Afilias (my employer) sponsored/sponsors Slony development. We
Dinesh Pandey wrote:
> I am using Postgres. How can I send execution log into a file.
>
>
>
psql -o filename
I also recommend:
psql -H -e -o filename
Mage
---(end of broadcast)---
TIP 7: don't forget to increase your free space map setti
I am using Postgres. How can I send execution log into a
file.
Testdb=>\i MyCreateScript.sql
Thanks
Update:
it might be not plpython, but similar to the plperl bug I found last time.
The script which can produce the bug:
create table test (id int, date timestamp);
create or replace function trigger_test() returns trigger as $$
plpy.info(TD['new'])
return 'MODIFY'
$$ language plpytho
I have a plpgsql function that I am generating from time to time, like
once a week or so. What it does is it compares some phone numbers for
certain prefixes and then outputs the phone numbers without the
prefixes.
First I tried to make the function read from the database the prefixes,
but w
Title: RE: [GENERAL] Postgres 8.02 connectivity
Hi Richard
I worked out what the problem was.
I needed an IP Mask(subnet) after the IP.
255.255.255.0 solved that
Thanks again for you help!!
Kind Regards,
Shaun Clements
-Original Message-
From: Richard Huxton [mailto:dev@archonet
Shaun Clements wrote:
Thanks.
Firewall was the problem.im going to kill the technician who installed
windows :)
Im now coming up with a new error.
Missing or erroneous pg_hba.conf file.
Ive added the following line.
Host all all myip trust
Try a /32 on the end of the client's ip:
hostall
Shaun Clements wrote:
Hi All
I have been quite content with postgres, until a recent installation on a
windows box, in an attempt to setup a new server.
There is an option when you install Postgres, to allow other computers to
connect to the DB server. I selected that option, so I can connect over
Vlad wrote:
Hello,
in need to increase reliability of the service (and perhaps eventually
offload main DB server) we are looking to setup replication for the
database server. I found two solutions:
Slony ( http://gborg.postgresql.org/project/slony1/projdisplay.php )
PGCluster ( http://pgfoundry.org
Title: [GENERAL] Postgres 8.02 connectivity
Hi All
I have been quite content with postgres, until a recent installation on a windows box, in an attempt to setup a new server.
There is an option when you install Postgres, to allow other computers to connect to the DB server. I selected that
54 matches
Mail list logo
