Re: [GENERAL] SAST FATAL: could not access private key file "server.key"

/docs/8.3/static/ssl-tcp.html I would guess that your key file is owned by root and only readable by root and that PostgreSQL is running as the postgres user and thus can't read the file. But that's just speculation. -- Bill Moran Collaborative Fusion Inc. http://people.collaborati

Re: [GENERAL] Query running slow but was running fine before

utput of: SELECT relname, n_tup_ins, n_tup_upd, n_tup_del, n_live_tup, n_dead_tup FROM pg_stat_user_tables ; -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-general mailing list (pgsql-general@

Re: [GENERAL] Backing up and deleting a database.

rchive AS (SELECT * FROM ??? WHERE [some where clause to identify old records]); DELETE FROM ??? WHERE [same where clause]; COMMIT; 2) COPY stage_archive TO 'some_file.sql' 3) Back up or otherwise archive some_file.sql 4) DROP TABLE stage_archive; -- Bill Moran Collaborative Fusion

Re: [GENERAL] Is it possible to do some damage to database with SELECT query?

om the tables (see the GRANT docs). By doing so, you ensure that even if someone can create a dangerous procedure and execute it via query, that they can't do any damage. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-

Re: [GENERAL] pg_query transaction: auto rollback? begin or start?? commit or end???

...resending, email didn't go through. On Tue, Jul 22, 2008 at 1:02 PM, Bill Wordsworth <[EMAIL PROTECTED]> wrote: > Is this recommended? > > pg_query("begin transaction read write;", $connection); > if(pg_transaction_status($connection) == 2) { >

[GENERAL] pg_query transaction: auto rollback? begin or start?? commit or end???

nection); } pg_query("commit transaction;", $connection); pg_close($connection); Now *any* error inside transaction will trigger auto rollback for *all* inserts so I don't need to explicitly issue conditional rollback? Also is "begin/commit transaction" == "start/end trans

Re: [GENERAL] pg_query transaction: auto rollback? begin or start?? commit or end???

he connection is bad. PGSQL_TRANSACTION_ACTIVE is reported only when a query has been sent to the server and not yet completed." Cheers, Bill On Wed, Jul 23, 2008 at 3:02 AM, Karsten Hilbert <[EMAIL PROTECTED]> wrote: > On Wed, Jul 23, 2008 at 01:15:30PM +1000, Chris wrote: > >

Re: [GENERAL] php + postgresql

the next. My opinion is avoid them unless you have a demonstrated need for the speed increase. In that case, make sure you have the time to understand and code for all the potential issues. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~

Re: [GENERAL] php + postgresql

reSQL users to PHP- is it the LAMP stack? Cheers, Bill On Fri, Jul 25, 2008 at 11:53 AM, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > On Fri, 2008-07-25 at 17:40 +0200, Tino Wildenhain wrote: >> Hi, >> >> > I think that PHP (like PostgreSQL, perhaps?) suffers from a repu

[GENERAL] Problems with pg_dump and -t wildcards

a tiny file with nothing but a couple of comments in it. Anyone know what's wrong? - Bill Thoen Here's what I get: $ psql -dspatial1 Welcome to psql 8.1.5, the PostgreSQL interactive terminal. ... spatial1=# \d List of relations Schema |

Re: [GENERAL] Problems with pg_dump and -t wildcards

Ah ha! I'm reading the wrong docs. Duh... I guess it's upgrade time! Thank you. Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: On Fri, 2008-07-25 at 11:36 -0600, Bill Thoen wrote: I'm having some problems with pg_dump and the -t switch

Re: [GENERAL] php + postgresql

On Fri, Jul 25, 2008 at 4:29 PM, Bill Wordsworth <[EMAIL PROTECTED]> wrote: > years. It is newbies like him and fan-boys of Ruby/Python/Perl who > give PHP a bad name. But I fail to understand the little animosity > within some PostgreSQL users to PHP- is it the LAMP stack? On Fr

Re: [GENERAL] replication only

