Craig Ringer [EMAIL PROTECTED] writes:
Kakoli Sen wrote:
It was running fine initially and the database was lying idle for a
few days. Today I looged into the machine and restarted the server by
killing the process by 'kill -9 pid'. And then restarted it by
'postmaster -i -D
Hi,
Actually, I tried stopping server by 'kill `cat
/opt/pgsql/data/postmaster.pid`. This did not work. So I used kill -9 on Red
Hat 4.
This is a test database where we are in the process of setting up. So it
does not have live data. Still I do agree, it was not a good idea.
Now, do I have to
Blair Bethwaite [EMAIL PROTECTED] writes:
I'm wondering whether there would be any extra overhead (CPU, memory,
io, etc), above and beyond the implicit ACCESS SHARE, incurred by
putting a simple SELECT into a transaction block?
Every PG command is executed in a transaction, whether explicit or
Kakoli Sen wrote:
Hi,
Actually, I tried stopping server by 'kill `cat
/opt/pgsql/data/postmaster.pid`. This did not work. So I used kill -9 on Red
Hat 4.
This is a test database where we are in the process of setting up. So it
does not have live data. Still I do agree, it was not a good idea.
Kakoli Sen [EMAIL PROTECTED] writes:
Actually, I tried stopping server by 'kill `cat
/opt/pgsql/data/postmaster.pid`. This did not work. So I used kill -9 on Red
Hat 4.
Define did not work ... what happened exactly?
I do not know of any prepackaged Postgres distribution for Red Hat that
would
Hi all,
I'm wondering whether there would be any extra overhead (CPU, memory,
io, etc), above and beyond the implicit ACCESS SHARE, incurred by
putting a simple SELECT into a transaction block?
Cheers,
-Blair
--
In science one tries to tell people, in such a way
as to be understood by
Scott Marlowe wrote:
On Tue, Mar 11, 2008 at 7:33 PM, Justin [EMAIL PROTECTED] wrote:
I view updates/patches of any kind like this, if ain't broke don't fix it.
I normally only update computers with security patches only after i prove it
don't destroy installs.
But that's juast it.
On Wed, Mar 12, 2008 at 12:02 AM, Russell Smith [EMAIL PROTECTED] wrote:
Scott Marlowe wrote:
On Tue, Mar 11, 2008 at 7:33 PM, Justin [EMAIL PROTECTED] wrote:
I view updates/patches of any kind like this, if ain't broke don't fix
it.
I normally only update computers with security
On Wed, 12 Mar 2008, Russell Smith wrote:
Scott Marlowe wrote:
I too wait a day or two to test it on a staging server, but
I've never had a pgsql update blow back in my face, and I've done an
awful lot of them.
So you missed 8.1.7 then or weren't using those features at the very
least? You
sathiya psql wrote:
Is there any article describing the migration database from postgresql 7.4to
8.1
The basic tips are:
1. Use pg_dump from 8.1 to dump your 7.4 database
2. Read the release notes for the intervening versions to see what might
affect your applications.
In particular, the
On Wed, Mar 12, 2008 at 11:40:18AM +0100, Ivan Sergio Borgonovo wrote:
I'd like to make this query work
select 1,
st.Name, sm.Name, sm.MethodID, sm.Description,
pt.Name, pm.Name, pm.MethodID, pm.Description
from
shop_commerce_paymethods pm,
I'd like to make this query work
select 1,
st.Name, sm.Name, sm.MethodID, sm.Description,
pt.Name, pm.Name, pm.MethodID, pm.Description
from
shop_commerce_paymethods pm,
shop_commerce_shipmethods sm
inner join shop_commerce_shiptypes st on
If I do \dF:
Schema | Name | Description
++--
pg_catalog | simple | simple configuration
(1 row)
\dFd:
Schema | Name |Description
+
Hi everyone,
I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp)
that code is
Const f2_MAX_TRAMS = 5
Dim f2_rTarifaA as new ADODB.Recordset
Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua
Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa
Dim i As Integer, j
On Wed, 12 Mar 2008 11:48:24 +0100
Martijn van Oosterhout [EMAIL PROTECTED] wrote:
On Wed, Mar 12, 2008 at 11:40:18AM +0100, Ivan Sergio Borgonovo
wrote:
I'd like to make this query work
select 1,
st.Name, sm.Name, sm.MethodID, sm.Description,
pt.Name, pm.Name, pm.MethodID,
On Tue, Mar 11, 2008 at 5:28 PM, Tom Lane [EMAIL PROTECTED] wrote:
Kynn Jones [EMAIL PROTECTED] writes:
If one can set up this insert operation so that it happens automatically
whenever a new connection is made, I'd like to learn how it's done.
For manual psql sessions, you can put some
Please always ensure that the list is copied on replies (use Reply to
all) so that other people can help you.
sam escribió:
On Mar 11, 5:39 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
sam escribió:
Iam not able to understand if this is a version problem or the way iam
using
Hi,
Does somebody knows how to compile oralink in postgresql 8.2? The boss
wants it because it saw it working in a postgresql 8.1. I hate oralink
because it looks like a dummy's job (the makefile is a mess and
there's no documentation, not even a README file).
Any information is welcome.
Thanks
Kynn Jones wrote:
On Tue, Mar 11, 2008 at 5:28 PM, Tom Lane [EMAIL PROTECTED] wrote:
Kynn Jones [EMAIL PROTECTED] writes:
If one can set up this insert operation so that it happens automatically
whenever a new connection is made, I'd like to learn how it's done.
For manual psql sessions, you
On Wed, Mar 12, 2008 at 07:52:29AM -0400, Kynn Jones wrote:
An ON CONNECT trigger enforced by the database seems a bit scary to me.
If it's broken, how you gonna get into the DB to fix it?
A psql --skip-on-connect-trigger, only available to, say,
superusers ? Or a database flag (like the
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Hi! I want to set up a trigger (somehow) that, whenever someone connects
database my_db, will fire and thereby run a stored PLPERL procedure
perl_setup() in the new connection's environment. (BTW, this procedure adds
useful definitions,
This is not a flame about current or previous release of Postgres.
I have just gone through the awful experience of upgrading from Postgres
8.2 to 8.3 with a database that had one of the many Postgres extensions
included. The problem comes down to the way that Postgres extensions are
packaged up,
Tim Child [EMAIL PROTECTED] writes:
If I do \dF:
Schema | Name | Description
++--
pg_catalog | simple | simple configuration
(1 row)
Huh. Seems like initdb forgot to install all the Snowball stemmers.
What do you find in
On Tue, 2008-03-11 at 06:47 -0700, rrahul wrote:
Any major clients of the two.
You can add you own points too.
Perhaps someone can comment on current MySQL backups procedures. I
believe that MySQL used to (still does?) require shutdown to be backed
up. I don't know whether this was true for
I'm pleased to announce that wiki.postgresql.org is now open for business!
The PostgreSQL Wiki replaces the technical documentation area
(techdocs) on the PostgreSQL website and provides an easy-to-use
area for PostgreSQL users and developers to read and document
experiences with any area of
You can make a backup in MySQL in several ways:
1) Using mysqldump;
2) Lock tables and copy their files one-by-one (MyISAM-only);
3) Shutdown server and copy all files (can be a slave in a replicated
setup);
4) Using InnoDB hot backup (commercial tool);
On 3/12/08, Reece Hart [EMAIL PROTECTED]
Tim Child [EMAIL PROTECTED] writes:
In my snowball_create.sql I find:
-- No language-specific snowball dictionaries, for lack of shared
library support
Really!?
This build comes from postgresqlformac.com the Unified Installer -
8.3.0 (PostgreSQLforMac)
Hm, do they have plpgsql or any
Reece Hart wrote:
On Tue, 2008-03-11 at 06:47 -0700, rrahul wrote:
Any major clients of the two.
You can add you own points too.
Perhaps someone can comment on current MySQL backups procedures. I
believe that MySQL used to (still does?) require shutdown to be backed
up. I don't know
On Wed, 12 Mar 2008 09:13:14 -0700
paul rivers [EMAIL PROTECTED] wrote:
For a database of InnoDB tables, people tend to replicate the
database, and then backup the slave (unless the db is trivially
That recalled me the *unsupported* feeling I have that it is easier
to setup a HA replication
Take a look at pgpool . http://pgpool.projects.postgresql.org/
2008/3/12, Ivan Sergio Borgonovo [EMAIL PROTECTED]:
On Wed, 12 Mar 2008 09:13:14 -0700
paul rivers [EMAIL PROTECTED] wrote:
For a database of InnoDB tables, people tend to replicate the
database, and then backup the slave
David Potts wrote:
This is not a flame about current or previous release of Postgres.
I have just gone through the awful experience of upgrading from Postgres
8.2 to 8.3 with a database that had one of the many Postgres extensions
included. The problem comes down to the way that Postgres
I noticed this immediately when using the PostgreSQL tool for examples of
dumps for creating export of database/table structure/data for the
MyJSQLView
application. I considered implementing a similar copy dump, but seems it
would
not be handled properly with SQL statements.
danap.
This is
V8.2.0 on Linux
Can't rename a db, complains that it doesn't exist. Yet psql -l shows
that it does and I can connect to it ???
mmdcc228_SETUP(120)% psql stdb2 -c alter database stdb rename to
stdb_tmp
ERROR: database stdb does not exist
mmdcc228_SETUP(121)% psql -l
List of
Tim Child [EMAIL PROTECTED] writes:
There is a file here with the same name:
/Library/PostgreSQL8/lib/postgresql/plpgsql.so
What else is in that directory? If you don't have dict_snowball.so
it's not gonna work.
So I could try and run that snowball_create.sql script from src (which
I have
On Wed, Mar 12, 2008 at 10:03 AM, Gauthier, Dave
[EMAIL PROTECTED] wrote:
V8.2.0 on Linux
Look into updating, there were some serious bugs fixed between 8.2.0
and 8.2.6 It's a pretty simple thing, since you don't need to dump /
reload for it.
Can't rename a db, complains that it doesn't
Ivan Sergio Borgonovo wrote:
On Wed, 12 Mar 2008 09:13:14 -0700
paul rivers [EMAIL PROTECTED] wrote:
For a database of InnoDB tables, people tend to replicate the
database, and then backup the slave (unless the db is trivially
That recalled me the *unsupported* feeling I have that it is
On Wed, 12 Mar 2008 17:47:35 +0100
jose javier parra sanchez [EMAIL PROTECTED] wrote:
Take a look at pgpool . http://pgpool.projects.postgresql.org/
I knew about it.
Giving a look at
http://pgpool.projects.postgresql.org/#restriction
it doesn't seem something that can be completely hidden to
On Wed, Mar 12, 2008 at 10:15 AM, Alvaro Herrera
[EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo wrote:
On Wed, 12 Mar 2008 09:13:14 -0700
paul rivers [EMAIL PROTECTED] wrote:
For a database of InnoDB tables, people tend to replicate the
database, and then backup the slave (unless
Last week I set up Postgres 8.3 on a WindowsXP machine. Had it up and
running and imported data. Now when I try to start the server (after
a machine restart) I get the message:
pg_ctl: another server
Hello,
I am having trouble with a function designed to return all column
constraints on a table. The problem is not in the SQL, which works fine
on its own. The problem comes when the function is invoked using SELECT
* FROM function_name(arg_name) AS temp_table(.). When the function
On Wed, 12 Mar 2008 10:26:21 -0700
Scott Marlowe [EMAIL PROTECTED] wrote:
On Wed, Mar 12, 2008 at 10:15 AM, Alvaro Herrera
[EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo wrote:
On Wed, 12 Mar 2008 09:13:14 -0700
paul rivers [EMAIL PROTECTED] wrote:
For a database of InnoDB
On Wed, Mar 12, 2008 at 10:49 AM, Lee Hachadoorian
[EMAIL PROTECTED] wrote:
Last week I set up Postgres 8.3 on a WindowsXP machine. Had it up and
running and imported data. Now when I try to start the server (after
a machine restart) I get the message:
On Wed, Mar 12, 2008 at 10:49 AM, Lee Hachadoorian
[EMAIL PROTECTED] wrote:
Last week I set up Postgres 8.3 on a WindowsXP machine. Had it up and
running and imported data. Now when I try to start the server (after
a machine restart) I get the message:
I am considering the utility value of creating a functional index on a name
field. To minimize the number of invalid searches caused by spacing errors
and mis-matched lettercase I am contemplating doing something like this:
CREATE UNIQUE INDEX idxUF_table_column ON table
(lower(trim(both ' '
It was far stupider than that. I had been playing around with a
couple of different data clusters before doing a complete reinstall of
PostgreSQL. I just realized I was trying to start a cluster that I
was no longer using and the postgres account didn't have appropriate
permissions for. It's
--- Greg Smith [EMAIL PROTECTED] wrote:
If you look at the link I passed along before, you'll see the
difference
with MySQL is that they've been abusing their customers with minor
point
releases that try to add new features. Instead some of these
introduce
functional regressions,
Added to TODO:
* Remove use of MAKE_PTR and MAKE_OFFSET macros
http://archives.postgresql.org/pgsql-general/2007-08/msg01510.php
---
Tom Lane wrote:
Gregory Stark [EMAIL PROTECTED] writes:
Trevor Talbot [EMAIL
Added to Win32 TODO:
o Diagnose problem where shared memory can sometimes not be
attached by postmaster children
http://archives.postgresql.org/pgsql-general/2007-08/msg01377.php
---
Magnus
On Wed, Mar 12, 2008 at 11:53 AM, Dave Page [EMAIL PROTECTED] wrote:
I'm pleased to announce that wiki.postgresql.org is now open for business!
Awesome!
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor
Glyn Astill wrote:
--- Greg Smith [EMAIL PROTECTED] wrote:
If you look at the link I passed along before, you'll see the
difference
with MySQL is that they've been abusing their customers with minor
point
releases that try to add new features. Instead some of these
introduce
Tim Child [EMAIL PROTECTED] writes:
There is other things in that directory including dict_snowball.so
Well, that's even stranger. It's real hard to see how the
src/backend/snowball Makefile would have built dict_snowball.so
and not built the correct version of snowball_create.sql.
Anyway, if
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 12 Mar 2008 14:35:19 -0400 (EDT)
Bruce Momjian [EMAIL PROTECTED] wrote:
This is something I noticed too when looking at MySQL and postgres.
The frequency of bug fixes and features, some coming over pretty
quickly from the community
--- Bruce Momjian [EMAIL PROTECTED] wrote:
Glyn Astill wrote:
--- Greg Smith [EMAIL PROTECTED] wrote:
If you look at the link I passed along before, you'll see the
difference
with MySQL is that they've been abusing their customers with
minor
point
releases that try to
At 09:47 PM 3/11/2008, rrahul wrote:
Hi,
I am a database professional but have never used Postgre. My client was
exploring the posiblity of using Postgre instead of Mysql and wnated to know
the comments from the community.
I waned you people you post your views on the following comparision
paul rivers [EMAIL PROTECTED] writes:
Is this something that wouldn't be fixed by:
- dump 8.2 database
- load dump into 8.3 database
- for each extension, run the 8.2 drop extension script in 8.2's contrib
- for each extension, run the 8.3 install extension script in 8.3's contrib
The
On Tue, Mar 11, 2008 at 4:51 PM, Andrej Ricnik-Bay [EMAIL PROTECTED]
wrote:
On 12/03/2008, Kynn Jones [EMAIL PROTECTED] wrote:
Of course I may not have quite
understood how that this procedure adds useful definitions,
mostly subs, to Perl's main package. This needs to be done
for each
Glyn Astill [EMAIL PROTECTED] writes:
--- Bruce Momjian [EMAIL PROTECTED] wrote:
MySQL has incentives to _not_ make their community release
production-quality.
I mean features being pulled into the enterprise release that haven't
had much time to be tested even in the community release.
For
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
- dump version N database
- create empty version N+1 database
- install N+1's version of each needed contrib module into new database
- restore dump, ignoring object already exists errors
There is a TODO to
On Wed, Mar 12, 2008 at 07:34:03PM -, Greg Sabino Mullane wrote:
- dump version N database
- create empty version N+1 database
- install N+1's version of each needed contrib module into new database
- restore dump, ignoring object already exists errors
There is a TODO to figure out
Hello
I am translating tips from czech language, that I would copy to wiki.
Please, I invite any help with language fix - my translation is really
basic.
current work is on: http://www.pgsql.cz/index.php/PostgreSQL_SQL_Tricks
Thank you
Pavel Stehule
On 12/03/2008, Dave Page [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
- dump version N database
- create empty version N+1 database
- install N+1's version of each needed contrib module into new database
- restore dump, ignoring object already exists errors
There is a TODO to figure out some cleaner way of
Angus B. Atkins-Trimnell [EMAIL PROTECTED] writes:
I am having trouble with a function designed to return all column
constraints on a table.
I think the problem is that you're declaring the contype return column
as char (ie, character(1)) when pg_constraint.contype is actually char
(a
Alvaro Herrera wrote:
Ivan Sergio Borgonovo wrote:
On Wed, 12 Mar 2008 09:13:14 -0700
paul rivers [EMAIL PROTECTED] wrote:
For a database of InnoDB tables, people tend to replicate the
database, and then backup the slave (unless the db is trivially
That recalled me the
On Mar 12, 2008, at 3:19 PM, Tom Lane wrote:
- restore dump, ignoring object already exists errors
Couldn't one use the dump listing feature of pg_restore and comment
out the extensions when restoring? Not likely to be a big improvement
over ignore errors :-)
--
Sent via
Guys,
I've created 2 sample tables with 1 column each - type
char(1) and type integer. After inserting equal number
of rows (4M or more) tablesizes are exactly the same, while
I would expect table with char(1) to be slighly smaller...
What's causing it ? Thanks!
Server version is 8.3.
Best
Add psql TODO:
o Include the symbolic SQLSTATE name in verbose error reports
http://archives.postgresql.org/pgsql-general/2007-09/msg00438.php
---
Alvaro Herrera wrote:
Tom Lane wrote:
Benjamin Arai
On Wed, Mar 12, 2008 at 11:46:12AM -0400, James B. Byrne wrote:
CREATE UNIQUE INDEX idxUF_table_column ON table
(lower(trim(both ' ' from(regexp_replace(column, /( ){2,}/g, )
What I intend this to do is to squeeze out excess whitespace, strip off
leading and trailing blanks, and then
On Wed, 2008-03-12 at 14:22 -0400, Lee Hachadoorian wrote:
It was far stupider than that. I had been playing around with a
couple of different data clusters before doing a complete reinstall of
PostgreSQL. I just realized I was trying to start a cluster that I
was no longer using and the
Alex Vinogradovs [EMAIL PROTECTED] writes:
I've created 2 sample tables with 1 column each - type
char(1) and type integer. After inserting equal number
of rows (4M or more) tablesizes are exactly the same, while
I would expect table with char(1) to be slighly smaller...
What's causing it ?
Consider the following case which is almost exact snapshot of part of our
scheme:
Table cities
Column| Type | Modifiers | Description
--++---+-
ficity_id| integer| not
Is it possible to change the Service Account password for Service
Account name postgres
and if so how?
Windows XP Home SP2
PostgreSQL v8.3.0
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Mar 12, 8:11 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
Please always ensure that the list is copied on replies (use Reply to
all) so that other people can help you.
sam escribió:
On Mar 11, 5:39 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
sam escribió:
Iam not able to
Hi everyone,
I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp)
that code is
Const f2_MAX_TRAMS = 5
Dim f2_rTarifaA as new ADODB.Recordset
Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua
Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa
Dim i As Integer, j
There is a file here with the same name:
/Library/PostgreSQL8/lib/postgresql/plpgsql.so
So I could try and run that snowball_create.sql script from src (which
I have downloaded) and try and get the required functionality? That
would be the easiest for now.
On the production system I will
There is other things in that directory including dict_snowball.so
ascii_and_mic.so latin2_and_win1250.so utf8_and_big5.so
utf8_and_gbk.so
cyrillic_and_mic.so latin_and_mic.so utf8_and_cyrillic.so
utf8_and_iso8859.so
dict_snowball.sopgxs
In my snowball_create.sql I find:
-- No language-specific snowball dictionaries, for lack of shared
library support
This build comes from postgresqlformac.com the Unified Installer -
8.3.0 (PostgreSQLforMac)
Now I am considering that it might have been better to compile my own,
but
Hi Everyone,
I am wanting to ask some opinions on implementing PL/R into V8.3 on
Win32. I have a need to be able to perform some relatively demanding
statistical functions as the basis of producing data for reports.
In short R appears to have more than enough capability to do the job
(from a
Hi everyone,
I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp)
that code is
Const f2_MAX_TRAMS = 5
Dim f2_rTarifaA as new ADODB.Recordset
Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua
Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa
Dim i As Integer, j
Well, if you have a crappy system that cannot sustain concurrent load or
even be backed up concurrently with regular operation, one solution is
to write a kick-ass replication system.
Still, it would be nice to have a kick-ass replication system for PG,
too. We've been toying with WAL
Hi Devrim,
When I tried to install, I got this error.
[EMAIL PROTECTED] pq8.2.6]# rpmbuild --rebuild --define 'buildrhel3 1'
postgresql-8.2.6-1PGDG.f8.src.rpm
-bash: rpmbuild: command not found
Do you know where can I download rpmbuild for RHEL 3?
Thank you for your help,
Tri
-Original
On Mar 11, 2008, at 10:28 PM, Tom Lane wrote:
An ON CONNECT trigger enforced by the database seems a bit scary to
me.
If it's broken, how you gonna get into the DB to fix it?
regards, tom lane
If creating the trigger wouldn't be possible from within the database
Alban Hertroys wrote:
On Mar 11, 2008, at 10:28 PM, Tom Lane wrote:
An ON CONNECT trigger enforced by the database seems a bit scary to me.
If it's broken, how you gonna get into the DB to fix it?
regards, tom lane
If creating the trigger wouldn't be possible from within the
Hi,
I finally figure out how come (i think) my analyszing of some specific
tables is taking so freaking long. 12million rows, ~11GB table.
I had some of the columns with the stat level set up to 1000. (this was
previously because I was trying to optimise somethings to make things
faster. ) When
josep porres wrote:
but the most important is how can I reference the fields inside de loop
By the fields I assume you mean the fields with names that end in a
number from 1 to 5, and you want to access those fields in a loop as if
you were indexing an array?
I think you might want to
Is there a query to pg_catalog tables to find out which table/column
has
the stat level not at default in 1 sweep?
Try this:
select c.relname, a.attname, attstattarget
from pg_catalog.pg_attribute a, pg_catalog.pg_class c,
pg_catalog.pg_namespace n
where a.attrelid = c.oid and
On Wed, Mar 12, 2008 at 1:02 PM, paul rivers [EMAIL PROTECTED] wrote:
- Auto_increment columns as pkeys in InnoDB tables are practically
required, yet severely limited scalability due to how a transaction
would lock the structure to get the next auto-increment (significantly
improved in
On Wed, 2008-03-12 at 21:33 -0500, Adam Rich wrote:
select c.relname, a.attname, attstattarget
from pg_catalog.pg_attribute a, pg_catalog.pg_class c,
pg_catalog.pg_namespace n
where a.attrelid = c.oid and c.relnamespace=n.oid
and n.nspname = 'public' and a.attnum 0
Funny, that does not
Scott Marlowe wrote:
On Wed, Mar 12, 2008 at 1:02 PM, paul rivers [EMAIL PROTECTED] wrote:
- Auto_increment columns as pkeys in InnoDB tables are practically
required, yet severely limited scalability due to how a transaction
would lock the structure to get the next auto-increment
You might want to keep this one on the list. I'm out of my league
with this one I think
On Wed, Mar 12, 2008 at 11:24 AM, Gauthier, Dave
[EMAIL PROTECTED] wrote:
stdb2=# select '|'||datname||'|' from pg_database ;
?column?
|postgres|
|template1|
|template0|
On Wed, Mar 12, 2008 at 4:48 AM, Ivan Sergio Borgonovo
[EMAIL PROTECTED] wrote:
one of the inner join doesn't have an on relationship.
As you could see in the other (longer) query I'm just trying to put in
the same row what would be
Could you get what you want by cross joining the first
On Wed, Mar 12, 2008 at 8:45 PM, Ow Mun Heng [EMAIL PROTECTED] wrote:
On Wed, 2008-03-12 at 21:33 -0500, Adam Rich wrote:
select c.relname, a.attname, attstattarget
from pg_catalog.pg_attribute a, pg_catalog.pg_class c,
pg_catalog.pg_namespace n
where a.attrelid = c.oid and
On Wed, 12 Mar 2008 21:30:57 -0700
Scott Marlowe [EMAIL PROTECTED] wrote:
You might want to keep this one on the list. I'm out of my league
with this one I think
Can you pg_dump the database? What about vacuum? What does:
SELECT * FROM pg_database; Return?
J
On Wed, Mar 12, 2008 at
Hi all,
I have recently turned up the postgresql logging facilities on a
rather database intensive application in the hope of finding bugs and
tuning queries. We're using 8.0.8, though thinking of moving to 8.3 as
the new HOT functionality looks like it would be useful for us given
the high
Blair Bethwaite [EMAIL PROTECTED] writes:
Why would we be getting a duplicate key violation on the primary key
of this table when we aren't doing anything in the UPDATE (that I can
tell) to change it?
Corrupted index, perhaps? Can you REINDEX that table?
There are at least two known bugs in
On Wed, 2008-03-12 at 21:40 -0700, Scott Marlowe wrote:
On Wed, Mar 12, 2008 at 8:45 PM, Ow Mun Heng [EMAIL PROTECTED] wrote:
On Wed, 2008-03-12 at 21:33 -0500, Adam Rich wrote:
select c.relname, a.attname, attstattarget
from pg_catalog.pg_attribute a, pg_catalog.pg_class c,
95 matches
Mail list logo