Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> I presume they have to drop the default, then drop the sequence to get
> rid of it.
Hmm. Right at the moment I don't think you *can* get rid of it, short
of dropping the column altogether.
regression=# create table z(f1 serial);
NOTICE: CRE
Should that sequence really stick around as an integer, numeric and text
field???
What are you unhappy about exactly? We expended a fair amount of sweat
to make it behave just like that ...
It's confused the odd IRC user (pgsql newbie). Seems like it breaks the
'serial type' illusion...
I pres
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Should that sequence really stick around as an integer, numeric and text
> field???
What are you unhappy about exactly? We expended a fair amount of sweat
to make it behave just like that ...
regards, tom lane
--
Should that sequence really stick around as an integer, numeric and text
field???
test=# create table test (a serial);
NOTICE: CREATE TABLE will create implicit sequence "test_a_seq" for
serial column "test.a"
NOTICE: CREATE TABLE will create implicit sequence "test_a_seq" for
serial column "
On Tue, 19 Apr 2005, Simon Riggs wrote:
I'd suggest this as a backpatch for 8.0.x, when completed.
Not a chance --- it's a new feature, not a bug fix, and has substantial
risk of breaking things.
No problem for me personally; I only request it, according to users
wishes.
Users wish deterministic pr
On Mon, 18 Apr 2005, Simon Riggs wrote:
On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian writes:
I guess I didn't see the connection between the file system backup and
the WAL files, when in fact you need the WAL files that go with the file
system badckup to do
Use the DirecFunctionCall1, DirecFunctionCall2, etc. functions.
... John
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Sent: Monday, April 18, 2005 10:40 PM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] Call to build
Thanks, fixed.
---
Christopher Kings-Lynne wrote:
> Is that broken?
>
> http://momjian.postgresql.org/main/writings/pgsql/sgml/build.html
>
> Chris
>
> Bruce Momjian wrote:
> > Patch applied. Thanks. Sorry for the delay
As others pointed out, DirectFunctionCall2 is your friend. There is a
mailing list for TelegraphCQ. It's a Yahoo group - visit
http://groups.yahoo.com/group/telegraphcq
About accessing data from a table in another database ... we need to
know more about what exactly you're doing. Please post on
Patch applied. Thanks. Sorry for the delay in applying.
---
David Fetter wrote:
> On Tue, Mar 08, 2005 at 12:27:21PM +0800, Christopher Kings-Lynne wrote:
> > >Luckily, PG 8 is available for this. Do you have a short exa
Is that broken?
http://momjian.postgresql.org/main/writings/pgsql/sgml/build.html
Chris
Bruce Momjian wrote:
Patch applied. Thanks. Sorry for the delay in applying.
---
David Fetter wrote:
On Tue, Mar 08, 2005 at 12:27:21PM +
sizeof(Datum) == sizeof(long) - is that compatible with %d formatting (I'm
guessing something like vsprintf takes place in elog)? Wouldn't this need %ld
or %lu?
Sorry if this misses the point, I wasn't clear from original post if the
segfault was on elog or after it.
Regards, Philip.
On Tue
Olivier Thauvin <[EMAIL PROTECTED]> writes:
> Datum
> header_querytxt(PG_FUNCTION_ARGS)
> {
> elog(NOTICE, "querytxt");
> Datum tag;
> /* converting TEXT value to integer one */
> tag = DirectFunctionCall1(rpmtagvalue, PG_GETARG_TEXT_P(1));
> elog(NOTICE, "querytxt %d", tag);
Simon Riggs wrote:
> On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
> > Tom Lane wrote:
> > > Bruce Momjian writes:
> > > > I guess I didn't see the connection between the file system backup and
> > > > the WAL files, when in fact you need the WAL files that go with the file
> > > > syste
Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > The wal file could be truncated after the log switch record, though I'd
> > want to make sure that didn't cause other problems.
>
> Which it would: that would break WAL file recycling.
Good point. I don't see non-full WAL archiving as
Would you modify this so it can go in /contrib or pgfoundry? Is there
general interest for this?
---
Ilya A. Kovalenko wrote:
>Greetings,
>
> I suggest function for "inet" increment w/ int8 (signed).
>
> FUNCTION in
On Mon, 2005-04-18 at 19:21 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > The wal file could be truncated after the log switch record, though I'd
> > want to make sure that didn't cause other problems.
>
> Which it would: that would break WAL file recycling.
Yeh, there's ju
I hope I am on good list, else point me where I should ask.
I create a C function like this:
CREATE
-- IFUPDATE or REPLACE
FUNCTION rpmquery(rpmheader, INT) RETURNS SETOF TEXT AS
'MODULE_PATHNAME', 'header_query' LANGUAGE C IMMUTABLE STRICT;
(do not take care, code come from the .sql.in)
Simon Riggs <[EMAIL PROTECTED]> writes:
> The wal file could be truncated after the log switch record, though I'd
> want to make sure that didn't cause other problems.
Which it would: that would break WAL file recycling.
> That would be initiated through a single function pg_walfile_switch()
> wh
Alvaro Herrera wrote:
On Sun, Apr 17, 2005 at 06:56:01AM -0700, Joshua D. Drake wrote:
From a "people who call me" perspective. I am never asked about
inheritance. Most of the people don't even know it is there.
The requests I get are:
Just wondering, does anybody asks you about the excessive loc
Alvaro Herrera wrote:
> On Sun, Apr 17, 2005 at 06:56:01AM -0700, Joshua D. Drake wrote:
>
> > From a "people who call me" perspective. I am never asked about
> > inheritance. Most of the people don't even know it is there.
> > The requests I get are:
>
> Just wondering, does anybody asks you abo
On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian writes:
> > > I guess I didn't see the connection between the file system backup and
> > > the WAL files, when in fact you need the WAL files that go with the file
> > > system badckup to do the recovery.
On Mon, 2005-04-18 at 16:44 +0200, [EMAIL PROTECTED] wrote:
> Rob Butler <[EMAIL PROTECTED]> wrote on 18.04.2005, 15:05:20:
> >
> > > I'd say it's very not cool :) It's not we all
> > > expected from PITR.
> > > I recall now Simon mentioned about that and have it
> > > in his TODO.
> > > Other thi
"Victor Y. Yegorov" <[EMAIL PROTECTED]> writes:
> So, I'd like to ask -- what is the "reverse" function for heap_fill_tuple(),
> is it OK to use index_getattr()?
That's probably what you *have* to use, since the normal deconstructors
assume they are working with heap tuples, which are different.
The world rejoiced as [EMAIL PROTECTED] ("Jim C. Nasby") wrote:
> On Sun, Apr 17, 2005 at 06:56:01AM -0700, Joshua D. Drake wrote:
>> >Is it really an important area to improve, or are there other
>> >priorities? I know some people wished we had better support for
>> >inheritance, but how strong
Can you tell me more about the good ODBC driver being worked on?
I was thinking of working on this myself, but if someone is already
solving the problem, that's great!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
Sent: Sunday, April 17,
Clinging to sanity, [EMAIL PROTECTED] (ElayaRaja S) mumbled into her beard:
> Hi,
> I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
> i have to install postgresql 7.4.5. Plz let me know how to uninstall
> completely - postfesql 7.3.2
>
> I am getting as [EMAIL PROTECTED] root]
Greetings,
I don't really know if this is the correct place to ask this question, if not please direct me to the correct mailing list.
I'm trying to develop a new operator for PostGreSQL (actually for
TelegraphCQ, which is an extension of PSQL). Part of the operator's
procedure is the @-operator.
Hi!
For bitmaps, I need to search each value being inserted (for each column of
the index) in the list of already existing values (stored in index's header
area). To do that I need:
1) create Datum from PageItem's value (I store each value in it's own
PageItem);
2) compare newly inserted Datum
> -Original Message-
> From: ElayaRaja S [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 18, 2005 1:38 PM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] pg_hba.conf
>
>
> Hi,
> I am using Redhat linux 9. i had configure in pg_hba.conf as
> hostpostgres postgres 10.10.0.76
Hi,
I am using Redhat linux 9. i had configure in pg_hba.conf as
hostpostgres postgres 10.10.0.76 255.255.255.0 password
If i try to connect with postgresql admin i am getting excpetion as
An erro has occured:
Error connecting to the server: could not connect to server:
Connection re
Added to TODO:
* Compress WAL entries [wal]
I have also added this email to TODO.detail.
---
Simon Riggs wrote:
> On Sun, 2005-04-10 at 21:12 -0400, Bruce Momjian wrote:
> > Jim C. Nasby wrote:
> > > Maybe better f
Tom Lane wrote:
> Bruce Momjian writes:
> > Tom Lane wrote:
> >> Archive on stop is right out. The common reason for a stop is that the
> >> system is being shut down, and we don't have time to archive a WAL file
> >> before init will kill -9 us.
>
> > Ah, good point. Can we do it for 'smart' s
Bruce Momjian writes:
> Tom Lane wrote:
>> If you are looking for things that will fundamentally break the system,
>> try renaming one of the indexes of a core system catalog ;-). We could
>> avoid that dependency if we went by OIDs instead.
> Right now you can use a temporary table in place of
Tom Lane wrote:
> Bruce Momjian writes:
> > I guess I didn't see the connection between the file system backup and
> > the WAL files, when in fact you need the WAL files that go with the file
> > system badckup to do the recovery. Do you have new suggested text?
>
> I think it probably needs to
Bruce Momjian writes:
> Tom Lane wrote:
>> Archive on stop is right out. The common reason for a stop is that the
>> system is being shut down, and we don't have time to archive a WAL file
>> before init will kill -9 us.
> Ah, good point. Can we do it for 'smart' shutdown mode, which is the
> d
Tom Lane wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> >> So some changing-oid operations like vacuum full, reindex, etc will not
> >> affect these system catalogs?
>
> > Is it possible to cluster system tables?
>
> No, and yes. CLUSTER, REINDEX, and similar things change the
>
Bruce Momjian writes:
> I guess I didn't see the connection between the file system backup and
> the WAL files, when in fact you need the WAL files that go with the file
> system badckup to do the recovery. Do you have new suggested text?
I think it probably needs to mention *both* the tar dump
Bruce,
> FYI, I did a presentation on the porting of PostgreSQL to Win32 on
> Saturday:
Good thing, too, you're doing this preso for OSCON.
> http://candle.pha.pa.us/main/writings/pgsql/win32_port.pdf
>
> It has few diagrams because I did the diagrams on a white board.
Well, add some di
[EMAIL PROTECTED] wrote:
> Hi
> in the function ExecChooseHashTableSize()
> (~/src/backend/executor/nodeHash.c)
> are determined the bytes of the hash table. The correspondent code is:
>
> /*
> * Target in-memory hashtablesize in SortMem kilobytes
> */
> hash_table_bytes = SortMem *1024L
>
>
Tom Lane wrote:
> Bruce Momjian writes:
> > Ragnar Hafstað wrote:
> >> On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote:
> >>> I am not clear on what the "backup dump file" is? I assume it means
> >>> 0001123455CD. It is called "WAL segment file" above. I
> >>> will rename tha
Tom Lane wrote:
> Bruce Momjian writes:
> > OK, I updated the two current TODO items:
> > * Automatically force archiving of partially-filled WAL files when
> > pg_stop_backup() is called or the server is stopped
>
> > Is this OK?
>
> Archive on stop is right out. The common reason fo
Bruce Momjian writes:
> OK, I updated the two current TODO items:
> * Automatically force archiving of partially-filled WAL files when
> pg_stop_backup() is called or the server is stopped
> Is this OK?
Archive on stop is right out. The common reason for a stop is that the
system
Bruce Momjian writes:
> Ragnar Hafstað wrote:
>> On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote:
>>> I am not clear on what the "backup dump file" is? I assume it means
>>> 0001123455CD. It is called "WAL segment file" above. I
>>> will rename that phrase to match the above
[EMAIL PROTECTED] writes:
> I'm trying to develop a new operator for PostGreSQL (actually for
> TelegraphCQ, which
> is an extension of PSQL). Part of the operator's procedure is the @-operator.
> So now
> my question is: How do I call the on_pb function from inside my own function?.
DirectFunct
Bruce Momjian writes:
> You mean don't force the archive copy but just have pg_stop_backup()
> hang until the files fill? Yea, we could do that, but there is no way
> to know how long the hang might take.
Actually I meant both.
--
greg
---(end of broadcast)--
Ali Baba <[EMAIL PROTECTED]> writes:
> if i need to add a column in pg_proc ,is any body can
> give me overview to do this.
You're in luck:
http://archives.postgresql.org/pgsql-committers/2005-03/msg00433.php
regards, tom lane
---(end of broadcast)
On Mon, Apr 18, 2005 at 02:39:52PM +0200, [EMAIL PROTECTED] wrote:
>
> I'm trying to develop a new operator for PostGreSQL (actually for
> TelegraphCQ, which
> is an extension of PSQL). Part of the operator's procedure is the @-operator.
> So now
> my question is: How do I call the on_pb functio
Rafaqat Ali <[EMAIL PROTECTED]> writes:
>Can any one tell me how can I get triggerOid from triggerName
> in c code. I first tried to use SearchSysCache Function but it does
> not search o the basis of triggername.
Posting the same question three times on two different lists doesn't
endear
FYI, I did a presentation on the porting of PostgreSQL to Win32 on
Saturday:
http://candle.pha.pa.us/main/writings/pgsql/win32_port.pdf
It has few diagrams because I did the diagrams on a white board.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.ph
Greg Stark wrote:
> Bruce Momjian writes:
>
> > I see your point. New text is:
> >
> > 4 Again connect to the database as a superuser, and issue the command
> >
> > SELECT pg_stop_backup();
> >
> > This should return successfully.
> >
> > 5 Once the W
Oleg Bartunov wrote:
> On Mon, 18 Apr 2005, Rob Butler wrote:
>
> >
> >> I'd say it's very not cool :) It's not we all
> >> expected from PITR.
> >> I recall now Simon mentioned about that and have it
> >> in his TODO.
> >> Other thing I don't understand what's the problem to
> >> generate WAL fil
OK, I updated the two current TODO items:
* Allow point-in-time recovery to archive partially filled write-ahead
logs
Currently only full WAL files are archived. This means that the most
recent transactions aren't available for recovery in ca
Bruce Momjian writes:
> I see your point. New text is:
>
> 4 Again connect to the database as a superuser, and issue the command
>
> SELECT pg_stop_backup();
>
> This should return successfully.
>
> 5 Once the WAL segment files used du
Rob Butler <[EMAIL PROTECTED]> wrote on 18.04.2005, 15:05:20:
>
> > I'd say it's very not cool :) It's not we all
> > expected from PITR.
> > I recall now Simon mentioned about that and have it
> > in his TODO.
> > Other thing I don't understand what's the problem to
> > generate WAL file
> > by
Oleg Bartunov wrote:
> > Is there something in the current wording that needs clarification?
>
> I'd say it's very not cool :) It's not we all expected from PITR.
> I recall now Simon mentioned about that and have it in his TODO.
> Other thing I don't understand what's the problem to generate WAL
On 4/18/05, ElayaRaja S <[EMAIL PROTECTED]> wrote:
> Hi,
> I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
> i have to install postgresql 7.4.5. Plz let me know how to uninstall
> completely - postfesql 7.3.2
Hello,
You really should consider asking your question on some anot
On Mon, 18 Apr 2005, Rob Butler wrote:
I'd say it's very not cool :) It's not we all
expected from PITR.
I recall now Simon mentioned about that and have it
in his TODO.
Other thing I don't understand what's the problem to
generate WAL file
by demand ? Probably, TODO should says about this.
This w
HI,
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
if i install the postgreSQL 7.4.5 and i used the command,
bash-2.05b$ psql
psql: relocation error: psql: undefined symbol:
Jeff Davis wrote:
> On Mon, 2005-04-18 at 00:20 -0400, Bruce Momjian wrote:
> > Jeff Davis wrote:
> > >
> > > Can you sort of run through the failure case again, and how to prevent
> > > it?
> >
> > The failure case in the original docs is that you do your
> > pg_stop_backup(), and then delete al
> I'd say it's very not cool :) It's not we all
> expected from PITR.
> I recall now Simon mentioned about that and have it
> in his TODO.
> Other thing I don't understand what's the problem to
> generate WAL file
> by demand ? Probably, TODO should says about this.
This would definetly be a good
ElayaRaja S said:
> Hi,
> I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and i
> have to install postgresql 7.4.5. Plz let me know how to uninstall
> completely - postfesql 7.3.2
>
> I am getting as [EMAIL PROTECTED] root]# rpm -e postgresql
> error: package postgresql is not instal
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
I am getting as [EMAIL PROTECTED] root]# rpm -e postgresql
error: package postgresql is not installed
if i try to check the v
Greetings,
I don't really know if this is the correct place to ask this question, if not
please
direct me to the correct mailing list.
I'm trying to develop a new operator for PostGreSQL (actually for TelegraphCQ,
which
is an extension of PSQL). Part of the operator's procedure is the @-operato
Le Monday 18 April 2005 13:47, ElayaRaja S a écrit :
> Hi,
> I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
> i have to install postgresql 7.4.5. Plz let me know how to uninstall
> completely - postfesql 7.3.2
rpm -e postgresql ?
I am not sure this kind of question should
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
--
Warm Regards,
S.ElayaRaja
Mobile: (+91) 98450 59540
E-Mail: [EMAIL PROTECTED]
[EMAIL PROTECTED]
---
Hello All
Can any one tell me how can I get triggerOid from triggerName
in c code. I first tried to use SearchSysCache Function but it does
not search o the basis of triggername.
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hello All
Can any one tell me how can I get triggerOid from triggerName
in c code. I first tried to use SearchSysCache Function but it does
not search o the basis of triggername.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comma
I'm using systable_beginscan() with TriggerConstrNameIndex
(Band systable_getnext().
(B
(BBTW, which value are you using as the cacheId
(Bwhen you call SearchSysCache() for pg_trigger?
(B
(BI couldn't find a suitable value in syscache.h.
(B
(Brafaqat ali wrote:
(B> Hello All
(B>
Hello,
if i need to add a column in pg_proc ,is any body can
give me overview to do this.
Thanks,
Asif Ali
__
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250
---
Hello All
Can any one tell me how can I get triggerOid from triggerName
in c code. I first tried to use SearchSysCache Function but it does
not search o the basis of triggername.
---(end of broadcast)---
TIP 3: if posting/reading through Use
On Mon, 18 Apr 2005, Bruce Momjian wrote:
Jeff Davis wrote:
I could still use a little clarification. It seems sort of like there is
an extra step, like:
(1) start archiving
(2) pg_start_backup()
(3) copy PGDATA directory with tar
(4) pg_stop_backup()
(5) ??
And the text you have at
http://candle.p
72 matches
Mail list logo