Re: [GENERAL] 9.6.1: INSERT with PK as serial [FIXED]

than that. That fixed all but one error which I'll address. Thanks, Rich -- 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] 9.6.1: INSERT with PK as serial

problem. It's now fixed. Much appreciated, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] COPY to question

user, can copy tables directly to ~/? Rich -- 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 to question [ANSWERED]

On Tue, 17 Jan 2017, Tom Lane wrote: Use psql's \copy instead. Thanks, Tom. Rich -- 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] Rookie Questions: Storing the results of calculations vs. not?

Action" by Robin Dunn to write the GUI for your application. "Introduction to SQL, 4th Edition" by Rich F. van der Laans to learn the power of the various SQL data manipulation clauses. "SQL for Smarties, 3rd Edition" by Joe Celko to get better insight into effectively writte

Re: [GENERAL] Historical Data Question

Rick F. van der Lans' "Introduction to SQL, 4th Ed." are also excellent sources of useful insight into temporal math. Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.| Accelerator(TM) <http:

Re: [GENERAL] Surrogate VS natural keys

relate multiple players and multiple clubs. If you think of the logic involved, your third table has only one row for each player-club combination. Therefore, each row is unique by definition and a surrogate key adds no value. Rich -- Richard B. Shepard, Ph.D. |The Environme

Re: [GENERAL] Surrogate VS natural keys

specified point in time, it gets much more complicated. That's when reading Rick Snodgrass' book helps a lot. Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.| Accelerator(TM) <http://www.appl-ecosys.

Re: [GENERAL] simple SQL question

strings, why not enter and store them with the decimal point? Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.| Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-66

Re: [GENERAL] Intelligent Database in postgreSQL

ng a fuzzy SQL addon. I've not looked at it in a while because we don't need that capability right now. I've never looked for a hook to a NN so I cannot comment on that. Neural networks, of course, are totally different from fuzzy logic, and address different problems. They are

Re: [GENERAL] How to handle 'not a number' in postgresql

I will have to hack it in with a boolean and would rather not do so. It would be appropriate to convert NaN to NULL since the valid is literally unknown. Rich -- Richard B. Shepard, Ph.D. | IntegrityCredibility Applied Ecosystem Services, Inc.|

Re: [GENERAL] How to handle 'not a number' in postgresql

"unknown value." The same holds when the equipment mal-functions. The result would be a number if the equipment worked, but that does not make it a non-number otherwise. Maybe we have a difference in semantics that is dependent upon the application. Rich -- Richard

[GENERAL] Locking & concurrency - best practices

