On Wed, 2006-04-05 at 14:46 +0200, Stefan Nobis wrote:
> Is there any way (or working solution) to extend PostgreSQL to accept
> Oracles outer join syntax with '(+)'?
Not AFAIK, and there are no plans to add support that I'm aware of.
EnterpriseDB claim to have pretty good Oracle compatibility, so
On Tue, 2006-03-21 at 16:58 -0500, Kevin Murphy wrote:
> I have a table for which PG 8.3 is guessing wrong about a plan when the
> result set gets large.
There is no such thing as "PG 8.3".
>-> Index Scan Backward using merged_weight_date_idx on merged
> (cost=0.00..31295593.98 rows=14183
On Sun, 2006-03-05 at 08:50 +0530, IYENGAR SURESH PARTHASARATHY wrote:
> i want to fully understand the functioning of postgres indexes with
> respect to the code.
See src/backend/access/ in the source tree, specifically the nbtree/,
hash/, gist/ and index/ subdirectories -- each directory has a
On Sun, 2006-02-26 at 12:08 -0500, Tom Lane wrote:
> We'd consider removing these features if they were actually blocking
> support of some spec-required behavior ... but since they don't, it's
> quite unlikely they'll ever be removed.
Right; there are plenty of places in which PostgreSQL extends
On Thu, 2006-02-23 at 17:12 -0300, Carlos Henrique Reimer wrote:
> When the pg_locks view is used the internal lock manager data
> structures are momentarily locked and that is why I would like to know
> if some application is reading the pg_locks view and how many times.
>
> Is there a way to di
On Fri, 2006-02-17 at 11:34 +0800, Qingqing Zhou wrote:
> AFAIK there is no such API for this purpose. The reason is that to access
> BTree, you have to setup complex enough environment to enable so. For
> example, the buffer pool support, the WAL support etc. So though exporting
> such API is easy
On Tue, 2006-02-14 at 13:53 -0500, Kevin Murphy wrote:
> A Windows PostgreSQL guru who cares (;-)) might help this guy with his
> benchmark of mysql, firebird, sqlite, and postgresql:
>
> http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
Yeah, see recent discussion:
http://archives.postgresq
On Fri, 2006-01-20 at 09:16 +0100, DB Subscriptions wrote:
> BEGIN
> CREATE USER NEW.userid WITH PASSWORD NEW.pword IN GROUP NEW.groupe;
>
> RETURN new;
> END;
You can't use PL/PgSQL variables in DDL commands. Try using EXECUTE:
EXECUTE 'CREATE USER ' || NEW.userid || '...';
-Neil
On Tue, 2006-01-17 at 15:01 -0800, Glen Parker wrote:
> We're still on 7.4 (sorry, probly should have mentioned that). Does
> that documentation apply to the 7.4 series as well?
AFAIK, there haven't been any major changes to TOAST since 7.4, so most
of that documentation should be applicable.
>
On Sat, 2006-01-07 at 20:38 +, Marcos José Setim wrote:
> I want to use the Prepare and Execute resources of PostgreSQL to
> increment the performance of my SQL's.
> $sSQL = 'INSERT INTO teste (nome) VALUES( ? )';
>
> $oDB->Prepare( $sSQL );
The PREPARE documentation states:[1]
Prep
On Sun, 2006-01-08 at 00:12 +, Marcos José Setim wrote:
> I'd like that create functions in plpgsql with prepared SQL and plan
> saved, to that the Postgresl increase the performance of executions.
>
> This is possible?
plpgsql internally caches query plans the first time a function is
invoke
[EMAIL PROTECTED] wrote:
PostgreSQL runs for a while but always eventually (30min - 2hrs) crashes.
Dec 20 17:14:57 server4 kernel: postmaster: page allocation failure.
order:0, mode:0xd0
Dec 20 17:14:57 server4 kernel: [] __alloc_pages+0x2e1/0x2f7
This looks like a kernel or hardware issue,
On Fri, 2005-11-18 at 11:00 +0100, Wolfgang Keller wrote:
> Given the focus of Sun on fault-tolerance etc., one of THE projects
> that they should definitely sponsor is
> http://gborg.postgresql.org/project/pgreplication/projdisplay.php
AFAIK pgreplication is no longer active. However, the Slony
On Sun, 2005-23-10 at 16:35 -0700, Steve V wrote:
> Which library is GetTopTransactionId() available in?
It's defined in the backend executable, as is GetCurrentTransactionId().
A similar wrapper function to the one shown here:
http://archives.postgresql.org/pgsql-general/2005-06/msg00709.php
sh
On Tue, 2005-18-10 at 22:21 -0500, Tony Caduto wrote:
> From what i understand Postgresql will scale with more cpus, but not in
> the same way as threaded server would.
Threading isn't really relevant. PostgreSQL currently forks a new
process for each client connection, and each process can be s
On Mon, 2005-17-10 at 12:25 -0500, Jim C. Nasby wrote:
> So, if you have a bunch of int2's all next to each other in a table,
> they will happily just consume 2 bytes. The issue comes when you try
> and mix them with other fields randomly, since many other fields
> require int alignment.
We could
On Fri, 2005-14-10 at 09:43 -0400, John D. Burger wrote:
> I believe these queries are exactly equivalent, but I presume the
> planner doesn't know that.
> explain select gazPlaceID from gazPlaces
> where gazPlaceID not in (select gazPlaceID from gazContainers);
> explain select gazPlaceI
On Sat, 2005-15-10 at 16:42 -0400, jeff sacksteder wrote:
> It occurs to me that I don't know how to define unsigned integer
> datatypes. I'm making a schema to describe network packets and I need
> columns to contain values from 0-255, etc.
>
> I can't seem to find any documentation on this. What
On Tue, 2005-11-10 at 14:43 +0200, Martijn van Oosterhout wrote:
> My personal favourite bug-tracker is debbugs, as used by the Debian
> Project. You can submit bugs by email, they get forwarded to
> maintainers (which can be a mailing list) via email. When they reply,
> the reply is also stored wi
On Thu, 2005-06-10 at 12:07 -0600, Aly S.P Dharshi wrote:
> http://sql-info.de/postgresql/postgres-gotchas.html
>
> Any comments from folks on the list ?
"SELECT column alias, ...": this is a known issue. AFAIK it is not easy
to solve.
"Unquoted object names fold to lower case": this is intentio
Emi Lu wrote:
Greetings,
If one column "col1" is defined as :
col1 varchar(1) not null default ''
Does it means that col1's definition is equal to
col1 char(1) not null default ''
Not quite; for example,
neilc=# create table t1 (x char(1) not null);
CREATE TABLE
neilc=# create table t2 (x
Kevin Murphy wrote:
I just wanted to confirm that the COPY command always stores data in the
table in the order in which it appears in the import file.
This is not the case -- depending on the content of the FSM, the newly
added rows might be distributed throughout the table.
-Neil
---
Alvaro Herrera wrote:
IIRC Neil Conway posted a patch to make 8.0.2 use LRU instead of ARC,
when the whole patent issue arised.
http://archives.postgresql.org/pgsql-patches/2005-01/msg00253.php
-Neil
---(end of broadcast)---
TIP 9: In versions
Tom Lane wrote:
Joseph Shraibman writes:
If I put the pg_xlog directory on its own disk, then that disk fails,
does that mean the postgres is hosed or does it just mean that postgres
no longer safe from a power outage?
The latter. The WAL is actually write-only during normal operation.
We
[EMAIL PROTECTED] wrote:
Does Postgres have any kind of configuration that determines the
speed of data transfer to the clients?
No.
Is there any kind of connection priority?
No, although it is possible to crudely set priorities via OS-level tools
like nice(1).
-Neil
---
Scott Marlowe wrote:
You might want to schedule analyzes to run every thirty minutes or every
hour.
I doubt that is necessary or wise. Rerunning ANALYZE should only be
necessary when the distribution of your data changes significantly --
e.g. after a bulk load or deletion of a lot of conten
Vivek Khera wrote:
The first sentence rules out MySQL, so the second sentence should read
"So that leaves Postgres". Your problem is solved ;-)
(If you are accustomed to Oracle, you are probably expecting an ACID
database, which rules out MySQL too).
Does MySQL with InnoDB not qualify as
Alvaro Herrera wrote:
I don't think you can use just plpgsql's parser. The problem is that it
relies on the main backend parser to figure out anything it doesn't
understand.
I think it depends on what kind of information you want to extract from
a PL/PgSQL function definition. The PL/PgSQL pa
Joshua D. Drake wrote:
If you are using savepoints you can rollback to a specific point of
a parent transaction.
Although you can't use savepoints (explicitly) in functions. PL/PgSQL
exceptions (which are actually implemented internally via savepoints)
can be used to achieve a similar effect.
laser wrote:
> SELECT url,sum(ct) as ctperkw from ctrraw group by url order by ctperkw
> desc limit 1000;
> and the query run out of memory, the log file attached.
Have you run ANALYZE recently? You might be running into the well-known
problem that hashed aggregation can consume an arbitrary amou
[EMAIL PROTECTED] wrote:
Is there a similar command in Postgresql so that the client application
can find out if there's an unresolved transaction before it starts a new
one?
See PQtransactionStatus() in libpq; if you're using a different language
interface, it should provide some means to ge
Tino Wildenhain wrote:
Google or your favourite search engine helps :-)
http://www.postgresql.org/files/documentation/books/aw_pgsql/node71.html
is among the first results.
Unfortunately those docs are quite out of date. This page is better:
http://developer.postgresql.org/docs/postgres/data
Alvaro Herrera wrote:
Huh, I meant a patch for getting the error message from RAISE EXCEPTION.
Does Pavel's patch address that too?
Yes.
(I just posted a revised patch to -patches, I'll apply it later tonight.)
-Neil
---(end of broadcast)---
T
Alvaro Herrera wrote:
No, we don't have SQLERRM support yet. If you were asking about getting
the messages from RAISE EXCEPTION, I'm afraid there's no way to get it
in the EXCEPTION clause.
If you want to contribute it, patches are welcome ...
Actually, Pavel Stehule sent in a patch for this
Dinesh Pandey wrote:
./configure --enable-integer-datetimes --prefix=/usr/local/pgsql
--with-tclconfig=/usr/local/lib --with-tcl
configure: error:
*** Could not execute a simple test program. This may be a problem
*** related to locating shared libraries. Check the file 'config.log'
*** for t
Mohan, Ross wrote:
1) Many (many!) uninitialized variables in code. Optimizers don't
do well with this.
Um, what?
2) Not clear (to me, a nonprogrammer) whether this is GNU C, ANSI C,
"Postgres" C, or what the overall coding protocol is.
Postgres is mostly ANSI C89, with limited use
On Wed, 2005-06-01 at 08:22 +0200, Philippe Lang wrote:
> What is the best way to calculate an MD5 Sum for a set of rows in a
> table, on a Postgresql server?
The md5() builtin function. contrib/pgcrypto is available if you need
more sophisticated hashing / encryption.
-Neil
--
On Tue, 2005-05-31 at 15:43 -0400, Tom Lane wrote:
> OK, next question: is this a bug fix we should back-patch into 7.4,
> or just change it in HEAD?
I agree with Alvaro: fix it in HEAD, but don't backport the change to
8.0 or 7.4.
-Neil
---(end of broadcast)---
Himanshu Baweja wrote:
is there any other better way by which i can get a list of locks
acquired and waited for during entire run of my application
Hacking the backend would be the easiest route, I think. Why do you need
this information -- what are you trying to do?
-Neil
-
Felix E. Klee wrote:
I have the created a C-Language function (code is below). Now, I
wonder: How do I handle exceptions, for example if malloc cannot assign
the necessary memory? Do "palloc" and "pfree" handle such a case
cleanly?
Yes -- they will roll back the current transaction on if ther
Paul Newman wrote:
We are currently using a 32byte varchar for our primary keys. We tried
to reduce this down to 16 bytes but varchar didn't seem to store this
correctly.
In what way was it not stored "correctly"? The size limit should not
significantly affect varchar behavior, other than bounding
Dan Black wrote:
How can i calculate table and index size on hard disk?
See contrib/dbsize in the PostgreSQL source tarball.
-Neil
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Tom Lane wrote:
Performance?
I'll run some benchmarks tomorrow, as it's rather late in my time zone.
If anyone wants to post some benchmark results, they are welcome to.
I disagree completely with the idea of forcing this behavior for all
datatypes. It could only be sensible for fairly wide valu
Bruce Momjian wrote:
Is there a TODO anywhere in this discussion? If so, please let me know.
There are a couple:
- consider changing hash indexes to keep the entries in a hash bucket
sorted, to allow a binary search rather than a linear scan
- consider changing hash indexes to store each key's h
Marc G. Fournier wrote:
Please note that the security issues were those already reported by Tom
Lane, as well as a manual fix for them. These releases are mainly to
ensure that those installing and/or upgrading existing installations
have those fixes automatically.
Note that if you're upgrading
Tom Lane wrote:
I have a gut reaction against that: it makes hash indexes fundamentally
subservient to btrees.
I wouldn't say "subservient" -- if there is no ordering defined for the
index key, we just do a linear scan.
However: what about storing the things in hashcode order? Ordering uint32s
d
Tom Lane wrote:
On the other hand, once you reach the target index page, a hash index
has no better method than linear scan through all the page's index
entries to find the actually wanted key(s)
I wonder if it would be possible to store the keys in a hash bucket in
sorted order, provided that the
Jim C. Nasby wrote:
>> No, hash joins and hash indexes are unrelated.
I know they are now, but does that have to be the case?
I mean, the algorithms are fundamentally unrelated. They share a bit of
code such as the hash functions themselves, but they are really solving
two different problems (dis
Jim C. Nasby wrote:
Having indexes that people shouldn't be using does add confusion for
users, and presents the opportunity for foot-shooting.
Emitting a warning/notice on hash-index creation is something I've
suggested in the past -- that would be fine with me.
Even if there is some kind of adv
Christopher Petrilli wrote:
This being the case, is there ever ANY reason for someone to use it?
Well, someone might fix it up at some point in the future. I don't think
there's anything fundamentally wrong with hash indexes, it is just that
the current implementation is a bit lacking.
If not, t
Ying Lu wrote:
May I know for simple "=" operation query, for "Hash index" vs. "B-tree"
index, which can provide better performance please?
I don't think we've found a case in which the hash index code
outperforms B+-tree indexes, even for "=". The hash index code also has
a number of additional
Vlad wrote:
ok, since there is no gurantee that server-side prepared query is
still active, pergaps postgresql interface library provide way to
check if a prepared before query still alive prior runing exec
I'm not sure I quite follow you -- in some future version of the backend
in which prepared
Tom Lane wrote:
That's what it is supposed to do. It would hardly be possible to
"prepare" a query at all if we had to wait till EXECUTE to find out
which tables it was supposed to use.
An alternative would be to flush dependent plans when the schema search
path is changed. In effect this would m
Dennis Sacks wrote:
The disadvantage is, you'll have to have some process for deleting
old data from the table, as it will stay around and it will bite you
when you get the same pg_backend_pid() again down the road.
Rather than use pg_backend_id(), why not just assign session IDs from a
sequence?
Hubert Fröhlich wrote:
Those days, we had PostgreSQL 7.1 and 7.2, and we had to be careful oids
approaching 2^32 (2.14 billion)
Now, we have 8.0. What does the situation look like?
With the default settings, there is exactly the same risk of OID
wraparound as in earlier releases. However, you ca
Pavel Stehule wrote:
CREATE OR REPLACE FUNCTION foo(integer, integer) RETURNS integer AS $$
BEGIN
RETURN $1 + $2;
END; $$ LANGUAGE plpgsql;
CREATE OR REPLACE FUNCTION foo(integer) RETURNS integer AS $$
BEGIN
RETURN foo($1,10); -- 10 is "default" value
END; $$ LANGUAGE plpgsql;
Note that if you
Dawid Kuroczko wrote:
For a test you might want to try also this approach (both from perl and
from psql):
$dbh->do('PREPARE sth_tim (int,inet,boolean,timestamptz) AS INSERT
INTO timestamps VALUES ($1,$2,$3,$4)');
$sth_tim = $dbh->prepare("EXECUTE sth_tim(?,?,?,?)");
...and later execute it. (and
Chris Smith wrote:
I'm trying to use a limit clause with delete, but it doesn't work at the
moment
It isn't in the SQL standard, and it would have undefined behavior: the
sort order of a result set without ORDER BY is unspecified, so you would
have no way to predict which rows DELETE would remov
Chandra Sekhar Surapaneni wrote:
Can we write our own niladic functions in 8.0.0? I want to write a
niladic function similar to current_timestamp, but I did not find any
information in the documentation.
If you mean a function without any arguments, it is trivial:
CREATE FUNCTION foo() RETURNS .
Edwin New wrote:
I have encountered a situation where a java process is dying but leaving
locks active.
If the connection to PostgreSQL is severed (e.g. the client actually
disconnects), the current transaction will be rolled back and any held
locks will be released.
So it seems that the proble
Stanislaw Tristan wrote:
It's a possible to compress traffic between server and client while server
returns query result?
It's a very actually for dial-up users.
What is solution?
You could use an SSH tunnel with compression to achieve this.
-Neil
---(end of broadcast)-
Bruce Momjian wrote:
Syntax error reporting has been improved in our code so 8.1 might be
better and catching such errors.
Yes, current sources catches this at definition-time:
% psql -f test.sql
psql:test.sql:21: ERROR: syntax error at or near "EXCEPTIONRATIO_OUT"
at character 1
QUERY: EXCEPTIO
On Tue, 2005-02-15 at 20:13 -0700, Michael Fuhr wrote:
> Do user-defined functions need to check palloc()'s return value,
> or does return guarantee success?
It guarantees success.
-Neil
---(end of broadcast)---
TIP 9: the planner will ignore you
On Wed, 2005-02-09 at 10:48 +0530, Antony Paul wrote:
> Hi all,
> This is giving error in 7.3.3.
>
> CREATE TEMP TABLE temptest3(col int PRIMARY KEY) ON COMMIT DELETE ROWS;
> ERROR: parser: parse error at or near "ON" at character 51
>
> Is this supported.
No. Looking at the manual would h
On Tue, 2005-02-08 at 18:11 -0500, Tom Lane wrote:
> Vitaly Belman <[EMAIL PROTECTED]> writes:
> > Doing an EXECUTE for a query which returns results still yields 'f'
> > for the FOUND variable.
>
> This is not a bug. Read the list of statements that update FOUND.
> EXECUTE is not one of them.
S
Paul Tillotson wrote:
Does anyone know a safe way to shutdown just one backend
Sending it a SIGTERM via kill(1) should be safe.
-Neil
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail c
On Tue, 2005-02-01 at 18:37 -0500, Tom Lane wrote:
> Do you think it's worth groveling through the other uses of forboth()
> for the same type of error?
I just checked the other uses of forboth(), and didn't notice any
errors.
-Neil
---(end of broadcast)
On Tue, 2005-02-01 at 01:53 -0500, Tom Lane wrote:
> /*
> * Increment command counter between queries, but not after the
> * last one.
> */
> if (planlist_item != NULL)
> CommandCounterIncrement();
>
> but planlist_item will *never* be NULL he
Jim C. Nasby wrote:
I'd really like to see an improvement in how sort_mem/work_mem is
handled.
So would I :) (I think it's well known that the current system is not
optimal.)
Do you have any thoughts on how to improve it?
-Neil
---(end of broadcast)
Josh Berkus wrote:
If you know of a PostgreSQL package, from any source, that installs with trust
on network ports, please notify Core (and Core only, please).
Why only -core?
-Neil
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Tom Lane wrote:
The correct place for a sysadmin to limit memory usage would be in the
ulimit settings the postmaster starts under. Of course, Neil's argument
still holds in general: anyone who can write arbitrary queries is not
going to have any difficulty in soaking up unreasonable amounts of
re
On Thu, 2005-01-27 at 20:03 -0600, Jim C. Nasby wrote:
> Yes, there is a risk allowing ad-hoc settings; you can starve the
> machine for memory.
A malicious user who can execute SELECT queries can already consume an
arbitrary amount of memory -- say, by disabling GEQO and self-joining
pg_class to
On Mon, 2005-01-24 at 21:03 -0600, Wes wrote:
> Implicit indexes created by a constraint do not appear to honor the default
> tablespace. The index gets created in the "null" tablespace.
>
> I took pg_dumpall output and modified the schema to place everything in
> specific table spaces. When th
On Thu, 2004-12-16 at 11:09 -0500, Tom Lane wrote:
> I think we should go ahead and do that for 8.0. I'm getting tired of
> reading reports that stem from this mistake (I think this is the third
> one in the past month ...). I can't see any real downside to accepting
> both spellings, can you?
I
Richard Huxton wrote:
You want "elsif" - plpgsql isn't a hugely sophisticated language and its
parser is having trouble there. I'm guessing the parser is somehow
putting the "elseif" branch under the initial "then" so it never gets
executed.
Indeed; the parser thinks an unrecognized keyword indi
Eric Brown wrote:
I've got quite a few plpgsql functions that insert, update or delete.
They're all declared to return void. All other functions, I can just run
'select f(...);' from psql to test them. I don't understand how to test
these ones that return void from psql.
neilc=# create function
On Tue, 2004-12-14 at 17:15 -0800, Tim Vadnais wrote:
> My question is:
> What is stand-alone mode?
http://www.postgresql.org/docs/7.4/static/app-postgres.html
-Neil
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Tue, 2004-12-14 at 14:12 -0600, Scott Marlowe wrote:
> IS this same issue true for hash or GiST indexes?
Yes, it is: currently, only btree indexes are WAL safe.
(I spent some time recently looking into adding page-level concurrency
and WAL to GiST, but I haven't had a chance to finish that wor
On Wed, 2004-12-15 at 10:22 +1100, Harvey, Allan AC wrote:
> I have a small table about 20 rows, a constant, that is receiving
> about 160 updates per second.
> The table is used to share gathered data to other process asynchronously.
> After 5 min it is 12 updates per second.
> Performance returns
On Mon, 2004-12-13 at 17:43 -0500, Jimmie H. Apsey wrote:
> Hello all,
> I have just loaded Postgresql 7.3.6-7 onto a new server on the
> recommendation of Tom Lane. It is part of Red Hat AS 3.
> I have Postgresql 7.1.3-5 running on Red Hat AS 2.1.
> I have a simple view from which I select on bo
On Sun, 2004-12-12 at 20:25 -0800, Lonni J Friedman wrote:
> OK, thanks. So is there any real benefit in doing this in a generic
> (non-dspam) sense, or is it just a hack that wouldn't be noticable?
> Any risks or potential problems down the line?
It saves 4 bytes per row; depending on alignment
On Mon, 2004-12-06 at 23:55 -0500, Tom Lane wrote:
> Bear in mind that the price of honoring sort_mem carefully is
> considerably far from zero.
I'll do some thinking about disk-based spilling for hashed aggregation
for 8.1
> The issue with the hash code is that it sets size parameters on the
> b
On Mon, 2004-12-06 at 22:19 -0300, Alvaro Herrera wrote:
> AFAIK this is indeed the case with hashed aggregation, which uses the
> sort_mem (work_mem) parameter to control its operation, but for which it
> is not a hard limit.
Hmmm -- I knew we didn't implement disk-spilling for hashed aggregation
On Mon, 2004-12-06 at 19:37 -0500, Paul Tillotson wrote:
> I seem to remember hearing that the memory limit on certain operations,
> such as sorts, is not "enforced" (may the hackers correct me if I am
> wrong); rather, the planner estimates how much a sort might take by
> looking at the statist
On Tue, 2004-11-30 at 17:54 +1100, Johan Wehtje wrote:
> I am getting the error "Column n.nsptablespace does not exist" in my
> application when I connect using my Administrative tool. This only
> happens with Version 8, but it does crash my application, does anyone
> have any ideas ?
You need
On Thu, 2004-11-25 at 15:00 -0500, Fred Fung wrote:
> I am running PostgreSQL 7.4.5 and I notice the following 2 sets of
> error messages generated by the postmaster everything I do a query
> through my frontend application program
The source of the errors is your frontend application, not Postgre
On Thu, 2004-11-25 at 10:24 +0100, Bjørn T Johansen wrote:
> do I still need to use ::int8 to
> make it use indexes in 8.0 as I need in 7.x?
That should no longer be necessary.
-Neil
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comm
Ulrich Meis wrote:
CREATE TABLE data.question_result (
id bigserial PRIMARY KEY,
trial_idbigint NOT NULL REFERENCES data.trial(id),
question_id bigint REFERENCES content.question(id),
,
);
mydb=# explain analyze select * from data.questi
On Mon, 2004-11-22 at 08:59 -0500, Geoffrey wrote:
> So that would say the previous statements are not accurate? That is,
> there's no problem with using a varchar?
Right; there is no reason to prefer CHAR(n) over VARCHAR(n), unless you
need whitespace padding.
-Neil
Peter Eisentraut wrote:
There are certainly ways to handle this. But no one has seriously proposed
getting rid of OIDs and presented a plan for fixing all the other holes that
move would leave.
Right; I certainly have no intention of trying to remove OIDs any time
soon. However, I _will_ be pro
On Thu, 2004-11-11 at 14:34 -0500, Tom Lane wrote:
> Geoffrey <[EMAIL PROTECTED]> writes:
> > Do I get more oids on a 64 bit machine?
>
> No.
Nor will OIDs ever be 64 bit, I'd hazard to guess.
In any case using OIDs in applications is a bad idea -- you probably
should not be using them at all, l
Andrew Lazarus wrote:
Is there some clear reason why I can't using EXECUTE of a PREPAREd query
as I can a SELECT statement in CREATE TABLE AS, INSERT, FROM clause,
sub-selects, etc.? If not, wouldn't this be a very useful change?
You can already do CREATE TABLE AS ... EXECUTE.
I agree being able
I don't see the big difference between what Marco is suggesting and user
threads -- or to be more precise, I think user threads and event-based
programming are just two sides of the same coin. A user thread just
represents the state of a computation -- say, a register context and
some stack. It
Henk Ernst Blok wrote:
I assume(d) the more expensive statistics (e.g., value distribution
info) are updated only when outdated too much or on request (manual
vacuum).
They are only updated on request -- i.e. when an ANALYZE is issued.
So if explain can get the most recent count, why
not use it
On Mon, 2004-10-25 at 22:59, Deepa K wrote:
> Hi,
> I am using postgresql 7.1.3 in RedHatLinux 7.2.
Note that PostgreSQL 7.1.3 is quite old -- you should consider
upgrading.
> Can anyone tell me how
> to connect with postmaster through TCP socket (it is started with -i
> option) using libpq fro
On Mon, 2004-10-25 at 00:43, Tom Lane wrote:
> He's not. There were two other recent security reports, which core kept
> to ourselves until the release could be made.
Ah, ok -- fair enough. Are those additional security fixes mentioned in
the release notes?
-Neil
---(e
Marc G. Fournier wrote:
In order to address a recent security report from iDefence, we have
released 3 new "point" releases: 7.2.6, 7.3.8 and 7.4.6
Assuming you're referring to the make_oidjoins_check bug, I don't think
it is accurate to bill these as "security releases". As the 7.4.6
release no
On Thu, 2004-10-21 at 06:40, Thomas F.O'Connell wrote:
> Is the ON COMMIT syntax available to temporary tables created using the
> CREATE TABLE AS syntax?
No, but it should be. There's a good chance this will be in 8.1
> If not, is there a way to drop such a table at
> the end of a transaction?
On Wed, 2004-10-13 at 14:58, John Ossmann wrote:
> I'm not sure where to find it exactly, but does anyone know how much
> data a column of type "text" in a postgres DB can hold?
There is no limit on what "text" itself can contain. However, a field of
any data type can contain at most 1GB (compress
On Wed, 2004-10-13 at 06:31, Ed Stoner wrote:
> I am unable to use the "CREATE USER" command with numeric user names
> (i.e. CREATE USER 35236 WITH PASSWORD '1234';). Is this a limitation or
> a problem somewhere with how I have things configured? Is there are
> workaround?
A username is an i
1 - 100 of 156 matches
Mail list logo