Re: [GENERAL] FK check implementation

2014-10-13 Thread Nick Barnes
On Sat, Oct 11, 2014 at 5:01 AM, Adrian Klaver wrote: > On 10/10/2014 10:41 AM, Nick Barnes wrote: > > >> I understand why the FK insert needs to lock on the PK row. But why is >> the PK delete trying to lock the FK row? If it finds one, won't the >> delete fai

Re: [GENERAL] FK check implementation

2014-10-10 Thread Nick Barnes
On Sat, Oct 11, 2014 at 1:32 AM, Tom Lane wrote: > Nick Barnes writes: > > I'm looking at the code behind the foreign key checks in ri_triggers.c, > and > > something's got me a little confused. > > > In both cases (FK insert/update checking the PK, and PK u

[GENERAL] FK check implementation

2014-10-10 Thread Nick Barnes
I'm looking at the code behind the foreign key checks in ri_triggers.c, and something's got me a little confused. In both cases (FK insert/update checking the PK, and PK update/delete checking the FK) the check is done with a SELECT ... FOR KEY SHARE. This makes perfect sense for PK checks, but i

Re: [GENERAL] I want to create a read only database for a specified user.

2010-11-16 Thread Chris Barnes
Thanks Greg, just what I asked for! Chris > From: g...@turnstep.com > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] I want to create a read only database for a specified > user. > Date: Tue, 16 Nov 2010 18:10:33 + > > > -BEGIN PGP SIGNED MESSAGE- > Hash: RIPEMD160 > >

[GENERAL] I want to create a read only database for a specified user.

2010-11-16 Thread Chris Barnes
Hello, I have a postgres user, that was used to create a database with some 1500+ tables. I now want to have this database or all tables capable of read-only. Is there an easy way of doing this? I am running 8.4.4. on Linux Centos 5 Chris Barnes Recognia Inc.

Re: [GENERAL] ERROR: Out of memory - when connecting to database

2010-11-08 Thread Chris Barnes
> Date: Mon, 8 Nov 2010 20:05:23 +0100 > From: k...@comgate.cz > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] ERROR: Out of memory - when connecting to database > > Replaying to my own mail. Maybe we've found the root cause: > > In one database there was a table with 200k records w

Re: [GENERAL] pg view of table columns needed for scripting

2010-10-22 Thread Chris Barnes
From: dave.gauth...@intel.com To: pgsql-general@postgresql.org Date: Fri, 22 Oct 2010 09:14:01 -0700 Subject: [GENERAL] pg view of table columns needed for scripting Hi: Is there something like a pg_xxx view that I can use to get the column names and data types of a table, si

Re: [GENERAL] Is there a plugin/script for nagios that monitors pitr being up to djavascript:;ate?

2010-10-22 Thread Chris Barnes
> On Fri, 2010-10-22 at 08:37 -0400, Chris Barnes wrote: > > Is the a plugin or script that will allow pitr to be monitored and > > trigger an alarm when the pitr master/slave databases > > get out of sync? > > > > The reason I'm asking, I have had one o

[GENERAL] Is there a plugin/script for nagios that monitors pitr being up to djavascript:;ate?

2010-10-22 Thread Chris Barnes
l log txfr), but not the point. Any help would be appreciated... Chris Barnes

[GENERAL] Postgre 9.0 replication using streaming.

2010-10-05 Thread Chris Barnes
masters at out local collocation site. Is there a way configure postgres 9.0 to have 4 unique streaming connections from this one machine with the 4 databases to the 4 databases on 4 machines. Thanks for your reply, Chris Barnes CBIT Inc.

[GENERAL] Autovacuum settings between systems

2010-09-28 Thread Chris Barnes
I am using 8.4.2 on centos 5.4 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux I have autovacuum processes that appear to have been running most of the day. There aren't any messages in the log, but there must be something wrong for it to take this long? d

[GENERAL] Creating a column interger with default to not null

2010-09-24 Thread Chris Barnes
I am confused with what this is telling me. I have a table and I am trying to add a new column with constraint not null. What am I missing? Chris pgdb001=> alter table schema.table add COLUMN column_name integer not null; ERROR: column "column_name" contains null values

Re: [GENERAL] Postgres wont drop foriegn keys on tables.

