her, so one join is made for
each variable that we want to plot; it joins the timestep values of the
variable on the X axis to those on the Y axis.
Regards,
Peter
--
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
is especially attractive, not only because it
That does sound interesting. However, I'm storing several hundreds or
thousands of data points (depending on the data set). How is Postgresql's
overhead when it comes to extracting one or two items from an array in
a query?
Cheers,
Peter
--
http://sjamaan.ath.cx
--
"The pro
this function is that it will not correctly
initcap a "magical brace enclosed literal", like '{...@*#!t!#*@}' ,
although I dare say that isn't enough of a problem to discourage its
use.
Can someone suggest a better implementation, that doesn't rely on
magical braces? E
Here's the entry to the wiki:
http://wiki.postgresql.org/wiki/Culturally_aware_initcap
I've added "you've handling"
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
use this type of solution to manage trees up to
about 100,000 nodes in size with good performance. Other
non-recursive solutions include Vadim Tropashko's (now with Oracle)
Nested Interval Tree Encoding methods, which map directly to the
dotted path (1.1.3) type tree notations in the examples in
7; IMMUTABLE
I would like to be able to RAISE a more appropriate, business domain
level notice, such as 'could not validate barcode' or 'could not
validate e-mail address', based on a CASE statement that checks the
dynamic type of $0 against some likely candidates for my application.
> Hello
>
> you can use pg_typeof(some) function
>
> Regards
> Pavel Stehule
That's great Pavel, thanks a lot.
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d really want an index? If so, any answers to the
OP's main question; what would be the most efficient way to handle
this type of thing?
--
Peter Hunsberger
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Apr 30, 2010 at 11:29 AM, Tom Lane wrote:
> Peter Hunsberger writes:
>> If all subscriptions are roughly equal in popularity then any single
>> select should give ~ 10% of the data. That would seem to be selective
>> enough that you'd really want an index?
>
On fre, 2010-04-30 at 17:36 +0100, Grzegorz Jaśkiewicz wrote:
> why specific_name column on that view contains also OID ?
> This makes two databases that are identical, have different values
> there. Is there any specific reason for that ?
It was a convenient choice. You could propose a different
On tis, 2010-05-04 at 09:19 +0100, Grzegorz Jaśkiewicz wrote:
> 2010/5/3 Peter Eisentraut :
> > It was a convenient choice. You could propose a different method for
> > generating the specific routine name, but given that it has to fit into
> > an identifier and has
will
continue to allow usage of the view; though it is still marked as
needing to be rebuilt from a user perspective any calls to it will
succeed if there is a possible way for the view to still be valid. If
there is no possible way for any use of the view to succeed then the
calls fail.
his, but you
can also figure it out if you spend a bit of time with Google
Basically, every node in the tree is a table row with two columns, say
left and right. All children are contained within the left and right
of the parent. Pre-order tree traversal gives the algorithm for
assigning left a
On lör, 2010-05-08 at 11:06 +0200, John Gage wrote:
> Is the documentation available anywhere as a single page text file?
> This would be enormously helpful for searching using regular
> expressions in Vim, for example, or excerpting pieces for future
> reference.
It would be pretty easy to
On ons, 2010-05-12 at 15:24 +0200, John Gage wrote:
> Yes it would. In fact, I have often wondered why this doesn't exist.
> How can I do it?
cd doc/src/sgml
make html JADEFLAGS='-V nochunks -V rootchunk'
That will produce an index.html file with the entire documentation in
it.
--
Sent vi
On lör, 2010-05-15 at 15:40 -0700, Yang Zhang wrote:
> yang=# select * from qapb;
> id | pb
> +
> 0 | \012\006hello?\020\000\030\000 \000*\014\012\006hello!\020\000\030\000
> (1 row)
>
On lör, 2010-05-15 at 22:50 -0700, Yang Zhang wrote:
> On Sat, May 15, 2010 at 10:20 PM, Peter Eisentraut wrote:
> > You have null bytes in the data value, which is not supported very well
> > in PL/Python. Try the 9.0 beta version; it should be fixed there.
>
> Thanks.
;t screw around with convoluted hacks. Encrypt the
critical data in the database and be done with it.
--
Peter Hunsberger
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, May 20, 2010 at 8:03 PM, Richard Walker wrote:
> Peter Hunsberger wrote:
>>
>> If you really need security of some form at the physical database
>> level then don't screw around with convoluted hacks. Encrypt the
>> critical data in the database and be
you, but I'm not
sure I'd want to deal with the performance implications...
However, I will point out that if you can't read the data you may be
able to tell who created a given row, but so what? All the variations
on your scenario that I can think of at the moment all se
On Fri, May 21, 2010 at 6:40 AM, Sam Mason wrote:
> On Thu, May 20, 2010 at 09:33:23PM -0500, Peter Hunsberger wrote:
>> On Thu, May 20, 2010 at 8:03 PM, Richard Walker
>> wrote:
>> > If the hacker gets root access so they can read
>> > the raw database files
an index, so although you could never see the
result directly (except in a dump) queries to get at it might perform
half reasonably.
--
Peter Hunsberger
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
have a small key size), so that some portion
of this is encrypted. However, if you're doing that, you might as
well just encrypt the data directly...
--
Peter Hunsberger
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.po
On Mon, May 24, 2010 at 3:24 PM, Hector Beyers wrote:
> Dear Peter,
> can you elaborate on what you mean by storing 'this' in the index. Are you
> referring to the function that is applied over the data?
> How would you be able to see the result with a dump?
Yes, you would
? XLS,
and to a lesser extent XLSX are baroque proprietary formats which
aren't particularly well supported by most opensource tools.
Openoffice.org does a fair job at it, but that's about it.
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
On tis, 2010-05-25 at 12:05 -0400, Richard Wallace wrote:
> 1) When using cursor_to_xml in a plpgsql function, the FOUND variable does
> not seem to get set, so there is no way to exit a loop that is iterating over
> the cursor. Below is the function code; it loops indefinitely when it is run.
>
This is the wrong list for this. You should post to pgsql-jobs only,
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
You may even be okay if you just
do setjmp() from within C++. The longjmp() will hopefully only affect
stack unwinding before we get down to the C++ part of the stack, where
that matters.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hat do you think? I suppose that such
undefined behaviour is absolutely intolerable. It's not a serious
suggestion, just something that I think is worth pointing out.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to do that in code I was writing, I'd build a pool
> allocator based on a memory context that handed out palloc'd chunks... and
> I'd just give up on destructors for those objects.
>
> http://www.parashift.com/c++-faq-lite/dtors.html#faq-11.10
> http://www.parashift.co
_string != NULL)
strcpy(error_string, e.what());
return false;
}
// They could add this catch-all, which we could fall back on to be on
the safe side
catch(...)
{
// We can't do anything except swallow - this could be anything
that doesn't inherit from std::exception
}
--
Re
Hello,
Is it possible to avoid seeing a CONTEXT notice from error messages
returned by the server due to a RAISE EXCEPTION within a trigger?
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
thors
supporting it.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e file edition of the Postgres documentation is in...pdf
> format. Huh?
>
I suppose the next thing you'll be suggesting is that, because
Postgres is a database, the documentation should be stored as some
form of searchable table within the database itself?
--
Peter Hunsberger
--
e front end goes on it's merry way...
--
Peter Hunsberger
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t's own unique set of
states. The only ones you need worry about are the ones a _user_ is
actually interacting with at any given point.
>
> Looks like we are going to cut off a few options of the game.
> ps: do i top post or bottom post here?
>
Bottom post.
--
Peter Hu
On tis, 2010-06-08 at 11:04 +0200, John Gage wrote:
>
> Yet, the only one file edition of the Postgres documentation is
> in...pdf format. Huh?
>
> I know. I know. I have already brought this up. And various ways
> of
> creating a one file text edition of the documentation have been
> p
postgres) has oracle compatibility features. I'm not specifically
aware that it supports nested procedures, but it may well.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On lör, 2010-06-12 at 11:18 +0200, John Gage wrote:
> A one file html version would be a godsend.
I've committed a build target for that now. Use 'make postgres.html' in
doc/src/sgml/.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On lör, 2010-06-12 at 09:10 -0400, Tom Lane wrote:
> Peter Eisentraut writes:
> > On lör, 2010-06-12 at 11:18 +0200, John Gage wrote:
> >> A one file html version would be a godsend.
>
> > I've committed a build target for that now. Use 'make postgres.htm
00m+ rows, on commodity hardware (4
> SATA disks in raid 10), and inserts to the indexes on those tables remain
> quite acceptable from a performance standpoint.
>
Can you define acceptable? IIRC the OP is looking for 20,000+ inserts / sec.
--
Peter Hunsberger
--
Sent via pgsql-general m
I am trying to upgrade our postgresql from 8.3 to 8.4.
I found the "window" as field name makes many errors during pg_restore.
- like "item.window".
Is there any way I can restore the dump file from 8.3 without errors.
Peter
Well, I guess that's the best solution: change the field name.
I hope to find some alternative solution, but I know it won't be easy.
Thank you.
Peter
-Original Message-
* Stephen Frost (sfr...@snowman.net)
The best solution would probably be to rename those fields in the 8.
On lör, 2010-06-19 at 22:56 +0100, David Goodenough wrote:
> These projects need help to realise that adding Postgresql is not a
> big
> job, especially for those using JDBC which can already connect to all
> DBs. It strikes me that if the project could write a few pages
> gleaned
> from other por
On fre, 2010-06-18 at 02:43 +0800, Craig Ringer wrote:
> The xml datatype documentation should probably mention that whole
> documents must be loaded with an XMLPARSE(DOCUMENT 'doc_text_here),
> they
> cannot just be cast from text to xml as happens when you pass an xml
> document as text to a para
, but you may find
it useful to SET client_encoding TO whatever the client encoding of
your client appliation is (I'd haza
http://www.postgresql.org/docs/8.3/static/multibyte.html
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
ome background information, but you may find
it useful to SET client_encoding TO whatever the client encoding of
your client appliation is (I'd hazard a guess that it's win1252 if
you're in western Europe or North America.
http://www.postgresql.org/docs/8.3/static/multibyte.html
like that from Pentaho (Kettle / Spoon) might
be in order? One step to handle the escape chars and one to load the
actual CSV...
--
Peter Hunsberger
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the
shipped PLs don't have any external dependencies (the docs indicate
that it's a simple matter of "createlang plpythonu dbname"). It's
quite clear that plpython.dll does exist in the directory specified.
What should I do?
--
Regards,
Peter Geoghegan
--
Sent via
Thanks guys; I've installed Python 2.6.4 from the official MSI
installer, and everything works fine.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
>
>> How should this be written ?
>
> I don't think you can use the "IF" like this in a normal query. You could
> write a pl/pgsql function instead to do this..
You can write such a query inline in 9.0, by use of DO...but you
probably just want to define a fu
e culprit. This can be set dynamically though.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
broken. A database
should have content fields that map to the needs of the application.
As you describe your application requirements, that is a bit string
and not an integer. Use bit strings and your application logic is
transparent, obvious and easy to maintain. Use integers and you have
to
On Thu, Jul 22, 2010 at 4:09 PM, Howard Rogers wrote:
>
> On Fri, Jul 23, 2010 at 12:35 AM, Peter Hunsberger
> wrote:
> > On Wed, Jul 21, 2010 at 11:13 PM, Howard Rogers wrote:
> >>
> there's a room-full of users who can look
> at code '4097'
, and store a row
for each day. You could easily start partitioning historical data per
year or per decade.
Cheers,
Peter
--
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
is especially attractive, not only because it can be economically
and scientifical
;t really
scale the results very far. However, if you've got some specific
goals in mind I might be able to provide some hints. If you're an
IEEE member I can point you at a presentation I did on the basics (I
think)...
--
Peter Hunsberger
--
Sent via pgsql-general mailing list (pgsql-
On fre, 2010-07-30 at 16:45 -0500, Derek Arnold wrote:
> Has there ever been any interest in adding a keyword option for
> returning row lists rather than dicts?
I don't think so, but it sounds like a reasonable idea. Other possible
approaches are
- Using a factory class like psycopg
(http://in
Tutorials would be good, but in a separate section of the site.
Cheers,
Peter
--
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
is especially attractive, not only because it can be economically
and scientifically rewarding, but also because it can be an ae
eared toward developers. The manual is "only"
three clicks away on that site.
Cheers,
Peter
--
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
is especially attractive, not only because it can be economically
and scientifically rewarding, b
or message in windows event viewer for the
pgagent service when I attempt to start pgagent. I'm not sure where I
should put the pgpass.conf file so that it's in the postgres service
account's %APPDATA%\postgresql directory. Perhaps someone could give
further direction.
--
Regards,
> pgpass.conf file should in %APPDATA%\postgresql directory of user/account,
> which you will use to start the pgagent.
>
> Suppose if you want start pgagent as user peter account on windows, then you
> have to keep the pgpass.conf file in %APPDATA%\postgresql directory of p
ined) FK relationships. That's
probably ok for this kind of stuff, there are ways to get the
equivalent of strong typing back either on the DB side or at run
time. You're essentially end up hacking a relational database to
support network database type operations, so to the extent that people
need that you've got something useful...
--
Peter Hunsberger
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t our cache
management in place we don't need this, but yeah, this could have
simplified things in many ways. But, what's the mechanism / transport
for the notification? MQ type stuff ?
--
Peter Hunsberger
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
n enum.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On ons, 2010-08-25 at 00:15 -0700, wstrzalka wrote:
> I'm currently playing with very large data import using COPY from
> file.
>
> As this can be extremely long operation (hours in my case) the nice
> feature would be some option to show operation progress - how many
> rows were already imported.
ttp://blog.tapoueh.org/blog.dim.html
Change the last part of the query from "WHERE a.tablename IS NULL" to
"WHERE a.tablename IS NOT NULL". That'll show you what tables your
SERIAL sequences are being used on.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mail
ase statement. If you can't do
that, then I think it would be easiest to code this up in a procedure,
but before anyone jumps on that you might want to let us know if you
are free to add columns to the schema?
--
Peter Hunsberger
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
required for XML support
Any idea ?
Thanks Peter
parser.h made me change the include path.
Could possibly the version of libxml2 be an issue: 2-2.7.7 ???
Thx: Peter
On Wed, Sep 15, 2010 at 12:18 PM, Dave Page wrote:
> On Wed, Sep 15, 2010 at 10:57 AM, Peter Roethlisberger
> wrote:
> > Hi there,
> >
> > I t
h the identical version of
PostgreSQL/PostGIS, but that was last updated one or two months ago and which
is intensly used as our testing and development server, which never gave us the
same error message.
Where could I start to troubleshoot this problem.
Peter Hopfgartner
--
Sent via pgsql-ge
Tom Lane wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 15.09.2010 16:07
>Peter Hopfgartner writes:
>> Since some days we are getting the above message.
>> Also in the PostgreSQL logs we get:
>>
Tom Lane wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 15.09.2010 17:40
>Peter Hopfgartner writes:
>> Tom Lane wrote
>>> This is a result of something sending SIGTERM to the backend p
]: Leaving directory `/tmp/postgresql-8.4.4/src/interfaces'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/tmp/postgresql-8.4.4/src'
make: *** [all] Error 2
Thansk: Peter
Tom Lane wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 15.09.2010 17:40
>Peter Hopfgartner writes:
>> Tom Lane wrote
>>> This is a result of something sending SIGTERM to the backend p
Peter Hopfgartner wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 16.09.2010 16:56
>Tom Lane wrote
>
>Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
>administrator comm
Tom Lane wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 16.09.2010 17:37
>Peter Hopfgartner writes:
>> Now we had the error, but systemtap did not report any SIGTERM. Is it
>> possible to have this error wi
Tom Lane wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 16.09.2010 18:49
>Peter Hopfgartner writes:
>> Tom Lane wrote
>>> Peter Hopfgartner writes:
>>>> Now we had the error
Thanks for the input Tom. Compiling openssl with the shared option did the
trick.
On Thu, Sep 16, 2010 at 3:49 PM, Tom Lane wrote:
> Craig Ringer writes:
> > On 16/09/2010 4:35 PM, Peter Roethlisberger wrote:
> >> /usr/local/openssl/lib64/libssl.a: could not read symbols: B
"Frank Ch. Eigler" wrote
Subject: Re: Getting FATAL: terminating connection due to administrator command
Date: 16.09.2010 22:59
>
>Peter Hopfgartner writes:
>
>> [...]
>> > >http://sourceware.org/systemtap/examples/process/sigmon.stp
>
&g
on't know how they handle that. Perhaps they try to read your mind.
Perhaps PHP adds some kind of type conversion for types it knows for
those two interfaces.
Cheers,
Peter
--
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
is especially attractiv
th them.
There's no "unknown" type (and it wouldn't be very useful in any
case, because how would you go about displaying an unknown type?)
Cheers,
Peter
--
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
is especially attractive,
that most libpq wrapping drivers use libpq's
PQserverVersion(), which returns an integer that looks like 9.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
gt; config_file=/etc/postgresql/8.4/main/postgresql.conf
> With different pids. Is this normal ?
>
This is normal. Postgres is said to have a multi-process architecture
(which is often contrasted with a multi threaded architecture). The
number of processes isn't very predictable.
--
Regards
Am Donnerstag, 10. Juli 2008 schrieb Chris Cosner:
> Using RHEL 5, with Postgresql 8.1, Apache, mod_perl, mod_auth_pgsql,
> DBI, DBD::Pg
>
> Perl cgi scripts that access the database get the following in httpd
> error_log:
> DBI connect('dbname=db','',...) failed: could not connect to server:
> Per
Am Freitag, 11. Juli 2008 schrieb Gábor Farkas:
> is the only solution to create a new database-instance? (initdb, new
> port, etc.) ?
You analysis is entirely correct. You have to re-initdb with a correct
locale.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
Am Dienstag, 15. Juli 2008 schrieb Morten Barklund:
> My problem is, that the lowercase versions of non-ascii characters are
> broken. Specifically I found, that when lower() is invoked on a text with
> non-ascii characters, the operating system's locale is used for converting
> each octet in the s
Am Dienstag, 15. Juli 2008 schrieb Morten Barklund:
> I can see that lc_collate (sorting) and lc_ctype (lower-upper conversion)
> is set to en_DK and I guess that default encoding for en_DK is iso88591 or
> maybe windows1252.
It is ISO-8859-1. There is no support for Windows charmaps on Linux.
>
Am Wednesday, 6. August 2008 schrieb erithema:>
> SELECT id_autori , xpath ('/Authority/Nome', testo)
> FROM autori
> WHERE xpath_bool('/Authority[Nome="ABELARDO"]', testo) ;
>
> I get this error:
> ERROR : the function xpath_bool(unknown , xml) do not exsist at character
> 69 HINT: no function
Am Wednesday, 6. August 2008 schrieb sagswe:
> When i run ' \i /usr/local/pgsql/share/pgxml.sql' in postgre , I get error
> saying file or directory named 'MODULE_PATHNAME' doesn't exist. How to get
> this MODULE_PATHNAME exist?.
This sounds like your installation is botched? How did you install
On Monday 11 August 2008 20:15:37 Mani, Arun wrote:
> Is there a configuration setting to increase the error checking level or
> any tool available to do the same.
No
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql
Am Thursday, 7. February 2008 schrieb Lawrence Oluyede:
> PostgreSQL 8.3 instead doesn't allow the insertion of XML with doctype
> in its new native data type returning this error message:
>
> """
> ERROR: invalid XML content
> DETAIL: Entity: line 2: parser error : StartTag: invalid element name
Am Thursday, 14. August 2008 schrieb Clemens Schwaighofer:
> Why is Postgres not using the indexes in the 8.3 installation.
Might have something to do with the removal of some implicit casts. You
should show us your table definitions.
--
Sent via pgsql-general mailing list (pgsql-general@postg
Am Thursday, 14. August 2008 schrieb Dmitry Teslenko:
> SELECT SUM(...) FROM table1 WHERE field3 = 'ABC' AND field1 <> 1
> GROUP BY field2
>
> And planner picks up a sequential scan of a table. Why does he?
Presumably because it thinks it is the best plan, and I see no reason to doubt
that
Am Friday, 15. August 2008 schrieb Thomas Finneid:
> First question is, what is the rationale behind having a limit on the
> table name?
Is is an implementation detail. Fixed-length name fields are more efficient
to process. And when you have fixed-length fields you need to choose some
reasona
Am Tuesday, 19. August 2008 schrieb Ivan Sergio Borgonovo:
> I just learnt that NOT DEFERRABLE is default.
> Is it mandated by SQL standard?
Yes.
> Is there any shortcut if I've to change to deferrable most of my
> constraints?
Probably not, short of writing a little script.
> Other than pgfou
Am Tuesday, 19. August 2008 schrieb Ivan Sergio Borgonovo:
> > Is there any reason they put it that way in the standard other than
> > the mantra "stricter is better"?
>
> After reflecting a bit I think it is a matter of "failing earlier".
Deferrable constraints are an optional feature of SQL, and
ossible to keep inserting and deleting entries once the serial
sequence has been exhausted? I can't find this anywhere in docs.
To me, it is perfectly possible that there is only one entry in the
table, with a serial value equal to its upper limit.
Thanks in advance. Kind regards,
Peter
--
Oops, my example was a bit incorrectly edited.
I wanted to say that the range of a serial datatype goes from 1 to 5
(incluse) and I insert five entries (not 10).
Peter
Peter Billen schreef:
Hi all,
I would like to ask a question about the serial datatype. Say I have a
field of type serial
advance,
Peter
ries van Twisk schreef:
On Aug 21, 2008, at 2:23 PM, Peter Billen wrote:
Oops, my example was a bit incorrectly edited.
I wanted to say that the range of a serial datatype goes from 1 to 5
(incluse) and I insert five entries (not 10).
Peter
Peter Billen schreef:
Hi all,
I would
Thanks. I thought it was a bit counter-intuitive to have a BIGSERIAL
while I will only have a few thousands of entries, which are updated (by
DELETE and INSERT) constantly.
Thanks Scott,
Peter
Scott Marlowe schreef:
On Thu, Aug 21, 2008 at 1:08 PM, Peter Billen <[EMAIL PROTECTED]>
601 - 700 of 2098 matches
Mail list logo