I have a "parent_tbl" and dozens of data tables, with foreign keys referencing the PK of "parent_tbl" (one-to-many). There are 100+ users accessing the application, usually (but not always) each user is working on a different record in parent_tbl. (this would seem like a pretty standard scena

Re: [GENERAL] Locking & concurrency - best practices

> You should be able to do "select for update" on both parent and child > records and get the effect you desire. > I don't think that will work. Let me demonstrate: (this is simplified, but sufficient to make my point) -- Connection 1 -- begin trans; select * from parent_tbl where id=1 for upda

Re: [GENERAL] Locking & concurrency - best practices

> > From what I can tell, this kind of roll-your-own application level > locking system is exactly what advisory locks are for. Search the > archives for the last couple of weeks as I remember someone posting > some really helpful functions to assist in using advisory locks. > > Erik Jones Yes

Re: [GENERAL] Locking & concurrency - best practices

> Advisory locks would work here (better that than table lock), but I > don't think that's the right approach. Transaction 2 should simply do > a > select * from parent_tbl > where id=1 for update; > > at the start of the transaction. That's actually what I'm doing (just forgot to include it in

[GENERAL] altering foreign keys

In my database, I have a core table that nearly all other tables key against. Now I need to adjust all of those foreign keys to add a "on update cascade" action. Is there a way to alter the existing keys? (it didn't jump out at me in the manual) If not, is there a serious issue preventing this

Re: [GENERAL] altering foreign keys

> In my database, I have a core table that nearly all other tables > key against. Now I need to adjust all of those foreign keys to > add a "on update cascade" action. Is there a way to alter the > existing keys? (it didn't jump out at me in the manual) > Would it be possible to modify confupdt

Re: [GENERAL] Simple row serialization?

> I'd like to implement some simple data logging via triggers on a small > number of infrequently updated tables and I'm wondering if there are > some helpful functions, plugins or idioms that would serialize a row If you're familiar with perl, you can try PL/Perl. http://www.postgresql.org/docs

Re: [GENERAL] Getting the count(*) from two tables and two date ranges in same query

> Resulting in 4 columns in the ResultSet like: > > count(*)_from_table2_between_fromdate1_and_todate1 = X > count(*)_from_table2_between_fromdate2_and_todate2 = Y > count(*)_from_table3_between_fromdate1_and_todate1 = Z > count(*)_from_table3_between_fromdate2_and_todate2 = V > > Is thi

Re: [GENERAL] Oracle Analytical Functions

> and I would like to create a new view that takes the first table and > calculates the time difference in minutes between each row so that the > result is something like: > > client_id,datetime, previousTime, difftime > 122,2007-05-01 12:01:00, 2007-05-01 12:00:00, 1 > 455,2007-05-01 12:03:00, 20

Re: [GENERAL] Oracle Analytical Functions

> I tried this function but it keeps returning an error such as: > > ERROR: invalid input syntax for integer: "2007-05-05 00:34:08" > SQL state: 22P02 > Context: PL/pgSQL function "lagfunc" line 10 at assignment Whoops, this line: > > client_id := thisrow.datetime; Should be: clien

Re: [GENERAL] NoSQL -vs- SQL

t of developing a better tool for a specific application or class of applications. And that's my $2.00 worth. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Cannot Start Postgres After System Boot

o point out what I'm doing incorrectly (e.g., removing /tmp/.s.PGSQL.5432 and postmaster.pid when the startup process complains they're not right) I'll save this information for the next time. I can also provide the 'start' section of the Slackware init file so I could learn w

[GENERAL] Upgrade from 8.3.3

ith the 8.x releases), I wonder if I should upgrade to 8.4.5 or 9.0. I suspect the former, but I'd appreciate thoughts from more knowledgeable folks here. Rich -- 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] Cannot Start Postgres After System Boot

or do I need to do something first? Many thanks, Rich#!/bin/bash # PostgreSQL startup script for Slackware Linux # Copyright 2007 Adis Nezirovic # Licensed under GNU GPL v2 # Do not source this script (since it contains exit() calls) # Before you can run postgresql you'll need to

Re: [GENERAL] Cannot Start Postgres After System Boot

k properly to start the server. I will provide whatever system information is needed to help diagnose and fix this problem. Many thanks, Rich Many thanks, Rich -- 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] Cannot Start Postgres After System Boot

stgres | UTF8 template1 | postgres | UTF8 (7 rows) So, why can't I connect to a database by entering, for example, 'psql aesi'? Thanks, Rich -- 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] Cannot Start Postgres After System Boot

connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.post

Re: [GENERAL] Cannot Start Postgres After System Boot

On Thu, 21 Oct 2010, Lennin Caro wrote: Try to delete the files like this .s.PGSQL.5432 .s.PGSQL.5432.lock 8.x-main.pid and restart postmaster Lennin, The sockets are not to be found. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Cannot Start Postgres After System Boot

On Thu, 21 Oct 2010, Adrian Klaver wrote: What does your postgresql.conf file show for ? : listen_addresses = Adrian, #listen_addresses = 'localhost' # what IP address(es) to listen on; This hasn't changed. Thanks, Rich -- Sent via pgsql-general mailing list

Re: [GENERAL] Cannot Start Postgres After System Boot

le to cleanly stop and restart when necessary)? Many thanks, Rich -- 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] Cannot Start Postgres After System Boot