2010-09-23 Thread Chris Barnes
Sorry, I am running the following. [postg...@pgprd01 pgcheck]$ psql --version psql (PostgreSQL) 8.4.2 contains support for command-line editing [postg...@pgprd01 pgcheck]$ uname -a Linux system.name.com 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux From:

[GENERAL] Postgres wont drop foriegn keys on tables.

2010-09-23 Thread Chris Barnes
I am having an odd problem that I have seen before. It usually clears itself after I restart postgres. I am attempting to drop an foreign key on a table and it sits for hours and doesn't drop or put anything into the log. Killing the alter puts an error in, but it doesn't time out and it cause

[GENERAL] upgrade postgresql from 8.4.x to 8.4.4

2010-09-09 Thread Chris Barnes
Is there a procedure to upgrade from 8.4.x to 8.4.4 or am I over thinking it? I'm hoping I can just yum upgrade postgresql and have it just upgrade it without having to dump and restore the whole db. It would be nice if I had to only bounce postgresql to start using the newer version :) Thank

Re: [GENERAL] logging postgres to syslog on centos, truncates the postgres message.

2010-09-09 Thread Chris Barnes
On separate lines it is, thanks Tom. > To: compuguruchrisbar...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] logging postgres to syslog on centos, truncates the > postgres message. > Date: Thu, 9 Sep 2010 10:39:10 -0400 > From: t...@sss.pgh.pa.us

[GENERAL] logging postgres to syslog on centos, truncates the postgres message.

2010-09-09 Thread Chris Barnes
Hoping someone can help me with this problem. I am logging postgres to syslog on a CentOS release 5.4 (Final) ( 2.6.18-164.el5 ). When I look for an update statement it appears to be truncated and missing the whole statement. Is there a quick way to resolve this? Is it linux or postgres? Tha

[GENERAL] Using concatenation operator

2010-08-17 Thread Chris Barnes
I have a (stupid) question regarding using concatenation operator. I would like to get the list of tables from the database and output the select count(*) for each of them I don't want the schema name proceeding the select, how can I omit without receiving the error below. psql eventdb0

Re: [GENERAL] How to determine which tables are created from inheritance.

2010-08-13 Thread Chris Barnes
I have answered my own question. After some poking around I was able to find what I was looking for. I have posted for future reference. select relname,relid from pg_stat_user_tables where relid in (select inhrelid from pg_inherits) and relname like 'table%' order by relname; Thanks, Chris

[GENERAL] How to determine which tables are created from inheritance.

2010-08-13 Thread Chris Barnes
I am using londiste and would like to add tables for partitioned tables only. I.E. exclude the parent. I am currently using the select below. What postgres catalog table would I query to see this information? psql database -t -c "select schemaname||'.'||relname from pg_stat_user_tables where

Re: [GENERAL] alter table alter type CASCADE

2010-05-05 Thread Chris Barnes
It has been some years since I worked with Oracle, doesn't Oracle recompile the view when the object it references changes in structure? Send From: thombr...@gmail.com Date: Wed, 5 May 2010 10:12:34 +0100 Subject: Re: [GENERAL] alter table alter type CASCADE To: s...@compulab.co.il CC: p

[GENERAL] Errors starting postgres after initializing new database

2010-04-27 Thread Chris Barnes
I have just initialized a database with no errors, used the postgresql.conf file from another system running 8.4.2. Attempted to start and got the fatal error below. I than ran pgtune and got the same error. I am not sure what the problem is? Is there more detailed logging than below, or can b

Re: [GENERAL] pg_hba.conf

2010-04-27 Thread Chris Barnes
I've had problems before with the listen_addresses and had to set it accordingly. Wouldn't accept connections locally. listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses;

[GENERAL] Running vacuum after delete does not remove all space allocated

2010-03-31 Thread Chris Barnes
I have deleted the rows in a table and vacuumed full, there appears to be space allocated that after a truncate it removes. Why is this? \d t8000_us_ts_size_test_2d Table "dbprc001.t8000_us_ts_size_test_2d" Column | Type | Modifiers ---+---

[GENERAL] Processor speed relative to postgres transactions per second

2010-03-29 Thread Chris Barnes
like faster drives and controllers, there must be some improvement over the other processor. Is there anything to support this, a document or someone's personal experience? C

Re: [GENERAL] Does anyone use in ram postgres database?

