On Wed, Aug 18, 2004 at 02:47:26PM +0800, Christopher Kings-Lynne wrote:
> >It is not just a typo that you make in the SQL command. You often need
> >to do
> >
> > insert into table which has primary key
> > if the insert failed, do update of the existing record
>
> Do the update first the
It is not just a typo that you make in the SQL command. You often need
to do
insert into table which has primary key
if the insert failed, do update of the existing record
Do the update first then the insert.
Chris
---(end of broadcast)---
On Tue, Aug 17, 2004 at 02:56:19PM -0400, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Doing it only for interactive mode seems too error-prone to me (it works
> > in psql, but not from my script).
>
> You're missing the point: a script cannot safely work this way. A human
> ty
Tom Lane wrote:
Oliver Jowett <[EMAIL PROTECTED]> writes:
Since the default config now allows TCP/IP connections from localhost,
maybe we should tweak the default pg_hba.conf to work around this
problem? (e.g. use the /32 syntax which works ok)
Maybe we should press Sun to fix their bugs?
Well,
Oliver Jowett <[EMAIL PROTECTED]> writes:
> Since the default config now allows TCP/IP connections from localhost,
> maybe we should tweak the default pg_hba.conf to work around this
> problem? (e.g. use the /32 syntax which works ok)
Maybe we should press Sun to fix their bugs?
Until M$, Solar
Tom Lane wrote:
Oliver Jowett <[EMAIL PROTECTED]> writes:
Is there a Right Way to pass extra options for
shared-library linking?
LDFLAGS_SL is meant for this, I believe. Dunno whether you can set it
via configure, though ... that may be an oversight. In the meantime
you could hand-hack Makefile.
8.0.0beta1 tarball built with gcc 3.2.3 under Solaris 9 on a E250
(ultrasparc). I see the same bug as described in
http://archives.postgresql.org/pgsql-admin/2004-05/msg00248.php: a mask
of 255.255.255.255 in pg_hba.conf is rejected with
LOG: invalid IP mask "255.255.255.255" in pg_hba.conf fi
On 17 Aug 2004, Greg Stark wrote:
> With Postgres I effectively have to work in autocommit mode. Starting over
> from scratch every time I make a typo is infeasible. It feels like trying to
> type in a C program using "cat". I've done it before but it's not something I
> want to repeat often.
I a
We will either remove it in 8.0 or mention its removal in 8.1. It is
probably wisest to remove in 8.1.
---
Bruce Momjian wrote:
>
> Added to open items:
>
> * remove to_char(interval) if we initdb
>
>
> --
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
Hopefully the third try is a charm ;-)
Version 3 is now available: fixes the init script. Previously
/etc/init.d/postgresql worked the first time used (i.e. would initdb and
start postgres) but not the second and subsequent times.
[ blink...
Joe Conway <[EMAIL PROTECTED]> writes:
> Hopefully the third try is a charm ;-)
> Version 3 is now available: fixes the init script. Previously
> /etc/init.d/postgresql worked the first time used (i.e. would initdb and
> start postgres) but not the second and subsequent times.
[ blink... ] Was
OK, I have added a new pg_dump TODO section with adjustments based on
feedback from original list:
* pg_dump
o Allow pg_dumpall to use non-text output formats
o Have pg_dump use multi-statement transactions for INSERT dumps
o -Allow pg_dump to dump CREATE CONVERSION (Chris
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> let me know when you are ready ...
It's branded, wrap away...
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> This behaviour allows much closer mimicking of Oracle and other RDBMS's
> transactional behaviour
This is my single biggest pet peeve with Postgres. When I was first
starting it was the single most frustrating violation of the "least surprise"
principl
IMVHO, I think the following todo item should make it for 8.0:
Allow database recovery where tablespaces can't be created
When a pg_dump is restored, all tablespaces will attempt to be
created in their original locations. If this fails, the user must
be able to adjus
We decided it didn't make much sense to allow the on-row sequences to be
anywhere but the default tablespace.
Hmmm...
I can understand the performance/utility rationale, but I don't like the
lack of orthogonality on principle. I like elegance;-) As a sequence looks
a lot like a table, I guess it s
I'd like to hack it for them but I don't know where \l is called and
defined. Could someone point me where the code is?
src/bin/psql$ grep pg_database *.c
Probably in describe.c
Erm, but what stops them from going:
SELECT * FROM pg_database;
Chris
---(end of broadcast)-
On Wed, Aug 18, 2004 at 09:23:44AM +1000, Philip Warner wrote:
> At 07:10 AM 18/08/2004, Tom Lane wrote:
> >I have not had an opportunity to benchmark it but I fear a savepoint may
> >cost near as much as a full xact in practice.
>
> Out of curiosity, does this mean that using a savepoint per stat
On Tue, Aug 17, 2004 at 08:21:13PM -0300, Haroldo Stenger wrote:
Hola,
> On Tue, 17 Aug 2004 16:58:56 -0400, Alvaro Herrera Munoz
> <[EMAIL PROTECTED]> wrote:
> > Establishing a savepoint is a non-trivial operation (cost-wise). Several
> > internal server structures have to be prepared for it.
At 09:26 AM 18/08/2004, Philip Warner wrote:
Also, will the 'interactive-session' check consider an included file (\i)
to be interactive? I'd vote yes.
In retrospect, I assume the interactive-session limit would not be a
problem here since the command would be entered interactively. The source
o
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> let me know when you are ready ...
I've committed the patch itself. I have to leave for a few hours,
but I can update the release notes and branding when I get back.
regards, tom lane
---(end of bro
At 04:44 AM 18/08/2004, Bruce Momjian wrote:
it turns off when the transaction completes?
Not sure I like this part; I would like to be able to set the variable at
the start of a psql session and have it run for the entire session. Or,
even better, set it in a psql initialization file.
Also, wil
At 07:10 AM 18/08/2004, Tom Lane wrote:
I have not had an opportunity to benchmark it but I fear a savepoint may
cost near as much as a full xact in practice.
Out of curiosity, does this mean that using a savepoint per statement will
be no worse than using psql in autocommit mode?
--
Hola Alvaro
On Tue, 17 Aug 2004 16:58:56 -0400, Alvaro Herrera Munoz
<[EMAIL PROTECTED]> wrote:
> > On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> > > The other objection is that this would create very substantial overhead.
> >
> > why?
>
> Establishing a savepoint is a
On Tue, 17 Aug 2004, Tom Lane wrote:
I have just found a bug in _bt_getstackbuf that I think explains Joe
Conway's recent reports of PANICs under heavy concurrent insertions.
We're gonna have to re-wrap 7.4.4 or relabel it 7.4.5, your choice.
let's relable it 7.4.5 ... with Devrim doing up the SPRM
I have just found a bug in _bt_getstackbuf that I think explains Joe
Conway's recent reports of PANICs under heavy concurrent insertions.
We're gonna have to re-wrap 7.4.4 or relabel it 7.4.5, your choice.
Fortunately the bug is not present in 7.3 and earlier, so those
packagings can forge ahead.
Alvaro Herrera Munoz <[EMAIL PROTECTED]> writes:
> Establishing a savepoint is a non-trivial operation (cost-wise). Several
> internal server structures have to be prepared for it.
Check
> It's way cheaper than normal transaction start and commit,
Is it? You have the same amount of work to do
On Tue, Aug 17, 2004 at 03:33:01PM -0300, Haroldo Stenger wrote:
Haroldo,
> On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> > The other objection is that this would create very substantial overhead.
>
> why?
Establishing a savepoint is a non-trivial operation (cost-wis
Joe Conway wrote:
Version 2 of the source rpm is now available here:
http://www.joeconway.com/postgresql-8.0.0beta1/SRPM/postgresql-8.0.0beta1-2PGDG.src.rpm
I've also put up i386 binary rpms for fc1 and fc2, and x86_64 binary
rpms for fc2.
Hopefully the third try is a charm ;-)
Version 3 is now
> Bruce Momjian
> Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > Added to TODO list:
> >
> > > * Add an option to automatically use savepoints for each
> statement in a
> > > multi-statement transaction.
> >
> > > When enabled, this would allow errors in multi-statement
> t
Could I ask the general question:
"What else is needed for PITR?"
- What isn't clear about how PITR works? what it is or what its good for?
- What additional features are required?
- What additional tools are required to make it useful?
- What additional documentation do we want? (Assuming you'v
Magnus,
There is a fixed buffer of 1024 bytes. I have a feeling ythat one has to
be changed to dynamic.
You're quite right. The 'InfoBufferSize' denotes 1122 bytes after this call.
if(!GetTokenInformation(AccessToken,TokenGroups,InfoBuffer,1024,&InfoBufferSize))
Regards,
Thomas Hallgren
-
If someone wants to take a peak at it ... it *shrunk* from 7.3.6 ...
-rw-r--r-- 1 pgsql pgsql 10367088 Aug 17 15:53 postgresql-7.3.7.tar.gz
-rw-r--r-- 1 pgsql pgsql 11288430 Mar 4 21:35 postgresql-7.3.6.tar.gz
I'm re-running the build right now, to see if there are any errors that
I've miss
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Doing it only for interactive mode seems too error-prone to me (it works
> in psql, but not from my script).
You're missing the point: a script cannot safely work this way. A human
typing at the terminal can notice that his command failed and react to
t
Haroldo Stenger <[EMAIL PROTECTED]> writes:
> On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
>> It might be reasonable to offer that behavior as an option, but I think
>> I'd only want it on for interactive input.
> How could the server tell interactive input from scripted
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Added to TODO list:
>
> > * Add an option to automatically use savepoints for each statement in a
> > multi-statement transaction.
>
> > When enabled, this would allow errors in multi-statement transactions
> > to be automatica
Hi Tom
On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> The other objection is that this would create very substantial overhead.
why?
> It might be reasonable to offer that behavior as an option, but I think
> I'd only want it on for interactive input.
How could the ser
Yes, one :-)
Is your account by any chance a member of a large number of groups? If
so, how many?
There is a fixed buffer of 1024 bytes. I have a feeling ythat one has to
be changed to dynamic.
//Magnus
>-Original Message-
>From: Thomas Hallgren [mailto:[EMAIL PROTECTED]
>Sent: den 17
I'm trying to run initdb on win32, freshly compiled from CVS HEAD, but I
get the following error:
creating template1 database in data/base/1 ... failed to get token
information: 122
Any ideas?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP
Tom Lane wrote:
Bruce Momjian <[EMAIL PROTECTED]> writes:
Added to TODO list:
* Add an option to automatically use savepoints for each statement in a
multi-statement transaction.
When enabled, this would allow errors in multi-statement transactions
to be automatically ignored.
Like I said, my
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Added to TODO list:
> * Add an option to automatically use savepoints for each statement in a
> multi-statement transaction.
> When enabled, this would allow errors in multi-statement transactions
> to be automatically ignored.
Note that whoever
Philip Warner wrote:
> At 01:47 AM 12/08/2004, Tom Lane wrote:
> >It might be reasonable to offer that behavior as an option, but I think
> >I'd only want it on for interactive input.
>
> My preference would be for something like:
>
> set savepoint_per_statement=true
>
> then interactive & s
Added to open items list:
* fix dollar quoting problems in pg_restore
---
Philip Warner wrote:
>
> > CREATE FUNCTION xxx() RETURNS integer
> > AS $$ begin return 1;
> >2004-08-12 01:38:48 EST:
Hi,
On Tue, 17 Aug 2004, Marc G. Fournier wrote:
>
> Sorry for delay, working through the packages ...
>
> 7.4.4 is available via ftp right now if anyone wants to take a quick peak
> at it ... they seem right, based on sizes ...
I can't see them in ftp site??
ncftp /pub/source/v7.4.4 > pwd
Sorry for delay, working through the packages ...
7.4.4 is available via ftp right now if anyone wants to take a quick peak
at it ... they seem right, based on sizes ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: ysc
> > (1) the "CREATE SEQUENCE foo TABLESPACE disk2" syntax does not seem
> > to be implemented.
>
> This is intentional. Sequences are not large enough to need to be
> pushed around among multiple tablespaces. Also, if we did allow
> sequences to be associated with tablespaces, we'd be preclu
Oliver Jowett <[EMAIL PROTECTED]> writes:
> I've changed Makefile.shlib to add all of LDFLAGS to SHLIB_LINK for now,
> but I'm assuming there's a reason that it was only using -L flags
> originally.
IIRC, on some platforms there are elements of LDFLAGS that will actively
break shared library lin
Fabien COELHO <[EMAIL PROTECTED]> writes:
> (1) the "CREATE SEQUENCE foo TABLESPACE disk2" syntax does not seem
> to be implemented.
This is intentional. Sequences are not large enough to need to be
pushed around among multiple tablespaces. Also, if we did allow
sequences to be associated wi
> > > and afaik it is on Bruce's Beta-TODO list too.
> > Argh, I missed this one! Is it somewhere on line?
> Yep, URL at the top:
Quite an unexpected location! thanks for the pointer.
> Current version at ftp://momjian.postgresql.org/pub/postgresql/open_items.
IMVHO, I think the following todo
Fabien COELHO wrote:
>
> Dear Bruce,
>
> > > (1) the "CREATE SEQUENCE foo TABLESPACE disk2" syntax does not seem
> > > to be implemented.
> > >
> > > (2) when creating an implicit sequence with SERIAL, the sequence
> > > is created in the tablespace of the schema/database, not the one
> >
Dear Bruce,
> > (1) the "CREATE SEQUENCE foo TABLESPACE disk2" syntax does not seem
> > to be implemented.
> >
> > (2) when creating an implicit sequence with SERIAL, the sequence
> > is created in the tablespace of the schema/database, not the one
> > of the table, although indexes a
I'm trying to build 7.4.3 under Solaris 9 with gcc and static linking of
libgcc. This requires passing '-static-libgcc' when linking both
binaries and shared libraries.
Passing 'LDFLAGS=-static-libgcc' to configure only partially works.
Binaries are correctly linked with that flag, but shared l
Fabien COELHO wrote:
>
> > > (3) psql auto completion does not have "CREATE/DROP TABLESPACE" in
> > > its list.
> >
> > I have already posted a patch for
> > this(http://candle.pha.pa.us/mhonarc/patches/msg0.html)
>
> Good. I should have checked the pending patch queue.
>
> > and afaik i
Fabien COELHO wrote:
>
> Dear hackers,
>
> Some minor comments about the new tablespace feature in 8.0beta1:
>
> It seems to me that tablespaces and sequences are not yet prefectly
> integrated.
>
> (1) the "CREATE SEQUENCE foo TABLESPACE disk2" syntax does not seem
> to be implemented.
>
> > (3) psql auto completion does not have "CREATE/DROP TABLESPACE" in
> > its list.
>
> I have already posted a patch for
> this(http://candle.pha.pa.us/mhonarc/patches/msg0.html)
Good. I should have checked the pending patch queue.
> and afaik it is on Bruce's Beta-TODO list too.
Argh
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> could this due the fact that moving that tuple will not
> save any storage space ?
Yup. VACUUM FULL is not interested in collapsing out unused CTID slots.
regards, tom lane
---(end of broadcast)---
Fabien COELHO wrote:
(3) psql auto completion does not have "CREATE/DROP TABLESPACE" in
its list.
I have already posted a patch for
this(http://candle.pha.pa.us/mhonarc/patches/msg0.html) and afaik it
is on Bruce's Beta-TODO list too.
Stefan
---(end of broadcast)-
Pavel Stehule <[EMAIL PROTECTED]> writes:
> Can I set somewhere an long for text, which is in current_query in
> "pg_catalog.pg_stat_activity"?
No. You could attach gdb to the backend that's running the troublesome
query and do "p debug_query_string" ...
regards, tom lan
Dear hackers,
Some minor comments about the new tablespace feature in 8.0beta1:
It seems to me that tablespaces and sequences are not yet prefectly
integrated.
(1) the "CREATE SEQUENCE foo TABLESPACE disk2" syntax does not seem
to be implemented.
(2) when creating an implicit sequence with
Hi all,
looking at how ctid is used is clear to me:
insert line (A) in a table; ==> ctid = (0, 1);
rollback an update for the line (A);
insert a line (B) in the table; ==> ctid = (0, 3);
vacuum full;
insert a line (C) in the table; ==> ctid = (0, 2);
I was expecting this for a normal vacuum
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 17 Aug 2004, Peter Eisentraut wrote:
> > I'd like to hack it for them but I don't know where \l is called and
> > defined. Could someone point me where the code is?
>
> src/bin/psql$ grep pg_database *.c
Thanks.
- --
Devrim GUNDUZ
Am Dienstag, 17. August 2004 12:30 schrieb Devrim GUNDUZ:
> I'd like to hack it for them but I don't know where \l is called and
> defined. Could someone point me where the code is?
src/bin/psql$ grep pg_database *.c
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I just received a question about psql. They want psql to show 'only' the
databases that the 'current_user' owns.
I'd like to hack it for them but I don't know where \l is called and
defined. Could someone point me where the code is?
Thanks.
Hello
I my work I have problem with some ugly SQL. Processing some query takes 2
days and more (problem is in queries not in PostgreSQL). I can't wait on
end of query and can't take text of query from serverlog. Text of queries
has about 2 - 7 Kb. I have problem identifi queries in our is, beco
To be more specific, i am trying to implement an operator, and i get the
tuples being projected in ExecScan (called from ExecSeqScan). I just
needed them unprojected.
thanks,
--h
On Mon, 16 Aug 2004, Sailesh Krishnamurthy wrote:
> > "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
>
> Tom>
65 matches
Mail list logo