s very lacking, so much so that any attempt at suggesting a "best" option would be pointless. Provide some more information on your requirements and people will be able to answer intelligently. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMA

Re: [GENERAL] replication only

In response to Jef Peeraer <[EMAIL PROTECTED]>: > > On Tue, 5 Aug 2008, Bill Moran wrote: > > > In response to Jef Peeraer <[EMAIL PROTECTED]>: > > > > > > i read about the replication possibilities with postgresql. If i just > > > need

Re: [GENERAL] max_fsm_relations question

script run VACUUM after it > populates each new table? No. If that parameter is too low you need to raise it, period. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-general mailing list (p

[GENERAL] GUI for master-slave?

? (SimpleDB?)) services for this? Does NAVICAT do master-slave? Cheers, Bill -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] GUI for master-slave?

Since it supports master-slave with Slony, has anyone had good experience using phpPgAdmin for master-slave? Not much in docs... On Wed, Aug 6, 2008 at 2:59 PM, Bill Wordsworth <[EMAIL PROTECTED]> wrote: > Is there any GUI for master-slave (I prefer CLI too)? > > Are there any Post

Re: [GENERAL] How to get many data at once?

at is to process that row immediately instead of copying it from $row to $rows[]. > How to do this in a more efficient way? Use a more efficient language, such as C, instead of PHP. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone:

Re: [GENERAL] big database with very small dump !?

o see which directories have all the space. (or du -h --max-depth=1 /var/pgsql/data on Linux) -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 IMPO

Re: [GENERAL] automatic REINDEX-ing

mally not needed, although there _are_ some corner cases that seem to require it. One particular corner case is VACUUM FULL, which tends to bloat indexes. If you're using vacuum on a schedule appropriate to your database activity, you'll probably not need reindex. If you

Re: [GENERAL] Postgres eats all memory

other than PG on this system that are eating RAM. 3) You're being fooled by the fact that Linux will use all the available RAM all the time (which isn't particularly a bad thing) -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAI

Re: [GENERAL] text .vs. varchar

let's say I choose an upper limit (p.ex. 200) for the string sizes > and I start a fresh database with VARCHAR(200). > > What tradeoffs can I expect ? disk usage ? query execution times ? See the "Tip" on this page, it answers your questions: http://www.postgresql.org/docs

Re: [GENERAL] Custom sort

this by defining an ENUM for the values. ENUMs sort in the order the values were defined. You could also define a pgsql function that did the sort for you, if ENUMs didn't cut it. i.e.: SELECT sort_col FROM some_table ORDER BY my_sort_func(sort_col); -- Bill Moran Collaborative Fusion Inc. h

Re: [GENERAL] What's size of your PostgreSQL Database?

fast, high- quality disks, as 10 15,000 RPM disks are going to perform better than 10 7,200 RPM disks. Another solution is RAM, if you can get enough RAM in the system to hold your working set of data, then the speed of the disk is not really relevant. Of course, that's tough to do if you&

Re: [GENERAL] Re: can't get UPDATE ... RETURNING ... INTO ... to compile successfully

.html > > As per this documentation, you should be able to do it. It works for > the INSERT command, but not UPDATE. For the INSERT command, it makes > my code look neater and I image it's more efficient too. Is it possible that your UPDATE command is updating multiple rows? I don

Re: [GENERAL] CASE

to be executed for each case. Personally, I don't understand the question. Perhaps if you provided an example of what you are trying to do with CASE WHEN and why it doesn't work for you. It _does_ sound like you need to be using something like pl/pgsql. -- Bil

Re: [GENERAL] Re: can't get UPDATE ... RETURNING ... INTO ... to compile successfully

In response to Alvaro Herrera <[EMAIL PROTECTED]>: > Bill Moran wrote: > > > Is it possible that your UPDATE command is updating multiple rows? I > > don't believe RETURNING will work on an UPDATE that touches more than 1 > > row. > > Hmm, why not?

Re: [GENERAL] DELETE

Add the USING list clause: usinglist A list of table expressions, allowing columns from other tables to appear in the WHERE condition. This is similar to the list of tables that can be specified in the FROM Clause of a SELE