2010-03-26 Thread Chris Barnes
stgresql.org > Subject: Re: [GENERAL] Does anyone use in ram postgres database? > > Chris Barnes wrote: > > > > > > We are testing in memory postgres database and have questions about > > configuring the ram mount point and whether there is great gains in > > s

[GENERAL] Does anyone use in ram postgres database?

2010-03-25 Thread Chris Barnes
accomplished this? Cheers, Chris Barnes _ Stay in touch. http://go.microsoft.com/?linkid=9712959

Re: [GENERAL] Create a function that updates the record with and timestamps

2010-03-22 Thread Chris Barnes
gt; > In response to Chris Barnes : > > I would like to have postgres update the last_modified column with the > > current_date on an update of the record. > > > > I am not sure if there is a very simple way of doing this? > > > > Or, do I need to create a f

[GENERAL] Create a function that updates the record with and timestamps

2010-03-22 Thread Chris Barnes
I would like to have postgres update the last_modified column with the current_date on an update of the record. I am not sure if there is a very simple way of doing this? Or, do I need to create a function and a trigger to call the row and update with new data and set the last_modified t

[GENERAL] Raid 10 settings for optimal postgres performance?

2010-03-03 Thread Chris Barnes
I have just configured our disks to raid10 from raid5. The raid 10 is now 6 drives giving us 750G use by OS and postgres. What is the preferred setup for postgres concerning cache settings on the controller and disks and the preferred block size allocated for the disks when postgres uses bl

Re: [GENERAL] Setting a table to be ignored by autovacuum

2010-02-19 Thread Chris Barnes
mpuguruchrisbar...@hotmail.com > > On 18 Feb 2010, at 18:47, Chris Barnes wrote: > > > Right you are, I'm due to upgrade end of month on this system. > > Here I was thinking 8.4. Sorry for the spam. > > > > Chris > > > > > > [postg...@pgprd01

Re: [GENERAL] Setting a table to be ignored by autovacuum

2010-02-18 Thread Chris Barnes
gmail.com; d...@archonet.com; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Setting a table to be ignored by autovacuum > > Chris Barnes escribió: > > > > > > > > Right you are, I'm due to upgrade end of month on this system. > > > > Her

Re: [GENERAL] Setting a table to be ignored by autovacuum

2010-02-18 Thread Chris Barnes
om CC: compuguruchrisbar...@hotmail.com; pgsql-general@postgresql.org On Thu, Feb 18, 2010 at 12:37 PM, Richard Huxton wrote: On 18/02/10 17:20, Chris Barnes wrote: I'm trying to have this table ignored by the autovacuum process. It wasn't created with this in mind, hoping there

[GENERAL] Setting a table to be ignored by autovacuum

2010-02-18 Thread Chris Barnes
Hi, I'm trying to have this table ignored by the autovacuum process. It wasn't created with this in mind, hoping there is still a way? Thanks, Chris alter table schema.table SET (autovacuum_enabled = false); ERROR: unrecognized parameter "autovacuum_enabled"

Re: [GENERAL] error creating database

2010-02-17 Thread Chris Barnes
This depends on your OS. If you are running (linux) redhat or centos you would edit this file /etc/sysconfig/i18n and change your locale to, for example. Save it and reboot. There are probably ways around this when creating the database, but we install our OS with this in mind. LA

[GENERAL] Truncate and delete adds wal logs for slave to process.

2010-02-11 Thread Chris Barnes
I have a question regaring delete & truncate versus a drop of the tables and recreating it. We have a database that gets recreated each week that is 31 GB in size. The way that it is currently being done is to truncate all of the tables. I would like to confirm. Because both

[GENERAL] Warning when selecting column from pg_stat_user_tables.

2010-02-09 Thread Chris Barnes
I have this error when selecting from the pg_stat_user_tables. I restarted postgres and the error went away. Has anyone else seen this error? Chris Barnes [postg...@preventdb02 londiste]$ cat /data/pgsql/data/pg_log/postgresql-Tue.log WARNING: pgstat wait timeout WARNING

[GENERAL] Postgres wal shipping from 8.33 to 8.42.