d your database. Scott, Postgres has not been running. That's the problem I've been trying to solve. The only reason I've manually killed the socket and its lock is when the system shut down uncleanly and postgres would not start while they were present. Thanks, Rich -- Sent via pgs

Re: [GENERAL] Cannot Start Postgres After System Boot

On Thu, 21 Oct 2010, Reid Thompson wrote: what does $ netstat -an |grep 5432 return? something is running on tcp port 5432 Doesn't show that. [rshep...@salmo ~]$ netstat -an |grep 5432 tcp0 0 127.0.0.1:5432 0.0.0.0:* LISTEN Rich -- Sent via

Re: [GENERAL] Cannot Start Postgres After System Boot

fect. I killed the lowest numbered process and that removed them all. However, I still cannot start a new postgresql process. Rich -- 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] Cannot Start Postgres After System Boot [SOLVED]

and cleanly upgrade postgres and move from 8.3.3 to 8.4.5. (I've just posted a question on the CMS MadeSimple forum asking if there's an issue with 9.0. If not, that's to what I'll upgrade.) Much grasses, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql

Re: [GENERAL] The first dedicated PostgreSQL forum

no longer use Usenet news groups as much as I did. When this same issue came up on other mail lists someone would always point out that there are websites (gmane, perhaps?) that allow a Web BUI interface to mail lists. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] The first dedicated PostgreSQL forum

supporting the idea of a Web-based forum. As an old curmudgeon I much prefer mail lists. Rich -- 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] The first dedicated PostgreSQL forum

On Sat, 13 Nov 2010, Tom Lane wrote: That would be cool. Wonder if there's something like that out there already. I don't know if BUI-based subscription is supported, but there are reported solutions. Take a look at gmane.org (mail<->Usenet news groups) and see if that m

[GENERAL] Proper Permissions for /usr/local/pgsql/data

ata": Operation not permitted The directory /usr/local/pgsql/data is owned by me; what should the permissions be so I don't get that error message above? TIA, Rich -- 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] Proper Permissions for /usr/local/pgsql/data

/upgrading. When the new version is installed in a different file system ownership information is not available. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] psql symbol lookup error

undefined symbol: PQconnectdbParams I've not encountered this with previous versions of postgres installed in /var/lib/pgsql/. I would like to understand why I get this error trying to run on the command line while L123 apparently has no problems using the httpd/firefox front en

Re: [GENERAL] psql symbol lookup error

[rshep...@salmo ~]$ psql aesi psql: error while loading shared libraries: libpq.so.5: cannot open shared object file: Permission denied Perms on the links /usr/lib/libpq.so.5 are 777 (owned by root.root); on /usr/local/pgsql/ they are the same. Continued pointers to solutions appreciated. Thanks, Ri

[GENERAL] Problems With -9.0.1

one/ man/postgresql.conf.sample timezonesets/ pg_hba.conf.sample psqlrc.sample tsearch_data/ pg_ident.conf.samplerecovery.conf.sampleunknown.pltcl pg_service.conf.sample snowball_create.sql What do I do to overcome this impasse and get postgres running aga

Re: [GENERAL] Problems With -9.0.1

cate an incomplete PostgreSQL installation, or that the file "/bin/postgres" has been moved away from its proper location. FATAL: invalid value for parameter "timezone_abbreviations": "Default" [1]+ Exit 1 postgres -D /usr/local/pgsql/data This

Re: [GENERAL] Problems With -9.0.1 [SOLVED]

ow me to log in. There's a problem with the perl DBD::Pg module that prevents it from loading. Sigh. I'll focus on that now. Thanks, Rich -- 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] Problems With -9.0.1

