Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
Implementing this type of syntax checker isn't hard since the code
is already there, but there might be a small, ugly problem. IIRC,
the parser and/or semantic analyzer of PL/pgSQL relies on knowing
whether the function is called
Michael Ben-Nes wrote:
I recomend you to compile PG from source so you can use the new 8.0.1
PostgreSQL 8.0.1 is available in the Debian experimental suite, package
name postgresql-8.0.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
in the
PostgreSQL documentation.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
, say, Nagios.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
NTPT wrote:
Having some sort of line numbering in result query would be nice...
The query result has line numbering. How else are you accessing the
individual rows?
Is the issue really that you want psql to number the lines on display?
That could be implemented.
--
Peter Eisentraut
http
order to tables or views or
actually had some kind of automatic row number available, that would
still make the semantics of your data dependent of the particularities
of the queries that you use to access it, which doesn't sound like a
good idea to me.
--
Peter Eisentraut
http
is not an issue.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
)::text ~~ 'J%'::text)
What part of Index Scan are you misunderstanding?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Condition.
Well, the truth is that it has *the option* to use the index, but it doesn't
have to. This really mostly independent of the LIKE index issue. If you
think that the plan choice is not optimal, try EXPLAIN ANALYZE and post the
results if you need help interpreting them.
--
Peter
Charl Gerber wrote:
DROP DATABASE db_name IF EXISTS (--- is there something similar in
Postgre? Like the CREATE OR REPLACE FUNCTION)
No, you just go ahead and ignore the error.
CREATE DATABASE db_name;
USE db_name;
\connect db_name
SOURCE users.sql;
\i users.sql
--
Peter Eisentraut
josue wrote:
is there a way return a column with the row number automatically
generated according the way the rows were processed by the query.
No, but you can easily keep a counter in the client.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
bothered
to implement it until now).
I remain mystified why the WIN encoding would default to a fairly
obscure Cyrillic encoding considering most Russian users that I know
are using either KOI8 or Unicode.
Legacy.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
with PostgreSQL 6.3 at best, so I'd disregard
this report.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Am Samstag, 12. Februar 2005 23:32 schrieb Preston Landers:
If the postgresql encoding WIN is intended to be Cyrillic 1251, then
it should be labeled as such in the docs to avoid confusion.
Well, isn't it? You pointed to the place in the documentation yourself.
--
Peter Eisentraut
http
mirror then.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(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
. And of
course, to report a bug/vulnerability/etc you would write to
pgsql-bugs, not core.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Tope Akinniyi wrote:
If I may ask, is there any plan for embedded PostgreSQL database
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
exactly one 'master' cat.
It seems to me that you should merge this table into the cats table.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
and get a backtrace.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Bruno Lavoie wrote:
is there a way to easily configure postgresql to auth with pam on
debian?
Yes, the same way as on any other platform. What particular problem are
you having?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Am Dienstag, 18. Januar 2005 11:32 schrieb David Teran:
maybe its a silly question, but is there a way to list all databases
with an SQL command? I know about the \l command from psql, but i
wonder if such things are possible with SQL.
SELECT * FROM pg_database;
--
Peter Eisentraut
http
, the pessimistic alternative is using the transaction isolation
level Read Committed and explicitly locking all rows you want to alter
using SELECT FOR UPDATE. Again, read the documentation for details.
In any case, explicitly reading xmin and friends is not necessary.
--
Peter Eisentraut
http
Lonni J Friedman wrote:
Now i need to add an additional DB for a different server, but I
can't afford any down time to restart postgresql for the changes in
pg_hba.conf to take effect.
pg_ctl reload or (equivalently) kill -HUP
--
Peter Eisentraut
http://developer.postgresql.org/~petere
you should have at least 300 * several PostgreSQL connection slots,
which is probably more than the 1000 or so that is the default.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Don't 'kill -9
Am Dienstag, 11. Januar 2005 13:43 schrieb Jason Tesser:
Can you insert and update data in views in 8.0 I know you cannot in 7.4.
Views not updatable in 7.4 or in 8.0. You need to write your own update
rules. Nothing has changed in that regard.
--
Peter Eisentraut
http
see something usable.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
in this particular
case.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Scott Marlowe wrote:
unix_socket_directory = /home/pgmaster/tmp
The directory I'm trying to use is world writable. Am I missing
something simple here?
Yes, single quotes around the parameter value.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Jamie Deppeler wrote:
Problem i am having at the moment i cant get a true alpha sort to
work as Order By is sorting A..Z then a..z where i need aA..zZ sort
independant of case.
Initialize the database cluster with a locale setting other than C.
--
Peter Eisentraut
http
Dave Brazzeal wrote:
I'm running postgreSQL on SLES 8
No, there isn't. If we were able to write a repair utility, we might as
well fix the code to prevent the damage in the first place.
If you have a problem that you need to repair, please provide specifics.
--
Peter Eisentraut
http
.
Is there any wway to get the older versions for Window$?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
contribution.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message
will have to implement that manually in PostgreSQL,
with triggers and a bunch of code.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Unicode characters greater than or equal
to 0x1, then I don't have a good answer.
But more often, this error means that your file is not in Unicode in the
first place. If so, set the client encoding to the real encoding of
your file, e.g.
export PGCLIENTENCODING=LATIN1
--
Peter Eisentraut
http
(LD_LIBRARY_PATH; PATH; PGLIB etc). Anyone come across that?
Moving the installation to a different path is not supported for
permanent use before 8.0. You better try to install in the same
directory layout on all machines where you want to deploy.
--
Peter Eisentraut
http
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
be corrected in the future.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Joshua D. Drake wrote:
Well you can't just upgrade 7.2.1 to 7.4.6. You have to dump and
restore.
The Debian package does that automatically. On some days...
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
and be
re-routed to pgsql.* instead ... on our server (and we encourage
others to do the same), the comp.* groups will be aliased to the new
pgsql.* hierarchy, so that posts to the old groups will still get
through ...
What exactly is this meant to achieve?
--
Peter Eisentraut
http
:
SELECT number
FROM procedures
WHERE date + (numdays || ' days')::interval = CURRENT_TIMESTAMP;
Just to add to the record, the mathematically sound way to write this
query would be this:
SELECT number
FROM procedures
WHERE date + numdays * interval '1 day' = current_timestamp;
--
Peter
away. This is one reason.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 8: explain analyze is your friend
proposed
getting rid of OIDs and presented a plan for fixing all the other holes that
move would leave.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose
??
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
the news: Not only the server encoding and the server locale have to
match. The same is true on the client side. In particular, in order to
avoid errors from the PO files, your LC_CTYPE and your PGCLIENTENCODING need
to be compatible.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Holger Klawitter wrote:
Shouldn't psql honour the current locale setting (LC_CTYPE) or/and
have a command line option to set the encoding?
The environment variable PGCLIENTENCODING serves this purpose.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Jim Seymour wrote:
echo $? after it happens yields 141. There is no 141 in
/usr/include/sys/errno.h.
Exit code 141 means signal 141 - 128 = 13 = SIGPIPE. I haven't finished
thinking what that means in this case, though ...
--
Peter Eisentraut
http://developer.postgresql.org/~petere
.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
mike wrote:
Is it possible to undo a transaction after it has completed (using 8
beta1)
Using the new point-in-time recovery feature, but you need to set that
up first.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
forwarded to the Usenet. That
might be interesting.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
in C and compile it
into a shared library.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
be even
more than the dba user.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
a primary key column
later.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 8: explain analyze is your friend
matter? I'm using the pltcl.so from my older
7.2 branch.
That doesn't work. You need to use the one that was compiled for the server
that you are using. You may need to adjust the path in the dump file.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Am Dienstag, 2. November 2004 09:09 schrieb Alex P:
Will there be a release 7.4.7 in the future?
Possibly.
When can the production release of 8 be expected?
When it's ready. Probably this year.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
to ensure that a second sort (such as
the oid?) is used?
Yes.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Am Dienstag, 19. Oktober 2004 02:31 schrieb Robby Russell:
Isn't the purpose to promote PostgreSQL? not *nix-only flavors?
It could be argued that the purpose is to get one's job done.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Terry Lee Tucker wrote:
When one moves from version 7.x to 8.x, will my old pgplsql functions
continue to work with the single quotes
Of course.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you
the second.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(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
appears to
have recommended at some point. My suggestion was to use null values.
Of course, if you don't want null values, you declare your column accordingly.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
except for bloat? It's not like SQL is utterly
compatible with any programming language; users will still have to learn all
the operators anyway.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9
of =
works for varchar keys with length 32 as well.
Please post the actual table definitions, the actual data, the actual
command you are running, and the actual results you are getting.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Lars Haugseth wrote:
Version 8.0.0beta2 supports a global configuration file. It's should
be located in '~postgres/etc/pgsql'.
That would be pretty useless, since normal users often don't have read
access to another user's home directory.
--
Peter Eisentraut
http://developer.postgresql.org
Hadley Willan wrote:
Reason being I'd like to install them locally on my laptop so that
when I'm lap topping it, I still have docs without the need for an
Internet connection.
The documentation is always included in the release tarball.
--
Peter Eisentraut
http://developer.postgresql.org
John Sidney-Woollett wrote:
Why not create this file during the make install, and explicitly
set the current/standard default options (for psql) in the
$PREFIX/share/psqlrc file?
Because it would take up space, computing power, and attention without
achieving anything.
--
Peter Eisentraut
Daniele Beauquier wrote:
How to import an Excel table into a Postgresql table in a simple way?
Export into a text file and import using COPY.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can
John Sidney-Woollett wrote:
With the advent of postgres v8, would it be possible to change the
default behaviour of psql from AUTOCOMMIT=ON to AUTOCOMMIT=OFF ?
Absolutely not. This will break every psql use in existence.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Vic Cekvenich wrote:
What can I run on OS X as a pgAdmin equivalment (other than the Java
solutions)?
phpPgAdmin might be worth a try.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off
. The problem is that people will use the new psql
expecting it to behave like the old one. This isn't a small secondary
change; it fundamentally changes the interaction with the program.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
AUTOCOMMIT in your psql configuration
file. We don't put feature-altering switches in the build process if
we can help it. Since most people use prebuilt binaries, such a switch
would be mostly useless at best.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Greg Donald wrote:
I get the error:
aggregates not allowed in WHERE clause
Try HAVING then.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
DatabaseMetaData.storesUpperCaseIdentifiers().
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(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
ppp wrote:
initdb -E ISO-8859-2 --locale=pl -D ppp
then pg_ctl -D ppp start
and i get: FATAL: invalid value for option 'LC_MESSAGES': 'pl'
Maybe your system only understands locale names of the form pl_PL.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
from one database session. But
you could use dblink from contrib to overcome this restriction.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
command is ok but the second
one fails?
All the commands are run in one transaction, so if one fails, the whole
sequence is rolled back.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: don't forget
that
over the past 4 release cycles, beta phases have lasted 3.5 months on
average, with little deviation. Based on that, I would not expect a
final release before the middle of November.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
TABLE :myValue
hardcoded ...
If myValue is double quoted, then the values will automatically be
concatenated by the backend parser, but for strange (SQL-standard) reasons
you need a line break in between.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Am Montag, 16. August 2004 16:20 schrieb Csaba Nagy:
Peter is definitely not a newby on this list, so i'm sure he already
thought about some kind of pooling if applicable... but then I'm
dead-curious what kind of application could possibly rule out connection
pooling even if it means so many
details.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
machines with a shared
storage (talk to your hardware vendor) or a replicating file system
(like DRBD) and make the two machines monitor each other so that only
one machine has the database mounted at any time.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Am Dienstag, 10. August 2004 10:05 schrieb [EMAIL PROTECTED]:
Will PostgreSQL 8.0 include replication server (not contrib/*) and nested
transactions support?
No and yes.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
I'm looking at a database-using program (PostgreSQL/libpq and MySQL) which
does the following: A daemon process opens a database connection, forks
children on request, and those children access the database using that
inherited connection. After one request, the child dies. It seems to me
release, but not in the release notes.
Also, what is the etymology of the term Slony?
Russian:
slon = elephant
slony = elephants
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: Have you checked our
and the cost calculation yields
that it would be more efficient to not use the index. If you disagree,
please show the timings generated by EXPLAIN ANALYZE.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6
Joel Rodrigues wrote:
The files do exist, for example:
/usr/include/libxml2/libxml/xpath.h
Try
make all CPPFLAGS=-I/usr/include/libxml2
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: the planner
database for that kind of job?
None. :-)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL
such as the Unicode Collation Algorithm.
The latter in fact allows what many people appear to be looking for: a
variable weighting option that allows you to promote punctuation
characters to the first pass. But I don't think any operating system
implements that, yet.
--
Peter Eisentraut
http
is to execute it as a stored procedure.
That won't necessarily help you on PostgreSQL, because in stored
procedures you can paste together queries from user-provided strings.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Nilabhra Banerjee wrote:
Thanks a lot.. This much is enough for meIf I get
some time afterwards I go thru it again But I am
still curious to know about the CFlags variable..what
are the other values it can take.
Depends on your system. Try man cc.
--
Peter Eisentraut
http
will
have problems.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 8: explain analyze is your friend
. There are a lot more paths compiled in than just the
rpath. If you want to change the installation paths, you need to
rebuild from scratch.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get
mike wrote:
All the date-time types seem to only be for specific time dates and
not for a running total.
You probably want the interval type.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
.
These installation instructions are completely bogus. The new text that
I just committed reads:
The user running make install may need root access; depending on how
you configured the PostgreSQL installation paths.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Am Freitag, 9. Juli 2004 08:30 schrieb Bret Busby:
Thus, recognised, international, industry certification of
open source application systems development, either involving PostgreSQL
as a database backend by itself, or, involving PostgreSQL as a factor
could be useful, apart from having the
Dennis Gearon wrote:
another name that does not work is 'H1q2W3e4R5_web_user'.
Sounds like a quoting problem. In the meantime, read this:
http://www.fr.postgresql.org/docs/7.4/static/bug-reporting.html
It seems to not like many alternations between numbers and letters.
Dennis Gearon
David Garamond wrote:
CREATE TABLE somereallylongname1 (...);
CREATE TABLEALIAS name1 somereallylongname1;
SELECT * FROM name1 ...;
Is there such a thing?
A view does exactly what you need.
---(end of broadcast)---
TIP 9: the planner
Tim Robinson wrote:
select * from temp where a like 'a\\\'%'
this should return all strings starting with a\' but it returns
nothing!!!
\ is also the quoting character of LIKE, in addition to being a quoting
character on the string literal level. If you want all strings
starting with
[EMAIL PROTECTED] wrote:
Can I take the INFORMATION SCHEMA views from 7.4 and install them in
older versions of PostgreSQL, if so, how far back can they work?
No. For your purposes, you maybe be able to backport them and
distribute the altered versions with your product. For some cases this
Wei Shi wrote:
Hi, does anyone know how to get the schema information
of a table. More specifically, I would like to know
1. which field(s) are primary keys?
2. the data type of each field of a table?
3. If a field is a foreign key, what field/table it
is referring to.
Use the information
501 - 600 of 934 matches
Mail list logo