2010-02-04 Thread Chris Barnes
We are trying to minimize our downtime in production to upgrade from 8.33 to 8.42. What we would like to be able to do is this: Upgrade the slave we are currently shipping to, to version 8.4.2. Continue to pitr to this server. And switch over and then upgrade the master. My question is,

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Chris Barnes
Telnet is usually installed by default on windows or unix box, telnet to the database box should work. telnet 207.6.93.IP 5432 should work Make sure that windows firewall and antivirus software firewall are temporarily disabled to test. > Date: Mon, 1 Feb 2010 09:49:49

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Chris Barnes
You should be able to telnet to the port and get a response back as in the exmple below. Of course substitude the ip for the database. [postg...@pgprd01 londiste]$ telnet 127.0.0.1 5432 Trying 127.0.0.1... Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. > Date: M

[GENERAL] Equivalent of mysql type mediablob in postgres?

2010-01-18 Thread Chris Barnes
I would like to move a table that is used to store images from mysql to postgres. The only stumbling I may encounter, may be switching from mysql blob to something in postgres. We store chart images in a mysql medium blob type. How can I store these in postgres? Chris | IMA

Re: [GENERAL] Archive command seem to be working.

2009-12-23 Thread Chris Barnes
r the configuration is loaded (and you aren't hitting any other system limitations) it should begin archiving the files again. Cheers, Andrew From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Barnes Sent: terça-feira, 22 de dezembro d

[GENERAL] Archive command seem to be working.

2009-12-22 Thread Chris Barnes
kups/wal_arch/%f Is there a way to restart a service without taking the database down/up? Any help would be appreciated. Cheers, Chris Barnes _ Windows Live: Make it easier for yo

[GENERAL] Bestpractice for upgrading from enterpriseDB 8.3.3 to rpm 8.4.1.

2009-11-26 Thread Chris Barnes
this? Any suggestions would be appreciated. Cheers, Chris Barnes _ Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail you. http://go.microsoft.com/?l

Re: [GENERAL] Is there a tool used to display statement times from postgres logs

2009-11-20 Thread Chris Barnes
Fri, 2009-11-20 at 12:59 -0500, Chris Barnes wrote: > > Would someone have a tool that displays statement execution > > times/stats from the standard output from postgres logs? > > > > I have attempted pgfouine but not had sucess with the log format. > > > > Do

Re: [GENERAL] Is there a tool used to display statement times from postgres logs

2009-11-20 Thread Chris Barnes
gt; Subject: Re: [GENERAL] Is there a tool used to display statement times from > postgres logs > > Chris Barnes wrote: > > Would someone have a tool that displays statement execution > > times/stats from the standard output from postgres logs? > > > > the

[GENERAL] Is there a tool used to display statement times from postgres logs

2009-11-20 Thread Chris Barnes
Would someone have a tool that displays statement execution times/stats from the standard output from postgres logs? I have attempted pgfouine but not had sucess with the log format. Does anyone use pgfouine or have something that works for them? Chris

Re: [GENERAL] Looking for a script that performs full online backup of postgres in archive mode

2009-11-09 Thread Chris Barnes
l online backup > of postgres in archive mode > > On Mon, Nov 09, 2009 at 09:15:03AM -0500, Chris Barnes wrote: > > Would anyone in the postgres community have a shell script that > > performs a full online backup of postgres? > > Here's roughly what we do: > &

[GENERAL] Looking for a script that performs full online backup of postgres in archive mode

2009-11-09 Thread Chris Barnes
Would anyone in the postgres community have a shell script that performs a full online backup of postgres? Any help would be appreciated. _ Windows Live: Keep

[GENERAL] postgres logs indicate errors with prepared statements, since pgbouncer was installed.

2009-11-03 Thread Chris Barnes
We are using pgbouncer and seeing these errors in the postgresql logs. I don't believe pgbouncer allows for server prepared statements, so why would I see anything in the logs at all? 2009-11-03 12:00:37 EST:u...@10.0.0.1(56270):822ERROR: prepared statement "dbdpg_p1573_3968" does

[GENERAL] Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres

2009-11-03 Thread Chris Barnes
Does anyone use solid state drives for postgres? Has there been any benchmark that states whether mechanical disk drives out perform solid state drives? Is there any benefit, they are quite expensive. Chris Barnes

[GENERAL] 2009-11-02 08:31:30 EST:u...@host(48990):4562ERROR: current transaction is aborted, commands ignored until end of transaction block

2009-11-02 Thread Chris Barnes
I hope someone can help me determine what is going on with my database. We have released code this weekend to our application and I have switched over to my hot standby that has been tuned and modified to raid10. It is up and appeared come on line and pitr is running to the standby (ok) We

Re: [GENERAL] Logging statements longer than 1000ms doesn't appear to work

2009-09-22 Thread Chris Barnes
#x27;t appear > to work > Date: Tue, 22 Sep 2009 15:08:39 -0400 > From: t...@sss.pgh.pa.us > > Chris Barnes writes: > > I've have set the parameter in my postgresql.conf file and have restarted > > postgres. > > > When reviewing the log file I am f

Re: [GENERAL] Logging statements longer than 1000ms doesn't appear to work

2009-09-22 Thread Chris Barnes
longer than 1000ms doesn't appear > to work > Date: Tue, 22 Sep 2009 15:08:39 -0400 > From: t...@sss.pgh.pa.us > > Chris Barnes writes: > > I've have set the parameter in my postgresql.conf file and have restarted > > postgres. > > > When r

[GENERAL] Logging statements longer than 1000ms doesn't appear to work

2009-09-22 Thread Chris Barnes
I've have set the parameter in my postgresql.conf file and have restarted postgres. When reviewing the log file I am finding that all of the statements are being logged (0.108 ms)? Is there some other parameter that I have missed? log_min_duration_statement = 1000 # -1 is disab

[GENERAL] oom ( kernel: postgres invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 )

2009-09-16 Thread Chris Barnes
I am having a problem with the system freezing when the system is very busy. I have found the entry oom-killer in our messages log. I would like to confirm that the proper way of dealing with this is to set the sysctl parameter below. Also, the kernel parameter for shmmax and shmall are not cor

Re: [GENERAL] Locks in postgres causing system load and crash.

2009-09-14 Thread Chris Barnes
cott.marl...@gmail.com > To: compuguruchrisbar...@hotmail.com > CC: pgsql-general@postgresql.org > > On Mon, Sep 14, 2009 at 8:58 AM, Chris Barnes > wrote: > > We have a situation where the database locks escalate and load causes > > problems or the system crashes in some

Re: [GENERAL] Reverse-engineering table creation statements

2009-09-14 Thread Chris Barnes
pg_dump --schema-only --schema=SCHEMA --table=TABLE produces creation script. Chris http://www.postgresql.org/docs/8.0/interactive/backup.html From: thombr...@gmail.com Date: Mon, 14 Sep 2009 16:15:23 +0100 Subject: [GENERAL] Reverse-engineering table creation statements To: pgsql-

[GENERAL] Locks in postgres causing system load and crash.

2009-09-14 Thread Chris Barnes
We have a situation where the database locks escalate and load causes problems or the system crashes in some circumstances. We have munin installed and notice that the locks (access share locks) climbed to 2.7k. I'm wondering what or how I can get a snapshot of the table(s) and perhaps t

Re: [GENERAL] Postgresql Hardware

2009-09-11 Thread Chris Barnes
Purchase solid equipment and fairly current machines. We buy referbished system at a fraction of the cost of new. For example; IBM 3650 with 8 x 300g SAS drives and controller, 4 slot dual with the following specs. 16 gb memory. model name : Intel(R) Xeon(R) CPU E5345

Re: [GENERAL] PG connections going to 'waiting'

2009-09-05 Thread Chris Barnes
Is the any way to look at the statistics on the name of table, length and type over a period of time? Or, would we have to use munin and capture these stats for analysis later? Chris > To: alan.mc...@gmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] PG connections go

