On Wed, 24 Jan 2001, Willis, Ian (Ento, Canberra) wrote:
speed with tranactions on
row level locking
I though that postgresql had more data type
no, MySQL has 'type of the week' contests to see how many non-compliant
types they can think of, and add them ...
Helo all,
Please try this script, it will crash the current connection.
I'm using the 01/18/2001 PostgreSQL v7.1 beta3 snapshot.
-- Script begin -
create table blah(
var_field varchar(8),
n1 integer default 23,
n2 integer,
arr_str varchar[],
Nick Worth wrote:
Hi,
I have recently started porting some stuff from Oracle to PostgreSQL, and am
having trouble with the following construct from Oracle:
DELETE FROM serviceproviders sp1
WHERE exists (SELECT 1
FROM serviceproviders sp2 where
thanks for the response, with UltraDEV 4.0 the problem seems to be solved.
Joel Bernstein [EMAIL PROTECTED] 19.01.2001 16.49 Uhr
I have not tried prepareCall with postgreSQL but it makes sense
that it would not be implemented.
prepareCall is a JDBC method used to call stored procedures in a
"Robert M. Craver II" wrote:
I cannot successfully execute the sql statement:
SELECT percentage, MAX(start_date) FROM sometable
WHERE id = 1
I get the error message:
ERROR: Attribute sometable.percentage must be GROUPed
or used in an aggregate function
I know that I have seen
Hi all,
I'm experiencing some strange behaviour with postgresql 7.0.3 on Red Hat
Linux 7. I'm sending lots of insert statements to the postgresql server
from another machine via JDBC. During that process postgresql continues to
take up more and more memory and seemingly never returns it to
I'm curently using the jan 19 snapshot and every
thing works great till I try to order by a specific column in php.
$thread_result = pg_exec($db, "SELECT thread FROM
$main_db ORDER BY thread;");
any sugestions as to what might be the
problem?
Mike
Hi all,
I'm experiencing some strange behaviour with postgresql 7.0.3 on Red Hat
Linux 7. I'm sending lots of insert statements to the postgresql server
from another machine via JDBC. During that process postgresql continues to
take up more and more memory and seemingly never returns it to the
I cannot successfully execute the sql statement:
SELECT percentage, MAX(start_date) FROM sometable
WHERE id = 1
I get the error message:
ERROR: Attribute sometable.percentage must be GROUPed
or used in an aggregate function
I know that I have seen examples of selecting multiple columns
I had a machine with a bad CPU that did that, but I don't know that this is
your case.
Perhaps a bad index?
Can you determine if only one table is the cause (i.e. Vacuum Analyze
table).
Anything in the logs?
--rob
- Original Message -
From: "Dave Cramer" [EMAIL PROTECTED]
To: [EMAIL
sorry if any of you got this twice, but it appears i was unsubscribed from
pgsql-general at some point and it wouldn't let non-subscribers post, so
i'm trying again now that i am again subscribed...
hi. i tried looking through the faq and some of the manuals but didn't
come across too much
Dear pgsql,
I created a databased and I used it for two days
Suddenly I got the following message
FATAL 1: cannot create init file mydb/base/mydb/pg_internal.init.1016
when I run psql and I cannot access the data any more.
I am evaluating pgsql and this looks a serious problem to me.
I
On Fri, Jan 19, 2001 at 10:22:42AM +0900, Tatsuo Ishii wrote:
...
ALso, you could use UNICODE(UTF-8). For upcomming 7.1, PostgreSQL will
provide automatic conversion between:
UTF-8 -- EUC-CN
UTF-8 -- EUC-TW
UTF-8 -- Big5
Out of interest, does --enable-recode do anything if you don't have
Anyone got a solution for this error:
initdb: pg_encoding failed
Perhaps you did not configure PostgreSQL for multibyte support or
the program was not successfully installed.
---
Here's what i wrote:
---
./configure --prefix=/usr/local/postgresql --enable-locale\
--enable-multibyte
hi. i tried looking through the faq and some of the manuals but didn't
come across too much useful info on the following. i'm trying to put some
more corporate types at ease here. an employer of mine has been using
mysql, and it's been great, but we're finding that we're going to need
Wow! postgresql is a miracle! :-)
I'm starting to wonder why anybody would want to use Oracle...
Alexander Jerusalem
[EMAIL PROTECTED]
vknn
At 14:02 24.01.01, Denis Perchine wrote:
* Fast case insensitive text search via indexes (function based indexes)
Try to:
create table test (s text);
El Mi 24 Ene 2001 08:06, Zak McGregor escribi:
Other irritations I've found with MySQL are (briefly):
- no subselects (makes for ugly hacks in code)
- no views
- no foreign keys
Didn't know they didn't have foreign keys. :-(
- no constraint support
- completely lacking date integrity
Mitch Vincent wrote:
I haven't used PL/pgSQL very much but it looks like a good language in which
to make some simple functions for this application I'm writing..
Is it possible (with PL/pgSQL) to access other records in other tables than
the tuple that pulled the trigger (and called the
PostgreSQL gurus,
I am in the process of writing a technical book featuring PostgreSQL (among
other technologies). I would like to document the contents of the PGDATA
directory. There are a few files there that I haven't been able to figure out.
They are 'pg_logs' and 'pg_variables'. I can make
On Mon, Jan 22, 2001 at 07:04:51PM +0530, Anand Raman wrote:
hi guys
While trying to isnert data into a table using the \copy i am getting a
error which states Bad timestamp representation..
I am not sure why it is occuring..
Can some one point out what this mistake is ..
My datestyle is
Hi all,
My apologies if this has been answered - I haven't found a reference to
it...
I am using PostgreSQL 7.0.3 (installed from an RPM) on a RedHat 6.0 system.
I have created a database and are trying to create a trigger. The purpose
of this trigger is to automatically add the current date
1. Is it documented anywhere that an apostrophe / single quote is bad news
inside of a C-style /* */ comment? I just found out the hard way.
Seems to be OK inside of the one line -- comment.
2. How does one view column comments created with COMMENT ON COLUMN?
TIA.
Brian E. Pangburn
Do they exist ? I've looked but can't find any.
Theres idug.org and isug.com, unfortunately imug.org was taken by Macs
instead of MYsql which seemed more appropriate.
Anyway there are various php user groups going around as well just was
hoping somethingmight exist for postgresql.
Any type of commerce or site that tracks user profiles... That's a LOT of
sites that would have a need for a enterprise level DB.
Remember, the goal is 5 nines uptime. :)
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
Something that I can do in mysql is (please excuse the Java):
(connection.createStatement()).executeUpdate(
"create temporary table tmp1_" + localUniqueId + " " +
"(_index int not null auto_increment primary key) " +
queryString
);
Basically I'm creating a
Postgresql's SQL implementation is way ahead of MySQL's relatively
stunted vocabulary. But on the other hand, MySQL implements most
of the popular functionality. The other thing is that MySQL is
blindingly fast and has a very uncomplicated API.
If you need real SQL and can't afford
"Brendan Green" [EMAIL PROTECTED] writes:
The problem is that when I try to insert a record into the table, I get the
following error:
ERROR: CURRENT used in non-rule query.
I've been banging my head against a brick wall for the past few days. I
*think* that it has something to do with a
"[Bad-Knees]" [EMAIL PROTECTED] writes:
Anyone got a solution for this error:
initdb: pg_encoding failed
Is your PATH pointing at the right set of Postgres executables?
I think that would happen if initdb finds a 'postgres' in PATH
that doesn't have pg_encoding along with it, which would
John Frank [EMAIL PROTECTED] writes:
Does anyone have experience hacking the HASH index code to allow more
overflow pages?
Er, why not use btree instead? The hash index code isn't nearly as well
debugged or maintained as btree.
Of course, if you want to adopt the hash stuff as a personal
"Mike Sears" [EMAIL PROTECTED] writes:
I'm curently using the jan 19 snapshot and every thing works great till I t=
ry to order by a specific column in php.
$thread_result =3D pg_exec($db, "SELECT thread FROM $main_db ORDER BY threa=
d;");
And?
regards, tom lane
David Wall writes:
Now that MySQL has transaction support through Berkeley DB lib, and it's
always had way more data types,
I count 25 documented and distinct data types for MySQL, and 30 for
PostgreSQL.
http://www.postgresql.org/devel-corner/docs/postgres/datatype.htm
There have been several recent benchmarks by non-mysql and postgres people
and the speed argument does not seem to be valid.
Even though MySQL still beats postgres in speed if they are compared with
one user on the DB, postgres seems to destroy MySQL in speed as you tend to
add users.
Adam Lang
tc lewis [EMAIL PROTECTED] writes:
2. who provides commercial support for postgresql?
See http://www.postgresql.org/users-lounge/commercial-support.html
any recommendations?
My opinion might be considered biased ;-)
regards, tom lane
I though that postgresql had more data type
no, MySQL has 'type of the week' contests to see how many non-compliant
types they can think of, and add them ...
Something I'm curious about: does MySQL support user-defined datatypes?
If so, how hard is it to make a new datatype? I think
David Wall schrieb:
Now that MySQL has transaction support through Berkeley DB lib, and it's
always had way more data types, what are the main advantages postgresql has
over it? I don't think mysql has subselects and such, but they did add a
master-slave replication feature as well as
Hi there,
maybe anyone can help me with the following problem.
Using PostgreSQL 7.03 on a Suse 6.3 Linux (kernel 2.2.13) with a P3/550
MHz,
I get a performance problem with a select command which takes up to 10
seconds.
The following tables are involved in this command:
CREATE TABLE
* Mirko Zeibig [EMAIL PROTECTED] [010124 09:07] wrote:
Hello,
I have a table:
CREATE TABLE pge (
pge_id SERIAL,
pge_pathCHAR(255) CONSTRAINT ak_pge_path UNIQUE,
PRIMARY KEY (pge_id)
);
From other tables I now reference pge_id as well as pge_path. Somewhere I
have
[snipped foreign keys set up across non-comparable types]
This will not succeed:
INSERT INTO lnk VALUES ('1', '/adm');
ERROR: Unable to identify an operator '=' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast
I had a hard time to get
Hi all.
I need to store XML documents in database, so I use large objects for
them. Now I have a problem: I want to search for patterns in documents,
and it looks like there is no standard way to do it, so I write
C function to do it, but it has limitation: it is not support regular
expressions.
On Wed, 24 Jan 2001, Tom Lane wrote:
Something I'm curious about: does MySQL support user-defined datatypes?
No, it does not.
If so, how hard is it to make a new datatype? I think datatype
extensibility is one of the cooler features of Postgres ...
Check this out:
* Dave Cramer [EMAIL PROTECTED] [010124 09:08] wrote:
Tom,
Thanks for the hint, and no I wasn't looking in the right place. Here is the
backtrace
This isn't a backtrace, you need to actually type 'bt' to get a backtrace.
-Alfred
Is there a place where I can see what the new features for 7.1 are expected
to be? I'm hopeful for native BLOB support smile
David
On Wed, 24 Jan 2001, Peter Eisentraut wrote:
David Wall writes:
Now that MySQL has transaction support through Berkeley DB lib, and it's
always had way more data types,
I count 25 documented and distinct data types for MySQL, and 30 for
PostgreSQL.
Not to mention that Postgres has an
On Wed, 24 Jan 2001, Raymond Chui wrote:
I also have a HP machine with OS HP-UX 10.20, I have installed
Perl 5.6 and DBI. But when I install DBD (DBD-Pg-0.95) it requires
me install all those *.h files and libpg.* files first. I don't want to
install PostgreSQL server in the HP machine, I
Konstantinos Agouros wrote:
Well I was in a real hurry... I just managed to see Postgresql, Addison Wesley
and the price in Germany \:)))
http://www.linuxtag.de/
http://php.net/books.php
http://www.concert-band.de/
If you are in a real hurry, you can buy this book at
"Brendan Green" [EMAIL PROTECTED] writes:
The problem is that when I try to insert a record into the table, I get the
following error:
ERROR: CURRENT used in non-rule query.
I've been banging my head against a brick wall for the past few days. I
*think* that it has something to do
Hi,
I've already posted something about this trouble, and all I tried didn't
worked very well...
Here is my tables :
CREATE TABLE accord_editeur
(
id_regie int4 not null,
num_editeur int4 not null,
num_site int4 not null,
num_emplacement int4 not null,
num_campagne int4 not null,
Hello,
I've noticed a bug if pg_ctl. If you do the following:
pg_ctl -w -D $PGSQL/data -o '-p 1' start;
The pg_ctl script will loop doing a 'psql -l' to connect to the postmaster
process on port 5432 (but postmaster is using 1 in this case). The
pg_ctl script should take the port
Something I'm curious about: does MySQL support user-defined datatypes?
No, it does not.
If so, how hard is it to make a new datatype? I think datatype
extensibility is one of the cooler features of Postgres ...
Making new datatypes sounds good, but in practice how easy is it to do? I
hi guys
on looking at the postgres log i could find this information too
DEBUG: Data Base System is in production state at Wed Jan 24 20:20:26 2001
Server process (pid 22751) exited with status 139 at Wed Jan 24 20:23:33 2001
Terminating any active server processes...
Server processes were
Have you done a vacuum analyze on the database? And what
does explain show for the query?
On Wed, 24 Jan 2001, Andreas Rieke wrote:
SELECT DISTINCT level_1_de from property_list pl, properties p,
materials m where m.oid=p.material_oid and p.property_list_oid=pl.oid
and m.is_new=FALSE;
I have seen in the documentation that you can get the timestamp
of tomorrow by entering
timestamp(date 'Tomorrow')
this is almost what i need... is it possible to get something
like with the unix date command:
date --date '1 month' ?
or where is date documented... i didn't find it.
--
There is some information here :
http://www.postgresql.org/devel-corner/docs/postgres/release.htm
- Original Message -
From: "David Wall" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 24, 2001 1:07 PM
Subject: 7.1 expected features list?
Is there a place where I
You should probably ask the MySQL people that.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Marten Feldtmann" [EMAIL PROTECTED]
To: "David Wall" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, January
Your are correct !
#0 0x40171b80 in strcoll () at strcoll.c:228
#1 0x8115b1f in lztext_cmp ()
#2 0x8115b72 in lztext_eq ()
#3 0x8098809 in vacuum ()
#4 0x8096120 in vacuum ()
#5 0x8095705 in vacuum ()
#6 0x8094e9d in vacuum ()
#7 0x8094e21 in vacuum ()
#8 0x81000b3 in ProcessUtility ()
hi guys
While executing a simple query my the psql session reports that the
session has closed abnormally..
Can any one point out why .. The sample sql query is as follows..
arttoday=# select
arttoday-# art1.name,
arttoday-# CASE WHEN exh.title IS NULL THEN 'Untitled' ELSE exh.title
On Wed, 24 Jan 2001, Alexander Klimov wrote:
I need to store XML documents in database, so I use large objects for
them. Now I have a problem: I want to search for patterns in documents,
and it looks like there is no standard way to do it, so I write
C function to do it, but it has
Greetings.
I have a postgresql database installed on a drive that's gone flakey. I'm
about to replace the drive, and wondering about one small point.
Is it safe to just shut down the database, tar everything up, replace the
drive, untar, and start it back up? None of the paths, etc, are
58 matches
Mail list logo