Re: [GENERAL] pg_get_serial_sequence Strangeness/Unreliable?
ALTER SEQUENCE OWNED BY worked! Thanks folks. jeff. On 26-Nov-08, at 1:04 PM, Alvaro Herrera wrote: Jeff MacDonald wrote: Hi Tom, so far as I know the table owns the serial in so much as when i do a \d of the table it says this status_id | integer | not null default nextval('status_status_id_seq'::regclass) How else can I check? He means ALTER SEQUENCE ... OWNED BY I don't know how you can ensure that it is, short of begin; drop table status; \d status_status_id_seq -- verify that the sequence exists; if owned, it should have been dropped too rollback; -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- 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] pg_get_serial_sequence Strangeness/Unreliable?
On 25-Nov-08, at 10:44 AM, Tom Lane wrote: Jeff MacDonald [EMAIL PROTECTED] writes: The issue, is that when I run pg_get_serial_sequence on a particular table/column it returns NULL. Does the column actually own that sequence? Or is its default just something that was inserted manually? Hi Tom, so far as I know the table owns the serial in so much as when i do a \d of the table it says this status_id | integer | not null default nextval('status_status_id_seq'::regclass) How else can I check? -- 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] pg_get_serial_sequence Strangeness/Unreliable?
On 25-Nov-08, at 10:51 AM, V S P wrote: Did you first insert into public.news_status insert into public.news_status (status_id) values (DEFAULT) and then get the sequence? Hi VSP I'm not sure what relevance this has, a sequence already exists whether you insert into it or not. Just sometimes if you don't insert or select, you cannot get the currval for that session. Also since you have a domain 'public' I personally always do 'set searc_path to public' before doing any SQLs -- this way I know that I do not need to prefix my table names with 'public' all the time. I don't have a need for multiple schemas right now, so public is assumed. Thanks tho. jeff. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] pg_get_serial_sequence Strangeness/Unreliable?
Hello everyone, I'm using PostgreSQL 8.2.5 on amd64-portbld-freebsd6.1, compiled by GCC cc (GCC) 3.4.4 [FreeBSD] 20050518 The issue, is that when I run pg_get_serial_sequence on a particular table/column it returns NULL. Here are my tests: simplyas_associations= \d news_status Table public.news_status Column | Type | Modifiers ---+--- + status_id | integer | not null default nextval('status_status_id_seq'::regclass) newsletter_id | integer | not null status| boolean | not null indate| character varying(15) | not null Indexes: status_pkey PRIMARY KEY, btree (status_id) status_newsletter_id btree (newsletter_id) simplyas_associations= select pg_get_serial_sequence('news_status','status_id'); pg_get_serial_sequence (1 row) So, for fun I added a new column to this table , and ran pg_get_serial_sequence there simplyas_associations= alter table news_status add column test_id serial; NOTICE: ALTER TABLE will create implicit sequence news_status_test_id_seq for serial column news_status.test_id ALTER TABLE simplyas_associations= select pg_get_serial_sequence('news_status','test_id'); pg_get_serial_sequence public.news_status_test_id_seq (1 row) So my new column works. The only next step I could think of was to compare my 2 sequences with \d, turns out their attributes are both identical. Ideas? Thanks Jeff MacDonald -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Solaris 10, mod_auth_pgsql2
Greetings. I'm trying to compile mod_auth_pgsql2 for Solaris 10, I have the blastwave packages installed for libpq, apache2 and apache2_devel I'm following this how to http://archives.postgresql.org/pgsql-performance/2007-10/msg00076.php However, when I run it i get this sandbox# /opt/csw/apache2/sbin/apxs -i -a -c -l /opt/csw/postgresql/ include -L /opt/csw/postgresql/lib -lpq mod_auth_pgsql.c /opt/csw/apache2/share/build/libtool --silent --mode=compile cc - prefer-pic -DSSL_EXPERIMENTAL -DSSL_ENGINE -xO3 -xarch=386 -xspace - xildoff -I/opt/csw/bdb44/include -I/opt/csw/include -I/opt/csw/bdb44/ include -I/opt/csw/include -DSOLARIS2=8 -D_POSIX_PTHREAD_SEMANTICS - D_REENTRANT -mt -I/opt/csw/apache2/include -I/opt/csw/apache2/ include -I/opt/csw/apache2/include -I/opt/csw/bdb44/include -I/opt/ csw/include -c -o mod_auth_pgsql.lo mod_auth_pgsql.c touch mod_auth_pgsql.slo mod_auth_pgsql.c, line 117: cannot find include file: libpq-fe.h mod_auth_pgsql.c, line 520: undefined symbol: PGresult mod_auth_pgsql.c, line 520: undefined symbol: pg_result mod_auth_pgsql.c, line 521: undefined symbol: PGconn mod_auth_pgsql.c, line 521: undefined symbol: pg_conn mod_auth_pgsql.c, line 533: warning: implicit function declaration: PQsetdbLogin mod_auth_pgsql.c, line 536: warning: implicit function declaration: PQstatus mod_auth_pgsql.c, line 536: undefined symbol: CONNECTION_OK mod_auth_pgsql.c, line 537: warning: implicit function declaration: PQreset mod_auth_pgsql.c, line 540: warning: implicit function declaration: PQerrorMessage mod_auth_pgsql.c, line 545: warning: implicit function declaration: PQfinish mod_auth_pgsql.c, line 555: warning: implicit function declaration: PQexec mod_auth_pgsql.c, line 565: warning: implicit function declaration: PQresultStatus mod_auth_pgsql.c, line 565: undefined symbol: PGRES_EMPTY_QUERY mod_auth_pgsql.c, line 566: warning: implicit function declaration: PQclear mod_auth_pgsql.c, line 571: undefined symbol: PGRES_TUPLES_OK mod_auth_pgsql.c, line 579: warning: implicit function declaration: PQntuples mod_auth_pgsql.c, line 580: warning: implicit function declaration: PQgetvalue mod_auth_pgsql.c, line 580: warning: improper pointer/integer combination: op = mod_auth_pgsql.c, line 841: warning: implicit function declaration: crypt mod_auth_pgsql.c, line 1123: warning: syntax error: empty declaration cc: acomp failed for mod_auth_pgsql.c apxs:Error: Command failed with rc=65536 Now the strange thing is this sandbox# ls -l /opt/csw/postgresql/include/libpq-fe.h -rw-r--r-- 1 root bin17983 Feb 16 2007 /opt/csw/ postgresql/include/libpq-fe.h I'm not that great with compiling and whatnot, so I'm at a bit of a loss. Advice ? Thanks. Jeff MacDonald Interchange Technologies 613 292 6239 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Solaris 10, mod_auth_pgsql2
Yup, this was in thanks ! Jeff. On 1-Nov-07, at 2:27 PM, Tom Lane wrote: Jeff MacDonald [EMAIL PROTECTED] writes: sandbox# /opt/csw/apache2/sbin/apxs -i -a -c -l /opt/csw/postgresql/ I think you want -I not -l in front of that include path ... regards, tom lane Jeff MacDonald Interchange Technologies 613 292 6239 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] Compile problems with contrib/xml in 7 series
Hi, I think the subject says it all. I need to install contrib/xml from the 7 series, not contrib/xml2 from the 8 series. See below for my attempted build http://www.suite2101.com/help/pgsql Please let me know if you have any ideas. -- Unless otherwise indicated, anything I write is either garnered from experience or pulled out of my ass, depending on situational needs.. Jeff MacDonald ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Compile problems with contrib/xml in 7 series
On 5/15/07, Joshua D. Drake [EMAIL PROTECTED] wrote: Jeff MacDonald wrote: Hi, I think the subject says it all. I need to install contrib/xml from the 7 series, not contrib/xml2 from the 8 series. See below for my attempted build http://www.suite2101.com/help/pgsql Please let me know if you have any ideas. looks like you are missing your -dev packages for xml. except that they are all in /usr/include/libxml2/libxml I even tried gmake -I/usr/include/libxml2/libxml no go. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Compile problems with contrib/xml in 7 series
On 5/15/07, Alvaro Herrera [EMAIL PROTECTED] wrote: Jeff MacDonald escribió: On 5/15/07, Joshua D. Drake [EMAIL PROTECTED] wrote: Jeff MacDonald wrote: Hi, I think the subject says it all. I need to install contrib/xml from the 7 series, not contrib/xml2 from the 8 series. See below for my attempted build http://www.suite2101.com/help/pgsql Please let me know if you have any ideas. looks like you are missing your -dev packages for xml. except that they are all in /usr/include/libxml2/libxml configure --with-includes=/foo/bar maybe? Or something along that line. There isn't a configure in the contrib/xml directory, i did try make -I/usr/include/libxml2 and make -I/usr/include/libxml2/libxml Jeff. -- Unless otherwise indicated, anything I write is either garnered from experience or pulled out of my ass, depending on situational needs.. Jeff MacDonald ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] a bug, now(), default CURRENT_TIME, WAL Logs.
Hi Folks, Well I think i had 'now' in there in someplaces and that got parsed. I've fixed it in all databases on my system now, so doing forward I'm safe. However there is a 2 week period in which the dates for some items are not what they should be. Of course they should be now() whenever now was at the time, but they are all 2005-09-21 21:09:59.180154-04 I was wondering if there was a way I could use the WAL logs to find what date certain oid's were inserted. Then query my table where date = 2005-09-21 21:09:59.180154-04, corelate the time in teh WAL log and update my table.. But I've no idea how to iteract with the wal log. Thanks again folks. Could you have done something like: CREATE TABLE ts_def_test2(a int4, b timestamp with time zone default 'now'); Which gives: CREATE TABLE ts_def_test2 ( a integer, b timestamp with time zone DEFAULT '2005-10-05 00:08:05.381034+01'::timestamp with time zone ); The difference being that 'now' is a literal timestamp (with timezone) that gets evaluated in your CREATE TABLE statement. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] a bug, the bugs list, and how to break the website search.
Hi, I very rarely have reason to post to this list so I was reluctant to sign up for such heavy traffic, but I have a few things to bring up and they're all 'general' 1: Go to the website and type in now() into the search box, it will break Error in query: Unmatched parenthesis 2: On the support page beside pgsql-bugs, it tells us to post in the bug reporting form, AND signup for 2 mailing lists. I can't possibly see how this would encourage anyone to want to report a bug if they have to jump thru these hoops. Just my 2 cents. 3: An actual but that I'll repeat here even tho I've already posted it as bug # 1938 Lets say i have a table with a row that looks something like this.. articleposted timestamp default now(), And yesterday afternoon I did a dump/restore. Now my table reads article posted | timestamp with time zone | default '2005-10-03 17:14:25.581388-04'::timestamp with time zone Which means it's interpreting the now() instead of just copying it. Kind of a pain when I just restored 75 databases with many many default now()'s as you can imagine. Thanks in advance. -- Jeff MacDonald http://www.halifaxbudolife.ca http://www.nintai.ca ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] Diskspace
Hi, I have a database that is about 3.5 gigs big. And I have a pretty serious hunch that there isn't that much data. I did a du -s *|sort -n in /usr/local/pgsql/data/base/9039913 And got a list that ends with these entries. 55648 18070582 137296 13312252 294736 13312279 845648 13312283.2 1049104 13312283 1049104 13312283.1 There are pleanty of other tables, but these are teh big ones. So I tried this select * from pg_statio_user_tables where relid = 13312283; and got no row returned, when i did select * from pg_statio_user_tables where relid = 13312279; i told me which table i was looking for. So I guess my question is, how do i find out what 13312283.* are, are they safe to delete ? Will a dump/reload fix things up ? I'm trying a vacuum now, as well i checked the queries in pg_statio_all_tables too. Thanks. -- Jeff MacDonald http://www.halifaxbudolife.ca ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Diskspace
Hi, We after some more reading I learned that this huge file is my TOAST table.. Is there a way to schrink that down ? Thanks. Jeff. On Mon, 20 Dec 2004 09:39:15 -0400, Jeff MacDonald [EMAIL PROTECTED] wrote: Hi, I have a database that is about 3.5 gigs big. And I have a pretty serious hunch that there isn't that much data. I did a du -s *|sort -n in /usr/local/pgsql/data/base/9039913 And got a list that ends with these entries. 55648 18070582 137296 13312252 294736 13312279 845648 13312283.2 1049104 13312283 1049104 13312283.1 There are pleanty of other tables, but these are teh big ones. So I tried this select * from pg_statio_user_tables where relid = 13312283; and got no row returned, when i did select * from pg_statio_user_tables where relid = 13312279; i told me which table i was looking for. So I guess my question is, how do i find out what 13312283.* are, are they safe to delete ? Will a dump/reload fix things up ? I'm trying a vacuum now, as well i checked the queries in pg_statio_all_tables too. Thanks. -- Jeff MacDonald http://www.halifaxbudolife.ca -- Jeff MacDonald http://www.halifaxbudolife.ca ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Diskspace
I'm using 7.3.4 Jeff. On Mon, 20 Dec 2004 10:48:18 -0300, Alvaro Herrera [EMAIL PROTECTED] wrote: On Mon, Dec 20, 2004 at 09:39:15AM -0400, Jeff MacDonald wrote: Hi, select * from pg_statio_user_tables where relid = 13312283; See the pg_class table, using the relfilenode column. So I guess my question is, how do i find out what 13312283.* are, are they safe to delete ? Probably none. You'd have to VACUUM FULL or maybe REINDEX, depending on which version you are using. -- Alvaro Herrera ([EMAIL PROTECTED]) I suspect most samba developers are already technically insane... Of course, since many of them are Australians, you can't tell. (L. Torvalds) -- Jeff MacDonald http://www.halifaxbudolife.ca ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] Diskspace
pg_class tells me select relname,relfilenode,relpages from pg_class where relfilenode = 13312283; relname | relfilenode | relpages ---+-+-- pg_toast_13312279 |13312283 | 367639 So now I guess I have to find out what 13312279 is.. Ah HA ! # select relname,relfilenode,relpages from pg_class where relfilenode = 13312279; relname | relfilenode | relpages ---+-+-- email_log |13312279 |36821 It just so happens that email_log has around 700,000 rows, that would explain the space issues. I do know that email_log is 100% deleteable, so I'll proceed with hosing that. Does all this sound reasonable ? Jeff. On Mon, 20 Dec 2004 10:51:32 -0300, Alvaro Herrera [EMAIL PROTECTED] wrote: On Mon, Dec 20, 2004 at 09:48:57AM -0400, Jeff MacDonald wrote: I'm using 7.3.4 And what about pg_class? -- Alvaro Herrera ([EMAIL PROTECTED]) Industry suffers from the managerial dogma that for the sake of stability and continuity, the company should be independent of the competence of individual employees. (E. Dijkstra) -- Jeff MacDonald http://www.halifaxbudolife.ca ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Diskspace
well, i did a delete from email_log and then a vacuum and the files are still lingering around... still huge. the postmaster did die due to a diskspace issue, so i wonder if it's still just keeping a wierd lock on those files or something.. idea's ? On Mon, 20 Dec 2004 11:01:32 -0300, Alvaro Herrera [EMAIL PROTECTED] wrote: On Mon, Dec 20, 2004 at 09:57:35AM -0400, Jeff MacDonald wrote: # select relname,relfilenode,relpages from pg_class where relfilenode = 13312279; relname | relfilenode | relpages ---+-+-- email_log |13312279 |36821 It just so happens that email_log has around 700,000 rows, that would explain the space issues. I do know that email_log is 100% deleteable, so I'll proceed with hosing that. Does all this sound reasonable ? Certainly. -- Alvaro Herrera ([EMAIL PROTECTED]) Para tener más hay que desear menos -- Jeff MacDonald http://www.halifaxbudolife.ca ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[GENERAL] weird issues with plpgsql calls.
Hi, I've made up 2 plpgsql calls, the table and function schema is available at http://www.bignose.ca/help/pg.txt I call them like this select ad_hits(33760); select ad_inquiries(33760); i did an update ad_base set hits = 0, inquiries = 0 to initialize both rows, since i added them using alter table. if i call ad_inquiries a few times, the number increments just fine, but if i call ad_hits, it increments hits like it should, but also sets inquiries to zero. which is very strange and annoying ;) any help would be great, thanks ! PostgreSQL 7.3.4 on i386-unknown-freebsd5.1, compiled by GCC gcc (GCC) 3.2.2 [FreeBSD] 20030205 (release) -- Jeff MacDonald http://www.bignose.ca ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[GENERAL] regular backups - super user
Hi, WHen i run pg_dumpall as the super user [postgres in my case] it asks for a password for every database. I don't know my users passwords. Is there a way to make the super user able to backup without passwords ? Thanks. Jeff. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] creating index's on functions.
Hi, I have a table, where one of the columns extradata is a gob of XML. I'd like to be able to create an index on this function.. so i tried this CREATE INDEX actitemsXML_idx ON act_items (pgxml_xpath(extradata,'//RequestInfo/refund_id/text()','','')); And i got this nice little error ERROR: parser: parse error at or near '//RequestInfo/refund_id/text()' at character 66 I tried escaping the single quotes.. that basically leaves me at a psql prompt with a ', meaning i need to close my quote, but they're all escaped. If anyone has any input for adding index's on functions that have single quotes in them, that would be great. Thanks. Jeff. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Request for Input [PostgreSQL Merchandise]
Greetings All, At PostgreSQL Inc. we wish to expand our elephant gear product line. Your input would be greatly appreciated so please surf over to http://www.pgsql.com And take our quick poll on what you would like to see for sale on our site. Thanks Everyone. Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] www.pgsql.com | www.hub.org 1-902-542-0713 | 1-902-542-3657 - Facsimile : 1 902 542 5386 IRC Nick : bignose PGP Public Key : http://bignose.hub.org/public.txt ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] Printing PostgreSQL reports
I think CURSORS would be the correct way to do it.. http://www.postgresql.org/docs/aw_pgsql_book/node142.html Jeff On Tue, 20 Feb 2001, Richard Ehrlich wrote: I can post info to PostgreSQL from a webform via JSP, and I can post reports from PostgreSQL to a webpage. Can anyone tell me how I might format a PostgreSQL report to a web page so that it will print discrete, sequenced pages? Thanks, Richard Ehrlich Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] www.pgsql.com | www.hub.org 1-902-542-0713 | 1-902-542-3657 - Facsimile : 1 902 542 5386 IRC Nick : bignose PGP Public Key : http://bignose.hub.org/public.txt
Re: [GENERAL] Installing Postgresql 7 on either RaQ3i or RaQ2
Hello, Recently i had to upgrade a raq3 from 6.5.2 (default) to the 7 series. there's a few ways you can go about it. 1 : backup the "cobalt" database , unrpm the postgresql 6.5.2 but carefull not to hose the special-sauce.rpm.. then install postgresql 7 from source (it compiles fine.) initdb and restore, and remember that for the gui to work postgres has to run on port 5833 (afaik) or 2: make another user and install 7.0 under that user, so they are both running. that way you haven't touched the default 6.5.2 installation and your cobalt raq3 license/support doesn't instantly expire. oh and if you hose your special sauce schema, don't both calling SUN, they won't give it to you for free.. or so i heard :) Jeff On Mon, 5 Feb 2001, Tatsuo Ishii wrote: I desperately need to get Postgresql 7 running on either a RaQ2 or RaQ3i. I have tried getting help on the Cobalt list-server and at Cobalt but the only response I get is that it will effect my GUI . Since I have been a long supporting Mac user the conversion to the Linux environment has been slow but rewarding. Any help or suggestion in getting Postgresql 7 running would be greatly appreciated. Kind regards, James I suppose you have no problem to build PostgreSQL 7.1 beta on RaQ2. Just unpacking the tar file and following the procedure documented in the "INSTALL" file should work. What kind of problems do you have? I have been told by Cobalt that if I install it will affect the GUI interface and render it unavailable? Can I simply download the 7.1 files and install? Should not effect the GUI? On my RqQ2 there is no GUI using PostgreSQL at all. So I don't believe installing PostgreSQL affects that part. I'm not sure about RaQ3i though. However, in a theory if the PostgreSQL part of the GUI has been installed in none standard place (that is /usr/local/pgsql), it should not harm pre-installed PostgreSQL to install new PostgreSQL by yourself. I think you should ask the dealer what "it will affect the GUI interface and render it unavailable" exactly means. -- Tatsuo Ishii Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] www.pgsql.com | www.hub.org 1-902-542-0713 | 1-902-542-3657 - Facsimile : 1 902 542 5386 IRC Nick : bignose PGP Public Key : http://bignose.hub.org/public.txt
Re: [GENERAL] Postgres demographics?
which just happens to be a sym link all to the same dir :) jeff On Mon, 11 Dec 2000, Tim Barnard wrote: snip We have some demographics available at http://www.pgsql.com/user_gallery snip I believe what was intended was: http://www.pgsql.com/register Tim Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] www.pgsql.com | www.hub.org 1-902-542-0713 | 1-902-542-3657 - Facsimile : 1 902 542 5386 IRC Nick : bignose PGP Public Key : http://bignose.hub.org/public.txt
Re: [GENERAL] Postgres demographics?
Hi, We have some demographics available at http://www.pgsql.com/user_gallery Jeff On Thu, 7 Dec 2000, GH wrote: Has anybody collected information about what people use Postgres how and to do what? I think it would be interesting to see where our Collective got its roots. Personally, I came from a PHP background using MySQL. An eCommerce (oh, I hate that word) project stretched the limits of MySQL and Postgres fit the bill very nicely. I was somewhat hesitant due to the massive anti-Postgres propaganda spread by just about everybody, but I am glad I made the switch and would not consider using MySQL for any but the simplest and least likely to grow project. Hats off to -core and to other developers as well as to the community. We have a Good Thing. gh Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] www.pgsql.com | www.hub.org 1-902-542-0713 | 1-902-542-3657 - Facsimile : 1 902 542 5386 IRC Nick : bignose PGP Public Key : http://bignose.hub.org/public.txt
Re: [GENERAL] Very queer errors with Postgres/PHP
i actually figured this out.. it was a byproduct of some othere errors the client negelected to tell me he was experiencing :) jeff On Thu, 23 Nov 2000, Tom Lane wrote: Jeff MacDonald [EMAIL PROTECTED] writes: Warning: PostgreSQL query failed: ERROR: Attribute 't' not found in /home/vhosts/mmfreedomclub.com/php-global/conf.php on line 25 line 25 $select = pg_exec($dbh,"SELECT password FROM members WHERE member_id = $user"); Hm. What does $user contain? If it's just "t" (no quotes) that'd provoke this error message. regards, tom lane Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] www.pgsql.com | www.hub.org 1-902-542-0713 | 1-902-542-3657 - Facsimile : 1 902 542 5386 IRC Nick : bignose
[GENERAL] Features
Hi Folks, I know this one has been asked alot, but since i can't search, i'm gonna re-ask. 1: Reliablility - is there any documents out there regarding stability and reliablilty of postgresql 2: replication - still in exotic list ? there is huge market demand, and lots of people willing to throw cash into it. 3: don't think it's been asked, but does postgresql have any XML support, or has anyone looked into it ? Jeff MacDonald [EMAIL PROTECTED]
[GENERAL] \i - users
hi , i'm trying to import a database with teh \i command from a pg_dump. as a regular user i get lots of errors regarding max query length exceeded . however if i run it as pgsql i don't get the error. problem comes in because these tables must be owned by the regular user and not pgsql Jeff MacDonald [EMAIL PROTECTED]
Re: [GENERAL] doing backups
that's true but that still assumes you know the pasword. also someone mentioned that you can just su to any account, well that's true but it still doesn't negate teh fact that the user has a passwd on thier database. as i said, i think the postgres user should have acess to all databases no matter what. jeff On Mon, 3 Apr 2000, Moray McConnachie wrote: Now if you make pgsql user and postgresql analgous to root and unix, the postgres user shouldn't need a passwd. My root users always have passwords. *shrug* But you're right, automated backup on password protected databases is next to impossible right now, especially when using pg_dump. If those users want to enable you to do backups for them perhaps they should give you (and only you) some sort of ident controlled access. I missed the first half of this, but, if I have understood correctly, I don't think this is the case: you can do automated backups by doing echo -e 'username\npassword\n' | pg_dump -u databasename Yours, Moray Jeff MacDonald [EMAIL PROTECTED]
[GENERAL] sql92
quick question SQL-92 - is this an ansi standard ? Jeff MacDonald [EMAIL PROTECTED]
[GENERAL] doing backups
hi folks, I'm writing out a nightly backup script for a machine. This machine has many databases, running on different ports. ie: 5432,5433 etc.. These servers are ""owned"" (use term loosly) by users on the system, and some users have choses to set passwds. which is 100% within their right. However that makes it a pain for postgres to do pg_dumps. Now if you make pgsql user and postgresql analgous to root and unix, the postgres user shouldn't need a passwd. anyone care to discuss this topic ? Jeff MacDonald [EMAIL PROTECTED]
[GENERAL] PostgreSQL Book
If anyone else is interested in writing a PostgreSQL book please contact [EMAIL PROTECTED] Jeff MacDonald [EMAIL PROTECTED]
[GENERAL] (Fwd) open source article (fwd)
hi, i was asked to forward this to the list. please reply to the author -- Forwarded message -- Date: Mon, 6 Mar 2000 18:49:53 -0700 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: open source article Hi, I write an Internet Business Law column for Internet.com's Boardwatch magazine www.boardwatch.com. I'm writing a series of articles on open source and I'd like to get community feedback for my next article dealing with the question below. Can you post this or email your group members? If they want to respond or comment they can do so by emailing me at [EMAIL PROTECTED]. I'll review responses until March 31, 2000, the deadline for the article. QUESTION: I believe that Open Source is a very important freedom movement, because, like Harvard's Professor Lessig says, code is law, but with a non-human police force. With closed code, we'll all be prisoners in the very near future. So I believe that code MUST be open. But can anyone tell me why software can't be both open and sold like Windows? Why is it that software has to be basically given away if it's open? I'm not sure that anyone in Open Source has ever answered this question. It just seems to be assumed without any critical analysis. Why can't Open Source developers get a royalty percentage of the sale price just like writers, recording artists or movie actors, and the product sold just like Windows is through traditional channels, so that the developers get paid for their work? Thanks and best regards, Tony Stanco -- Tucson Free Unix Group - [EMAIL PROTECTED] -- --- End of forwarded message --- - Angus Scott-Fleming GeoApplications, Tucson, Arizona [EMAIL PROTECTED] 1-520-323-9170 / fax 1-208-248-3124 - Proud user of Pegasus Mail, PM-Burst and Waffle - To Unsubscribe: send mail to [EMAIL PROTECTED] with "unsubscribe freebsd-questions" in the body of the message
[GENERAL] Another Database Poll
www.linux.com mysql is at 53 %, pgsql at 14 % Jeff MacDonald [EMAIL PROTECTED]
Re: [GENERAL] Calender
Um , we're trying to push postgres here :) i was thinking the diagram with "spiffier arrrows" and some drop shadows with a "ligntened elephant" behind On Tue, 22 Feb 2000, Lincoln Yeoh wrote: At 03:28 PM 21-02-2000 -0400, Jeff MacDonald wrote: the image we've chosen is at http://bignose.org/pg/catalogs.gif its from the docs. i'm going to spiff it up and put the elephant behind it. Might look better with the elephant in front of it ;). Looks like a lot of spiffing up to do.. How about an Elephant, Penguin and Little Red BSDaemon dancing under a Solaris Sun ;) ? Hehe. Hmm what other logos... Cheerio, Link. Jeff MacDonald [EMAIL PROTECTED]
Re: [GENERAL] Calender
that's also a good idea. On Tue, 22 Feb 2000, Bruce Momjian wrote: You know, you may be better off just choosing a few table like pg_class, pg_attribute, and pg_type, and pg_proc and showing those in a fancy manner. Um , we're trying to push postgres here :) i was thinking the diagram with "spiffier arrrows" and some drop shadows with a "ligntened elephant" behind On Tue, 22 Feb 2000, Lincoln Yeoh wrote: At 03:28 PM 21-02-2000 -0400, Jeff MacDonald wrote: the image we've chosen is at http://bignose.org/pg/catalogs.gif its from the docs. i'm going to spiff it up and put the elephant behind it. Might look better with the elephant in front of it ;). Looks like a lot of spiffing up to do.. How about an Elephant, Penguin and Little Red BSDaemon dancing under a Solaris Sun ;) ? Hehe. Hmm what other logos... Cheerio, Link. Jeff MacDonald [EMAIL PROTECTED] -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 **** Jeff MacDonald [EMAIL PROTECTED]
Re: [GENERAL] Calender
people pushing elphants ? i say hell with that, we should just buy 2 elphants, breed them and tatoo "PostgreSQL" on the calfs and sell'em. re: stuffed elephant, supppliers haven't found anything yet, and they said that these would probably be quite pricy. jeff On Wed, 23 Feb 2000, Lincoln Yeoh wrote: At 11:39 AM 22-02-2000 -0400, Jeff MacDonald wrote: Um , we're trying to push postgres here :) Yah, but I just couldn't resist.. How about a picture of the Postgres People pushing elephants in various ways ;). Link. p.s. Any sign of the stuffed toy elephant? It's got to be cute tho, e.g. bright big black eyes, big head, cute little trunk, wearing nice little Postgres t-shirt, that kind of thing. And not too expensive.... Jeff MacDonald [EMAIL PROTECTED]
[GENERAL] parser
hi, got this question from a user, anyone up for some discussion on it 1) I have been using 6.3 and recently tried to move to 6.5. I found that the word "offset" is now a reserved word and I have used it as a field name in a table. 6.5 reports this as an error. I wonder if the parser should do this since the context is as a field name. == Jeff MacDonald [EMAIL PROTECTED] irc: bignose on EFnet ==
Re: [GENERAL] cgi with postgres
alfred, that seems like a very reasonable solution, in regard to the other chaps responce, i'm not worried about web users anyway, cause they can't see the perl source. it's users on the system i'd like to protect against. On Fri, 14 Jan 2000, Alfred Perlstein wrote: * Jeff MacDonald [EMAIL PROTECTED] [000114 13:38] wrote: hey folks, this is a security issue i'd like to get some info on, i'm sure it's more with cgi than postgres, but heck. issue: how to secure cgi's that access postgres problem: passwords for postgres database are stored in plain text in scripts. (lets assume, perl, not a compiled language) points: make cgi dir 711 big deal, they can get the name of the file from the web, and copy it. how about sourcing a conf file that's in a 700 dir? set an obscure cgi script alias in apache big deal, they can read the cgi conf file. this is assuming they already have an account on the machine, something that cannot be ruled out. question in short: how to make perl accessing databases more secure, so any jack can't modify a database. thanks in advance. Jeff MacDonald [EMAIL PROTECTED] -- -Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]] Jeff MacDonald [EMAIL PROTECTED] === So long as the Universe had a beginning, we can suppose it had a creator, but if the Universe is completly self contained , having no boundry or edge, it would neither be created nor destroyed It would simply be. ===
Re: [GENERAL] Intro/Win9X
greets, does anyone ever look in ftp://ftp.postgresql.org/pub ? there is a precompiled nt binary in there. has been for a while. jeff On Mon, 10 Jan 2000, Ron Chmara wrote: Alexei Zakharov wrote: - Original Message - From: Huynh, Long [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 11, 2000 2:16 AM Subject: RE: [GENERAL] Intro/Win9X Well, is there NT version for evaluation? Well, there's no PostgreSQL evaluation. And what is more, Postgres is open source. Translation: In a world without fences, who needs Gates? It's free software, download the real thing, no fees, no per seat, no per user. Really. -Ronabop Jeff MacDonald [EMAIL PROTECTED] === So long as the Universe had a beginning, we can suppose it had a creator, but if the Universe is completly self contained , having no boundry or edge, it would neither be created nor destroyed It would simply be. ===
[GENERAL] View / Unions
Is they any guess on when it will be possible to do a view of a union of 2 tables ? thanks Jeff MacDonald [EMAIL PROTECTED] === So long as the Universe had a beginning, we can suppose it had a creator, but if the Universe is completly self contained , having no boundry or edge, it would neither be created nor destroyed It would simply be. ===
[GENERAL] XA 2 phase
I was sent this mail, and not sure how to reply to it... In transaction processing, a two-phase commit guarantees that synchronous transactions across multiple datasources will meet the ACID properties: atomic, consistent, isolated, durable. The protocol was standardized by the XA group. Most transaction processing books have a good description of this. I can't find any mention of support for this in the PostgreSQL doc, but maybe it's in there? On the Java JDBC front, the JDBC 2.0 spec has explicit support for the XA two-phase commit for transactions in: javax.sql.XAConnection So the questions would be: 1) Does PostgreSQL support XA 2-phase transactions? 2) Does the PostgreSQL JDBC adaptor support this as well? (Virtually all commercial RDBMs support XA 2-phase transactions, however, their Java JDBC driver support for this feature sometimes lags behind...) Thanks In advance.. Jeff == Jeff MacDonald [EMAIL PROTECTED]webpage: http://hub.org/~jeff [EMAIL PROTECTED] irc: bignose on EFnet ==
[GENERAL] Sites
Hi, I'm trying to compile a list of site that use postgres, not only web sites , but also businesses. Please email me your site/company name and a 1 or 2 line description of what you use postgres for. Email all replies to [EMAIL PROTECTED] jeff == Jeff MacDonald [EMAIL PROTECTED]webpage: http://hub.org/~jeff [EMAIL PROTECTED] irc: bignose on EFnet ==
Re: [GENERAL] How to compile PosttgreSQL on NT
I have used this file to take a hack at installing on nt. May I suggest more detail on items such as 1. Install the Andy Piper Tools who is andy piper ? = Jeff MacDonald // Hub.org Networking Services // PostgreSQL INC [EMAIL PROTECTED]// [EMAIL PROTECTED] // [EMAIL PROTECTED] http://hub.org/~jeff // http://hub.org // http://pgsql.com =
[GENERAL] Stored Procedures
Greets, Couple of questions, 1: does postgres support stored procedures 2: say a user has a microsoft sql server 7 database with ~120 stored procedures, and alot of data, is their a script or tool to convert that to a postgres database or does it have to be done by hand. Jeff MacDonald [EMAIL PROTECTED] === So long as the Universe had a beginning, we can suppose it had a creator, but if the Universe is completly self contained , having no boundry or edge, it would neither be created nor destroyed It would simply be. ===