Am 17.10.11 10:53, schrieb Thomas Kellerer:
> Susanne Ebrecht, 17.10.2011 09:31:
>> Hello,
>>
>> I couldn't find that somebody already mentioned it.
>>
>> PostgreSQL isn't supporting CHAR(0).
>>
>> An empty string has a length of 0.
>>
>> CHAR(0) can have two values: NULL and empty string.
>>
>> In
Am 24.09.10 14:54, schrieb Robert Haas:
On Fri, Sep 24, 2010 at 8:42 AM, Andreas Pflug
wrote:
The following bug has been logged online:
Bug reference: 5675
Logged by: Andreas Pflug
Email address: pgad...@pse-consulting.de
PostgreSQL version: 8.4.4
Operating system
The following bug has been logged online:
Bug reference: 5675
Logged by: Andreas Pflug
Email address: pgad...@pse-consulting.de
PostgreSQL version: 8.4.4
Operating system: Linux 2.6.26 i686
Description:out of memory at request size 32Mb
Details:
A slony 2.0 cluster
This issue still seems unaddressed.
Andreas Pflug wrote:
> The installer claimed a non-fatal problem, cluster is up and running.
> Excerpt from install-postgresql.log
>
> Installing pl/pgsql in the template1 databases...
> psql: Warnung: berflssiges Kommandozeilenargument ¯
The installer claimed a non-fatal problem, cluster is up and running.
Excerpt from install-postgresql.log
Installing pl/pgsql in the template1 databases...
psql: Warnung: berflssiges Kommandozeilenargument ¯CREATE LANGUAGE
plpgsql;® ignoriert
psql: Warnung: berflssiges Kommandozeilenargument ¯
Guillaume Smet wrote:
> On Mon, Apr 6, 2009 at 1:37 PM, Andreas Pflug
> wrote:
>
>> IMHO this should be mentioned in the docs explicitly (I find it quite
>> surprising that data can be lost even if the system is shutdown
>> correctly), or better when shutting down
Scott Mead wrote:
>
>
>
> On Mon, Apr 6, 2009 at 7:37 AM, Andreas Pflug
> mailto:pgad...@pse-consulting.de>> wrote:
>
> Running 8.3.7, I have a warm standby configuration with a
> archive_timeout of 10min.
>
> It's obvious that there's a
Running 8.3.7, I have a warm standby configuration with a
archive_timeout of 10min.
It's obvious that there's a 10min period where data could be lost if the
master fails and the warm standby server has to take over. What's not
obvious is that this is true even if the master server is shut down
reg
Tom Lane wrote:
> "Andreas Pflug" <[EMAIL PROTECTED]> writes:
>
>> If replace is used with UTF8 client_encoding, searching for a malformed
>> string, the backend will crash.
>>
>
>
>> SELECT replace('Ärger', chr(195), '
The following bug has been logged online:
Bug reference: 3716
Logged by: Andreas Pflug
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux,Windows
Description:utf8 crash with replace
Details:
If replace is used with UTF8
Dave Page wrote:
pgAdmin just uses pg_dump/pg_restore to handle the heavy lifting.
When I try to restore the backup using PGAdmin III, the log
window begins to fill up. Near the end, when it should say it's
restoring the BLOBS an error message appears stating the BLOBS
couldn't be restored.
Tomas Zerolo wrote:
hi, i am a teaching assistant in www.deu.edu.tr, in one of our db courses,
we are planning to teach from postgresql. but pgadmin's language is changing
to Turkish due to opsys regional settings. [...]
Just give pgadmin another environment:
from the command line type
Jon Keating wrote:
I have a database with the default encoding set to EUC_JP and the client
(using pgAdmin III) is set to EUC_JP as well.
pgAdmin uses Unicode (unless the DB is SQL_ASCII or MULE_INTERNAL), you
won't get happy if you change it using a SET command.
Regards,
Andreas
Tom Lane wrote:
Andreas Pflug <[EMAIL PROTECTED]> writes:
Is COPY foo TO STDOUT BINARY supposed to work?
I don't think psql will do anything particularly sane with binary copy
data, if that's what you meant.
echo "COPY foo TO STDOUT BINARY;" | psql >ba
Is COPY foo TO STDOUT BINARY supposed to work? The query will run some
time, but won't give a result.
I couldn't see any mentioning in the COPY command docs that would
prohibit use of this combination.
Tested with psql on 8.0.5 and 8.1.1.
Regards,
Andreas
---(end of
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of edward
Sent: 21 October 2005 10:40
To: pgsql-bugs@postgresql.org
Subject: [BUGS] BUG #1982: pgAdmin 1.2.2 crash when refreshing objects
The following bug has been logged online:
Bu
Bernard Simmons wrote:
The following bug has been logged online:
Bug reference: 1945
Logged by: Bernard Simmons
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1 Beta 2
Operating system: Windows 2000 Professional SP4
Description:pgAdmin Crash when adding user
THIBAULT Jean-Jacques wrote:
The following bug has been logged online:
Bug reference: 1847
Logged by: THIBAULT Jean-Jacques
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Linux (Mandrake)
Description:Error in some kind of UNION query.
De
Tom Lane wrote:
"Bobi Ivanov" <[EMAIL PROTECTED]> writes:
Thank you for your quick responce! I don't call them directly. I use pgsql
8.0.3 under
Fedora Core and I'm writing queries through pgAdminIII.
I would say then that this is a pgAdmin bug, and should be reported on
the pgAdmin mailing
"3";"12";"0";"7 days
is the result I'm getting in pgadmin.
Regards,
Andreas
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Bruce Momjian wrote:
If we don't have a way to check this, we'll regret it soon enough...
now maybe a GUC setting isn't the optimal way, but I think we need
*some* way besides ps. ps doesn't work remotely and I think there's
no simple equivalent under Windows either.
Sure, but the GUC only
John R Pierce wrote:
I would really like postgres to model the alter syntax of mysql,
which is really easy to modify table schema especially to include the
AFTER col_name part.
A) why does the order of the columns in a particular table matter at all?
If coding without caring (about portability/
Oliver Jowett wrote:
postgresbugs wrote:
The functionality provided by PGPASSWORD should not be removed unless
there is a functionality other than .pgpass, which is fine for some
uses and not for others, that will provide similar functionality. That
could be psql and pg_dump and the like accepti
Lucas Galfaso wrote:
Create a trigger using capitalized letters. Whenever you select the trigger,
the name of the trigger appears without quotes.
Fixed for 1.2.1, thanks for reporting.
Regards,
Andreas
---(end of broadcast)---
TIP 7: don't forget to
Tom Lane wrote:
"Dave Page" writes:
Tom Lane wrote:
I think the real answer is something more along the lines of
"don't run two copies of pgAdmin at once".
He might not be. pgAdmin uses a master connection (normally to
template1) and one connection to each database browsed (minus the master
conn
Tom Lane wrote:
"Dave Page" writes:
pgAdmin uses template1 by default as it is the only accessible database
that we can be sure will exist. There are 2 solutions to your problem:
1) Change your pgAdmin connection to use a different default database.
2) Select a different database to use as the t
Lucas Sultanum wrote:
I am not sure if this is a bug or I am doing something wrong. When I
execute the following command (*insert into a_cadclias values
('6542','65465','amaro','ámaro')*) on pgAdmin III Query it works pretty
well, but when I try to do the same through a C# App connecting to the
Sim Zacks wrote:
PGAdmin 1.2.0 Beta 2
Multi-line functions in plpythonu do not work when created using
pgadmin. The function is created but when it is run for the first time
an error of "cannot compile. syntax error on line 2" is given. The
functions have been tested and work when created with psql
Josh Berkus wrote:
The difference with currency would be the lack of a fixed conversion for
different units.For example, you can:
You're mixing up quite a lot of stuff here.
10m == 1000cm
This is just what I considered forbidden to be included in that "unit-ed
type" in my previous mail. c = c
Kouber Saparev wrote:
This sounds a lot like FAQ item 3.2 on
http://pginstaller.projects.postgresql.org/FAQ_windows.html. Check those
instructions as a first step.
Maybe you're right that there's something installed on my computer that's
bugging the postmaster. The only networking tool that I have
Karel Zak wrote:
On Mon, 2004-09-20 at 08:36 +, Andreas Pflug wrote:
Karel Zak wrote:
On Sun, 2004-09-19 at 15:29 -0400, Tom Lane wrote:
I want to rewrite it for 8.1 as numeric based datetype with some
formatting extension probably with some internal stuff from to_char()
familly.
How about a
Karel Zak wrote:
On Sun, 2004-09-19 at 15:29 -0400, Tom Lane wrote:
I want to rewrite it for 8.1 as numeric based datetype with some
formatting extension probably with some internal stuff from to_char()
familly.
How about a type that is also able to hold an ISO currency identifier?
After a long p
Julinho wrote:
I would like to sugest a control panel ou icontray interface to postgre
like service manager in MSSQL (icontray) or the Firebird Server manager
(control panel).
It would be very nice to control de service!
I never understood what that tray icon should be good for (beyond
filling u
Bruce Momjian wrote:
Andreas Pflug wrote:
Bruce Momjian wrote:
Andreas Pflug wrote:
Bruce Momjian wrote:
This has been corrected in current CVS.
But it still fails for tables in tablespaces. That's why I posted all
new functions a while ago.
Yes, you posted the functions, but I
Bruce Momjian wrote:
Andreas Pflug wrote:
Bruce Momjian wrote:
This has been corrected in current CVS.
But it still fails for tables in tablespaces. That's why I posted all
new functions a while ago.
Yes, you posted the functions, but I don't understand how to integrate
that into dbsi
Bruce Momjian wrote:
This has been corrected in current CVS.
But it still fails for tables in tablespaces. That's why I posted all
new functions a while ago.
Regards,
Andreas
---(end of broadcast)---
TIP 7: don't forget to increase your free space
Peter Eisentraut wrote:
10006226 wrote:
I installed version 8 software using msi pack and created postgres
user and one other.
On opening pgAdmin login form - couldn't overtype User-name postgres
and clicked form close icon (Red X).
MsgBox said "An error has occurred. Couldn't create a connection
d
Andras Kutrovics wrote:
LOG: select() failed in statistics collector: An operation was
attempted on something that is not a socket.
What's your operating system platform?
Regards,
Andreas
---(end of broadcast)---
TIP 7: don't forget to increase your
Nathan Daniels wrote:
I am running the Win32 build installed of the msi installer on a Win2K box.
After installing the database, I created a new database named 'FPMain' and a
new table named 'Trusted' with one column also named 'Trusted' of
varchar[100] NOT NULL. When I went to edit the table, the
Fabien COELHO wrote:
contrib/dbsize> make
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations -fpic -I. -I../../src/include -D_GNU_SOURCE -c -o
dbsize.o dbsize.c
dbsize.c: In function `database_size':
dbsize.c:58: error: too few arguments to function `GetDatabasePath'
m
PostgreSQL Bugs List wrote:
The following bug has been logged online:
Bug reference: 1199
Logged by: Marko Zmak
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.5 Dev
Operating system: Windows XP
Description:pgAdmin problem
This list is for pgsql, not for pgadmin.
Tom Lane wrote:
Food for thought: in 7.4,
regression=# select ('X '::char) = ('X'::char);
?column?
--
t
(1 row)
regression=# select ('Y '::char) = ('Y'::char);
?column?
--
t
(1 row)
regression=# select ('X '::char || 'Y '::char) = ('X'::char || 'Y'::char);
?column?
Gaetano Mendola wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruno Wolff III wrote:
| On Mon, Jul 12, 2004 at 14:47:34 +0200,
| Gaetano Mendola <[EMAIL PROTECTED]> wrote:
|
|>As someone says NULL = NULL is false
|
|
| As someone else pointed out, NULL = NULL is NULL which is not TRUE.
Yes
Tom Lane wrote:
It doesn't fix views that contain references to the column. The new
typmod would need to be propagated into the view's rule parsetree, and
perhaps to the type of the view's result column if the view directly
exposes the changed column (whereupon you need to recursively look at
the
Tom Lane wrote:
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
Today after changing (with pgadmin III) the datatype of
qrydorders.docomment from varchar(255) to varchar(2500) i got the
error "variable not found in subplan target lists" [ from a view
dependent on the table ]
This is an uns
Tom Lane wrote:
Richard Neill <[EMAIL PROTECTED]> writes:
This ordering is perverse!
No kidding.
No matter what the priority is of the
different characters, I cannot understand how the above can arise.
You are assuming that it's a byte-at-a-time process. It's not. I
believe the
Hiroshi Saito wrote:
Hi Andreas.
I have a problem.
It is a happening within this week.
See below.
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20030922_1.jpg
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20031007_1.jpg
Tonight, let me know it if you know something though it will be examined.
Thank y
Alexandr S wrote:
Pgadmin 3.1 don t work (operations like insert rows) with columns
named in russian language (title of column in russian language). But
the same operations using PhpPgAdmin - all works very well, right.
And if replace russian title of column with equivalent in english -
all
Javier Carlos wrote:
POSTGRESQL BUG REPORT TEMPLATE
Your name : Javier Carlos Rivera
Your email address
Jim,
first of all, this is the wrong mailing list. Use pgadmin-support for
pgadmin related questions.
The binary win32 release of pgAdmin3 is unicode enabled, which requires
Windows NT, 2000 or XP, 95 and 98 are too old.
Regards,
Andreas
---(end of broadcast)-
Bupp Phillips wrote:
Could you possible have some type of variable (preferably the Transaction
ID) that can identify an individual process?
There's pg_backend_pid() for 7.4 and backend_pid() as contrib module for
earlier releases.
Regards,
Andreas
---(end of broadcast)
Kenji Sugita wrote:
Attached is compilation error messages of current CVS:
gcc -traditional-cpp -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include -c -o pqcomm.o pqcomm.c
pqcomm.c: In function `StreamServerPort':
pqcomm.c:280: parse error before '<<' token
pqcomm.c:29
sad wrote:
is it possible to define user variables in session ?
If not then is it planned to implement ?
or it is principially impossible in PosqtgreSQL
psql has variables, but in general we don't support session varibles.
You could create a temp table and put a value in there easily.
Ping-Hua Shao wrote:
> Dear:
> I try to compile the libpq library (in 7.3.4 & 7.4 beta1 src folder)
> with bcc32.mak under bcc55 and bcb6, but have some problems when linked.
> The problems are about :
> 1._pqGethostbyname
> 2._pqStrerror
> can't referenced.
There are already patches for this on
Marcus England wrote:
On Mon, 2003-08-18 at 09:29, Joe Conway wrote:
Marcus England wrote:
Again, I don't know what your definition of "most, if not all other
DBMS's" is, but a quick read through my MSSQL2000 manual indicates SQL
Server is no different from Postgres in this regard. Sa
Tom Lane wrote:
Hm. The postmaster is sending back 'N' indicating that it does not want
to do SSL.
Are you sure you are connecting to an SSL-enabled postmaster?
Also, is your connection by any chance IPV6? It doesn't look like it
from the tcpdump, but I'm not sure I know how to tell.
Ah, that's
Hi Tom,
reducing the traced conversation to its essence it's just a ssl-request
to a non-ssl server :-(
localhost.32822 > localhost.postgresql: 0008 04d2 162f
localhost.postgresql > localhost.32822: 4e
And no hints from serverlog.
Are there some more debugging options that I could enab
Tom Lane wrote:
Bizarre. I looked through the recent sslmode patch, and while I found
some things I didn't like, none of them explain this. Could you perhaps
get a trace of the server-to-client interaction? Either strace'ing psql
or watching the IP traffic with a packet sniffer should do --- bu
Tom Lane wrote:
Andreas Pflug <[EMAIL PROTECTED]> writes:
I currently don't have a system to reproduce this, because I didn't
succeed making my 7.4 server accepting ssl-connections. I posted for
installation help on pgsql-admin but didn't get a reaction so far. RTFM
u
Tom Lane wrote:
=?ISO-8859-1?Q?Hans-J=FCrgen?= Hay <[EMAIL PROTECTED]> writes:
The hangs happen only when I connect via network unsing psql -h
localhost template1
And the problem is gone, when ssl is switched off in postgresql.conf
We have heard a couple of reports of problems with SSL con
This problem is happening with libpq 7.4 too.
I believe we have a problem with libpq 7.3.3 with encryption. I
currently don't have a 7.3.3/ssl system running, but this has been
reported by Christian Ruediger Bahls, who traced it, and Dave Page.
When running pgAdmin3 over a ssl encrypted connect
I believe we have a problem with libpq 7.3.3 with encryption. I
currently don't have a 7.3.3/ssl system running, but this has been
reported by Christian Ruediger Bahls, who traced it, and Dave Page.
When running pgAdmin3 over a ssl encrypted connection, it will hang,
even for very small queries
62 matches
Mail list logo