[GENERAL] Postgres bug #4907 : stored procedures and changed tables

2009-08-21 Thread Chris Barnes
We have run into postgres bug #4907 : stored procedures and changed tables To say, we have created a function and made changes to the table and the procedure no longer works giving the error below ERROR: structure of query does not match function result type CONTEXT: PL/pgSQL functio

[GENERAL] Pgbench tool download

2009-08-17 Thread Chris Barnes
I am looking for pgbench. Is there a good source from which I can download the most current version? your help is appeciated, Chris _ Stay on top of things, check email from other accounts! http://go.microsoft.com/?linkid=96

[GENERAL] How would I get information regarding update when running for a long time?

2009-07-22 Thread Chris Barnes
"ix_dchrisb" btree (date) "ix_dchrisd" btree (volume) Thanks for any help Chris Barnes _ More storage. Better anti-spam and antivirus protection. Hotmail makes it simple. http://go.microsoft.com/?linkid=9671357

[GENERAL] Create (function, procedure) and trigger to increment a counter

2009-07-16 Thread Chris Barnes
I have a table usage, I would like to create a (function or procedure) called by the trigger to increment column counter after an update. Can someone lend me a hand with the process behind creating this function,procedure and trigger. Table "public.usage" Column |

[GENERAL] Asking for assistance in determining storage requirements

