Am Freitag, 19. Mai 2006 02:35 schrieb Robert Treat:
On Thursday 18 May 2006 12:38, Josh Berkus wrote:
Personally, I'd go after MSSQL before I bothered with MySQL. Sure,
let's make *migration* easier for those who wake up and smell the BS, but
migration can (and probably should) be
Am Mittwoch, 10. Mai 2006 22:23 schrieb Mark Dilger:
Martijn van Oosterhout wrote:
On Wed, May 10, 2006 at 09:41:46AM +0200, Mario Weilguni wrote:
Could we make BEGIN fail when we already are in a transaction?
...
Or if you really want to screw things up, you could require COMMIT; COMMIT;
Hi,
I don't have win32-headers here, but as far as I remember the headers
(re-)#define many calls. getaddrinfo might be getaddrinfoA or something. When
you don't use the headers and try to link with the name getaddrinfo, it is
not found.
The options are either look, what name is actually used
Am Samstag, 29. Januar 2005 23:32 schrieb Marc G. Fournier:
On Wed, 26 Jan 2005, Christopher Browne wrote:
Actually, the latter isn't so.
If Mammoth or Pervasive or such release their own release of
PostgreSQL, nothing has historically mandated that they make that
release available
Hi,
I just read about this IBM-patent-issue at www.heise.de. IBM grants this
patens to all projects, which follow one of the licenses, which are approved
by the open-source-initiative. And the BSD-license is as far as I see
approved (I found New BSD license).
When releasing commercial
Hi,
in linux you can change LD_LIBRARY_PATH in a running process, but it does not
help. The library-loader initializes himself at process-startup and changing
LD_LIBRARY_PATH do not change the actual path, the process is using for
dlopen.
Tommi Mäkitalo
Am Dienstag, 8. Juni 2004 19:14
...
Another thing is that it might make more sense to sort email addresses by
domain first (case insensitively of course), then by left hand side (case
sensitively). Since the domain is really the most significant bit. This
is also convenient for many systems like email since they perform
Hi,
2) (using information schema ... little better)
SELECT table_name FROM information_schema.tables WHERE table_schema
= 'public';
or ...
...
I just looked at the information_schema. It is a very nice feature, but
difficult to use in psql.
I just wanted to see, what I can find
Am Sonntag, 4. Januar 2004 20:13 schrieb Alex J. Avriette:
On Sat, Jan 03, 2004 at 08:25:21PM -0500, Bruce Momjian wrote:
I finally figure it out, I just end up forgetting again later. I still
...
/functions
/databases
...
Long options sounds really good. It is like GNU-tools. A single -
...
Does anyone have a comparison of how many lines of code were added in
this release compared to previous?
7.2.4: 456204 lines of code in 1021 files
7.3.4: 480491 lines of code in 1012 files
7.4: 554567 lines of code in 1128 files (boah!)
I used a fresh extracted source-directory and
Hi,
in doc/man1/psql.1 there is a line:
Welcome to psql 7.4beta5, the PostgreSQL interactive terminal.
Tommi
Am Montag, 17. November 2003 02:23 schrieb Marc G. Fournier:
'k, I just moved the release into the /pub/source/v7.4 directory from the
v7.4beta one ... RC2 is still in place, so that I
Hi,
7.4beta4 is still mentioned in INSTALL.
Tommi
Am Mittwoch, 22. Oktober 2003 16:21 schrieb Marc G. Fournier:
'K, I packaged it up last night so that the ftp mirrors could get up to
date on it ... I'm going to put out an announce to -general and -announce
on this later this evening, but
Hi,
I installed 7.4beta5, created a data-dir and tried to start postgresql with
pg_ctl without initdb. As expected, this will fail. But pg_ctl tells me
postmaster successfully started, after a fatal error, which looks very
confusing. When I use -l for specifying a logfile, I don't even see the
Hi,
I just checked out the current CVS-version and everything is fine now on my
SuSE 8.2-box.
I set tcpip_socket in postgresql.conf to true and was able to connect to
localhost and 127.0.0.1. I added my local IPv4-netaddress to pg_hba.conf and
was able to connect to my networkadress.
Thank
Hi,
Am Mittwoch, 3. September 2003 20:16 schrieb Bruce Momjian:
...
As for the IPv6 issue --- how prevalent is this problem. What OS
versions are affected? Has the user done something special to enable
this?
I have a SuSE 8.2 out of the box. I have done nothing with IPv6. I don't even
Am Dienstag, 2. September 2003 17:24 schrieb Andrew Dunstan:
*nod* but it would be nicer if all loopback interfaces worked by default
- hence my localhost suggestion, which would match any of
127.0.0.1/32
:::127.0.0.1/128 and
::1/128
cheers
andrew
...
That sounds good. Is it
Am Dienstag, 2. September 2003 02:30 schrieb Andrew Dunstan:
Quick fix is probably to turn IPv6 off in the kernel unless it's needed
- on my RH box that is as simple as removing a line from
/etc/sysconfig/network and rebooting
Quick fix is to put the right IPv6-adresses into pg_hba.conf,
Hi,
the patch did not help.
Maybe it would help dumping all pg_hba.conf-etries after generation of
IPv6-adresses.
But there is another problem, which is related. I get a logentry:
LOG: could not bind IPv4 socket: Die Adresse wird bereits verwendet
Sorry - I have errormessages in german - I
Hi,
I doublechecked, that the patch applied. And there is a change. It workes for
connections from remote or to the ethernet-address, but not to localhost:
[EMAIL PROTECTED]:~ export PGHOST=localhost
[EMAIL PROTECTED]:~ psql -l
psql: FATAL: no pg_hba.conf entry for host ::1, user postgres,
On the results page they list kernels like linux-2.4.18-1tier or
linux-2.4.19-rc2 or redhat-stock-2.4.7-10cmp. This sounds really like
linux-kernel-versions.
Am Montag, 3. März 2003 13:41 schrieb [EMAIL PROTECTED]:
OSDL has just come out with a set of open-source database benchmarks:
Am Donnerstag, 5. Dezember 2002 05:22 schrieb Lamar Owen:
[cc: list trimmed]
On Wednesday 04 December 2002 22:52, Philip Warner wrote:
At 05:48 PM 4/12/2002 -0800, Christopher Kings-Lynne wrote:
Lack of marketing is one of Postgres's major problems.
What are the consequences of the
Hi,
I thought MySQL is marked as obsolete since PostgreSQL 7.3 ;-)
Tommi
Am Mittwoch, 4. Dezember 2002 03:55 schrieb Christopher Kings-Lynne:
Not that anyone cares, but I notice in the commit logs for MySQL 4.1, it
now has subselects.
Chris
---(end of
Am Sonntag, 1. Dezember 2002 06:47 schrieb Tom Lane:
Joe Conway [EMAIL PROTECTED] writes:
Someone asked earlier about how to change a bunch of existing tables int
the PUBLIC schema to some other schema. For grins I tried:
regression=# update pg_class set relnamespace=556829 where relname =
Or just reorg.
Am Mittwoch, 27. November 2002 15:02 schrieb Nicolai Tufar:
I always wandered if VACUUM is the right name for the porcess. Now, when
PostgreSQL
is actively challenging in Enterprise space, it might be a good idea to
give it a more
enterprise-like name. Try to think how it is
Am Mittwoch, 13. November 2002 07:22 schrieb Ross J. Reedstrom:
Hey Hackers -
...
CREATE VIEW current_modules AS
SELECT * FROM modules m
WHERE module_ident =
(SELECT max(module_ident) FROM modules
WHERE m.moduleid =
Hi,
I just discovered, that there is missing a const when passing a buffer to
PQescapeBytea and PQunescapeBytea. I fixed it and tried to create a usable
diff (I'm not so familar to diff).
Tommi
*** postgresql-7.3b3/src/interfaces/libpq/fe-exec.c 2002-09-04 22:31:47.0 +0200
---
Hi,
my other problems in PQescapeBytea disappeared. I can't find them any more.
I did some testing and all is fine.
Tommi
Am Sonntag, 3. November 2002 15:50 schrieb Bruce Momjian:
Tommi Mäkitalo wrote:
Hi,
not really. I can cast it away. Ugly, but it works.
But I think it isn't
Hi,
I just installed 7.3b3 on my server (SuSE linux 8.1 on x86 with gcc 3.2) and
discovered a problem with tabcompletition in pgsql. It doesn't work with
schema. I created a schema 's' and a table 'tab' in this schema. When typing
'select * from s.' followed by tab nothing happens. A second
28 matches
Mail list logo