Re: [GENERAL] Single character bitfields

and what you're trying to accomplish, but there's a bit string type: http://www.postgresql.org/docs/8.3/static/datatype-bit.html -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-general m

Re: [GENERAL] Dumping/Restoring with constraints?

computer (Mac OSX > with 8.3.3) and unzip it to mydb.sql. > > The local database is already created, with all tables and constraints and > all. Don't do that. Do one of the following: *) Allow the dump file to create all tables. *) In the early step dump the data

Re: [GENERAL] Dumping/Restoring with constraints?

In response to "Phoenix Kiula" <[EMAIL PROTECTED]>: > Thanks Bill for this recommendation: > > > > *) In the early step dump the data only with pg_dumpall --disable-triggers > > -a > > > Dumb question. Will this kind of pg_dumpall lead to down

Re: [GENERAL] Dumping/Restoring with constraints?

ng pg_dump (which you don't mention ... it's getting difficult to follow what you're doing in this thread) then you can also use the -C option to have pg_dump add a CREATE DATABASE statement to the dump file for you. If you actually want to switch database encodings, that's an

Re: [GENERAL] Vaccuum best practice: cronjob or autovaccuum?

with other users, feel free to continue as you are. It won't cause you any problems. The naptime at 600 is probably a bad idea. If you only have one user database on this system, then it only gets investigated by autovac once every 40 minutes (template0 ... template1 ... postgres ... yourdb) Consi

Re: [GENERAL] Vaccuum best practice: cronjob or autovaccuum?

In response to Alvaro Herrera <[EMAIL PROTECTED]>: > For the record: > > Bill Moran escribió: > > > The naptime at 600 is probably a bad idea. If you only have one user > > database on this system, then it only gets investigated by autovac once > > every

Re: [GENERAL] Vaccuum best practice: cronjob or autovaccuum?

cannot have. We use 'modest' > processors and 'modest' storage, in highly dependable embedded systems. Oh ... well this might change a lot. Depending on what you mean by "embedded", you may be using experience that's _very_ specialized to make gene

[GENERAL] RAISE NOTICE format in pgAdmin

sing RAISE NOTICE to debug functions? Bill -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] SELECT INTO returns incorrect values

PARENT ID: % % ', CATEGORY_NAME, PARENT_ID; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE Thanks, Bill -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Oracle and Postgresql

. Yes, you have to write a big check but you are insuring against a big risk. As others have stated, many of the factors that have a major influence on the choice of a database are not technical. Bill -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Server installation problem using freebsd ports

ate your ports tree (cvsup/portsnap) and try again. > If not working, show your /etc/make.conf > > > p.s. this is FreeBSD specific question and should go to freebsd-questions@ Or freebsd-ports, but either way it's working fine for me here on FreeBSD 6 with PG 8.3 port from

Re: [GENERAL] "Healing" a table after massive updates

nchmarks to see if it's really needed before you commit to it as a scheduled operation. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 IMPORTANT:

Re: [GENERAL] "Healing" a table after massive updates

In response to Alvaro Herrera <[EMAIL PROTECTED]>: > Bill Moran wrote: > > In response to "Gauthier, Dave" <[EMAIL PROTECTED]>: > > > > > I might be able to answer my own question... > > > > > > vacuum FULL (analyze is optional) &

Re: [GENERAL] Windows ODBC Driver

r for ODBC. It sees TEXT fields as VARCHAR instead of LONGVARCHAR. I do not know if the problem is at the ODBC level or the ADO level but test carefully if you are going to use TEXT fields. Bill

Re: [GENERAL] Windows ODBC Driver

Stephen Frost wrote: * Bill Todd ([EMAIL PROTECTED]) wrote: FWIW I cannot get the ODBC driver to work correctly with ADO and the OLE DB provider for ODBC. It sees TEXT fields as VARCHAR instead of LONGVARCHAR. I do not know if the problem is at the ODBC level or the ADO level but test

Re: [GENERAL] nightly vacuum

