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
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
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
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!
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 !
Thanks, everyone, for suggestions regarding QT. Idid find
a good book on QT in the computer section of a bookstore and spent quite some
time looking at it, the "hello world" exercise, and almost purchased it.
But I know from past experience that I am not going to make a lot of progress
Franco Bruno Borghesi wrote:
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
I am convinced that Tony Caduto is correct in everything he says about
Delphi.
If you are with some Company, and you have your full time to devote to
programming, and the support of a staff and a budget, why I am sure you can make
anything work for you. If you throw enough time and money
I suppose, with regard to the question of Delphi, one might simply line up
and summarize or itemize all of the items and points PRO and CON.
One finds such PRO and CON lists for Postgresql vs MySQL vs Oracle, for
Linux vs Windows,... for so many things.
But, its all analogous to an ocean
Ying Lu wrote:
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
One of your commands has an error, and the transaction has been aborted
because
Grant McLean wrote:
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
Mark Borins wrote:
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 FUNCTION unaccent(text) RETURNS text AS $$
BEGIN
RETURN translate($1, '\342\347\350\351\352\364\373',
I followed the new instructions (patch, autoconf,
configure --with-php=/usr/lib/apache/libphp5.so, etc.)
and get this error when running 'make':
make[3]: Entering directory
`/usr/local/src/postgresql-8.0.2/src/pl/plphp'
patching file php.h
Hunk #1 FAILED at 291.
1 out of 1 hunk FAILED -- saving
On Fri, 6 May 2005 07:50 pm, CSN wrote:
I followed the new instructions (patch, autoconf,
configure --with-php=/usr/lib/apache/libphp5.so, etc.)
and get this error when running 'make':
make[3]: Entering directory
`/usr/local/src/postgresql-8.0.2/src/pl/plphp'
patching file php.h
It
On Thu, May 05, 2005 at 03:21:40PM +0100, Peter Wilson wrote:
Why is this documentation on 'Christoper B. Browns homepage rather than
the Slony web pages? The 'official' Slony documentation I had available
was at :
http://gborg.postgresql.org/project/slony1/genpage.php?howto_idx
and
Hi Guys,
I am writing here again. Here is the scenario of my
problem:
I have Postgres 8.0.1 on Linux FC3 and everything
goes fine, except that a one time per week approximately I am getting server
crash with a message in log:
==
LOG: server process (PID
On May 5, 2005, at 5:03 PM, Grant McLean wrote:
Why would you need to take anything down to run pg_dump? And surely
bringing a slave up to speed using Slony would be much slower than
dump/restore?
You'd need to stop client access to PG to prevent changes from
occuring between when you take the
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Zlatko Matic)
wrote:
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
Hello All,
How do I create a cursor in psql .
I have a function which opens a cursor .
SampleDB=# create function reffunc(refcursor) returns refcursor as $$SampleDB$# beginSampleDB$# open $1 for select col from test;SampleDB$# return $1;SampleDB$# end;SampleDB$# $$ language sql;ERROR: syntax
Title: Extracting date from timestamp
How to extract date(mm/dd/yyy) from a timestamp .
On Fri, May 06, 2005 at 05:58:11AM -0700, Vidya wrote:
How do I create a cursor in psql .
I have a function which opens a cursor .
SampleDB=# create function reffunc(refcursor) returns refcursor as $$
SampleDB$# begin
SampleDB$# open $1 for select col from test;
SampleDB$# return $1;
On Fri, May 06, 2005 at 06:26:14PM +0530, Nageshwar Rao wrote:
How to extract date(mm/dd/yyy) from a timestamp .
You could cast the timestamp to date. See also Data Type Formatting
Functions and Date/Time Functions and Operators in the Functions
and Operators chapter of the documentation.
Peter Wilson wrote:
Grant McLean wrote:
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
Nageshwar Rao wrote:
How to extract date(mm/dd/yyy) from a timestamp .
See chapter 9.8. Data Type Formatting Functions, all about to_char()
If you just want your preset format you can use SELECT now()::date;
--
Richard Huxton
Archonet Ltd
---(end of
Michael Korotun wrote:
I have Postgres 8.0.1 on Linux FC3 and everything goes fine, except that a
one time per week approximately I am getting server crash with a message in
log:
LOG: server process (PID 5252) was terminated by signal 9
Sounds like something is sending SIGKILL (kill -9) to your
On Fri, 2005-05-06 at 07:54, Michael Korotun wrote:
Hi Guys,
I am writing here again. Here is the scenario of my problem:
I have Postgres 8.0.1 on Linux FC3 and everything goes fine, except
that a one time per week approximately I am getting server crash with
a message in log:
That's what was said 7 years ago. guess what it's still around and
going strong.
This is one of the most ridiculous arguments against using Delphi, every
year people
like you say this, then 7 years go by and your still wrong
The problem with Delphi is that it is uncertain where it will
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
It is just too bad that there is not a better, more user friendly, well
documented front-end tool for Postgresql in open source. It really is
kind of a
marketing issue, in a way. I mean, if someone could really put together
some
They are if you are doing any of your research at work :-)
I started using Delphi for shareware/hobby products and while the
initial investment was higher, I reap the benefits of a huge third party
and open source component environment.
Lets see, say you need a syntax highlighting editor
Michael Korotun wrote:
Yes, this is oom
Firstly it killed httpd and then postmaster. But who took all the memory? I
see there Free swap: 0Kb in the messages log - was it a reason?
Sounds likely.
I have 1GB of RAM. For shared memory I took about 262MB.
/etc/sysctl.conf
===
#shared
Greetings,
I tried to Vacuum table through JDBC. I got the following errors:
ERROR: VACUUM cannot run inside a transaction block
Does it mean I should only run vacuum through the command line such as
psql vacuum TableName ?
Thanks a lot,
Emi
---(end of
Ying Lu wrote:
Greetings,
I tried to Vacuum table through JDBC. I got the following errors:
ERROR: VACUUM cannot run inside a transaction block
Does it mean I should only run vacuum through the command line such as
psql vacuum TableName ?
Nope, it means exactly what the error says. You are
Hello all!
I've been working on a plpgsql function for the past couple of days and
have been wondering why it's been failing to update a table with
composite keys (where the key is a combination of two columns). I
thought it was a problem with my function code, but it appears to be
rooted
[EMAIL PROTECTED] (Tony Caduto) writes:
That's what was said 7 years ago. guess what it's still around
and going strong. This is one of the most ridiculous arguments
against using Delphi, every year people like you say this, then 7
years go by and your still wrong
I wasn't the one
On Fri, May 06, 2005 at 09:01:58AM -0400, Jeff - wrote:
slave and hten fire up dbmirror. Although it might work if you
install the dbmirror triggers, then dump restore.
It's a little trickier than that, but yes, it might work. Somewhere
in my mail archives, I have a very angry rant about
Michael Glaesemann [EMAIL PROTECTED] writes:
I thought that the unique key would be checked at the end of the update
statement:
No, it's never worked that way. Each row is checked as it is inserted.
With an example like this, you may or may not get a failure depending on
chance physical
On Thu, May 05, 2005 at 03:35:27PM +0100, Peter Wilson wrote:
Looking at Slony now, can someone tell me what the benefits of Slony are
over DBmirror? As far as I can see:
+ both are async Master-multiple slaves
+ both (I think) can do cascaded replication
This isn't really true of dbmirror.
Andrew Sullivan wrote:
On Thu, May 05, 2005 at 03:35:27PM +0100, Peter Wilson wrote:
Looking at Slony now, can someone tell me what the benefits of Slony are
over DBmirror? As far as I can see:
+ both are async Master-multiple slaves
+ both (I think) can do cascaded replication
This isn't really
[EMAIL PROTECTED] (Jeff -) writes:
On May 5, 2005, at 5:03 PM, Grant McLean wrote:
Why would you need to take anything down to run pg_dump? And surely
bringing a slave up to speed using Slony would be much slower than
dump/restore?
You'd need to stop client access to PG to prevent changes
Hi All,
Does Postgresql have a sql history of queries run capability?
Any ideas/pointers will be a great help. Could one capture the order
and SQL queries run?!
Thanks in advance and your help is appreciated.
Hrishi
---(end of broadcast)---
TIP
Peter Wilson wrote:
Andrew Sullivan wrote:
On Thu, May 05, 2005 at 03:35:27PM +0100, Peter Wilson wrote:
Looking at Slony now, can someone tell me what the benefits of Slony
are over DBmirror? As far as I can see:
+ both are async Master-multiple slaves
+ both (I think) can do cascaded
--- [EMAIL PROTECTED] wrote:
I was pleased with the progress I could make with Visual Basic and
Postgresql, as well as what I could do through MS Access. But it
would be so nice to have something that paints screens quickly and
allows one to develop things fast. Powerbuilder was nice
On Fri, 2005-05-06 at 12:48, Hrishikesh Deshmukh wrote:
Hi All,
Does Postgresql have a sql history of queries run capability?
Any ideas/pointers will be a great help. Could one capture the order
and SQL queries run?!
Thanks in advance and your help is appreciated.
There's a setting in
On Fri, May 06, 2005 at 12:09:14PM -0400, Chris Browne wrote:
What I need, for that, is a way of grabbing all the index definitions
for the table. One way to do that would be to run pg_dump -s -t a,
though I'd rather have a method that uses the connection I already
have to the database.
On Fri, May 06, 2005 at 05:42:38PM +0100, Peter Wilson wrote:
I got the lack of schema changes from the Slony documentation.
This seems odd. I see Brad already told you what to look for; but
putting schema changes in through slonik was _always_ part of the
design. What's always been true (and
I am not sure how I could encode the characters into UTF-8.
For example, I went to Unicode.org and looked up in the specs for lets say
an â is 00E2. If I wanted to do search for all names with an â in them how
would I do that?
00E2 into Octal is: 342
So would I do:
Select * from table where
Hrishikesh Deshmukh wrote:
Hi All,
Does Postgresql have a sql history of queries run capability?
Any ideas/pointers will be a great help. Could one capture the order
and SQL queries run?!
If you are using psql there is .psql_history.
Thanks in advance and your help is appreciated.
Hrishi
I'm using 9.3 and postgresql-8.0.1-6. I started Rekall which opens the
database connection wizard.
As the RDBMsS Server Type I pick the only one available:the Rekal PgSQL
Driver (Shouldn't there be drivers for other DB's in the type list also?)
The comment from the Rekal PgSQL driver
Hi,
I am new to PosGreSql and have problem connecting to PostGreSql from a
machine with pslodbc driver. I don't know what is wrong but in my
simple code to connect to the database using ODBCConnection from the
server machine, it does not send out error message when I specify the
server as
PostgreSQL 8.0.2 - Fedora 3
data_directory = '/usr/local/pgsql/data2' # use data in
hba_file = '/usr/local/pgsql/etc/pg_hba.conf' # the host-based #
ident_file = 'ConfigDir/pg_ident.conf' # the IDENT configuration file
external_pid_file = '/tmp/foo.pid' # write an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
your data directory points to /usr/local/pgsql/data2 and you've
started it with -D /usr/local/pgsql/etc
might be something to look at
regards,
- -
Jonel Rienton
http://homepage.mac.com/jrienton
Software Developer, *nix Advocate
On May 6,
Jonel Rienton wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
your data directory points to /usr/local/pgsql/data2 and you've
started it with -D /usr/local/pgsql/etc
might be something to look at
In version 8 you can specify the location of the data_directory with the
data_directory
dear readers,
i've created a simple Fooey table that inherits from Foo:
!--!
CREATE TABLE Foo(
fooid serial UNIQUE,
footype text);
CREATE TABLE Fooey(
datatext);
INHERITS(Foo);
I just tried the same setup as yours, and it worked fine, i was able
to start and stop the instance.
could it be that the process didn't start at all when you started it?
regards,
-
Jonel Rienton
http://homepage.mac.com/jrienton
Software Developer, *nix Advocate
On May 6, 2005, at 3:36 PM,
Joshua D. Drake [EMAIL PROTECTED] writes:
data_directory = '/usr/local/pgsql/data2' # use data in
-bash-3.00$ bin/pg_ctl -D /usr/local/pgsql/etc stop
Fixing this would seem to require teaching pg_ctl how to parse the
postgresql.conf file, which might be worth doing but it's a bit
you know what does work, if you issue the pg_ctl stop with /usr/local/
pgsql/data2 as the argument for -D
pg_ctl -D /usr/local/pgsql/data2 stop
odd tho.
On May 6, 2005, at 3:36 PM, Joshua D. Drake wrote:
Jonel Rienton wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
your data directory
On 06/05/2005 16:22 Ying Lu wrote:
Greetings,
I tried to Vacuum table through JDBC. I got the following errors:
ERROR: VACUUM cannot run inside a transaction block
Does it mean I should only run vacuum through the command line such as
psql vacuum TableName ?
You don't say what version of the
On Thu, May 05, 2005 at 11:07:10AM -0700, Don Laurine wrote:
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
On Fri, 6 May 2005, Aaron Steele wrote:
dear readers,
i've created a simple Fooey table that inherits from Foo:
!--!
CREATE TABLE Foo(
fooid serial UNIQUE,
footype text);
CREATE TABLE Fooey(
data
On Fri, May 06, 2005 at 01:51:45PM -0700, Aaron Steele wrote:
dear readers,
i've created a simple Fooey table that inherits from Foo:
!--!
CREATE TABLE Foo(
fooid serial UNIQUE,
footype text);
CREATE
Jonel Rienton wrote:
you know what does work, if you issue the pg_ctl stop with /usr/local/
pgsql/data2 as the argument for -D
pg_ctl -D /usr/local/pgsql/data2 stop
Yes that does work as it should. However as Tom Lane pointed out the
problem is that pg_ctl can't parse the postgresql.conf so if
On Fri, 2005-05-06 at 15:51, Aaron Steele wrote:
dear readers,
i've created a simple Fooey table that inherits from Foo:
!--!
CREATE TABLE Foo(
fooid serial UNIQUE,
footype text);
CREATE TABLE Fooey(
Hi Jerome,
You need to edit the pg_hba.conf file which controls the hosts Postgres will
allow to connect.
By default it's set to only allow connections from local host.
pg_hba.conf is located in the data directory of where you installed PG.
You can also tell a host to be TRUSTED, i.e no password
On May 7, 2005, at 1:10, Tom Lane wrote:
Michael Glaesemann [EMAIL PROTECTED] writes:
I thought that the unique key would be checked at the end of the
update
statement:
No, it's never worked that way. Each row is checked as it is inserted.
With an example like this, you may or may not get a
64 matches
Mail list logo