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 nu
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 som
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 ma
as_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
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, to
: 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 wi
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 fro
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.suite
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
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
x27;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.
: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
>
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
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
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 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://ww
sd5.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])
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)---
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:
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
ell 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 S
n'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 ne
which just happens to be a sym link all to the same dir :)
jeff
On Mon, 11 Dec 2000, Tim Barnard wrote:
>
> >
> > We have some demographics available at http://www.pgsql.com/user_gallery
> >
>
>
> I believe what was intended was:
>
> http://www.pgs
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,
-
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 &
nd 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]
not pgsql
Jeff MacDonald
[EMAIL PROTECTED]
s.
>
> 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]
quick question
SQL-92 - is this an ansi standard ?
Jeff MacDonald
[EMAIL PROTECTED]
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]
If anyone else is interested in writing a PostgreSQL book please contact
[EMAIL PROTECTED]
Jeff MacDonald
[EMAIL PROTECTED]
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 Boardw
www.linux.com mysql is at 53 %,
pgsql at 14 %
Jeff MacDonald
[EMAIL PROTECTED]
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 ;).
>
>
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, Jef
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:
>
>
ser should do this since
the context is as a
field name.
==
Jeff MacDonald
[EMAIL PROTECTED] irc: bignose on EFnet
==
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:
n 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]
==
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
[E
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
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
==
jeff
==
Jeff MacDonald
[EMAIL PROTECTED]webpage: http://hub.org/~jeff
[EMAIL PROTECTED] irc: bignose on EFnet
==
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 Se
=
Jeff MacDonald // Hub.org Networking Services // PostgreSQL INC
[EMAIL PROTECTED]// [EMAIL PROTECTED] // [EMAIL PROTECTED]
http://hub.org/~jeff // http://hub.org // http
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
46 matches
Mail list logo