yze > and\or reindex on a regular basis. So can you point me to any of the > settings that I may have wrong to have this done for me automatically? If this database is read-only aside from your massive uploads, then the following process will suffice: 1) Truncate all tables 2) Upload new data 3) a

Re: [GENERAL] Autovacuum, too often?

ight answer, but it seems to be a good answer 99% of the time. Sounds like your developers are using the database for what it was intended for, instead of just doing single row selects like a lot of amateurs I've come across. -- Bill Moran Collaborative Fusion Inc. [EMAIL PROTECTED] Phon

Re: [GENERAL] setting Postgres client

ct to with -h or put options in your .psqlrc file or set appropriate environment variables. More details here: http://www.postgresql.org/docs/8.2/static/app-psql.html -- Bill Moran Collaborative Fusion Inc. [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-general mailing list (pgsq

[GENERAL] Need Some Explanation of an EXPLAIN

ions of the two tables followed by the query plan that my PostgreSQL wants to use. So I have two questions: 1.) Why won't it use the indexes? 2.) How can I make this update faster? TIA, Bill Thoen Table "public.id2" Column | Type | Modifiers ---+--

[GENERAL] Why Does UPDATE Take So Long?

QUERY PLAN Seq Scan on farms (cost=0.00..59144.07 rows=2772207 width=54) (1 row) TIA, - Bill Thoen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Why Does UPDATE Take So Long?

Scott Marlowe wrote: On Tue, Sep 30, 2008 at 1:00 PM, Bill Thoen <[EMAIL PROTECTED]> wrote: Working with PG 8.1 I'm trying to update a char(4) column, and it's taking a very long time; 15 minutes so far and no end in sight. From the explain, it doesn't seem like it should ta

Re: [GENERAL] Why Does UPDATE Take So Long?

In response to Bill Thoen <[EMAIL PROTECTED]>: > Doesn't look like that's the problem. I moved my table over to another > Linux box running PG 8.3 and update performance was pretty bad there as > well. In the time that PG 8.3 was struggling with update there I created

Re: [GENERAL] Why Does UPDATE Take So Long?

fers are = 1000 #checkpoint_segments = 3 #checkpoint_timeout = 300 #checkpoint_warning = 30 What should I be looking for in the configuration to improve UPDATE performance? Thanks, - Bill Thoen Bill Moran wrote: In response to Bill Thoen <[EMAIL PROTECTED]>: Doesn't look like that's

Re: [GENERAL] Why Does UPDATE Take So Long?

Alvaro Herrera wrote: Bill Moran wrote: What I suspect is that the typical tuning advice applies here. I don't see any information about your configuration or your hardware setup. * What are shared_buffers set at? * What do the checkpoint configs look like? * In general, what does

Re: [GENERAL] How to force PostgreSQL to use multiple cores within one connection?

