Re: [GENERAL] one to many

2004-05-16 Thread Peter Eisentraut
Dennis Gearon wrote: How do I set up a one to many relationship in Postgres, (any DB for that matter.) Read about foreign keys: http://www.postgresql.org/docs/7.4/static/ddl-constraints.html#DDL-CONSTRAINTS-FK ---(end of broadcast)--- TIP 7:

Re: [GENERAL] Domains with constraints?

2004-05-16 Thread Peter Eisentraut
Dennis Gearon wrote: I have an older manual. Here are newer ones: http://www.postgresql.org/docs/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Upgrade from 7.3.4 to 7.4.2 went wrong

2004-05-16 Thread Peter Eisentraut
Robert Fitzpatrick wrote: I get this error after doing the upgrade on FreeBSD 5.2.1: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.2 Should I just re-initdb and the import my dump file? Yes. ---(end of

Re: [GENERAL] disallowing multiple NULLs in a unique constraint

2004-05-12 Thread Peter Eisentraut
Am Montag, 9. Februar 2004 06:06 schrieb David Garamond: SQL Server only allow one NULL in a unique constraint column (it's the unique index that does that, so the unique constraint behaves like that too). The question is, what is the best way to simulate that behaviour in Postgres? Can a

Re: [GENERAL] pgsql folder and its contents

2004-05-02 Thread Peter Eisentraut
Alexander Cohen wrote: I understand that, but i still really need some kind of reference on what files do what. Does anything of that sort exist? Not really. Read the man pages for the programs, use strings to see what files they might open, use ldd to see what libraries are used, delete all

Re: [GENERAL] cionnected users to server

2004-05-01 Thread Peter Eisentraut
Alexander Cohen wrote: Is there a way to get the list of connected users to a postgres server? ps ax | grep postgres: ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] users rights per table

2004-05-01 Thread Peter Eisentraut
victor wrote: I have to implement a structure of rights. I'm intrested if postgresql can restrict these operations(insert, update, select, delete) for a specified postgresql user. If this is possible, please tell me were could I find some documentation about this subject.

Re: [GENERAL] pgsql folder and its contents

2004-05-01 Thread Peter Eisentraut
Alexander Cohen wrote: Im looking to remove everyth9ing that is not absolutely necessary in the pgsql folder of my postgres server. Is there anyplace i can find information on what all the files in lib, share and bin are for? Im looking for somewhere or someone that can explain what each file

Re: [GENERAL] pg_restore problem

2004-04-27 Thread Peter Eisentraut
[EMAIL PROTECTED] wrote: pg_dumpall backup from 7.4 trying: pg_restore backup results in postgres' [Archiver]s suspicion that backup was not a valid archive. What you backup by pg_dumpall is to be restored using psql, not pg_restore. Read the man pages of pg_dump and pg_dumpall to confirm

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-27 Thread Peter Eisentraut
David Garamond wrote: Actually, what is needed is: - an exact mirror at all times; - a very simple, straightforward, and fast way to failover; done by software. http://www.drbd.org/ works well for us and can be set up quickly and from commodity parts. ---(end of

Re: [GENERAL] Unicode encoding

2004-04-27 Thread Peter Eisentraut
William Sweet wrote: support is enabled. Now, I'd like to only store Unicode chars in my PostgreSQL dbs. I hear there are 3 ways to accomplish this: 1) during PostgreSQL configure/build (installation level) 2) during initdb (cluster level) 3) CREATE DATABASE (db level) Each one of these

Re: [GENERAL] Unicode + LC_COLLATE

2004-04-23 Thread Peter Eisentraut
Am Donnerstag, 22. April 2004 16:37 schrieb Priem, Alexander: But if you use anything other than C, you can't use indexes in Like-clauses, right? No, see http://www.postgresql.org/docs/7.4/static/indexes-opclass.html. Would lc-collate=C be bad in combination with UNICODE encoding? What

Re: [GENERAL] Unicode problem ???

2004-04-22 Thread Peter Eisentraut
Am Donnerstag, 22. April 2004 09:48 schrieb Stijn Vanroye: Wouldn't it be better if I just set my client encoding to UNICODE in stead of LATIN1? I suppose the UNICODE encoding set is understood by windows (and delphi), since I write progs for a win enviroment. That really depends exclusively

Re: [GENERAL] Unicode + LC_COLLATE

2004-04-22 Thread Peter Eisentraut
Am Donnerstag, 22. April 2004 13:17 schrieb John Sidney-Woollett: Does anyone know what the effect of --lc-collate=C --encoding=UNICODE will be for sorts (and indexes?) when a multibyte unicode character is encountered? You get your strings sorted in binary order of the UTF-8 encoding, which

Re: [GENERAL] Unicode problem ???

2004-04-21 Thread Peter Eisentraut
Am Mittwoch, 21. April 2004 14:37 schrieb Priem, Alexander: I have a PostgreSQL 7.4 database running, which was initdb-ed using standard (SQL_ASCII) encoding, with -lc-collate=C option set. Everything is running fine, but I just discovered something funny. If text containing characters like ë

Re: [GENERAL] select statement sorting

2004-04-02 Thread Peter Eisentraut
Alexander Cohen wrote: i will get them back in the following order in the tuples: Alex Barbara Cohen alex But i want them back likke this: Alex alex Barbara Cohen Set your locale to something other than C. ---(end of broadcast)--- TIP

Re: [GENERAL] make check fails for 7.4.2 checked out from CVS

2004-03-11 Thread Peter Eisentraut
Tom Lane wrote: But shouldn't the minor-version bump between 7.3 and 7.4 libpq.so have prevented the dynamic linker from accepting the 7.3 libpq.so as the one to use? I thought the rule was same major version as requested, minor version = requested. Maybe, but the directory search order

Re: [GENERAL] make check fails for 7.4.2 checked out from CVS

2004-03-11 Thread Peter Eisentraut
Tom Lane wrote: On investigation, I can't find any sign that my Linux box does anything with library minor version numbers either. That seems to mean that we should be bumping the major version for every release (unless we made no externally visible changes at all, not even upward-compatible

Re: [GENERAL] Anyone has nls activated on Mac OS X?

2004-02-03 Thread Peter Eisentraut
Francois Suter wrote: I installed gettext using Fink and then gave it a go. The configure part went ok, but make complained that it couldn't find msgfmt. Either the package is split up into a run-time and a devel package, or it's just plain broken, because msgfmt certainly belongs into any

Re: [GENERAL] Where is initdb?

2004-01-26 Thread Peter Eisentraut
Jerome Lyles wrote: I have installed Postgresql 7.4 on a Suse 9.0 system using apt. I cannot do this: /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data Just run /etc/init.d/postgresql start and it will be taken care of. Read the README files in /usr/share/doc/packages/postgresql-* to

Re: [GENERAL] Where is initdb?

2004-01-26 Thread Peter Eisentraut
Jeremiah Jahn wrote: although it will be taken care of, make sure that initdb sets the local language to C or your string indexes will not be used.. Unless this has been fixed and en_US works as as well? It has been fixed. Be sure to read the documentation about details.

Re: [GENERAL] Postgress and MYSQL

2004-01-14 Thread Peter Eisentraut
Matt Davies wrote: 2. Documentation: In delving deeper into the Postgress database I have tried to find whatever I can to learn more. I have found an Oreilly book out there, but the TOC reads almost the exact same as the online documentation. I ask myself - have they lifted the documentation

Re: [GENERAL] query should use an index?

2004-01-10 Thread Peter Eisentraut
Bopolissimus Platypus wrote: create table test ( id serial primary key, t_end timestamp); there's an index: create index test_t_end on test(t_end); can or should a query like: select login,t_end from test order by t_end desc; use the index? It can, but that does not mean that

Re: [GENERAL] RedHat install question.

2004-01-09 Thread Peter Eisentraut
Am Donnerstag, 8. Januar 2004 16:32 schrieb Earnshaw, Peter J: I currently have postgresql-7.3.4-3.rh19 installed and need to compile with options: --enable-multibyte and --enable-unicode. These options do not exist in the 7.3 series. (They are the default behavior.) I also need to compile

Re: [GENERAL] release notes/Appendix E in documentation

2004-01-06 Thread Peter Eisentraut
Joshua D. Drake wrote: I think what you are really looking for is a regular summary of the hackers' activity, to know where things are moving. Someone used to do that, but I don't know what become of it. Isn't that the PostgreSQL Weekly news from Robert Treat? Yes, that's the one I meant.

Re: [GENERAL] Photos of PostgreSQL booth

2004-01-05 Thread Peter Eisentraut
Bruce Momjian wrote: Gaetano Mendola wrote: No one will be at the next fosdem ? They haven't invited us. Peter was going to check but I haven't heard back from him. I will be in attendance, but as far as I know there isn't going to be anyone holding a talk about PostgreSQL or something

Re: [GENERAL] Binaries (rpm) for SuSE 9.0...

2004-01-01 Thread Peter Eisentraut
Andreas writes: Since it is no official RPM anyway you could build it yourself as well if your server holds the necesary compilers and whatnot ... I stopped using SuSE's binaries for PG some time ago since they don't upgrade officially on newer versions and I'd rather have a clean

Re: [GENERAL] 'like' refuses to use an index???

2004-01-01 Thread Peter Eisentraut
Joseph Shraibman writes: Tom Lane wrote: BTW, 7.4 also has a specialized index opclass that can be used to create LIKE-compatible indexes even if you are using a non-C locale. Where is that documented? http://www.postgresql.org/docs/current/static/indexes-opclass.html Is it automatic for

Re: [GENERAL] Photos of PostgreSQL booth

2003-12-28 Thread Peter Eisentraut
Christian Kienle writes: Here are two pictures of the PostgreSQL booth on the Linux World Expo Conference in Frankfurt 2003. There are more photos here: http://developer.postgresql.org/~petere/past-events/lwe2003-pictures/ ---(end of

Re: [GENERAL] restore error - language plperlu is not trusted

2003-12-17 Thread Peter Eisentraut
Tom Lane wrote: Hm. The backend flat-out rejects all attempts at GRANT on untrusted languages, even if you are superuser and the grantee is too. I'm not totally sure about the rationale for that (Peter?) Why would you need it? It's only going to create fuss about useless functionality.

Re: [GENERAL] Why is postgres an ORDMS

2003-12-13 Thread Peter Eisentraut
Bruce Momjian wrote: Josué Maldonado wrote: Hello list, A friend of mine just asked me this, why is postgres an ORDBMS and what does it mean and how to apply it on real development. We are OR (object-relational) because we are extendable, unlike a typical DBMS. No, it means there are

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-10 Thread Peter Eisentraut
Bret Busby wrote: Regarding the PostgreSQL training that is provided by companies, a problem with that, as it exists, is that, insofar as I am aware, that training is not standardised, Linux training is not standardized by any measure either. Lots of companies and institutions offer their

Re: [GENERAL] Determining what a user can access

2003-12-09 Thread Peter Eisentraut
Martijn van Oosterhout wrote: I was just trying to find a query what would determine, given a username, what tables they can see and what permissions they have on those tables. Obviously this would only work for superusers, but does anyone have any ideas?

Re: [GENERAL] Is the COMMUTATOR clause required for self commutative operators?

2003-12-08 Thread Peter Eisentraut
[EMAIL PROTECTED] wrote: In the command CREATE OPERATOR name ( PROCEDURE = func_name [, LEFTARG = lefttype ] [, RIGHTARG = righttype ] [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ] [, RESTRICT = res_proc ] [, JOIN = join_proc ] [, HASHES ] [, MERGES ] [, SORT1 =

Re: [GENERAL] PostgreSQL from a newcomers perspective

2003-12-01 Thread Peter Eisentraut
connect via PHP just fine. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Feature Request for 7.5

2003-12-01 Thread Peter Eisentraut
. The library could then also be installed, but also be redistributable, so that developers could build these solutions. You might be interested in Clustered JDBC (http://c-jdbc.objectweb.org/), which implements a proxy approach but does not require knowledge of the database-specific protocol. -- Peter

Re: [GENERAL] PostgreSQL from a newcomers perspective

2003-12-01 Thread Peter Eisentraut
Unix-domain sockets. -- Peter Eisentraut [EMAIL PROTECTED] ---(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

Re: [GENERAL] perl(Pg) (S)RPM

2003-12-01 Thread Peter Eisentraut
in the SPEC file. I could not install the contrib stuff but I really want the plperl and plperlu languages. These languages are not in the -contrib package. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you

Re: [GENERAL] permission errors for set authority and schema public

2003-11-30 Thread Peter Eisentraut
CSN writes: I upgraded to 7.4 a few days ago and am getting these errors when importing dumps: permission denied to set session authority and permission denied for schema public. Not all of the dump is imported successfully. Looks like you need to restore as superuser. -- Peter Eisentraut

Re: [GENERAL] Drop Cascade of Domains

2003-11-29 Thread Peter Eisentraut
that tables with zero columns are valid, and the behavior of all commands and side effects has been aligned with that. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

Re: [GENERAL] building 7.4 with plperl

2003-11-24 Thread Peter Eisentraut
as thread-safe code. (--enable-thread-safety) */ #define USE_THREADS 1 So this seems to be the collision. Fixed in 7.4 branch and current. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through

Re: [GENERAL] Optimizing query

2003-11-19 Thread Peter Eisentraut
index arbitrarz expressions directly. The documentation contains more information about that. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [GENERAL] SuSE RPMs available for PostgreSQL 7.4

2003-11-19 Thread Peter Eisentraut
Lamar Owen writes: In the case of FreeBSD, isn't it the preference to use the ports system? The preference is to use the ports system once and then use the resulting packages the subsequent times. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] SuSE RPMs available for PostgreSQL 7.4

2003-11-19 Thread Peter Eisentraut
with this? If you manage to build RPMs for several operating systems out of one source RPM, great job. But the above still applies. The directory structure is a mirror of the SuSE FTP site. On ftp.postgresql.org? I'm only talking about ftp.postgresql.org. Yes. -- Peter Eisentraut

Re: [GENERAL] PostgreSQL v7.4 Released

2003-11-17 Thread Peter Eisentraut
Marc G. Fournier writes: And when will the coordinator learn that it is called PostgreSQL 7.4 and not PostgreSQL v7.4? Habit :) I would appreciate it if you could abandon that habit and stop making us look like losers. -- Peter Eisentraut [EMAIL PROTECTED

Re: [GENERAL] PostgreSQL v7.4 Released

2003-11-17 Thread Peter Eisentraut
of yourself, you're creating actual technical problems. I take offense at it because for years you've simply ignored all requests to do something about it. But I'm certainly not the only one who considers it odd. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] PostgreSQL v7.4 Released

2003-11-17 Thread Peter Eisentraut
Joshua D. Drake writes: Somebody please explain to me what the hell a difference it makes if we have a v in front of the version number? Packaging tools, packaging standards, convention, consistency of public presentation. -- Peter Eisentraut [EMAIL PROTECTED

Re: [GENERAL] Retoring non-administrative user databases

2003-11-16 Thread Peter Eisentraut
Keith C. Perry writes: What am I missing? A reproduceable test case. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Retoring non-administrative user databases

2003-11-16 Thread Peter Eisentraut
. A pg_dumpall dump must be restored as a superuser. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] DOMAIN usability

2003-11-15 Thread Peter Eisentraut
the constraint defs on a domain . information_schema.domain_constriants does not have the definations just the names are present. You need to join domain_constraints and check_constraints. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] Conservation of OIDs

2003-11-14 Thread Peter Eisentraut
in separate clusters, respectively, using three different directories, such as $ postmaster -D /usr/local/pgsql/data $ postmaster -D /usr/local/pgsql/qat $ postmaster -D /usr/local/pgsql/dev ... then the second and third command will fail. -- Peter Eisentraut [EMAIL PROTECTED

Re: [GENERAL] GUIDs

2003-11-13 Thread Peter Eisentraut
bytes and allows the conversion into several output formats. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Two build problems - openssl and plperl on RedHat

2003-11-10 Thread Peter Eisentraut
LD_LIBRARY_PATH. -- Peter Eisentraut [EMAIL PROTECTED] ---(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

Re: [GENERAL] Install files for version 7.4

2003-11-06 Thread Peter Eisentraut
Carlos Oliva writes: Not even for the beta version? In that case you want the file postgresql-7.4RC1.tar.gz. (or .bz2). -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Databases with different encodings

2003-11-04 Thread Peter Eisentraut
Jan Poslusny writes: Is some way to create two databases in the same database cluster with different encodings (specially utf-8 and iso 8859-2) and good sortings ? No. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4

Re: [GENERAL] PostgreSQL v7.4 Release Candidate 1

2003-11-04 Thread Peter Eisentraut
the release candidate tarball and run ./configure; make all; make check; make install on them to see whether everything works. If you have several compilers available (GCC and vendor compiler), try both. Report the results together with `uname -a` to [EMAIL PROTECTED] -- Peter Eisentraut [EMAIL

Re: [GENERAL] AS operator and subselect result names: PostgreSQL

2003-11-02 Thread Peter Eisentraut
. Because the SQL standard says so. -- Peter Eisentraut [EMAIL PROTECTED] ---(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

Re: [GENERAL] Trigger

2003-10-22 Thread Peter Eisentraut
to the database, you have a problem (that borders on unsolvable). -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Adding fields on the fly

2003-10-22 Thread Peter Eisentraut
? Number of columns? Number of tables? anything else? Adding a column runs in constant time. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Indexes and querys

2003-10-22 Thread Peter Eisentraut
in the where clause. PostgreSQL will choose to use an index when it thinks it will be faster, but this is not always the case. If you want to learn more about how indexes work or how to evaluate query performance, please read the documentation. -- Peter Eisentraut [EMAIL PROTECTED

Re: [GENERAL] Recomended FS

2003-10-20 Thread Peter Eisentraut
strong cpu ? Lots of memory, so you can cache a large fraction of the data in memory. A good hard disk, if you do a lot of updates and/or your memory is not big enough to cache most of the data. CPU is not as important. -- Peter Eisentraut [EMAIL PROTECTED] ---(end

Re: [GENERAL] constant time count(*) ?

2003-10-15 Thread Peter Eisentraut
Mark Harrison writes: Is there a way to optimize count(*) such that it does not have to do a sequential scan? No. If you need to count a lot, you need to store the information separately. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] Getting error codes for failed queries?

2003-10-15 Thread Peter Eisentraut
can't read. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [GENERAL] Getting error codes for failed queries?

2003-10-15 Thread Peter Eisentraut
translated to different languages, for instance? Yes. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] converting varchar date strings to date

2003-10-14 Thread Peter Eisentraut
pw writes: How can I typecast a date generated from VARCHAR fields into a date field Using CAST(). -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

Re: [GENERAL] How to list which tables are available?

2003-10-14 Thread Peter Eisentraut
B.W.H. van Beest writes: It seems so elementary, but how I get a list of which tables are available in a database. I can't find an SQL command for this, but there must be a way! SELECT * FROM pg_tables; -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] Pgsql on Windows

2003-10-13 Thread Peter Eisentraut
Dennis Gearon writes: How soon will 7.5 come out? (yes, I know, 7.4 is beta right now). All signs point to September 24, 2004. How difficult is it to set up cygwin? I found it quite easy. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: Domains (was Re: [GENERAL] int1?)

2003-10-09 Thread Peter Eisentraut
Ron Johnson writes: test1=# create domain d_tinyint as smallint constraint chk_tinyint CHECK (smallint between 0 and 255); ERROR: DefineDomain: CHECK Constraints not supported So, how would I create a domain that limits a smallint? You would have to wait for PostgreSQL 7.4. -- Peter

Re: [GENERAL] Call for Speakers / Presenters

2003-10-08 Thread Peter Eisentraut
, or even a single webmaster, notwithstanding the fact that there are de-facto experts in these fields. The method you are choosing might be a good way to get things done now and quickly, but it's not scalable. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] using copy to load odd characters

2003-10-07 Thread Peter Eisentraut
cannot contain null bytes. The type bytea can store arbitrary binary data. It requires you to escape null bytes so '\\000'. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [GENERAL] Call for Speakers / Presenters

2003-10-05 Thread Peter Eisentraut
Jillian Carroll writes: As your new PostgreSQL Master of Ceremonies, What? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

[GENERAL] Translators wanted for PostgreSQL

2003-10-05 Thread Peter Eisentraut
that have already done a significant amount of work, this is a call to start fixing up the remaining missing pieces in time for the 7.4 release. For those languages that still need a significant amount of work, do not worry about the 7.4 release date. There will always be a 7.4.1 release. -- Peter

Re: [GENERAL] Cannot create database

2003-10-05 Thread Peter Eisentraut
connections on Unix domain socket /tmp/.s.PGSQL.5432? createdb: database creation failed You did not start the database server. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

Re: [GENERAL] book on advanced postgresql?

2003-10-03 Thread Peter Eisentraut
to me. That is the reason why printable version are so hard to find. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Problem with lock?

2003-09-30 Thread Peter Eisentraut
or do I have to explicitly unlock the table somehow? Show us what commands you are running, in what sequence, how many sessions, etc. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] How to find LIMIT in SQL standard

2003-09-22 Thread Peter Eisentraut
you cannot use it in portable applications. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] encoding again

2003-09-09 Thread Peter Eisentraut
of us can't identify the characters or see what is wrong with them. Also, try a more recent PostgreSQL version, such as 7.3.4. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [GENERAL] C functions

2003-09-05 Thread Peter Eisentraut
examples of these kind of functions (in C or C++). contrib/tablefunc -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] About GPL and proprietary software

2003-08-31 Thread Peter Eisentraut
works with MySQL and no other database system. Are the following cases legal? That depends on whether the MySQL client library is LGPL (up to version 3) or GPL (from version 4 on). But a PostgreSQL forum is probably an entirely inappropriate place to discuss this. -- Peter Eisentraut [EMAIL

Re: [GENERAL] installing postgres7.3.4 problem

2003-08-26 Thread Peter Eisentraut
). This might light to complications if at some point you want to reinstall an RPM package for PostgreSQL. The other option is that you look for an RPM package of the PostgreSQL version you want for your distribution. -- Peter Eisentraut [EMAIL PROTECTED] ---(end

Re: [GENERAL] pg_dump and alter database

2003-08-22 Thread Peter Eisentraut
in the command CREATE DATABASE or ALTER DATABASE. But if you use pg_dump -C, then ALTER DATABASE ought to be dumped. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] plPHP -- sort of an announcement.. but not commercial

2003-08-05 Thread Peter Eisentraut
cover the most popular languages, but there should be room for serious external development. Btw., one concern I have about putting this PHP thing in the core is that it would create a circular build dependency between PostgreSQL and PHP. -- Peter Eisentraut [EMAIL PROTECTED

Re: [GENERAL] Error from Sub-Select, Simple Example.

2003-08-01 Thread Peter Eisentraut
the outer query. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] ERROR STRINGS IN PGSQL

2003-07-30 Thread Peter Eisentraut
Deepa K writes: Is proper error numbers are defined for all error strings returned by pgsql c library. No, you will have to wait for version 7.4 for that. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3

Re: [GENERAL] A creepy story about dates. How to prevent it?

2003-06-23 Thread Peter Eisentraut
the opposite setting he will not be happy either. So no one is happy. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do

Re: [GENERAL] A creepy story about dates. How to prevent it?

2003-06-20 Thread Peter Eisentraut
is not that great. A human is not going to mentally switch his preferred day/month order within the same SQL session. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

Re: [GENERAL] why are my SELECTs in transaction?

2003-06-19 Thread Peter Eisentraut
Travis Hume writes: So at this point all selects are screwed unless I issue a ROLLBACK; Why? Is there a way for SELECTs (or all SQL) statement that fail to NOT have this behaviour? You probably set autocommit to off. Turn it on. -- Peter Eisentraut [EMAIL PROTECTED

Re: [GENERAL] function given current output-row

2001-10-28 Thread Peter Eisentraut
Peter Pilsl writes: Is there a function that returns the number of the current outputline The client application is going to have to count the row numbers anyway in order to loop through them, so there is no obvious benefit of having the server deal with this. -- Peter Eisentraut [EMAIL

Re: [GENERAL] User privileges on sequences

2001-10-17 Thread Peter Eisentraut
() as well, though I don't see it in the docs offhand. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] To Postgres Devs : Wouldn't changing the select limit

2001-10-17 Thread Peter Eisentraut
than to not follow MySQL behaviour? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Blank SQL insert statements

2001-10-17 Thread Peter Eisentraut
are going to be NULL unless you specified something else when you created the table.) -- 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] creation time of a postgresql object

2001-10-14 Thread Peter Eisentraut
Emmanuel SARACCO writes: is there a way to know the creation time of a postgresql object (table, view etc.)? Not unless you store it yourself. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

Re: [GENERAL] using a plan in a c function

2001-10-14 Thread Peter Eisentraut
Emmanuel SARACCO writes: is it necessary to use plans in a c stored procedure? It's not only not necessary, it's not even possible. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5

Re: [GENERAL] Relation x does not exist error when x does exist

2001-10-12 Thread Peter Eisentraut
with that. PL/pgSQL compiles and caches the functions you are executing, so if you change the database schema under it (or in it) you lose. This is an intentional design choice. If you want to execute code dynamically you should look at the EXECUTE command in PL/pgSQL, or for some other language. -- Peter

Re: [GENERAL] Function Help

2001-09-24 Thread Peter Eisentraut
the $1. E.g., WHEN date_part(\'dow\',$1)=6 THEN date($1)+0 The $1 etc. are not macros, they are identifiers representing a typed expression. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1

Re: [GENERAL] Where are Perl DBI and DBD for PostgreSQL??

2001-09-23 Thread Peter Eisentraut
This is a different way to access PostgreSQL via Perl. This module is also include in the PostgreSQL distribution. Postgres-1.4.tar.gz This is an interface to Postgres95, not PostgreSQL. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end

Re: [GENERAL] Multibyte FAQ item

2001-09-23 Thread Peter Eisentraut
this code arbitrarily fast if it doesn't have to give the right answer. Nor do I believe these claims, btw. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list

Re: [GENERAL] creating user table

2001-09-22 Thread Peter Eisentraut
change depending on the database you're connected to. -- 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/faq.html

Re: [GENERAL] Global constants

2001-09-20 Thread Peter Eisentraut
Mihai Gheorghiu writes: Can there be anything like global constants in PG? CREATE TABLE my_constant ( val integer ); INSERT INTO my_constant VALUES ( 1024 ); -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

Re: [GENERAL] Performance question (stripped down the problem)

2001-09-19 Thread Peter Eisentraut
) with Count(*), which acts differently with respect to nulls, so it depends whether you want to use it. Besides that, I don't see anything blatantly obvious to speed this up. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

<    2   3   4   5   6   7   8   9   10   >