The following bug has been logged online:
Bug reference: 4290
Logged by: Andreas
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3
Operating system: Linux
Description:wrong double subselect with aggregate function
Details:
select version
The following bug has been logged online:
Bug reference: 4684
Logged by: andreas
Email address: postgre...@elbrief.de
PostgreSQL version: 8.3.6
Operating system: linux
Description:lastval in function
Details:
create table bla ( id serial primary key , name text not
Heikki Linnakangas schrieb:
andreas wrote:
if nextval is used inside a function in a insertstatement, you get always
the value from inside the last function. but i expected, that lastval()
deliver the value from the insertstatement. i think, this should
clearify in
the documentation, or better
The following bug has been logged online:
Bug reference: 3246
Logged by: Andreas
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Windows Vista
Description:User "name" could not be created.
Details:
Hi
I can not install postgre
The following bug has been logged online:
Bug reference: 3741
Logged by: Andreas
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4/8.3.beta2
Operating system: debian gnu linux
Description:translation mistake
Details:
FEHLER: Spalte »...« muss in der
The following bug has been logged online:
Bug reference: 3926
Logged by: Andreas
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3
Operating system: All
Description:Typo in documentation
Details:
There is a typo in http://www.postgresql.org/docs/8.3/static
to try to change it. I'd be willing to take responsibility for ripping
> out btree_gist's inet support altogether ...
>
> regards, tom lane
That is the reason why I just reported it instead of trying to fix it
myself first. Since I could not understand why
ary" index.
And the code should be as database independent as possible, therefore I
cannot use an array or another data type that may not be supported by
other DBMS.
Regards,
Andreas Peer
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Tom Lane schrieb:
> Andreas Peer <[EMAIL PROTECTED]> writes:
>
>> Well, the use case is a strange one... I would like to use a varchar()
>> column for storing a variable-length vector of integers. The numbers are
>> represented by the codepoints. Therefore,
uite
surprising that data can be lost even if the system is shutdown
correctly), or better when shutting down the postmaster should spit all
log segments containing all changes when archiving is on so the warm
standby server can catch up.
Regards.
Andreas
--
Sent via pgsql-bugs mailing l
Scott Mead wrote:
>
>
>
> On Mon, Apr 6, 2009 at 7:37 AM, Andreas Pflug
> mailto:pgad...@pse-consulting.de>> wrote:
>
> Running 8.3.7, I have a warm standby configuration with a
> archive_timeout of 10min.
>
> It's obvious that there's a
Guillaume Smet wrote:
> On Mon, Apr 6, 2009 at 1:37 PM, Andreas Pflug
> wrote:
>
>> IMHO this should be mentioned in the docs explicitly (I find it quite
>> surprising that data can be lost even if the system is shutdown
>> correctly), or better when shutting down
.sp_pp_set(@ppnr integer, @JobID
character varying) OWNER TO sa;
It fails to restore the parameters of a lot of functions... only 2 functions
(without any parameter) are restored fine.
Beste Gruesse / best regards
Andreas Nolte
Manz Automation AG
Andreas Nolte
Entwicklung / Appl
could create database and tables but I cannot populate data into any of
the tables.
How would I make this possible.
Best regards,
Andreas Mutota
GIS Analyst Programmer
Nationl Planning Commission
Central Bureau of Statistics
Private Bag 13356, Windhoek
Republic of Namibia
TeL: +264 61
The following bug has been logged online:
Bug reference: 4881
Logged by: Andreas Wenk
Email address: a.w...@netzmeister-st-pauli.de
PostgreSQL version: 8.4 RC1
Operating system: Linux Kubuntu 9.04 Jaunty
Description:KDE 4.2 not running any more when installing one
with de_DE).
Regards,
Andreas
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
This issue still seems unaddressed.
Andreas Pflug wrote:
> The installer claimed a non-fatal problem, cluster is up and running.
> Excerpt from install-postgresql.log
>
> Installing pl/pgsql in the template1 databases...
> psql: Warnung: berflssiges Kommandozeilenargument ¯
The following bug has been logged online:
Bug reference: 5057
Logged by: Andreas Kuckartz
Email address: a.kucka...@ping.de
PostgreSQL version: 8.2.14
Operating system: Windows
Description:Binaries missing
Details:
"Only PostgreSQL 8.2 and above are support
ic BOOL
+__attribute__((constructor))
+init(void)
+{
+ getGlobalDefaults(DBMS_NAME, ODBCINST_INI, FALSE);
+ return TRUE;
+}
+
+#else
/* These two functions do shared library initialziation on UNIX, well at least
* on Linux. I don't know about other systems.
A
lp)
I cannot reproduce these problems, sometimes the db is fast, sometimes very slow. The
perl script doesn't seem to be the problem, because I wrote all SQL Commands to a file
and processed them later ("psql dbname postgres < SQL-File").
Same thing
lp)
I cannot reproduce these problems, sometimes the db is fast, sometimes very slow. The
perl script doesn't seem to be the problem, because I wrote all SQL Commands to a file
and processed them later ("psql dbname postgres < SQL-File").
Same thing
0.0 0.7 0:00 postmaster
14838 andreas9 0 15228 14M 1796 S 0.7 5.9 11:58 parse.pl
The main postmaster is job 14819 (0.0% CPU). The postmaster spawned by perl is sucking
up 98.5% CPU.
cat /proc/meminfo writes:
total:used:free: shared: buffers: cac
.
The problem is, that sometimes the performance is good, and sometimes the database is
awfully slow.
If it is slow, postgres is eating up all CPU time and it takes at least 150 times
longer to insert the data.
I don't know why and what to do against that.
Andreas
On Mon, 20 Aug 2001 19:39:31
38:23 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> Andreas Wernitznig <[EMAIL PROTECTED]> writes:
> > I am aware of the performance drawbacks because of indices and
> > triggers. In fact I have a trigger and an index on the most populated
> > table. It is not possible
On Wed, 22 Aug 2001 19:19:42 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> Andreas Wernitznig <[EMAIL PROTECTED]> writes:
> > I took option 1 and managed to create a profile of a slow and a fast run:
>
> It's difficult to compare these profiles, because they seem t
You cannot insert and delete the same data within one transaction.
Only one change of a row is allowed.
Greetings
Andreas
On Wed, 29 Aug 2001 13:18:02 +0200
"Pawel Pawlowski" <[EMAIL PROTECTED]> wrote:
> When I insert to table new row and after this in the same transaction
eive the information gained from "vacuum analyze".
Greetings
Andreas
On Mon, 03 Sep 2001 12:26:39 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> Andreas Wernitznig <[EMAIL PROTECTED]> writes:
> > To make it more comparable I have made two additional runs, a slow and
> > a
the server was lost. Attempting reset: Failed.
This usually happens after some millions of rows are inserted into the database.
What can I do to avoid this error?
Greetings
Andreas
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
the postgresql-programmers is now:
Why don't you skip the automatic index creation for primary keys and let the user
decide to create an index,
that should be used in any case, regardless whether the table is full or empty ?
Andreas
On Fri, 5 Oct 2001 03:21:01 -0400 (EDT)
[EMAIL PROTECTED]
slower in Test B.
For both tests (steps 2-4) I use one connection to the database.
If I quit the connection after step 3 and establish a new connection for step 4 it
takes 39 seconds in either cases.
-> Using one connection the optimizer for pk/fk-checking is not updated by a "vacuum
analyz
Why don't you skip the automatic index creation for primary keys and let the user
decide to create an index,
that should be used in any case, regardless what the query planner recommends ?
On Fri, 05 Oct 2001 15:15:06 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> Andreas Wern
g decisions.
Then I have to execute a "vacuum analyze" or reconnect in case of foreign key checking.
I would like to tune postgresql to use an index in any case if it is available.
On Fri, 05 Oct 2001 18:01:08 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> Andreas Wernitznig <[
a question regarding handling
of large objects ??? I still have a probleme there!
Hope you can help with short e-mail.
Andreas
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
time() -- sorry for my
|> faulty memory. The case I am handling is in recovering local time given
|> a time_t (in UTC of course). I have independently derived a broken-down
|> time structure, so have both the original structure and the results of
|> localtime() available in my code.
dates and times before 1970), but if I'm understanding
|> things correctly we will need to somehow reimplement the entire time and
|> time zone support system within PostgreSQL. I'll start looking at the
|> FreeBSD code to see what is available. *sigh*
Since POSIX says years bef
I hope, this is really a bug and not something I didn't understand :-)
Best Regards
Andreas Heiduk
__
Verschicken Sie romantische, coole und witzige Bilder per SMS!
Jetzt bei WE
Hello!
Tom Lane <[EMAIL PROTECTED]> wrote
>
> Andreas Heiduk <[EMAIL PROTECTED]> writes:
> > If a view which calls a function is LEFT JOINed to a table but not all
> > result rows are matched by some criteria, then the function is called
> > for each row o
dfec250
psql:backup:845: ^
psql:backup:846: invalid command \N
psql:backup:847: invalid command \N
psql:backup:848: invalid command \N
This is on NetBSD-current, i386.
--
Andreas Gustafsson, [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
t looking for support or
workarounds, but simply to have the bug fixed. Whether or not I need
to preserve OIDs, the documented upgrade procedure for the case where
OIDs do need to preserved is not working, and that clearly is a bug in
either PostgreSQL itself or the documentation.
--
A
The following bug has been logged online:
Bug reference: 2598
Logged by: Andreas Langegger
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Gentoo Linux 3.3.6, Kernel 2.6.16
Description:Columns named R are not accessible - although R is not
key, date, time, remarks, R) values
(9, '2006-08-30', '12:00:00', 'no comments', 30);
causes:
ERROR: column "r" of relation "sunspots" does not exist
regards,
Andy
Tom Lane wrote:
> "Andreas Langegger" <[EMAIL PROTECTED]>
Win32's strftime be an acceptable solution?
elog.c is already doing this, however because of the length of the
zone names, not the localization problem. The attached patch is
completely untested because I don't have access to a win32 box.
regards,
andreas
Index: src/bin
k backported) on the same machine
finds cbrt and passes the 'gmake check' just fine.
Is this a known error or due to some intentional change that I've missed?
Regards,
Andreas
---(end of broadcast)---
TIP 7: You can help su
Alvaro Herrera wrote:
Andreas Lange wrote:
And here is from configure:
checking whether gettimeofday takes only one argument... no
checking for cbrt... no
Undoubtely this is the problem. Can you show the relevant config.log
extract?
Ok, here we go:
configure
Alvaro Herrera wrote:
Andreas Lange wrote:
configure:13462: checking for cbrt
configure:13519: /sw/sun-studio-11/SUNWspro/bin/cc -Xa -o conftest -fast
-fns=no -fsimple=1 -xtarget=opteron -xarch=amd64a conftest.c -lz
-lrt -lsocket >&5
"conftest.c",
: test -z
|| test ! -s conftest.err
configure:5211: $? = 0
configure:5214: test -s conftest
configure:5217: $? = 0
configure:5287: result: none required
regards,
Andreas Lange
-native
-xdepend -xlibmil -xlibmopt -xO5 -xregs=frameptr
I do understand the recomendation to avoid -fast, the tweaking is both
compiler version and hardware architecture dependant. Doing a make check
is always advisable.
regards,
Andreas
---(end of broadcast)
The following bug has been logged online:
Bug reference: 3280
Logged by: Andreas Sakowski
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: debian-linux
Description:wrong german-translation
Details:
If you truncate a table with a foreign
The following bug has been logged online:
Bug reference: 3716
Logged by: Andreas Pflug
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux,Windows
Description:utf8 crash with replace
Details:
If replace is used with UTF8
Tom Lane wrote:
> "Andreas Pflug" <[EMAIL PROTECTED]> writes:
>
>> If replace is used with UTF8 client_encoding, searching for a malformed
>> string, the backend will crash.
>>
>
>
>> SELECT replace('Ärger', chr(195), '
ually "max autovacuum connections" +
NBuffers.
My attached patch fixes this by adding "max autovacuum connections" * 2
to NBuffers before the check.
Best regards,
Andreas Kling
ACG Nyström AB
Index: src/b
be an error message at all. ;-)
Cheers,
Andreas
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
The following bug has been logged online:
Bug reference: 4252
Logged by: Andreas Andersson
Email address: [EMAIL PROTECTED]
PostgreSQL version: SQL 2.8
Operating system: Vista SP1
Description:SQL stops my graic cards
Details:
Post this bug on pockertracker forum
away the data in a temp table, dropping the problematic one and
recreating it made the whole thing work again.
Below is the declaration used (before and after the upgrade):
Regards,
Andreas
drop table gradsite_dev_course_classification;
create table gradsite_dev_course_clas
pg_description des ON des.objoid=rw.oid
WHERE ev_class = 12345
ORDER BY rulename
Regards,
Andreas
Christian Ruediger Bahls wrote:
it could be because of the encryption layer
that postgresql uses ..
i think this is because i use the encrypted layer
an uncomplete stacktrace i have from one
of
nsp ON nsp.oid=cl.relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=rw.oid
WHERE ev_class = 12345
ORDER BY rulename
Regards,
Andreas
Christian Ruediger Bahls wrote:
it could be because of the encryption layer
that postgresql uses .. i think this is because i use the encrypted
laye
trace down that ssl thing.
Regards,
Andreas
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Tom Lane wrote:
Andreas Pflug <[EMAIL PROTECTED]> writes:
I currently don't have a system to reproduce this, because I didn't
succeed making my 7.4 server accepting ssl-connections. I posted for
installation help on pgsql-admin but didn't get a reaction so far. RTFM
u
should do --- but make
sure you get the full contents of each packet sent and received.
Hi Tom,
the attached file is a tcpdump of a connect attempt.
Regards,
Andreas
00:14:21.128861 localhost.32821 > localhost.postgresql: F 2173273900:2173273900(0) ack
2168553850 win 32767 (DF)
hat I could enable in the backend
to be a bit more verbose about the communication process?
Regards,
Andreas
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
uld have answered "no". I didn't opt
vor IPV6 either, it's a stock SuSE 8.1.
Immediately, I checked the reported ssl hangs, and found both cases
working. Dave reported this failing on snake.pgadmin.org, which uses a
different openssl (0.9.7a), I'
this form.
=
===POSTGRESQL BUG REPORT TEMPLATE
=
===
Your name : Andreas Hinz
Your email address : [EMAIL PROTECTED]
System Configuration
-
Ar
assume DB2 and Oracle have similar facilities, not necessarily in SQL.
Perhaps pgadmin has this ability?
AFAIR pgAdmin2 does have a grant utility for this. pgAdmin3 has this on
the TODO for the next version.
Regards,
Andreas
---(end of broadcast)
e are already patches for this on the way; please look at
pgsql-patches of the last days.
Regards,
Andreas
---(end of broadcast)---
TIP 8: explain analyze is your friend
n?
i think mailing such questions to "BUGS" is not a good idea.
Just use the pgsql-sql and pgsql-performance mailing lists.
Regards,
Andreas
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
[EMAIL PROTECTED])
Looks like a cvs conflict because you changed something in pqcomm.c.
Remove pqcomm* and cvs update again.
Regards,
Andreas
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Bupp Phillips wrote:
Could you possible have some type of variable (preferably the Transaction
ID) that can identify an individual process?
There's pg_backend_pid() for 7.4 and backend_pid() as contrib module for
earlier releases.
Regards,
Andreas
---(end of broa
Jim,
first of all, this is the wrong mailing list. Use pgadmin-support for
pgadmin related questions.
The binary win32 release of pgAdmin3 is unicode enabled, which requires
Windows NT, 2000 or XP, 95 and 98 are too old.
Regards,
Andreas
---(end of broadcast
p
until fill all my partition (from 1GB grows up to 15GB !!!).
This is by design, you need to VACUUM regularly to keep your db healthy
as pointed out in the documentation.
Regards,
Andreas
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
ated
questions.
Which tool did you use to insert the data?
Regards,
Andreas
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hiroshi Saito wrote:
Hi Andreas.
I have a problem.
It is a happening within this week.
See below.
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20030922_1.jpg
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20031007_1.jpg
Tonight, let me know it if you know something though it will be examined.
Thank
Cymbal #2
Cymbal - 18 inch
[EMAIL PROTECTED] tgl]$ LC_ALL=en_GB sort zzz
Cymbal #1
Cymbal - 18 inch
Cymbal #2
[EMAIL PROTECTED] tgl]$
I verified this, and it's not GB specific as one might suggest... Same
with en_US, de_DE, fr_FR, af_ZA. Does this behaviour really make sense
2500 bytes.
Please let me know what's wrong with that.
Regards,
Andreas
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
a limited class of changes exist that
can be done without deep impact, namely changing between binary
compatible types and extending the length. This is what pgadmin3 does,
but apparently this wasn't correct.
Regards,
Andreas
---(end of broadcast)-
not TRUE.
Yes, that it's better.
Still not precise.
NULL = NULL
is NULL (which is neither TRUE nor FALSE)
while
(NULL = NULL) IS NULL
is TRUE...
Regards,
Andreas
---(end of broadcast)---
TIP 6: Have you searched our list archives?
DY$ LANGUAGE 'plpgsql'
I find the result of this function quite surprising, and certainly not
yielding what was intended (yes, this can avoided, I know). Surprise is
getting bigger, if fullname is declared as text...
IMHO the bottom line here is that the SQL-spec behavior of type ch
following error message:
column "datpath" does not exist
pgAdmin III V1.0.2 is for PostgreSQL 7.3 and 7.4 only, use a V1.1 snapshot.
Regards,
Andreas
---(end of broadcast)---
TIP 8: explain analyze is your friend
h offer tablespace size as well.
Regards,
Andreas
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
a.
Nathan,
please post pgadmin related stuff at pgadmin-support.
You probably didn't assign a primary key to that table, pgadmin3 will
refuse to edit tables on which it can't identify rows uniquely.
Regards,
Andreas
---(end of broadcast)
Andras Kutrovics wrote:
LOG: select() failed in statistics collector: An operation was
attempted on something that is not a socket.
What's your operating system platform?
Regards,
Andreas
---(end of broadcast)---
TIP 7: don't forget t
te a connection
dialogue!"
Known and already fixed.
Regards,
Andreas
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Bruce Momjian wrote:
This has been corrected in current CVS.
But it still fails for tables in tablespaces. That's why I posted all
new functions a while ago.
Regards,
Andreas
---(end of broadcast)---
TIP 7: don't forget to increase your
Bruce Momjian wrote:
Andreas Pflug wrote:
Bruce Momjian wrote:
This has been corrected in current CVS.
But it still fails for tables in tablespaces. That's why I posted all
new functions a while ago.
Yes, you posted the functions, but I don't understand how to integrate
that into dbsi
Bruce Momjian wrote:
Andreas Pflug wrote:
Bruce Momjian wrote:
Andreas Pflug wrote:
Bruce Momjian wrote:
This has been corrected in current CVS.
But it still fails for tables in tablespaces. That's why I posted all
new functions a while ago.
Yes, you posted the functions, but I
section "13.4.2 Use COPY FROM"
within "Performance Tips" would prevent other people like me doing such bad things.
Many thanks for the fast help.
Andreas Heiduk
Stephan Szabo <[EMAIL PROTECTED]> schrieb am 24.08.04 19:25:56:
>
>
> On Tue, 24 Aug 2004, Pos
up the tray with colourful useless stuff). Usually a server
process is started when the machine starts, and stopped when switched off.
To control the pgsql service, you can do this in pgAdmin III, in
addition to the usual services applet.
Regards,
Andreas
---(end of
period of work on multi currency applications, I found out
that adding 1 USD and 1 EUR won't give a good result...
Regards,
Andreas
---(end of broadcast)---
TIP 8: explain analyze is your friend
Karel Zak wrote:
On Mon, 2004-09-20 at 08:36 +, Andreas Pflug wrote:
Karel Zak wrote:
On Sun, 2004-09-19 at 15:29 -0400, Tom Lane wrote:
I want to rewrite it for 8.1 as numeric based datetype with some
formatting extension probably with some internal stuff from to_char()
familly.
How about a
ing tool that I have installed is
NetLimiter
This is a good example of a misleading error message, probably resulting
from examining errno. Using GetLastError() on those socket calls might
help reducing support requests.
Regards,
Andreas
---(end of broadcast)--
re a query to money.yahoo.com to establish.
It's even more complicated. In practice, real time rates of exchanges
are much less frequent than point in time rates.
Regards,
Andreas
---(end of broadcast)---
TIP 5: Have you checked our extensive
O any pgsql language should handle cr, crlf and lf equally as line
feed, to avoid client/server eol interpretation discrepancies.
Regards,
Andreas
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
the same through a C# App connecting to the
database through an ODBC driver I get the following error:
*"ERROR: 22021: invalid byte sequence for encoding \"UNICODE\": 0xe16d61"*
Sounds as if you're not using the correct client encoding; your app is
probably non-uni
copies of pgAdmin at once".
Which is still not the whole truth.
pgAdmin may open more connections to the "initial database", e.g. to
show the server status.
So the advice is "don't use the template1 database for pgadmin
connections if you're creating databases frequentl
d it be possible to teach pgAdmin to close extra connections
to template1 whenever it's doing CREATE DATABASE?
If those connections were guaranteed to be idle, we wouldn't need them.
They are independent windows, so we can't kill the conn.
Regards,
Andreas
finstance) REFERENCES
debug.form_instance(finstance) ON UPDATE CASCADE ON DELETE CASCADE
And the dump data order is:
-- Data for Name: form_a_int;
-- Data for Name: form_instance;
-- Data for Name: form_q;
Regards,
Andreas (Not a subscriber of this list)
begin;
--drop schema debug cascad
Lucas Galfaso wrote:
Create a trigger using capitalized letters. Whenever you select the trigger,
the name of the trigger appears without quotes.
Fixed for 1.2.1, thanks for reporting.
Regards,
Andreas
---(end of broadcast)---
TIP 7: don't forg
handle of an inherited pipe.
Regards,
Andreas
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
/robustness), unfortunately
programmers are seduced by MySQL to work like that..
B) is this any sort of SQL standard?
Definitely no.
Do not use SELECT * if you need a specific column ordering, *that* is
SQL standard.
Regards,
Andreas
---(end of broadcast
hat examine the
pids known to the postmaster (pg_get_collector_pid, pg_get_logger_pid, ...)
Regards,
Andreas
---(end of broadcast)---
TIP 8: explain analyze is your friend
"3";"12";"0";"7 days
is the result I'm getting in pgadmin.
Regards,
Andreas
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
1 - 100 of 132 matches
Mail list logo