then ask PostgreSQL to read it. There is a network API for COPY. Look up pg_put_line (or PQputLine or whatever the convention is for whatever API you're using). -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-346

Re: [GENERAL] Why Does UPDATE Take So Long?

table. The alternative UPDATE farms SET prog_year='2007'; takes hours! I don't know how many because I gave up after waiting for 1.5 hrs. Thanks all, - Bill Thoen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to force PostgreSQL to use multiple cores within one connection?

. > > > > Thanks. Was this query entered in psql shell? > > Yes, but if you're using something like php, you can enter it as a > single string and it will work. php also has pg_put_line(), which reduces the memory overhead on both the client and server. Hopefully, whateve

Re: [GENERAL] WARNING: 25P01: there is no transaction in progress

that log output ... it looks a little too low-level to be practical. I recommend setting log_statement=all in postgresql.conf. This will log every statement that's executed to your PG log file, which should give you an excellent view of what's actually happening. -- Bill Moran Collabora

Re: [GENERAL] WARNING: 25P01: there is no transaction in progress

hat they're sending an extra commit transaction on > line 36. > > Could someone do us a favour and check I've not misread that? Looks like it to me. Notice that they frequently issue two "start transaction" in a row. Seems like a flaw in their programming

Re: [GENERAL] on windows 8.3 many processes - is it normal?

In response to johnf <[EMAIL PROTECTED]>: > When I open task manager there appears 10 'postgres.exe' in the list. I this > normal. Windows XP, postgres 8.3 Postgres starts a new process for each connection in addition to a few maintenance processes. -- Bill Moran Co

[GENERAL] Left outer join question

thing you just can't do. Maybe it is possible to join T1 and T1again, back to each other but I didn't want to do that. Many Thanks, Bill -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Left outer join question

Thanks much. Silly Me, I had an extraneous comma -Original Message- From: Raymond O'Donnell [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2008 8:12 PM To: Bill Reynolds Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Left outer join question On 08/10/2008 01:02,

[GENERAL] Question About UNION

I'm trying to combine two tables, but I only want unique records based on the first two columns. Can UNION be used to join three-column tables but only include records based on the uniqueness of the first two columns? If not, how would I do this with PostgreSQL 8.1? -- Sent via pgsql-general

Re: [GENERAL] Question About UNION

Raymond O'Donnell wrote: On 09/10/2008 17:36, Bill Thoen wrote: I'm trying to combine two tables, but I only want unique records based on the first two columns. Can UNION be used to join three-column tables but only include records based on the uniqueness of the first two colum

Re: [GENERAL] Question About UNION

Raymond O'Donnell wrote: On 09/10/2008 17:59, Bill Thoen wrote: I'm trying to combine two tables, but I only want unique records based on the first two columns. Can UNION be used to join three-column tables but only include records based on the uniqueness of the first two colum

Re: [GENERAL] Question About UNION

Raymond O'Donnell wrote: On 09/10/2008 17:59, Bill Thoen wrote: I'm trying to combine two tables, but I only want unique records based on the first two columns. Can UNION be used to join three-column tables but only include records based on the uniqueness of the first two colum

Re: [GENERAL] Question About UNION

David Wilson wrote: On Thu, Oct 9, 2008 at 1:48 PM, Bill Thoen <[EMAIL PROTECTED]> wrote: No, this won't work. Here's an example of my tables: Table1 1, 12, A 2, 16, B 8, 6, A 19, 9, C Table2 1, 13, D 2, 16, B 8, 6, B 12, 5, A select * from table1 union select tabl

Re: [GENERAL] Question About UNION

David Wilson wrote: On Thu, Oct 9, 2008 at 3:31 PM, Bill Thoen <[EMAIL PROTECTED]> wrote: Thanks, but that didn't work. That selected only the records from table1. That's why I warned you about it being written in gmail. :) I'm sorry, you had it right the

Re: [GENERAL] Question About UNION

Josh Williams wrote: On Thu, 2008-10-09 at 10:59 -0600, Bill Thoen wrote: I'm trying to combine two tables, but I only want unique records based on the first two columns. Can UNION be used to join three-column tables but only include records based on the uniqueness of the first two co

[GENERAL] Bug In COPY TO?

I noticed that in PG 8.1 the docs for COPY TO say that you can use WITH HEADER, but when I do that it throws an error saying that this works only in CSV mode. Is this a bug or do I have something wrong with my syntax? COPY mytable TO '/data/out.txt' WITH HEADER DELIMITER '|' NULL '' ; -- Sen

Re: [GENERAL] what are those 3 passwords for ?

ire password authentication. So, even with the second command, you're still only using 1 password when you create the account. I feel that the man page for createuser explains this pretty well. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROT

[GENERAL] Update with a Repeating Sequence

| 0 4 | 0 5 | 0 6 | 0 into: field_id | seq --+- 1 | 0 2 | 0 3 | 0 3 | 1 3 | 2 4 | 0 4 | 1 5 | 0 6 | 0 What's the best way to that? TIA, - Bill Thoen -- Sent via pgsql-gener

Re: [GENERAL] Update with a Repeating Sequence

field_id if curr_seq is null then NEW.seq := 0 else NEW.seq := curr_seq + 1 (You have to figure out how to build the trigger infrastructure...) If you need to do it on a table that is already populated, let us know. On Tue, Oct 14, 2008 at 9:21 AM, Bill Thoen <[EMAIL PROTECTED]>

