Hello Tom,
Thanks a lot for your reply. It was an error I made - I was doing
"pg_dump dbname | gzip -9 > dbname-archive.gz >& /dev/null". As soon as
I removed ">& /dev/null" the file was not empty any more.
However, having the pg_dump and truncate inside a transaction, and
setting the isolation l
The following bug has been logged online:
Bug reference: 3056
Logged by: Pavel Stehule
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3
Operating system: Linux
Description:strange behave of CHECK constraint
Details:
Hello,
check constraint doesn't work corr
Is it just me, or did you reverse the sense of your check. In the
first case, you select with "[^0-9]", but your constraint uses
"[0-9]" without the carrot.
On Feb 22, 2007, at 4:48 PM, Pavel Stehule wrote:
The following bug has been logged online:
Bug reference: 3056
Logged by:
Pavel Stehule wrote:
> check constraint doesn't work correct:
There is nothing incorrect happening here. I think you are confused.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: You can help support t
The following bug has been logged online:
Bug reference: 3030
Logged by: Dr. Axel Reimann
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.8
Operating system: Gentoo Linux, Kernel 2.6.19, glibc 2.5
Description:Unable to query SQL_WCHAR column via ODBC
Details:
The following bug has been logged online:
Bug reference: 3041
Logged by: Matt Smith
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.3
Operating system: Mac OS X
Description:Universal Binary Support in Configure
Details:
Hello! From what I can tell, there is
The following bug has been logged online:
Bug reference: 3033
Logged by: Luigi Tarenga
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: OpenBSD 4.0 amd64
Description:performance issue with self join
Details:
hi,
my full version is Postgr
16 feb 2007 kl. 22.00 skrev Tom Lane:
"Pelle Johansson" <[EMAIL PROTECTED]> writes:
We have a join where we select which row to join on a subquery with a
coalesce on a column from a left join, which is not working as
expected.
The attached patch should fix this.
Hi Tom,
Thanks for the q
The following bug has been logged online:
Bug reference: 3032
Logged by: Craig White
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.5
Operating system: Windows XP
Description:Commit hung for days
Details:
I'm not looking for quick answers or a fix, but I w
The following bug has been logged online:
Bug reference: 3049
Logged by: Aaron Zedonis
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Windows
Description:psql does not honor md5 in pg_hba.conf file
Details:
I have set up a server on a Lin
The following bug has been logged online:
Bug reference: 3039
Logged by: Jessica
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Solaris 10
Description:install completely but can't connect to server
Details:
The procedure of installation a
The following bug has been logged online:
Bug reference: 3054
Logged by: Tux
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.3
Operating system: HP-UX 11.00
Description:getopt_long () misbehaviour
Details:
Might be some deep down misbehaving system library,
The following bug has been logged online:
Bug reference: 3052
Logged by: brian blakey
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.3
Operating system: linux (SUSE profesional 9.3 own build)
Description:Inconsistent results from PQexec... with rules
Details
The following bug has been logged online:
Bug reference: 3046
Logged by: Cedric Scott
Email address: [EMAIL PROTECTED]
PostgreSQL version: odbc 8 2 200
Operating system: WindowsXP
Description:odbc zip file corrupt
Details:
I downloaded 4 versions of psqlodbc-8_02_20
The following bug has been logged online:
Bug reference: 3051
Logged by: Juan
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Linux CentOS 4
Description:FATAL: too many trigger records found for relation
"pg_authid"
Details:
psql: FATAL:
The following bug has been logged online:
Bug reference: 3034
Logged by: Jessica
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Unix
Description:FATAL: could not open lock file
"/tmp/.s.PGSQL.5432.lock": Permission denied
Details:
Hi the
The following bug has been logged online:
Bug reference: 3044
Logged by: Jessica
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Solaris 10
Description:what is correct configuration?
Details:
I wonder if the configuration is correct becaus
Micheal,
On Tuesday 20 February 2007 14:09, Michael Meskes wrote:
> On Mon, Feb 19, 2007 at 03:46:38PM -0500, Bruce Momjian wrote:
> > I see no one replied to this report. All I can say that many people
>
> Hmm, seems my filter didn't recognize this was about ecpg.
>
> > compile ecpg, and this is
The following bug has been logged online:
Bug reference: 3048
Logged by: Dmitry Koterov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0
Operating system: Linux
Description:pg_dump dumps intarray metadata incorrectly
Details:
Steps to reproduce:
1. create
The following bug has been logged online:
Bug reference: 3037
Logged by: Pavel Stehule
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3
Operating system: Linux
Description:strange behave of CHECK constraint
Details:
check constraint is incorect for operator
The following bug has been logged online:
Bug reference: 3040
Logged by: Dreas Nielsen
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.3
Operating system: FreeBSD
Description:Domain type handling change in 8.2.2 breaks declarations
Details:
If a domain type
The following bug has been logged online:
Bug reference: 3038
Logged by: Eli Green
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.5 - 8.?
Operating system: Linux and Windows XP
Description:information_schema.constraint_column_usage has wrong
information for
Please unsubscribe me,
Thank you
Juan wrote:
Hola Juan,
> psql: FATAL: too many trigger records found for relation "pg_authid" post
> duplicate any tables pg_* into my "test BD" using;
>
> #psql -d Test < pg_[any].sql
>
> I can delete de BD (it's only a test), but that's not idea, I need solve
> this problem.
It seems to me y
"Dreas Nielsen" <[EMAIL PROTECTED]> writes:
> CREATE DOMAIN real_value
> AS double precision
> NOT NULL;
> CREATE DOMAIN significant_digits
> AS integer
> DEFAULT 2
> NOT NULL;
> CREATE TYPE measurement_result AS
>(value real_value,
> sig_figs significant_digits,
> std_dev d
"Pavel Stehule" <[EMAIL PROTECTED]> writes:
> root=# create table products(
> barcode char(13) NOT NULL
> check (barcode NOT similar to '%[^0-9]%')
> );
> root=# insert into products values('22');
> ERROR: new row for relation "products" violates check constraint
> "products_barcode_check"
>
"Tux" <[EMAIL PROTECTED]> writes:
> Might be some deep down misbehaving system library, but on HP-UX 11.00 (not
> on 11.11, and/or 11.23) getopt_long () misbehaves in that it causes all
> command line utilities to se the program name as the first argument,
Hmm. The Single Unix Spec,
http://www.op
"Jessica" <[EMAIL PROTECTED]> writes:
> logfile:
> LOG: could not bind IPv6 socket: Cannot assign requested address
> HINT: Is another postmaster already running on port 5432? If not, wait a
> few seconds and retry.
> FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission
> denie
we have installed Linux advanced server-4 and the postgres-7.4.6.
when we execute \d command following error is displaying
ERROR: relation "pg_catalog.pg_user" does not exist
The database otherwise works correctly. I can create tables, load
data, etc.
regards
Guru
---(
"Pavel Stehule" <[EMAIL PROTECTED]> writes:
> root=# create table products(
> barcode char(13) NOT NULL
> check (barcode NOT similar to '%[^0-9]%')
> );
> root=# insert into products values('22');
> ERROR: new row for relation "products" violates check constraint
> "products_barcode_check"
[EMAIL PROTECTED] writes:
> we have installed Linux advanced server-4 and the postgres-7.4.6.
> when we execute \d command following error is displaying
> ERROR: relation "pg_catalog.pg_user" does not exist
I don't know what "Linux advanced server-4" means, but if it's RHEL4
and you've got SELinu
31 matches
Mail list logo