Ss 0:00 postgres: writer process 17321 ?Ss 0:00 postgres: wal writer process 17322 ?Ss 0:00 postgres: autovacuum launcher process 17323 ?Ss 0:00 postgres: stats collector process 17405 pts/1S+ 0:00 grep postgres All processes running. Thanks,

[GENERAL] Ownership/Permissions Problem

bject file: Permission denied Yet, when I su to user postgres and run the command it loads the shell: postg...@salmo:/home/rshepard$ psql aesi psql (9.0.1) Type "help" for help. aesi=# What directory or file has the incorrect ownership and/or permissions, and what should they be? Ric

Re: [GENERAL] Ownership/Permissions Problem

12 2010-12-14 10:08 /usr/local/pgsql/lib/libpq.so.5 -> libpq.so.5.3* -rwxr-xr-x 1 root root 153929 2010-12-14 10:08 /usr/local/pgsql/lib/libpq.so.5.3* So libpq.so.5.3 has 755 permissions. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make change

Re: [GENERAL] Ownership/Permissions Problem

Very_ much appreciated; this has distracted me since last Sunday. Happy holidays, Rich -- 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] Ownership/Permissions Problem

On Fri, 24 Dec 2010, Joshua D. Drake wrote: You will want to make sure you didn't do that to /usr/local/pgsql/data . /usr/local/pgsql/data should be 700. Thanks, Josh. Fixed. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

Re: [GENERAL] OOO and postgres

table stanza. You can use them on the table name with alter table and insert into. The data type is VARCHAR(), not character varying[]. Why are you altering the table to be exactly how you defined it? Use single quotes to define text strings in your values statements. Perhaps you&

Re: [GENERAL] How to generate unique invoice numbers foreach day

from 1-365/6) followed by 1, 2, or 3 digits depending on how many invoices are generated each day. Makes sorting and comparisons simple. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Importing/Appending to Existing Table

I have an existing table with 15,492 rows and want to add additional rows from a .csv file. If I use 'COPY from with delimiter as ":" csv quote as "'" ' will this overwrite existing rows in the table or append rows? Rich -- Sent via pgsql-general mailing

Re: [GENERAL] Importing/Appending to Existing Table

On Wed, 2 Feb 2011, Sergey Konoplev wrote: No it wont overwrite, it will append rows. Thank you, Sergey. Rich -- 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] Importing/Appending to Existing Table

tered then moved to the actual application tables. I will not be surprised to discover duplicate data because of data-entry errors, but there should not be any duplicates in these permit compliance monitoring results. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] set theory question

databases and defined the 12 rules that a fully relational dbms must implement. You might also find books by Joe Celko insightful and useful. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Best RDB book to suggest

ntals behind RDBMS, its hard not to mention E.F. Codd's /The Relational Model for Database Management This topic comes up fairly regularly. I suggest that A-B should search the mail list archives to find books that I and others have recommended when this question is asked. Rich -- Sent

[GENERAL] Explicit NULL for no INTEGER data?

: ERROR: invalid input syntax for integer: "" CONTEXT: COPY water_well, line 1, column depth_seal: "" Do I need an explicit NULL in that column? Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

Re: [GENERAL] Explicit NULL for no INTEGER data? -- Update

On Fri, 18 Feb 2011, Rich Shepard wrote: Do I need an explicit NULL in that column? Update: Placing NULL or a blank produces the same error. How should I represent no value for an integer column in a .csv file? Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Explicit NULL for no INTEGER data? -- Update

On Fri, 18 Feb 2011, Mike Christensen wrote: It looks like you have to specify your own NULL string with the NULL AS parameter of the COPY command. Mike, I completely missed that option when I've read the copy page. My apologies! Rich -- Sent via pgsql-general mailing list (pgsql-ge

[GENERAL] Finding Errors in .csv Input Data

