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 going
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 limita
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 EN
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 ()
#
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, Janu
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 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.
--
SC-Netwo
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;
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 termi
> > 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 t
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 number
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,
num_publicite
> "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 someth
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 php.net/b
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
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
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
David
* 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
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:
http://www.mysql.com/d
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.
> [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
* 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. Somewher
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 "property_li
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 a
>> 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 data
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
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
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
http://www.mysql.com/
"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 lan
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
"[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 ha
"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 wi
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 Oracle/Sybas
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 tem
On Tue, Jan 23, 2001 at 08:12:58PM +0100, Konstantinos Agouros wrote:
> when I looked at the database-section of my bookstore browsing for the Practi-
> cal SQL Handbook I found a book on postgres from Addison Wesley. Is that one
> any good (I didn't have the time to look into it).
Yes, its the
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 -
Fr
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.
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
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 to
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
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 a
Hi,
Can anyone tell me where to find out information about going from 6.3 to 6.5? I have used the "\copy name to name" command to save all of the data to a file. I now want to import this data in 6.5. Any suggestions?-KeithDo You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
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
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 integ
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 te
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
features
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 --with-
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
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
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 usef
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
).
Anything in the logs?
--rob
- Original Message -
From: "Dave Cramer" <[EMAIL PROTECTED]>
To: <[EMAIL PRO
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 w
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'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
"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 ha
Gregory Wood wrote:
> Sorry, I was trying to give what I thought was a somewhat more concrete
> example without having to stipulate a number of qualifications. Let me
> rephrase to be more internationally correct: "If you are storing United
> States of America state abbreviations, they will ALWAY
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 procedur
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
>
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[],
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 ...
61 matches
Mail list logo