Re: [GENERAL] Update with a Repeating Sequence

Steve Atkins wrote: On Oct 14, 2008, at 9:04 AM, Bill Thoen wrote: I've got a table with repeated records that I want to make unique by adding a sequence code of 0,1,2,...,n for each set of repeated records. Basically, I want to turn: field_id | seq --+- 1 | 0

Re: [GENERAL] Update with a Repeating Sequence

Grzegorz Jas'kiewicz wrote: alter table foo add newid sequencial; alter table foo drop field_id; alter table foo rename newid to field_id; I can't do that; I need to preserve the field_id values. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your s

[GENERAL] UPDATE and Indexes and Performance

low update, which is further slowed by the presence of indexes. So when doing a large update should I just drop the indexes first, or is there some good reason to keep them? Thanks, - Bill Thoen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your su

Re: [GENERAL] Annoying Reply-To

before you send? You'd better, because a small > typo when you selected the recipient might mean that you're sending > love-letters to your boss or something like that :) I'd rather know that the computer had my back in the case of an error, instead of it helping me mindl

Re: [GENERAL] Annoying Reply-To

In response to "Mikkel Høgh" <[EMAIL PROTECTED]>: > > On 17/10/2008, at 13.20, Bill Moran wrote: > > > In response to "Mikkel Høgh" <[EMAIL PROTECTED]>: > > > >> On 17/10/2008, at 12.24, Tomasz Ostrowski wrote: > >> &g

Re: [GENERAL] Annoying Reply-To

In response to "Mikkel Høgh" <[EMAIL PROTECTED]>: > > On 17/10/2008, at 14.01, Bill Moran wrote: > > > Or, you could just be lonely. > > I resent that you're trying to make this a personal thing. I was going to answer the rest of this email, then I rea

[GENERAL] How Do I Find the Date When A Table Was Last Changed?

Is there a way to find when data in a postgresql table was last changed? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] TIME column manipulation/comparison hangups

ork, but it sure feels hacky to do: (extract(hours from now()) = extract(hours from time_column) AND (extract(minutes from now()) = extract(minutes from time_column) Am I missing something obvious? Anyone have any better methods for doing this? I'm working on 8.3. -- Bill Moran Collab

Re: [GENERAL] TIME column manipulation/comparison hangups

In response to "Scott Marlowe" <[EMAIL PROTECTED]>: > On Mon, Nov 3, 2008 at 12:01 PM, Bill Moran > <[EMAIL PROTECTED]> wrote: > > > > I'm trying to test the time in a time column to see if it's the same > > minute as the current ti

date_trun() with timezones? (was Re: [GENERAL] TIME column manipulation/comparison hangups)

In response to "Scott Marlowe" <[EMAIL PROTECTED]>: > On Mon, Nov 3, 2008 at 12:25 PM, Bill Moran > <[EMAIL PROTECTED]> wrote: > > In response to "Scott Marlowe" <[EMAIL PROTECTED]>: > > > >> On Mon, Nov 3, 2008 at 12:01 PM, Bill

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

very low, as PG only needs a single identifier, but I must have had _some_ reason for raising it. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

[GENERAL] Cannot restore table using pg_restore

the result.txt file are at the end of this message with only the data in the copy command removed. I must be doing something wrong but after three hours I cannot see what I am missing. Bill -- -- PostgreSQL database dump -- SET client_encoding = 'WIN1252'; SET standard_conforming_strin

[GENERAL] COPY with a variable path

? copy contact.palm_import from 'c:/_junk/palm.csv' with delimiter as ',' null as '' csv quote as '"'; Thanks, Bill -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] COPY with a variable path

Raymond O'Donnell wrote: On 27/11/2008 20:52, Bill Todd wrote: Substituting the input parameter for the literal path does not work and neither does using PREPARE/EXECUTE. How can I pass the file path as a parameter? You could write a pl/pgsql function which constructs the query

Re: [GENERAL] COPY with a variable path

Raymond O'Donnell wrote: On 27/11/2008 20:52, Bill Todd wrote: Substituting the input parameter for the literal path does not work and neither does using PREPARE/EXECUTE. How can I pass the file path as a parameter? You could write a pl/pgsql function which constructs the query

Re: [GENERAL] restored over postgres database

> when it starts up) > run initdb > start postgres > > All should now be clean and fresh. Assuming he meant the entire cluster and not just the postgres database. If the latter, a DROP/CREATE will return it to the normal state. -- Bill Moran Collaborative Fusion Inc. http://people.

