Mike
I use the following PLPERL/select "code" to view all FK's in my database
. I guess the "select" could be made into a pg_fkeys view. What do
people think...
Just a note. I used PLPERL because the fkey data is stored in a BYTEA
data field and other then a "C" function PLPERL works fine f
During the creation of my database, I'm doing
a:
CREATE UNIQUE INDEX account_idx ON Accounts
(account_id);
to add new rows to my table and keep the id's
unique.
During runtime (accessing by JDBC), is there anyway
when adding a new row to a table to know the last id entry so as to incr
I ran some experiments, and with the queries that I was
testing with, the clustered rtree was about 30% faster than
the unclustered one.
> This isn't really relevant to your main point, but: since an rtree
> doesn't have an associated sort order, it's not clear to me that this
> operation makes
On Mon, 23 Jul 2001, Keith Irwin wrote:
> Okay, I've done some experiments and here's what I've found out:
>
> 1. In order to drop columns from a table, you must delete and recreate
> the table.
Right now, yes. Hopefully we'll eventually have drop column (but see past
hackers discussions abou
Possibly. If your OS does not support or is not currently configured for
dual processor utilization, then your machine will not use the other
CPU. What OS/Version are you running?
-r
At 04:31 PM 7/23/01 -0500, Jack Long wrote:
>uh-oh, top looks like this for me:
>
> 3:35pm up 43 min, 3
If you are running on a dedicated postgres machine, run the command "top"
from the command line. The third and fourth line should read like:
CPU0 states: 0.0% user, 5.0% system, 0.0% nice, 94.0% idle
CPU1 states: 0.1% user, 0.0% system, 0.0% nice, 99.0% idle
(my system is idle now, but
How can I tell if postgresql is utilizing both processors of a dual
processor machine?
-Jack
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Yes, they are called sequences in postgres.
Create table tablename (id serial, )
This creates a sequence named tablename_id_seq
You can then do a select on
Select next('tablename_id_seq')
Which will give you the next sequence and increment it
Dave
-Original Message-
From: [E
For that matter, you could write a perl function using perl's built-in crypt()
function. I'm not sure if it's exactly identical to what mysql does, though I
strongly suspect that it is.
Philip Hallstrom <[EMAIL PROTECTED]> on 07/23/2001
02:13:27 PM
To: Jason DiCioccio <[EMAIL PROTECTED]>
You don't indicate how you're executing the copy. If you're using a
script/program, just add your own counter as the first field in the copy. I
do this 'all the time' from Perl scripts, and it works fine. If you're
using psql, I haven't a clue unless you massage the input data before doing
the
You could take the password hashing routine out of client/password.c (in
the mysql source) and write your own C function... I know just enough C
to think that it shouldn't be that hard, but not enough to do it :)
-philip
On Sun, 15 Jul 2001, Jason DiCioccio wrote:
> I am looking for a postgres
Okay, I've done some experiments and here's what I've found out:
1. In order to drop columns from a table, you must delete and recreate
the table.
2. Dropping a table deletes all foreign key triggers to that table, even
if you recreate that table. (Apparently the backend is using OIDs for
al
I have the same problem on Mac OS X. Has anyone gotten readline support
to work with OS X?
--Scott
On Sunday, July 22, 2001, at 07:47 PM, Tom Lane wrote:
> Justin Clift <[EMAIL PROTECTED]> writes:
>> The symptoms you mention are what happens when PostgreSQL is compiled
>> without the "readlin
Hi,
I'm Currently evaluating PostgreSQL, and comparing with other DBMS.
Actually, the point for me is robustness and particularly how to recover
from a power fail or a disk crash.
I couldn't find any accurate explanation about that point in the current
PostgreSQL doc, so could anyone give ,or dir
"Dr. Evil" wrote:
>
> I just want to say, that PG is an awesome thing. I'm finding new uses
> for constraints of various kinds to ensure data integrity in my DB.
> Constraints will really make the whole application more solid, because
> programming errors elsewhere still won't allow corrupt da
On Tuesday 17 July 2001 07:36, IMS wrote:
> How can I setup in Solaris and Red Hat Linux to start up postgresql
> automatically?
For RedHat Linux, if installed from the RPM's, simply type (as root)
/sbin/chkconfig --level 345 postgresql on
(assuming you want a postmaster in runlevels 3, 4, and 5
I am running PostgreSQL 7.1.2 on FreeBSD 4.3
This is an old 486 with only 12MB memory.
I am able to create databases and insert and retrieve data,
but when I try to query on the structure of the database
I am getting this error:
signin=# \d person_personid_seq
pqReadData() -- backend closed the
Yes,
Binaries can be found at
http://jdbc.fastcrypt.com
Source is in postgres cvs
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of stefan
Sent: July 16, 2001 1:06 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] JDBC 2.0 support?
Hi:
Are there JDBC
(Hm. Not sure this went through the first time, so resending: sorry for
the duplicate.)
Hi:
I'm using pg 7.1.2.
I've got a database with views which have permissions granted to a
certain
user. Defined something like:
create view whatever
revoke all on whatever from user
I don't get a parse error for the below query (made up some table
structures with those fields) on 7.2devel, what version are you
running?
On Mon, 23 Jul 2001, Raymond Chui wrote:
>
> SELECT id_1 FROM table1 WHERE state_code IN ('AZ','DE')
> UNION
> SELECT id_1 FROM table1 WHERE zip_code IN (
A table of lookup codes has many tables which reference it via foreign-key
declarations, and I want to be able to merge two codes into one.
For example lets say we have a CUSTOMER table and it uses a lookup 'code'
field from the CUSTOMER_TYPE table.
create table customer (
...
typeCod
If you are really just duplicating the database, not using replication (transactions
performed on both databases more or less simultaneously) this is a very easy thing to
do.
Dump the table defininitions with the MS SQL Server scripting tool. Include the
indexes. Use your favorite scriptin
You might suffer from a deadlock.
On Tue, 17 Jul 2001, Ben-Nes Michael wrote:
> Hi All
>
> VACUUM ANALYZE;
>
> return me the next error:
>
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while proce
On Mon, 16 Jul 2001, stefan wrote:
> Hi:
>
> Are there JDBC drivers for PostGresSQL?
http://jdbc.postgresql.org
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
56K Nationw
Thanks,
I'll check the sites.
See ya,
Marcelo Pereira
-- Remember that only God and Esc+:w saves.
__
(_.\ Marcelo Pereira |
/ / ___ [EMAIL PROTECTED] |
/ (_/ _ \__Matematica/99 - Imecc |
___\/_\___)___Unicamp___/
--
Drop the semicolon at the end of the string. In this context, it's not needed
to tell where the end of the statement is.
You might want to use a parameterized stored procedure that does multiple
updates inside a transaction. You would invoke the stored procedure via
mdb.Execute, as per your e
Andy Burns <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> why not run VMWare on NT4/W2K on the laptop, then run linux inside the
> virtual machine and run PGSQL there, you sacrifice some speed, but are
> running PGSQL on a real O/S that it is designed to run on, not
> shoehorn
Is it possible to obtain informations about current client connections to
the backend (user name /client ip adress) ?
Thanx in Advance
Michael
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.
Hi all,
- Original Message -
From: Peter Eisentraut <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 15, 2001 6:13 PM
> Those of you who wanted to help translating the messages of PostgreSQL
> programs and libraries, you can get started now. I've put up a page
> explaini
Precisely the point! There "shouldn't" be an issue with SMP boxes other
than OS differences that may result in one OS more efficiently utilizing
additional processors, yet there were striking differences in the
execution of my queries when I dropped the index after moving my system
from a single p
I am looking for a postgresql PASSWORD() function
that
produces hashes compatible with MySQL's
implementation.
I am converting from MySQL and I know of no other
way to
use the passwords I have in the old database other
than
having a compatible PASSWORD()
function.
I have searched around
On Tue, Jul 17, 2001 at 12:59:09PM +0200, Janning Vygen wrote:
> But then i thought: Do i really need complex middleware or is it just
> a wrapper around PostgreSQL??
Your original thinking is correct. You want a front-end (client),
some middleware that implements your business logic, and then
I am trying to use the following trigger:
CREATE TRIGGER formatname BEFORE update OR insert ON mytable FOR EACH row
EXECUTE PROCEDURE lower(name);
however, it gives me the message:
ERROR: CreateTrigger: function lower() does not exist
obviously this does exist, since I can do inserts/updates/
$ $ $ $ $ $ THE PROGRAM EVERYONE HAS BEEN WAITING FOR! $ $ $ $ $ $
Starting Today You Can Earn $8,000 to $32,000 Every Month!
For details on this unique program click on the hyperlink below:
http://www.geocities.com/staples1000us
if you have a problem with the above hyperlink send us a e
How can I know with which locale the database server was initialized?
Saludos :-)
--
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-
Martin Marques |[EMAIL PROTECTED]
Progr
Hi again,
You're probably best to look through the mailing list archives for the
best ways people have found for doing this. There have been a few
people with similar problems over time. :-)
If you don't find anything there, feel free to ask again.
:-)
Regards and best wishes,
Justin Clift
36 matches
Mail list logo
