It would seem that my postgresql database system is getting slower and
slower at dropping tables and possibly other tasks too.
Am I being paranoid? I don't think so.
Can anyone think of anything that would cause dropping a table with little
data contained within it to take several seconds (an
On Mon, Jun 04, 2001 at 11:16:40AM -0400, Jim Mercer wrote:
> would it be possible for me to create a template2 and have some arbitrary
> database use it instead of template1?
>
> the reason i ask this is that it would be useful to have something to the
> effect of:
>
> database access startup f
On Tue, Jun 05, 2001 at 01:17:00AM +0200, Rasmus Resen Amossen wrote:
> > Problem is not 'where'. Views in Postgresql doesn't allows you insert,
> > update or delete unless you define especila rules that explain Postgresql
> > what to do in each case.
> > Look Postgresql programming manual. Yo
Hi,
I've recently migrated from MySQL to PostgreSQL and as impressed as I am
with Postgres, I have found one seemingly missing feature to be a little
bothersome..
'mysqlimport' has the ability to skip duplicate records when doing bulk
imports from non-binary files. PostgreSQL doesn't seem to hav
On Wed, 6 Jun 2001, Bruno Wolff III wrote:
> I am interested in having a constraint checked at the end of a transaction
> that is close to a references constraint but not exactly the same.
> Simplfied versions of the table create statements look like the following:
> create table table1 (
> col
>> It's certainly not a big deal to use the cron, I just thought maybe
someone
>> had experimented with an internal mechanism. I'd like to try it someday,
>> when I know a lot more about Pg. My current project has an ever-growing
>> number of cron jobs (up to 6 now) and was just thinking about v
I am interested in having a constraint checked at the end of a transaction
that is close to a references constraint but not exactly the same.
Simplfied versions of the table create statements look like the following:
create table table1 (
col1 int primary key,
col2 int
);
create table table2 (
This article mentions Postgres multiple times. It even mentions
GreatBridge:
http://dailynews.yahoo.com/h/zd/20010606/tc/linux_forklifts_in_the_data_warehouse_1.html
Brent
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
On Wed, 6 Jun 2001, Fran Fabrizio wrote:
>
> Some thoughts are:
>
> 1. It would be portable with the database. I don't have to go setting up
> crons on the new machine if I move the db.
> 2. The cron usually involves writing a shell/perl/whatever script to call
> the psql client and pass in SQ
On Wed, 6 Jun 2001, Alvaro Herrera wrote:
> On Fri, 1 Jun 2001, Gerald Gutierrez wrote:
>
> Now, erserver seems to work, but it needs a bit hacking around that I
> hadn't done yet. Maybe when I get it working I'll see to writing
> something. In the mean time, source code is the only thing that ca
On Fri, 1 Jun 2001, Gerald Gutierrez wrote:
> The database article at Zend mentioned a replication server for
> PostgreSQL., available at www.pgsql.com. The press release says the code
> itself has been put into the CVS tree, but I can't find any documentation
> on it anywhere.
You won't find an
Some thoughts are:
1. It would be portable with the database. I don't have to go setting up
crons on the new machine if I move the db.
2. The cron usually involves writing a shell/perl/whatever script to call
the psql client and pass in SQL queries via STDIN or file redirect just to
invoke th
Are you using the "quote" function? You have to use it if you are to
guarantee that the data will be acceptable as "input".
$myVar = $myDB -> quote ($myVar)
> I'm using the Pg perl interface. But, think my problem was that I
had
> unescaped single quotes in the string. Added the following to my
jackie wrote:
Hello
EveryBody How could I get
the size(MB) of the Database
du on the datadirectory where the database are located.
Feite
14 matches
Mail list logo