2009-07-09 Thread Chris Barnes
using SAN with fiber channel hba and if anyone else uses this technology. We would also like to know if people have preference to the level of raid with/out striping. Sincerely, Chris Barnes Recognia Inc. Senior DBA _ Attention all

[GENERAL] Problems with postgres online backup - restore

2009-06-25 Thread Chris Barnes
I started an online backup of postgres, tar'd my data folder, copy to usb drive in production and restored it into my RC environment. Have I missed something important? When starting the database I receive many errors that look like the backup was corrupted. 2009-06-23 08:29:15 EDT:@:7614E

[GENERAL] Postgres online backup and restore

2009-06-25 Thread Chris Barnes
client001.t1020screen where criteria_rank like '%TR009%'; ERROR: missing chunk number 0 for toast value 738680 Version [postg...@pgprd01 data]$ cat PG_VERSION 8.3 Chris Barnes

[GENERAL] Postgres online backup and restore has errors that are concerning

2009-06-25 Thread Chris Barnes
ing chunk number 0 for toast value 738680 Version [postg...@pgprd01 data]$ cat PG_VERSION 8.3 Chris Barnes _ Windows Live helps you keep up with all your friends, in one place. http://go.microsoft.com/?linkid=9660826

Re: [GENERAL] [ADMIN] PostgreSQL installation problem on Windows XP Home

2005-03-04 Thread Bearden Barnes
with administrator and other system accounts.   Cannot Change the Password for the Administrator Account in User Accounts in Control Panel Article ID : 298252 http://support.microsoft.com/default.aspx?scid=kb;en-us;298252   --Bearden Barnes   -Original Message-From: Ha

Re: [GENERAL] Installing in SuSE 7.1

2001-05-05 Thread Bill Barnes
]> wrote: > Martín Marqués <[EMAIL PROTECTED]> writes: > > > On Jue 03 May 2001 22:51, Trond Eivind Glomsrød > wrote: > > > Bill Barnes <[EMAIL PROTECTED]> writes: > > > > Does anyone know of a package for 7.0.3 or 7.1 > that > > > >

[GENERAL] Re: HOWTO for pg 7.1 installation from cvs

2001-03-24 Thread Bill Barnes
Well, this wasn't the posting I had in mind, but it's even better. Didn't know that 7.1 was so well documented. Thanks, Developers. For anyone else's benefits here's the URL for the CVS fetch. http://www.postgresql.org/devel-corner/docs/postgres/cvs.html And here's the URL for the install

[GENERAL] Re: URL for gmake

2001-03-16 Thread Bill Barnes
[2] 10419 [1] Done(127) gmake install >make.install.log 2&1 $tail -f make.install.log sh: gmake: command not found Thus the reason for confusion about gmake. Cannot find a binary or link for gmake. How does it get called. Thanks again, -Bill -

[GENERAL] URL for gmake

2001-03-16 Thread Bill Barnes
Trying to rebuild v6.5.3 and the procedure calls for gmake. A google search is a dog-chasing-tail exercise. Can anybody help with a URL or an alternative. Thanks, -Bill __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://per

[GENERAL] pgaccess on Win9x