| Notice the NULL value for gravel_packed, while the "106" is for depth_drilled, two columns later. I'm stymied and wonder if there's a tool I can use to fix these 80 rows so the copy command will accept them. Rich -- Sent via pgsql-general mailing list (pg

Re: [GENERAL] Finding Errors in .csv Input Data

|11/15/1948|D|||106|||106|6.62|0|60|102|1|12.00||30.00|||B|G|G|AIR COMPRESSOR TESTED 30 GPM ALSO||3|MEL MEYER|RT 1 BOX 10 RENO|||3|NV003|JSWINGHOLM|1/16/2003|||F|11/11/1948|||261013.36|4369139.23 I hope you're able to see what I keep missing as the source of the problem. Rich -- Sent vi

Re: [GENERAL] Finding Errors in .csv Input Data

"RT 1 BOX 10RENO,",,3,"NV003","JSWINGHOLM",1/16/2003,"",,"F",11/11/1948,,,261013.36,4369139.23 68670|724||0||11/27/1948|D|N|N||H|C|32031|087|N18|18N|E20|20E|07MD|39.44|119.77|NV003|M|KAIPER, R L|||SIERRA MANOR||11/15/1948|D|||106|||106|6.62|0

Re: [GENERAL] Finding Errors in .csv Input Data

g this. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] pgAdmin3 Issue

27;m running 9.0.1 I should upgrade pgadmin3! Makes no sense. What do I need to do to display the databases in pgadmin3? Rich -- 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] pgAdmin3 Issue

On Fri, 25 Feb 2011, Raymond O'Donnell wrote: Upgrade to 1.12? Ray, That appears to have done the trick. I somehow thought I was working on the latest version; it's been that sort of a week. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] How to Create Table from CSV

he quotes and with appropriate delimiter and null values. The backslash is needed to make it work. Rich -- 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] Finding Errors in .csv Input Data

On Sun, 6 Mar 2011, Dimitri Fontaine wrote: Did you try pgloader yet? Nope. I did determine the reasons and fixed them so all rows read into the table. Thanks for the suggestion, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] Post-Upgrade Question: 9.0.1 -> 9.0.3

base was created with 9.0.1 but another was created in the 7.x era. Rich -- 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] Post-Upgrade Question: 9.0.1 -> 9.0.3

. Well, regardless, I'll go looking when I return from walking the dogs. Rich -- 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] Post-Upgrade Question: 9.0.1 -> 9.0.3

w the former got there during the installation of 9.0.1. I removed /bin/psql and made a softlink from the 9.0.3 version to /bin. Thanks, Rich -- 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] Post-Upgrade Question: 9.0.1 -> 9.0.3

matched that of the other binaries in /usr/local/pgsql.9.0.1/bin/. 9.0.3 was also installed into /usr/local. Shrug, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Upgraded to 9.0.3, No Man Pages

Somehow, when I installed 9.0.3 the man pages weren't installed. They're in the source tree but not in /usr/local/pgsql/share/ so I cannot make a symlink to /usr/share/man. Might this be something in the 'make install' script? I'll manually install them. Rich

Re: [GENERAL] Upgraded to 9.0.3, No Man Pages

d to find them after upgrading to 9.0.3. No such luck. Rich -- 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] Upgraded to 9.0.3, No Man Pages

; make; make install. Rich -- 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] Upgraded to 9.0.3, No Man Pages

: and install: Thanks for tracking this down, Adrian. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Adding PK to Existing Table

olumn UNIQUE, then add a NOT NULL constraint? Rich -- 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] Adding PK to Existing Table [RESOLVED]

On Fri, 1 Apr 2011, Raghavendra wrote: Try out this... alter table add primary key(column name); Raghavendra, Aha! I missed noticing that I need parentheses around the column name. Much thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

[GENERAL] Postgres-9.x - ADODB - PHP

the PHP application can connect to the back end? Rich -- 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] Postgres-9.x - ADODB - PHP

On Wed, 6 Apr 2011, Joshua D. Drake wrote: This seems more like a question for the adodb list. OK, Josh. Have you a URL for subscribing? Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] Postgres-9.x - ADODB - PHP

