Re: [GENERAL] EXISTS / IN - does it work on Postgresql?

[EMAIL PROTECTED] writes: WHERE ... EXISTS (SELECT ...) I was researching and found ambiguous information about this kind of subqueries, is that working fine with Postgresql? Yes. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end

Re: [GENERAL] pg_dump error - LOCALIZATION PROBLEM

() call suspicious. In many places an ASCII-only alternative is needed or the code needs to be rewritten. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [GENERAL] Numerical DB/Table Names

. They seem to be stored as binaries so I am unable to open any files under that directory. You are not supposed to be opening any internal files in any release. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

Re: [GENERAL] pg_dump error - LOCALIZATION PROBLEM

. A locale problem perhaps? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Working with dates and queries

: the fieldname is set to be a date field. Is this correct postgre syntax to find a date by month? If so: the fieldname I used was date since it is a researved word will this cause problems? If not what is the correct syntax? Thanks in advance -- Peter Eisentraut [EMAIL PROTECTED] http

Re: [GENERAL] locale and spanish acute

want to do is accent-fold your strings before sending them through pattern matching. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Ridicolus Postgresql review

call the latter for stored procedures, but that is terminological nonsense. And going out there writing an article claiming that in PostgreSQL users do not have the ability to create their own stored procedures, without further qualification, is confusing at best. -- Peter Eisentraut [EMAIL

[GENERAL] Installation location of Perl and Python modules

the default with an option for #4. The questions are, what would users expect and what would users like? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [GENERAL] user

in src/backend/parser/gram.y, remove the USER expansion of the c_expr nonterminal, and move the USER expansion of ColLabel up to TokenId. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3

Re: [GENERAL] What Is The Firing Order?

. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] Bug in createlang?

is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl -- Peter Eisentraut

Re: [GENERAL] query not using index

where event_id = 1; This is a bit of a PostgreSQL bug. See http://www.de.postgresql.org/devel-corner/docs/postgres/datatype.html#DATATYPE-INT Read the Note:. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

Re: [GENERAL] PostgreSQL On the Mac? OS9 or OSX?

Israel Evans writes: In looking over the documentation, I haven't seen any evidence of PostgreSQL working on the Mac. Is this the case, or am I missing something. You're missing something. ;-) 7.1 works on MacOS X. See the installation instructions. -- Peter Eisentraut [EMAIL PROTECTED

Re: MySQL's (false?) claims... (was: Re: [GENERAL] PL/java?)

Me writes: http://www.mysql.com/doc/M/y/MySQL-PostgreSQL_features.html Many of these advantages can easily interpreted as disadvantages. For example: I hope people aren't taking that feature comparison page as seriously as they took my parody of it. -- Peter Eisentraut [EMAIL

Re: [GENERAL] libpq

-lmysqlclient -lm All files are at its places. I use PostgreSQL 7.1.3. What I'm doing wrong? You didn't mention what platform you're on. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have

Re: [GENERAL] Error Codes, JDBC, SQLExceptions

Wieger Uffink writes: I would like to know if postgreSQL propegates any errorcodes at all, No. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [GENERAL] valid NULL DATE value

if any non-date fields usefully contain that value. (Probably unlikely.) -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [GENERAL] During dump: function not found

assuming (dangerous, I know) that these functions were created by PgAdmin rather than being a part of PostgreSQL. I deleted all tables and views named pgadmin* and am trying to weed out everything created by PgAdmin. Maybe PgAdmin could provide a drop script for that? -- Peter Eisentraut

Re: [GENERAL] Finding database names for overnight vacuum

Stephen Davies writes: I have a cron job which vacuums etc all of my databases but it does not work with 7.1.2 because of the change in structure of .../data/base. vacuumdb --all -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end

Re: [GENERAL] COPY and triggers

that rules are disabled.) -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL

Re: [GENERAL] confused on maximum characters

[EMAIL PROTECTED] writes: Looking at the docs Peter Eisentraut added this note at the bottom of the documentation for character data. --- The maximum value for n is 2147483648. The longest possible string is actually only about 1 GB, though. The storage size of (4+n) is actually incorrect

Re: [GENERAL] race conditions in my sequences

the generated primary key for the tuple you want to reference. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs

Re: [GENERAL] cmd-line interface

it. psql -V ON_ERROR_STOP= or check out ~/.psqlrc -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [GENERAL] psql -l

will trillich writes: in the old days (7.0.3) i could list databases via psql -l but these days (7.1) i must psql -l [-d] nameOfADatabaseFromPreordainedKnowledge probably because of some fuxnored setting. but which? Evidence please? -- Peter Eisentraut [EMAIL PROTECTED

Re: [GENERAL] Nusphere/MySQL-AB arguing

Well, you figure that one out. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] Postgresql Python 2