2001-03-04 Thread Bill Barnes
Hi Y'all: Unzipped pgaccess to C:\. Have TclPro 1.4 at c:\Program Files\TclPro1.4 Executing C:\pgaccess\main.tcl I get: couldn't load library "libpgtcl.dll": this library or a dependent library could not be found in library path while executing "load libpgtcl[info sharedlibextension]" [procedure

[GENERAL] If this isn't too crassly commercial ... looking for tech editors

2001-03-02 Thread Patricia . Barnes
I'm assured that this message won't be greeted with universal condemnation from the Postgres community - I'm an editor at Sams Publishing who is looking for a technical editor for a PostgreSQL developer's handbook. Interested? Send resume to [EMAIL PROTECTED] Thanks.

[GENERAL] Publisher seeks authors/technical reviewers

2001-03-01 Thread Patricia . Barnes
Sams Publishing, a computer book publisher based in Indianapolis, is looking for authors to write high-level PostgreSQL books and for technical reviewers. Interested parties should contact [EMAIL PROTECTED] Patricia G. Barnes Acquisitions Editor Sams Publishing 201 W. 103rd Street

[GENERAL] RE: postgresql-tcl-7.03 requires libtcl8.0.so

2001-02-27 Thread Bill Barnes
stgresql-tcl-7.0.3-2mdk with --nodeps and all > seems to work ;-) > > Regards > > Ben > > > -Original Message- > > From: Bill Barnes [mailto:[EMAIL PROTECTED]] > > Sent: 27 February 2001 09:59 > > To: pg-general > > Subject: [GENERAL]

Re: [GENERAL] Re: A How-To: PostgreSQL from Tcl via ODBC

2001-02-20 Thread Bill Barnes
Thanks. That cleared the bison problem. flex didn't work the same way though. Copied it also to /home/billb/pgsql. Reported missing. Needs to go someplace else? TIA Bill --- Tom Lane <[EMAIL PROTECTED]> wrote: > Bill Barnes <[EMAIL PROTECTED]> writes: > > Ran in

[GENERAL] Re: A How-To: PostgreSQL from Tcl via ODBC

2001-02-20 Thread Bill Barnes
Hooray! These instructions are just what an almost-novice needs. With the exception of changing the password to 'postgresql', the procedures started smoothly. Ran into a hitch at 'make' which reported that 'bison' was not installed. I'm running debian potato, so used the apt-get install of bis

[GENERAL] [HACKERS] ERROR: "Database 'products', OID nnn, has disappeared from pg_database"

2001-02-05 Thread Barnes, Sandy (Sandra)
that some kind of corruption has occured within > pg_database file, but I don't have the expertise to find where the problem > is occuring. Any help you can provide would be greatly appreciated. > > I am including the init script used. > <> > > Sandy Barnes > Honey

[GENERAL] archive search fails

2001-02-05 Thread Bill Barnes
Entering a search request at the archives website yields the following result: the website for ReadySetNet Error: File not found - Did you enter the correct domain name or URL Same results in Opera and Netscape. Appreciate a fix. Bill

[GENERAL] RE: pgaccess on Win95