On Wed, 6 Apr 2011, Rich Shepard wrote: Have you a URL for subscribing? Found one. Rich -- 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] Designing a DB for storing biological data

censored values. Since reporting levels change as instruments become more sensitive and analysts become better trained, you can have multiple reporting limits in your data. That's where the 'floor' and 'ceiling' columns come in. This should get you started. Rich -

Re: [GENERAL] Designing a DB for storing biological data

your spatial analyses with GRASS and your statistical analyses with R. Rich -- Richard B. Shepard, Ph.D. Applied Ecosystem Services, Inc. | Troutdale, OR 97060 USA www.appl-ecosys.com Voice: 503-667-4517 Fax: 503-667-8863 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

[GENERAL] Creating Table Copy

chema. While I suspect there's a way to write a SELECT statement for those rows that are not null and save the results to a different table name, I've not found the syntax in my postgres and SQL references. TIA, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] Creating Table Copy [RESOLVED]

On Mon, 16 Jun 2014, Rich Shepard wrote: While I suspect there's a way to write a SELECT statement for those rows that are not null and save the results to a different table name, I've not found the syntax in my postgres and SQL references. Got it: # create table benthos as sel

[GENERAL] Validating User Login Within Postgres

ogin within the database? What I've done in the past is search the User table for that name and password, return it to the application, and have a Python script see if the entered username and password match that stored in the table. All pointers and suggestions welcome. Rich -- Sent via p

Re: [GENERAL] Validating User Login Within Postgres

rate reports. Also, if you're thinking about security - please consider reading http://www.depesz.com/2007/08/18/securing-your-postgresql-database/ . Will do. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Question About Roles

s, she or he can be granted that group's privileges? Or, is that automatic if the role is included in the Users table? Rich -- 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] Question About Roles [ANSWERED]

On Wed, 2 Jul 2014, Tom Lane wrote: I might be misunderstanding, but I think you're looking for GRANT/REVOKE: GRANT rolename TO newuser; tom, You correctly understand my question. That's the syntax I need and did not see. Thank you, Rich -- Sent via pgsql-general mailing l

Re: [GENERAL] Question About Roles

this is doing. Initially, I read it as assigning a new user's role to an existing group's role; that's the opposite of what I want. Thanks, Rich -- 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] Question About Roles

steep, and it would add the cost and time of setting up and maintaining an in-house (or colo) httpd server. That's not my expertise, interest, or business. So, a stand-alone application is the route I've chosen. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgres

Re: [GENERAL] Question About Roles

. David, Ah, so! I'll read the docs to better understand this approach. Thanks for clarifying, Rich -- 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] Question About Roles

you want: CREATE USER new_management_user [other stuff here] IN ROLE management; Got it. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Appended '+' in Column Value

ero: select count(*) from benthos where stream = 'StarvationCrk'; count --- 204 select count(*) from benthos where stream = 'StarvationCrk+'; count --- 0 TIA, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Appended '+' in Column Value

On Sat, 23 Aug 2014, Ian Barwick wrote: You have a newline character. Try: select count(*) from benthos where stream = E'StarvationCrk\n'; Ian, Interesting; that query returned 202 of 204 rows. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Appended '+' in Column Value

On Fri, 22 Aug 2014, Adrian Klaver wrote: Is this only in psql? Adrian, Yes. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] UPDATE table: Syntax to Remove Terminal '\n'

hen I select distinct for that column: StarvationCrk+ That's a blank line below the name. TIA, Rich -- 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] UPDATE table: Syntax to Remove Terminal '\n' [RESOLVED]

that worked: update benthos set stream = 'StarvationCrk' where stream = E'StarvationCrk\n'; Much appreciated, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Single Table Report With Calculated Column

le in the chapter on table partitioning, but I could not apply that model to my table. TIA, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

<    1   2   3   4   5   6   7   8   >