clear. But what about the rest (could be the question of a user)? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org

Re: [GENERAL] Postgresql Python 2

Trond Eivind Glomsrød writes: Exactly what bug are you thinking of? The current build process tries to detect your current version of python and build for that.. The RPMs Lamar distributed had Python 1.5 hardcoded. If you fixed that in the meantime, my apologies. -- Peter Eisentraut

Re: [GENERAL] OIDs

. In almost any advanced storage system, data records will be numbered or incrementally arranged as they come in. Even if you eliminated the oids (which you could just set to random values if you wanted), there are still transaction ids and tuple ids, which you won't be able to get rid of. -- Peter

Re: [GENERAL] [PATCH] Partial indicies again

). -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(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

Re: [GENERAL] datatype for indexable char field larger than 256

/this/really/long/500/char/path' work if i define the field 'path' as type text? Sure, you can store up to 1 GB in a text field. also, type text field aren't indexable or are they? Sure they are. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [GENERAL] query syntax change?

as default due to lack of alias), employee_id, ref_name, etc. In non-unioned queries we can be a little more lax about this because the semantics are clear. Btw., order by + union doesn't work prior to 7.1 anyway. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

[GENERAL] Re: [SQL] Cross database foreign keys

Morgan Curley writes: Does anyone know if it is possible to connect to a differernt db from within a plsql function. I have multilple inter-related schemas and want to enforce some fk relationships. Not possible -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [GENERAL] 7.1-1 installation from RPM

Mihai Gheorghiu writes: I uncommented and made changes so that now the uncommented lines look like: tcpip_socket = true ssl = false max_connections = 32 # 1-1024 port = 5432 shared_buffers = 2*max_connections # min 16 This won't work. No arithmetic allowed. -- Peter Eisentraut [EMAIL

Re: [GENERAL] Newbie Question

Clay Judi Kinney writes: How do I create an autoincrement field in a postgresql table??? See FAQ. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [GENERAL] IpcMemoryCreate: shmget failed (Invalid argument)

Steve Wolfe writes: Perhaps someone should write a platform-specific FAQ for Linux that answers this question, so that the link provided would actually be useful. http://www.ca.postgresql.org/devel-corner/docs/postgres/kernel-resources.html#SYSVIPC -- Peter Eisentraut [EMAIL PROTECTED

Re: [GENERAL] ODBC 3.0 functions (UCASE, LCASE, etc.)

. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] Serial Type

be quite tricky and slow. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] Joining more than 2 tables

hard to tell what you want to happen, but perhaps you want two separate queries: select a.id, a.name, sum(b.qty) from a, b where a.id=xxx and b.id=a.id group by a.id, a.name; and the same with 'c' in place of 'b'. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [GENERAL] starting personal postmaster

. Alternative 2: Use the postmaster -k option, but your client programs are not going to see that. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [GENERAL] rotating log files

you need to do is pipe the log output through a separate program that closes and reopens the file once in a while. Apache has such a program, for example. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

Re: [GENERAL] creating constants in postgres

Thomas F. O'Connell writes: is there in postgres a way to create a constant like CURRENT_DATE for general use? Those things are just functions with a special syntax. No, it's not easily possible to create more such functions, but it's easy to create regular functions. -- Peter Eisentraut

Re: [GENERAL] caching/ virtual file systems

, so I was wondering if anyone had developed any tricks to get certain blocks of data files to fall into subdirectories? Unless you like your data, don't do that. What happens in case of a crash? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [GENERAL] Detecting locks

in your application after which you send a query cancel. A waiting lock still distinguishes it from a crashed program, ISTM. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting

Re: [GENERAL] help with serial type

(zero) by the implicit type converter. The serial type only generates a sequence number if you do not override it explicitly with a different value. So what you want is something like this: INSERT INTO TABLE atable (title, name, date_field) VALUES ('SQL2', 'Toy', current_date); -- Peter

[GENERAL] Re: Struggling to change default data location

in the postgresql.conf file (under /var/lib/pgsql/data or whereever PGDATA ends up...). -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

Re: [GENERAL] sysconfdir

and pg_hba.conf files. These files live in the data directory ($PGDATA), where initdb puts them. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

Re: [GENERAL] newbie question -- oid

Cefull Lo writes: What is the upper limit of OID? 2^31-1 -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] oid

Toomas Gavrilin writes: Is there any way to get rid of postgres automatic generation of system attribute column 'oid'? No. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe

Re: [GENERAL] client ssl

host all 127.0.0.1 255.255.255.255 trust So what's hapening, why psql cannot connect to postgres, it dosen't support ssl or what??? Is there any response from any program when you try to do connect via SSL? -- Peter Eisentraut [EMAIL PROTECTED] http

Re: [GENERAL] Telling if options were set correctly in 7.1?