2000-10-07 Thread Bill Barnes
>> Has anyone been able to execute the subject on PostgreSQL7.0.2 >> Error message reports unable to find libraries. > >You need to have Tcl/Tk installed. > >-- >Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ I should have been more specific. Sorry! TclPro 1.4 (evaluation

RE: [GENERAL] Talking with other Dbases.

2000-09-28 Thread Bill Barnes
If memory serves me correctly, Virtuoso (OpenLinkSW) and AOLserver both claim inter-database connections. >= Original Message From "Mitch Vincent" <[EMAIL PROTECTED]> = >> Hi, >> >> I'm pretty new to PgSQL (been lurking) and am wondering if >> it's possible to talk with other DB's easily

RE: [GENERAL] are my questions being received?

2000-09-15 Thread Bill Barnes
Yes >= Original Message From [EMAIL PROTECTED] (Wade D. Oberpriller) = >Hello, > >Are my questions being posted? If so, could someone just reply so I have peace >of mind. > >Wade Oberpriller >StorageTek >[EMAIL PROTECTED]

RE: [GENERAL] 7.1 Release Date

2000-08-29 Thread Bill Barnes
Oh, if only I could be so sanguine about my learning curve in matters of Linux, PostgreSQL, Enhydra, Glade, gnome-db, bonobo, HTML, XML, DHCP, NIS, NSF, DNS, ABC, XYZ, ETC, ETC, ETC. Bill >= Original Message From Lamar Owen <[EMAIL PROTECTED]> = >Tom Lane wrote: >> Lamar Owen <[EMAIL PRO

RE: [GENERAL] pgaccess not connecting

2000-08-26 Thread Bill Barnes
Sat, 26 Aug 2000, Tom Lane wrote: > >> Bill Barnes <[EMAIL PROTECTED]> writes: >> > kgb10:/home/billb# /etc/init.d/postgreql start -i >> > Starting PostgreSQL postmaster >> > kgb10:/home/billb# ps ax | grep postmaster >> > 24746 pts/5S 0:00 /u

RE: [GENERAL] pgaccess not connecting

2000-08-26 Thread Bill Barnes
That's it. Found the switch in /etc/postgresql/postmaster.init. Thank you very much, Bill >= Original Message From Tom Lane <[EMAIL PROTECTED]> = >Bill Barnes <[EMAIL PROTECTED]> writes: >> kgb10:/home/billb# /etc/init.d/postgreql start -i >> Star

[GENERAL] pgaccess not connecting

2000-08-26 Thread Bill Barnes
255.255.255.255 trust Thanks Bill Barnes

RE: [GENERAL] PostgreSQL and multiple database access

2000-06-14 Thread Barnes
Chapter 10 of Bruce's book has a really good discussion of locking and all that.(I was reading it yesterday.)  The book is at   http://www.postgresql.org/docs/aw_pgsql_book/   Barnes -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Beha

[GENERAL] COPY fails to read source file

2000-05-16 Thread Bill Barnes
--- The second instance gave me the results I wanted, but why did the first instance fail? If anything, I would have expected permission denied on the root owner. I have had the same results on other ocassions. What am I missing? TIA Bill Barnes

RE: [GENERAL] Book completed except for chapters 18 and 20

2000-05-14 Thread Bill Barnes
ve info >like this would go a long way towards problem+pain avoidance. > >Cheerio! >Link. > Thanks for this great piece of work. Bill Barnes This e-mail has been sent to you courtesy of OperaMail, a free web-based serv

[GENERAL] Creating tables with psql

2000-05-06 Thread Bill Barnes
What might I be missing? TIA Bill Barnes This e-mail has been sent to you courtesy of OperaMail, a free web-based service from Opera Software, makers of the award-winning Web Browser - http://www.operasoftware.com

RE: [GENERAL] date format problem

2000-05-03 Thread Bill Barnes
queries and updates. I don't know which SQL, Postresql or Sybase, is an extension or non-compliant. Bill Barnes >= Original Message From "Anand Raman" <[EMAIL PROTECTED]> = >HI bill >Try to cast the field to the datetime type > >'ur_string_goes_here

[GENERAL] kpgsql query executes but does not complete

2000-04-25 Thread Bill Barnes
nect I can select the new table. I have been able to execute 'select' and 'drop' queries in succession. Thanks for any clues. Bill Barnes

[GENERAL] date format and copy command

2000-04-25 Thread Bill Barnes
The copy command is copy tablename from '/usr/.../namefile.txt' using delimiters ';'; The pgsql response is 'bad date format'. Recommendations, please. Thanks, Bill Barnes

RE: [GENERAL] scheduling table design

2000-02-25 Thread Barnes
Nay, my friend, no mistake. Rather, I have you and Kaiq to thank for setting me straight, and I fully intend to follow your advice. What you say makes sense, and I'll go with it. I will use the datetime as well. Thank you. David Barnes -Original Message- From: [EMAIL PROT

RE: [GENERAL] scheduling table design

2000-02-25 Thread Barnes
name instead of an actual field. It is inflexible timewise, but does it offer any advantages such as speed or simplicity in the SQL searches? Has 3) ever been done, or is it seriously flawed somehow? Are there other solutions? Thank you again. David Barnes [EMAIL PROTECTED]

RE: [GENERAL] using ID as a key

2000-02-04 Thread Barnes
Take a look at Bruce's book at http://www.postgresql.org/docs/awbook.html He explains oid's and sequences extremely well, and that might be what you are looking for. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of sheila bel Sent: Friday, February 04,

RE: [GENERAL] PostgreSQL running on Redhat 6.1 and VB6.0

2000-01-24 Thread Barnes
You need this: http://www.insightdist.com/psqlodbc/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Matthew Dormer Sent: Monday, January 24, 2000 7:31 PM To: [EMAIL PROTECTED] Subject: [GENERAL] PostgreSQL running on Redhat 6.1 and VB6.0 Can you use

  1   2   >