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

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

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

[GENERAL] pg_get_serial_sequence Strangeness/Unreliable?

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

[GENERAL] Solaris 10, mod_auth_pgsql2

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

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

[GENERAL] Compile problems with contrib/xml in 7 series

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

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

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

[GENERAL] a bug, the bugs list, and how to break the website search.

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

[GENERAL] Diskspace

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

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

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

Re: [GENERAL] Diskspace

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

Re: [GENERAL] Diskspace

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

[GENERAL] weird issues with plpgsql calls.

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

[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:

[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

Re: [GENERAL] Printing PostgreSQL reports

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

Re: [GENERAL] Installing Postgresql 7 on either RaQ3i or RaQ2

ot;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

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

Re: [GENERAL] Postgres demographics?

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

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

[GENERAL] Features

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

Jeff MacDonald [EMAIL PROTECTED]

Re: [GENERAL] doing backups

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

% 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

[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'

Re: [GENERAL] Calender

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

Re: [GENERAL] Calender

0, 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

[GENERAL] parser

ser 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

Re: [GENERAL] Intro/Win9X

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

[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

[GENERAL] XA 2 phase

lags behind...) Thanks In advance.. Jeff == Jeff MacDonald [EMAIL PROTECTED]webpage: http://hub.org/~jeff [EMAIL PROTECTED] irc: bignose on EFnet ==

[GENERAL] Sites

== 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

[GENERAL] Stored Procedures

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