Re: [GENERAL] Switch off PITR

reload won't cause that parameter to be re-evaluated. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 IMPORTANT: This message contains confide

[GENERAL] COPY error with null date

eld, "", is a null date and causes the error following the record. How can I change the copy command above so that a null date or number will be imported as null? I do not care if empty strings are imported as an empty string or a null. Bill "IASAcctSys","09/09/1995&q

Re: [GENERAL] COPY error with null date

Joshua D. Drake wrote: On Fri, 2008-12-05 at 12:00 -0700, Bill Todd wrote: Joshua D. Drake wrote: On Thu, 2008-12-04 at 19:35 -0700, Bill Todd wrote: null as IS NULL results in the following error. ERROR: syntax error at or near "is" LINE 5: null

Re: [GENERAL] Editor for sgml files

ty good support for SGML/XML-ish files. Shows you when you're missing end tags and the like. Might not be for everyone, but just an option thrown in the mix. -- Bill Moran http://www.potentialtech.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to yo

Re: [GENERAL] Editor for sgml files

In response to Peter Eisentraut : > * The Elements of Style Hope this doesn't start a flame war, but: http://chronicle.com/article/50-Years-of-Stupid-Grammar/25497 -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mail

Re: [GENERAL] safelly erasing dirs/files

king for secure data destruction (akin to rm's -P flag) I don't know if there is a canned method for doing so. -- Bill Moran http://www.potentialtech.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Fast Search on Encrypted Feild

you get speedy, indexed searches, and the decryption overhead is only felt when it's time to decrypt the foreign key and link the data. For a query that's selecting 50 rows out of 50,000, this is a huge win, and in the worst case, it's still no worse than encrypting the data itself.

Re: [GENERAL] safelly erasing dirs/files

From the on-line help: |DROP DATABASE| drops a database. It removes the catalog entries for the database and deletes the directory containing the data. Joao Ferreira gmail wrote: Hello all, How can I safelly erase (with rm command in Linux) files or dirs concerning a specific database ? a

Re: [GENERAL] Postgres issues "Not enough storage is available to complete this operation" exception

experience, I'd be willing to bet that you really _are_ running out of disk space at the time the error is reported. I believe that large transactions can cause this, because they take up a lot of disk space during processing that is then freed once the transaction is either co

Re: [GENERAL] Out of sync Primary Key Index

"content_node_field_pkey" PRIMARY KEY, btree (field_name) > > From googling I need to reset my Primary Key, but > > reindex index content_node_field_pkey; > REINDEX > > Doesn't make any difference (no error is returned) > > Nor does > reindex t

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

/pgsql-general > > _____ > Windows Live: Friends get your Flickr, Yelp, and Digg updates when they > e-mail you. > http://go.microsoft.com/?linkid=9691817 -- Bill Moran htt

Re: [GENERAL] Books, the lulu.com scam

The Adobe ebook reader is available for Windows and Mac. I thought Adobe offered a Linux version too but apparently not. It is not Lulu's fault that Adobe does not offer a Linux version of the ebook reader. Bill Alan Gruskoff wrote: So I bought this "book" thinking it was a P

Re: [GENERAL] Strange performance degradation

re so few. If you -TERM them, any uncommitted data will be rolled back, which may not be what you want. Don't -KILL them, that will upset the postmaster. My answer to your overarching question is that you need to dig deeper to find the real cause of your problem, you're just starting to

<    2   3   4   5   6   7   8   9   10   11   >