X-No-Archive: trueThat's exactly what it was, thanks! 7.4 installed now, and I have ¨PhP support!!D.Walter Vaughan [EMAIL PROTECTED] a écrit: Desmond Coughlan wrote: Hi. As title. I'm getting a host of syntax errors, the last ten lines of which are ... NV_READ' undeclared (first use in
On Mon, Nov 13, 2006 at 01:26:08PM -0800, Kojak wrote:
I'm trying to install PL/pgSQL so that I can use it in a FUNCTION. I'm
using PostGres 6.5.x (I know I need to upgrade...but that is another
subject...).
No, you need to upgrade first. 6.5 is positivly prehistoric, no-one is
going to be
hi
I am trying to download PostgreSQL
8.1.5
however this link does not contain
anything:
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4-x86_64/
moreover the link
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4/
is just containing the
[snip]
I think the idea is to edit the postgresql.conf file on the fly and send
a SIGHUP to the postmaster. I haven't ever heard of anyone doing that,
but I don't see any reason why it wouldn't work.
It works, I did it for a while with the statement_timeout to change it
globally over night
Hi,
Le mardi 14 novembre 2006 14:36, Markus Schiltknecht a écrit :
I want to convert some large objects to bytea fields on the server.
Searching through the documentation didn't reveal any hints. Am I
missing something or is there really no such thing as a
lo_convert_to_bytea function?
You
Hi,
I want to convert some large objects to bytea fields on the server.
Searching through the documentation didn't reveal any hints. Am I
missing something or is there really no such thing as a
lo_convert_to_bytea function?
Regards
Markus
---(end of
PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though).
DBMS was running fine for some months but now one of the databases isn't
accessible. Any help would be greatly appreciated.
DBMS starts up fine, but any operation on the files database (psql files,
vaccumdb files, pgdump
On Tue, Nov 14, 2006 at 12:01:44AM +0100, Daniel Verite wrote:
Also, you'll find this extensively and better explained in this article, for
example:
http://ppewww.ph.gla.ac.uk/~flavell/charset/form-i18n.html
This is a *really* good article about character sets and form
submission. Especially
On Tue, Nov 14, 2006 at 07:54:30PM +0530, surabhi.ahuja wrote:
hi
I had Postgres 8.0.0 installed on my m/c and
now i have installed Postgresql 8.1.4 (FC 4) x86 , 64 bit arch.
i rebuild my executable giving -L$(ROOT)/postgres/lib/ -lpq
the directory $(ROOT)/postgres/lib
contains
I'm confused, what does statement timeout have to do with this? I was
assuming you would edit autovacuum = off to autovacuum = on wouldn't
that work?
Sorry for the confusion, I was thinking about the procedure of changing
programatically the config file and reload it, all this from a
On Tue, Nov 14, 2006 at 05:53:08AM -0500, Rob Owen wrote:
PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though).
DBMS was running fine for some months but now one of the databases isn't
accessible. Any help would be greatly appreciated.
DBMS starts up fine, but any
surabhi.ahuja wrote:
hi
I am trying to download PostgreSQL 8.1.5
however this link does not contain anything:
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4-x86_64/
moreover the link
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4/
is
On Tue, 14 Nov 2006 02:23:39 +0200
Igor Shevchenko [EMAIL PROTECTED] wrote:
Try with:
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
Bye Enrico
--
If Bill Gates had a penny for everytime Windows crashed,he'd be a
multi-billionaire by now ...oh look, he already is
[EMAIL PROTECTED] wrote:
He's just trying to do what you told him.
But the use of initdb won't correct the problem Igor got. There's something
wrong with his database so that he can't start the postmaster process:
PANIC: failed to re-find parent key in 23724
Unfortunately i don't have any
Thanks, but this is not working -
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
The files belonging to this database system will be owned by user postgres.
This user must also own the server process.
The database cluster will be initialized with locale C.
initdb:
X-No-Archive: trueHi, Thanks for all the help: we have our postgreSQL server on a 'backend' machine, and the client on a webserver.The application I want to develop is a school library, and as this is new to me, I come looking for ideas. Here's what I've done: on the backend, two users
Rob Owen [EMAIL PROTECTED] writes:
PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though).
DBMS was running fine for some months but now one of the databases isn't
accessible. Any help would be greatly appreciated.
Just one database? Sounds like it might be corrupt data in
I'm trying to install PL/pgSQL so that I can use it in a FUNCTION. I'm
using PostGres 6.5.x (I know I need to upgrade...but that is another
subject...). So far I've done the following:
create function pgpgsql_call_handler() returns opaque as
'/usr/local/pgsql/lib/plpgsql.so' language 'C';
create
My operating system is Red Hat Linux AS 4, Kerberos 5, with
postgresql-7.4.14 that I compiled. I can authenticate using
ssh, su, console login, and also have gotten apache
mod_auth_kerb to work with AD - but I am missing something
with postgresql. When I try:
[EMAIL PROTECTED] ~]$
am Mon, dem 13.11.2006, um 15:08:18 -0800 mailte [EMAIL PROTECTED] folgendes:
I just installed a fresh Postgres database. select version(); gives:
PostgreSQL 8.1.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)
Normal statements like select * from sometable work
Hello,
Our RPMS (PGDG) require gcj to install. Can we remove that dependency?
Joshua D. Drake
---(end of broadcast)---
TIP 6: explain analyze is your friend
A. Kretschmer wrote:
am Tue, dem 14.11.2006, um 0:58:56 -0500 mailte Tom Lane folgendes:
SunWuKung [EMAIL PROTECTED] writes:
Yep, I think this is it:
select trim(trailing '0.' from 1.020)
Um, I think not:
regression=# select trim(trailing '0.' from 1000.000);
rtrim
---
Hello Dimitri,
Cool, thank you.
Even though.. it looks a little... ehm... well optimized? Or shall I say
hard to read? However, it should work for what I want.
Shouldn't such a thing be at least in contrib? How about the reverse,
filling a large object with a bytea value? Admittedly, this
Thanks Martijn,
I reduced a number of the buffers and connection settings, and added some more
tracing and this is the result. The number (TopTransactionContext) is smaller,
but still very large. Any reason why this number would suddenly go sky high -
the same system was working fine just a
I just noticed this one:postgres=# select 1000.000::float;
float8
1000(1 row)
postgres=# select 1000.0001::float;
float8---
1000.0001(1 row)
postgres=# select 1000.000100::float;
float8---
1000.0001(1 row)
postgres=#HTH,Best regards,-- [EMAIL PROTECTED][EMAIL PROTECTED]
Csaba Nagy wrote:
[snip]
I think the idea is to edit the postgresql.conf file on the fly and send
a SIGHUP to the postmaster. I haven't ever heard of anyone doing that,
but I don't see any reason why it wouldn't work.
It works, I did it for a while with the statement_timeout to
On Tuesday 14 November 2006 10:52, Enrico wrote:
Try with:
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
Thanks, but this is not working -
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
The files belonging to this database system will be owned by user
hi
I had Postgres 8.0.0 installed on my m/c
and
now i have installed Postgresql 8.1.4 (FC 4) x86 ,
64 bit arch.
i rebuild my executable giving
-L$(ROOT)/postgres/lib/ -lpq
the directory $(ROOT)/postgres/lib
contains libpq.so with size = 133320
it gives an error (linking error i think),
I just installed a fresh Postgres database. select version(); gives:
PostgreSQL 8.1.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)
Normal statements like select * from sometable work fine.
I initiated the default databases, created the postgres user and I
tried to run
Good morning,
I've recently just inherited a PostgreSQL database that is a back end
for some logistics software we use here. We have our own Oracle
servers in our group on faster machines with automated backup so we
would like to move all the data over to Oracle.
The software came with scripts
On Mon, Nov 13, 2006 at 03:08:18PM -0800, [EMAIL PROTECTED] wrote:
I just installed a fresh Postgres database. select version(); gives:
PostgreSQL 8.1.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)
Normal statements like select * from sometable work fine.
Have
On Tue, Nov 14, 2006 at 01:58:49PM +0530, surabhi.ahuja wrote:
hi
I am using Postgres 8.0.0 and we found this issue ERROR: index
patient_pkey is not a btree
I have been informed that we should shift to Postgres 8.0.9
I beleive you've asked this a few times already. As a rule it always
best
He's just trying to do what you told him.
But the use of initdb won't correct the problem Igor got. There's something
wrong with his database so that he can't start the postmaster process:
PANIC: failed to re-find parent key in 23724
Unfortunately i don't have any idea how to solve this issue
On 11/13/06, Igor Shevchenko [EMAIL PROTECTED] wrote:
Hi All,
I've got a problem w/ one of pgsql installations. It can't start:
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/postgres -D /usr/pgsql/data
PANIC: failed to re-find parent key in 23724
Aborted
This is PostgreSQL 8.1.5 compiled from
Magnus Hagander wrote:
My pg_hba.conf looks like this (with pkoppe01 defined in
Active Directory but not defined in postgres using createuser)
You need to createuser with the AD username - this allows that user to
connect to PostgreSQL and to own and have various permissions in
PostgreSQL
My operating system is Red Hat Linux AS 4, Kerberos 5, with postgresql-7.4.14 that I compiled. I can authenticate using ssh, su, console login, and also have gotten apache mod_auth_kerb to work with AD - but I am missing something with postgresql.When I try:
[EMAIL PROTECTED] ~]$
Desmond Coughlan wrote:
X-No-Archive: true
Hi,
Thanks for all the help: we have our postgreSQL server on a 'backend'
machine, and the client on a webserver.
The application I want to develop is a school library, and as this is new to me, I come looking for ideas. Here's what
From: [EMAIL PROTECTED] on
behalf of surabhi.ahujaSent: Fri 11/10/2006 12:03 PMTo:
pgsql-general@postgresql.orgSubject: [GENERAL] how can i prove that
this issue on PG 8.0.0 ERROR: index "patient_pkey" is not a btree is solved in
8.0.9
hi
I am using Postgres 8.0.0 and we found this
Hi There,
I created a cluster with initdb into a custom directory /pgdata/bases, and
ser PGDATA environment to that value. I can start/stop postmaster from
command prompt.
Despite this, when I issue ./postgresql-8.1 start, cluster main is started
up instead.
Hence I modified init-d.functions
Hi Merlin,
On Tuesday 14 November 2006 17:36, you wrote:
On 11/13/06, Igor Shevchenko [EMAIL PROTECTED] wrote:
I've got a problem w/ one of pgsql installations. It can't start:
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/postgres -D /usr/pgsql/data
PANIC: failed to re-find parent key in 23724
2006/11/14, surabhi.ahuja [EMAIL PROTECTED]:
hi
I am trying to download PostgreSQL 8.1.5
however this link does not contain anything:
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4-x86_64/
moreover the link
Attached to backend postmaster and got the following. Hope this helps.
Attaching to program: /nfs/silence/bigdisk/eurrow/pgsql/bin/postmaster, process
170422
[Switching to Thread 1]
0x377c in ?? ()
(gdb) break errfinish
Breakpoint 1 at 0x119dc
(gdb) cont
Continuing.
[Switching
I have an 8.1.2 autovac which appears to be hanging/blocking
every few days or so, but we're don't understand what's causing
it. I wasn't able to catch a backtrace before we killed it. I
do not see autovac locks in the pg_locks view.
Will running 8.1.5 buy me anything in terms of being able
Hello.I read the documentation and set all configs like:lc_messages = Portuguese_Brazillc_monetary = Portuguese_Brazil.I installed the support to local language in the folder PostgreSQL\8.1\share\locale\pt_BR.
But I still receiving messages in English. What I missed?Thanks.-- Leodinei
I have an old server that is still working faithfully. It is running Red
Hat 7.2 and Postgersql 7.2. In anticipation of the day it will die, that
I am concerned is closer than I want it to be, I have set up a shinny
new server running Red Hat Enterprise 4.
I am trying to migrate the database from
X-No-Archive: true Good advice... and no, the 'four tables' was a typo; :) So far, there are only three... I reckon we're not going to split stock into two tables, but your point raises an important question. If I look over my shoulder, say we take Spanish books. There are six or seven copies
Christopher Browne wrote:
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Nicolas Barbier)
would write:
2006/10/28, Robert Treat [EMAIL PROTECTED]:
On Tuesday 10 October 2006 15:19, stig erikson wrote:
Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in
Hi all,
We have a database installed on Intel Xeon (Dell) and running on postgreSQL
8.1.
And the database couldn't start. Here is the logfile of what happend:
2006-11-14 00:28:38 PANIC: could not write to log file 6, segment 239
at offset 6430720, length 16384: Permission denied
2006-11-14
On Tue, 2006-11-14 at 06:08 -0800, [EMAIL PROTECTED] wrote:
The software came with scripts to create the owners, tables and
permissions in Oracle but when using pgAdmin (Windows client being
used to administer the PostgreSQL database at the moment) export
feature which dumps the entire
It depends how you plan to use it?
Maybe a helpful excercise for you to go through is to come up with some
use cases and see if you are storing all the data you'll need in a way
that makes it easy for you to use.
On Tue, 14 Nov 2006, Desmond Coughlan wrote:
X-No-Archive: true
Hi,
Thanks
On Tue, 2006-11-14 at 13:34 -0500, Ardian Xharra wrote:
Hi all,
We have a database installed on Intel Xeon (Dell) and running on
postgreSQL 8.1.
And the database couldn't start. Here is the logfile of what happend:
2006-11-14 00:28:38 PANIC: could not write to log file 6, segment 239
On Mon, Oct 30, 2006 at 10:49:33PM -0500, Ron Peterson wrote:
I created a set of PostgreSQL functions which implement the extended set
of digest/hashing functions provided by the Mhash library
(http://mhash.sourceforge.net/).
For anyone interested, the code is available here:
On Tuesday 14 November 2006 17:34, Alvaro Herrera wrote:
[EMAIL PROTECTED] wrote:
He's just trying to do what you told him.
But the use of initdb won't correct the problem Igor got. There's
something
wrong with his database so that he can't start the postmaster process:
PANIC:
On Thu, Nov 09, 2006 at 08:54:20AM -0500, Rick Schumeyer wrote:
To date I have always used pg on a system where I had pg superuser status.
I'm trying to move a database from such a system to one where I am just
a user, and I'm having a couple of problems.
The first is, the output of pg_dump
- Original Message -
From: Jeff Davis [EMAIL PROTECTED]
To: Ardian Xharra [EMAIL PROTECTED]
Cc: postgreSQL postgreSQL pgsql-general@postgresql.org
Sent: Tuesday, November 14, 2006 2:12 PM
Subject: Re: [GENERAL] Data corruption
On Tue, 2006-11-14 at 13:34 -0500, Ardian Xharra wrote:
--- Original Message ---
From: Jeff Davis [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Sent: 14/11/06, 19:05:33
Subject: Re: [GENERAL] Trouble migrating from PostgreSQL -- Oracle
Use pg_dump if you still
have problems with PgAdmin, and make sure you're connecting as
On Thu, Nov 09, 2006 at 04:37:23PM +0100, Alban Hertroys wrote:
'lo list,
I have a plpgsql SP where I loop through a cursor. I have an internal
variable that keeps the previous row, so that I can compare it with the
current row in the cursor.
Like so;
DECLARE
current
You want to do count(DISTINCT part_id) and count(DISTINCT desc).
On Sat, Nov 11, 2006 at 04:25:51PM -0800, Kojak wrote:
Here's a description of the scenario. The question I'm asking follows
the description.
3 tables
table1:
job_no int4
rate1 float4
qty1 float4
rate2 float4
qty2 float4
And, when coming up with the use cases you should be working with the
people who will actually be using the application. Wrt barcode
scanners, they typically just translate the barcode into a number. So,
you'll need a barcode printer to print barcodes for your ids to put on
the books.
Ben
On Tue, Nov 14, 2006 at 06:08:44AM -0800, [EMAIL PROTECTED] wrote:
Good morning,
I've recently just inherited a PostgreSQL database that is a back end
for some logistics software we use here. We have our own Oracle
servers in our group on faster machines with automated backup so we
would
On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
I have an 8.1.2 autovac which appears to be hanging/blocking
every few days or so, but we're don't understand what's causing
it. I wasn't able to catch a backtrace before we killed it. I
do not see autovac locks in the pg_locks view.
On Tue, Nov 14, 2006 at 01:31:28PM -0500, Carlson, James (Jim) wrote:
I have an old server that is still working faithfully. It is running Red
Hat 7.2 and Postgersql 7.2. In anticipation of the day it will die, that
I am concerned is closer than I want it to be, I have set up a shinny
new
On Tuesday November 14 2006 12:49 pm, Jim C. Nasby wrote:
On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
I have an 8.1.2 autovac which appears to be hanging/blocking
every few days or so, but we're don't understand what's
causing it. I wasn't able to catch a backtrace before we
On Tue, Nov 14, 2006 at 12:53:56PM -0700, Ed L. wrote:
On Tuesday November 14 2006 12:49 pm, Jim C. Nasby wrote:
On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
I have an 8.1.2 autovac which appears to be hanging/blocking
every few days or so, but we're don't understand what's
On Tuesday November 14 2006 12:56 pm, Jim C. Nasby wrote:
You don't have the vacuum cost delay settings set unreasonably
high, do you?
On Tuesday November 14 2006 12:56 pm, you wrote:
You don't have the vacuum cost delay settings set unreasonably
high, do you?
I'm not sure. Here's what we're
Rob Owen [EMAIL PROTECTED] writes:
Attached to backend postmaster and got the following. Hope this helps.
Nope, you got the postmaster itself there, you need to look at the new
child process. (It should look like postgres: startup in ps.)
regards, tom lane
Breakpoint 1, 0x000119dc in errfinish () from postmaster
(gdb) bt
#0 0x000119dc in errfinish () from postmaster
#1 0x0001a680 in AllocSetAlloc () from postmaster
#2 0x00012a1c in MemoryContextAlloc () from postmaster
#3 0x000100108c28 in _bt_search () from
Cabbar Duzayak wrote:
Hi,
We have huge amount of data, and we are planning to use logical
partitioning to divide it over multiple machines instances. We are
planning to use Intel based machines and there is not much updates but
mostly selects. The main table that constitutes this much of data
Can I install a PostgreSQL DB on a Novell LAN drive or must it be on a
server?
Thanks,
Michael
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Tue, 2006-11-14 at 15:04, [EMAIL PROTECTED] wrote:
Can I install a PostgreSQL DB on a Novell LAN drive or must it be on a
server?
Do you mean running postgresql on a linux or windows machine with the
$PGDATA directory located on a Novell / NFS / Samba mount, or do you
mean running
I am once again dealing with that age old problem of retrieving the
value of your inserted serial field in VB. I am fully aware that I can
manually pull the currval or nextval from my sequence, but I consider
having to manually deal with an auto-generated database object an
*extremely*
In the postgres log I am getting the following:
ERROR: type i does not exist
What is the cause of this error and/or how do I track it down?
I am running postgres ver 8.1.4 under redhat 4
Thanks for any help
Don
begin:vcard
fn:Don Laurine - DOH
n:Laurine;Don
org:Northwest River Forecast
On Tue, Nov 14, 2006 at 03:54:42PM -0600, John McCawley wrote:
I am once again dealing with that age old problem of retrieving the
value of your inserted serial field in VB. I am fully aware that I can
manually pull the currval or nextval from my sequence, but I consider
having to manually
Hello,
Does anyone know if it is possible to use SAN Splitting (the function of
splitting a mirror of disks so that there are two idential copies of a
Postgres Instance)? The reason that I ask is because I'm working on a
Hashing database to scale postgres to the moon and I'd like to be able to
That looks like the solution to my problem, thanks!...I tried running it
on my 8.0.8 server, but it wasn't found, I assume that's an 8.1 only
function?
Martijn van Oosterhout wrote:
On Tue, Nov 14, 2006 at 03:54:42PM -0600, John McCawley wrote:
I am once again dealing with that age old
Hi all,
We're trying to use connectby to transform a tree into an ordered set
of rows, specifically requirements rows.
We have data stored in a table with
keyid and parent_id, as described in the examples for
keyid is also the primary key of a table A, which has the field
A.seq_number.
We
Could someone give me some general hints as to what modifications I'd need to
make in the 8.2 source tree in order to remove the PG_MODULE_MAGIC requirement
for loading shared libraries into the backend? Is there any chance this could
be made into a configurable option so the user can choose
X-No-Archive: trueThanks. The main uses will be .. 1. available on www to query catalogue (open to everyone) 2avail. from the web for teachers and students to check their library account (necessitates an account) 3. available in the library itself both on a web interface (to allow the
Once upon a time, I put a question regarding deadlocks to the group,
and Tom Lane immediately answered with this:
The guy waiting on the tuple-specific lock is second in
line to actually mung the tuple. Whoever is first in line behind the
current tenant will be blocked trying to acquire
Rob Owen [EMAIL PROTECTED] writes:
Breakpoint 1, 0x000119dc in errfinish () from postmaster
(gdb) bt
#0 0x000119dc in errfinish () from postmaster
#1 0x0001a680 in AllocSetAlloc () from postmaster
#2 0x00012a1c in MemoryContextAlloc () from postmaster
#3
On Tue, Nov 14, 2006 at 02:46:41PM -0800, Shelby Cain wrote:
Could someone give me some general hints as to what modifications I'd
need to make in the 8.2 source tree in order to remove the
PG_MODULE_MAGIC requirement for loading shared libraries into the
backend? Is there any chance this
On Tue, 14 Nov 2006 21:26:02 +0200, Igor Shevchenko wrote:
I'd think starting a standalone backend and issuing a reindex database
should be enough to get him started. Now, the problem is figuring _how_
the index got in that state; or even _what_ index is the problematic
one. (I think it
Apologies, my reply should have gone to the list.
To answer your question, the sort of thing I'm thinking of is the
case where, maybe, one copy of a book is missing a page or two (not
unknown in a school library) - the first scenario can't record this,
nor can it tell which unlucky borrower ended
You are assuming I have the source for the library and although I've asked
nicely via email Microsoft hasn't responded to my requests for the source code
to kernel32.dll. ;)
Regardless, even if I had the source, adding PG_MODULE_MAGIC to an arbitrary
dll that has no need to know anything
X-No-Archive: trueOK, I think I understand. So the *.sql file that I provided doesn't need to be changed per se, as in the 'stock' table is OK (maybe change it 'stock_general')? I'd just add another table, with a foreign key 'pointing' back to 'stocks_general'... and a sequence, of course, so
X-No-Archive: trueJust had a thought. If you see .. http://www.chez.com/desmondcoughlan/unix/cdi_gt.sql.. I'd planned to have one table 'stock' and a column in that table for 'format', as we have books, CDs, DVDs, etc... What about if I had a separate table for books, another for
On Wednesday 15 November 2006 01:41, you wrote:
On Tue, 14 Nov 2006 21:26:02 +0200, Igor Shevchenko wrote:
I'd think starting a standalone backend and issuing a reindex database
should be enough to get him started. Now, the problem is figuring _how_
the index got in that state; or even
Hi,
Have you added the ability to store reservations, if a book is out. Maybe
having a table for this,
requests/reservations
id pk
user_id fk
item_id fk
date_requested (so that the first person on the list for this book is
notified)
Also, I'll assume there is more than one book per title,
X-No-Archive: trueMore tables and fewer columns in the tables? I *like* it! It hadn't occurred to me do it that way.Will this work ? http://www.chez.com/desmondcoughlan/unix/bibliotheque.sqlI haven't tested it yet, which brings me to two questions... a. will it work even if I
X-No-Archive: trueA really weird thing. This .. http://www.chez.com/desmondcoughlan/unix/bibliotheque.sql.. works almost perfectly. Except for this error .. 'psql:/usr/local/pgsql/bibliotheque.sql:54: ERROR: relation "titles" does not exist'I wrote
On Tue, Nov 14, 2006 at 01:20:38PM -0800, Don Laurine wrote:
In the postgres log I am getting the following:
ERROR: type i does not exist
What is the cause of this error and/or how do I track it down?
One possibility is that a query is trying to cast a value to the
i type, either
Desmond Coughlan wrote:
And our ultimate aim is for a barcode reader to be used by the librarian.
Any good sources to learn about that ?
I have only had a little exposure to barcode scanners - the one that a
client used just behaved as a keyboard, so there was no programming to
support
Desmond Coughlan wrote:
X-No-Archive: true
Just had a thought. If you see ..
http://www.chez.com/desmondcoughlan/unix/cdi_gt.sql
With the ISBN number you may want to look at contrib/isn - this adds
ISBN types.
If not then varchar(12) won't hold the new ISBN-13 format that is in
X-No-Archive: true Excellent.. thank you for that!D.Shane Ambler [EMAIL PROTECTED] a écrit: Desmond Coughlan wrote: X-No-Archive: true Just had a thought. If you see .. http://www.chez.com/desmondcoughlan/unix/cdi_gt.sqlWith the ISBN number you may want to look at contrib/isn - this adds
Does autovac maintain its state/counters across restats as to who
need to be vacuumed/analyzed? Or does killing autovac cause it
to reset the counters for the vacuum/analyze threshholds?
TIA.
Ed
---(end of broadcast)---
TIP 1: if
On Tuesday November 14 2006 1:02 pm, Ed L. wrote:
On Tuesday November 14 2006 12:56 pm, Jim C. Nasby wrote:
You don't have the vacuum cost delay settings set
unreasonably high, do you?
On Tuesday November 14 2006 12:56 pm, you wrote:
You don't have the vacuum cost delay settings set
Ed L. wrote:
Does autovac maintain its state/counters across restats as to who
need to be vacuumed/analyzed? Or does killing autovac cause it
to reset the counters for the vacuum/analyze threshholds?
Depends on the version. The contrib autovacuum does not maintain state
through a restart.
On Tuesday November 14 2006 11:51 pm, Matthew T. O'Connor wrote:
Ed L. wrote:
Does autovac maintain its state/counters across restats as
to who need to be vacuumed/analyzed? Or does killing
autovac cause it to reset the counters for the
vacuum/analyze threshholds?
Depends on the
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
solves your problem
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
On Tue, Nov 14, 2006 at 04:29:05PM -0800, Shelby Cain wrote:
You are assuming I have the source for the library and although I've
asked nicely via email Microsoft hasn't responded to my requests for
the source code to kernel32.dll. ;)
I see, you're doing something rather unsupported...
100 matches
Mail list logo