arm, cozy feeling from knowing that the options set in "postgresql.conf" have, indeed, been applied. What's the easiest way to check this? Use the SHOW command. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of bro

Re: [GENERAL] confirmation of insert/update

of the interface you're using. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] How to read a query plan?

) - Index Scan using wsflwebhost on websenseflat (cost=0.00..19688.55 rows=53 width=36) EXPLAIN Could someone give me an interpretation (or a URL that explains this)? http://www.de.postgresql.org/devel-corner/docs/postgres/performance-tips.html -- Peter Eisentraut [EMAIL PROTECTED

Re: [GENERAL] 7.1 on Solaris 8 run failure?

hared Memory and Semaphores" and there you would find all the information you need. At least this is how I imagined it. Is there a missing mental link? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of

Re: [GENERAL] man vacuum is broken?? in 7.1

should get. http://www.postgresql.org/devel-corner/docs/postgres/sql-vacuum.html -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [GENERAL] Is PostgreSQL database write to cooked files?

Raymond Chui writes: I am wonder are those files under $PGDATA/data/base/dbname/ directory cooked files? Can I copy or ftp them to other machine running PostgreSQL without export/import (pg_dump)? No. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e

Re: [GENERAL] using result as part of regular expression

larry a price writes: SELECT table1.name,table2.web,table2.email WHERE table1.name LIKE upper(table2.name).'%'; ^^ trying for 'content%' || is the operator for string concatenation. -- Peter Eisentraut

Re: [GENERAL] LOs and pg_dump, restore, vacuum for 7.1

David Wall writes: Does 7.1 "natively" handle large objects in dumps, restores and vaccums? In 7.0.3 there was a contrib for LOs. Yes. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)---

Re: [GENERAL] Remove data types?

Pruner Jan writes: Is it possible to remove data type 'name'? No. I'm trying to move our IS from Sybase Anywhere to PostgreSQL and I need to create table 'name'. Ain't gonna happen. ;-( -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e

Re: [GENERAL] Support of type procedure

is still there, but it probably doesn't work anymore, nor is there a syntax that allows you to create such a thing. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 5: Have you checked our extensive

Re: [GENERAL] linux/bsd

. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] Better Features document?

tures have clearly changed over time, so it would be time to update this section. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] strange query plan

y not need to scan the entire table in the presence of an index, but unfortunately this doesn't work yet. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 2: you can get off all lis

Re: [GENERAL] quota's ?

ittle more credit than that. ;-) -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Snapshot.base.tar.gz vs Snapshot.tar.gz

Joseph writes: What is the difference between the Snapshot.base.tar.gz vs Snapshot.tar.gz in the dev folder? I regularly get one or the other and just wondered how often I should get the BIG one. ftp://ftp.postgresql.org/pub/README.dist-split -- Peter Eisentraut [EMAIL PROTECTED

Re: [GENERAL] Database Name Case Sensitivity

, it would be pretty hard to simulate a double quote, other than by means such as psql -d '"Foo"' which is surely worse than anything we've got now. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--

Re: [GENERAL] Postgres 7.1RC1 on Solaris 7

/ahmed/config.log) and tell me the problem is, please? In configure, line 6846, can you replace the 'return 0;' by 'exit(0);'? It's a long shot, but I don't see any other possibility. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end

Re: [GENERAL] Need PostgreSQL startup scripts

ew of them official. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] problem with subselect: NOT IN

IS NOT NULL). -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] pg_hba.conf and crypt/password

d to it and compare with the crypto-gunge in pg_shadow. This is not possible. is this not what "crypt" is supposed to do? Crypt encrypts the password on the wire, not in the storage. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Pgsql-7.1RC1: SET SEED = something

to be fixed. Actually, this used to work, but for some reason it's called 'set random_seed' now. I seem to be responsible for this, although I can't imagine what the motivation might have been. Should I change it back? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e

Re: [GENERAL] Re: Patch (tiny): \cd (change dir) for psql.

to an ftp client.) -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Two tables for the price of one?

| postgres (2 rows) Both of these users probably have the same user id. See pg_shadow.usesysid column. If this installation was ever subject of a backup/restore, then this might explain things. If there are indeed duplicate user ids, dropping and recreating gmguest should work. -- Peter

Re: [GENERAL] C functions, arguments, and ssh oh my!

at(sshcmd, *uid, 255); strncat(sshcmd, " ", 255); strncat(sshcmd, *gid, 255); system(sshcmd); return 0; } You missed the part about fetching the arguments using PG_GETARG_xxx. Also you should use PG_RETURN_xxx and you need to null-terminate your string. --

Re: [GENERAL] PostgreSQL under Windows?

Christian Marschalek writes: Is it possible to compile and run PostgreSQL under Windows2000 ? Yes. See installation instructions. (Requires Cygwin.) -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast

Re: [GENERAL] New Book: PostgreSQL: The Elephant Never Forgets

L: The Elephant Never Forgets". -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Re: [HACKERS] Call for platforms AIX 4.3.3 Failed

, make sure that you don't mix different C++ compilers. You need to do 'gmake clean' at least in the libpq++ directory if you're switching. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 1

Re: [GENERAL] create user, user exists

groups has nothing to do with the authentication method used. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] URL for gmake

Bill Barnes writes: Trying to rebuild v6.5.3 and the procedure calls for gmake. A google search is a dog-chasing-tail exercise. Can anybody help with a URL or an alternative. http://www.gnu.org/software/make/ -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e

Re: [GENERAL] System Tables

overview than the one on the website (it is missing a lot of columns)? Maybe you haven't seen this:: http://www.postgresql.org/devel-corner/docs/postgres/catalogs.html If you're talking about the graph, you're right, that's pretty scarce. -- Peter Eisentraut [EMAIL PROTECTED] http

Re: [GENERAL] Fast Inserts and Hardware Questions

in drive arrays. Disabling fsync can be considered obsolete with 7.1 WAL. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] Compiling 7.1 JDBC driver

'make' and 'make install'. Running Ant directly doesn't work. Yeah, the README needs to be updated. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

[GENERAL] Re: Fast Inserts and Hardware Questions

. Indices only make sense for queries that retrieve less than about 5% of the data (with lots of other deciding factors involved). Since your application seems to be insert heavy you should try to avoid too many and too complicated indices. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org

Re: [GENERAL] table name case sensitivity

this. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] How to automatically start postmastrer with TCP/IPsupport (-i option) ???

that right? No. It discards the log output. 2) With which user shall I connect to the database? User "apache" or maybe user "nobody" ? Should I create a user 'apache' in PostgreSQL? Doesn't matter, but you have to make a user in PostgreSQL. System users are not automaticall

Re: [GENERAL] Two way encription in PG???

Boulat Khakimov writes: How do I encrypt/decrypt something in PG? Download 7.1 and use the contrib/pgcrypto module. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 2: you can get off all

Re: [GENERAL] NULL parameters abort functions

Bruce Richardson writes: I discover that if a function is passed a NULL parameter then it simply doesn't operate and a NULL value is returned. Is there *any* way round that? It makes life incredibly complicated. Upgrade to 7.1. -- Peter Eisentraut [EMAIL PROTECTED] http

Re: [GENERAL] INSERT ... RETURNING as Oracle

), the result will be uncertain. If you are worried about other transactions getting in the way then you should do SET TRANSACTION ISOLATION LEVEL SERIABLIZABLE. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast

Re: [GENERAL] PG_PWD and PG_PASSWORD Security

at the time the password is needed (during the connection attempt), the system can't read the pg_shadow table yet (because it's not connected yet, sort of). -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] System Catalog

Carlos Garcia writes: Hello, I working on your DB and I need to get some advanced data from the System Catalog. Pleace can you send me the system catalog or information. http://www.postgresql.org/devel-corner/docs/postgres/catalogs.html -- Peter Eisentraut [EMAIL PROTECTED] http

Re: [GENERAL] Errors in other languages

Luis Magaa writes: It is possible to display error messages from PostgreSQL in other languages rather than English ? No -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] pg_shadow.passwd versus pg_hba.conf password passwd

balt getting this to work with "localhost all crypt" in pg_hba.conf, but the password does not seem to be encrypted: /etc/.meta.id is plaintext of pg_shadow.passwd, and there is no obvious passwd file, so where's the crypt? On the wire. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] vacuum analyze again...

then that isn't really random, is it? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] Locking

ng inserts. No, PostgreSQL doesn't cheat. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] Re: Postgres slowdown on large table joins

but it could probably need to some work. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] Annotatable on-line documentation

;Give us words and we'll do the rest." -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] Function reference

Bruce Richardson writes: Is there a function reference for Postgresql anywhere? I can't find one in the standard documentation. http://www.postgresql.org/users-lounge/docs/7.0/postgres/functions.htm -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] misc psql questions

. Try \echo -n 'Prompt: ' \set varname `read input; echo $input` -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] Current Year

to find one. http://www.postgresql.org/users-lounge/docs/7.0/user/functions.htm -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] Regression test questions.

test create_function_1... ./run_check.sh: sql/create_function_1.sql: cannot open diff: expected/create_function_1.out: No such file or directory You didn't run 'make all' before 'make runtests'. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] Casting help

Mitch Vincent writes: if I try to cast minority to varchar (or anything else for that matter) I get ERROR: Cannot cast type 'bool' to 'varchar' Try: CASE WHEN minority THEN 'value of true' ELSE 'value if false' END -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

<    3   4   5   6   7   8   9   10   >