The community will need more details to move forward. Please read the
following mail; it is a good guide to how to post queries to get answers and
responses quickly.
http://archives.postgresql.org/pgsql-performance/2004-06/msg00235.php
Be a better student, ask good questions :)
Good luck.
On 1
--On Donnerstag, Dezember 21, 2006 15:47:40 + Tony Marston
<[EMAIL PROTECTED]> wrote:
The fact that the SQL standard says that the schemata view is supposed to
"Identify the schemata in a catalog that are owned by a given user" does
not automatically mean that the information can *ONLY* be
Jessica wrote:
> The following bug has been logged online:
>
> Bug reference: 2854
> Logged by: Jessica
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.2
> Operating system: Solaris
> Description:can't log out database system
> Details:
>
> I log into data
Mike wrote:
> The following bug has been logged online:
>
> Bug reference: 2855
> Logged by: Mike
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.2
> Operating system: RHEL AS 4.3 x86_64
> Description:SEGV on PL/PGSQL function
> Details:
>
> (retyping this
upgrade to 8.2.0
that problem was fixed there (had it myself as well)
- thomas
- Original Message -
From: "Terry Askew" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 21, 2006 6:13 PM
Subject: [BUGS] BUG #2853: Internal error XXOO Hangs while attempting to
clear table after several
The following bug has been logged online:
Bug reference: 2853
Logged by: Terry Askew
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.5
Operating system: Windows Server 2000
Description:Internal error XXOO Hangs while attempting to clear
table after several su
Postgres continues to hang while we attempt to dump tables after several
successful dumps. Is this a memory issue. Where is the data being dumped
to.Is it being temporarily stored in some repository that can only handle so
much data before it produces an exception message.
This is critical in
I am using PostgreSql 8.1 with pgAdmin III. OS is XP. this is my
function:
CREATE OR REPLACE FUNCTION sp_get_phase(character varying, character
varying, character varying)
RETURNS ret_dv_sp_get_phase AS
$BODY$
SELECT BOOK_NO, USER_ID, COMPANY_ID, PHASE, UPDATE_USER_ID,
UPDATE_DATE
The following bug has been logged online:
Bug reference: 2854
Logged by: Jessica
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Solaris
Description:can't log out database system
Details:
I log into database system, but I don't know how to
The following bug has been logged online:
Bug reference: 2846
Logged by: Roman Kononov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0 and older
Operating system: linux 2.6.15-27-amd64 ubuntu
Description:inconsistent and confusing handling of underflows, Na
The following bug has been logged online:
Bug reference: 2847
Logged by: Sandip
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Windows XP
Description:Bug with IN statement
Details:
this is my function:
CREATE OR REPLACE FUNCTION sp_get_p
The following bug has been logged online:
Bug reference: 2855
Logged by: Mike
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: RHEL AS 4.3 x86_64
Description:SEGV on PL/PGSQL function
Details:
(retyping this by hand ... forgive any mistakes
Norman Yamada wrote:
Running postgresql 8.2.0 on Debian testing, Linux kernel 2.6.12, Dual
Xeon 2.80GHz motherboard,
gcc 4.0.3.
If I run a statement like this:
select * from [table] limit null;
it crashes the server.
thanks for the report - this is already fixed in REL8_2_STABLE and will
a
Running postgresql 8.2.0 on Debian testing, Linux kernel 2.6.12, Dual
Xeon 2.80GHz motherboard,
gcc 4.0.3.
If I run a statement like this:
select * from [table] limit null;
it crashes the server.
Under 8.1.3, limit NULL was synonymous with limit ALL. Here, the
server terminates and restart
"Tony Marston" <[EMAIL PROTECTED]> writes:
> I have the following query:
> SELECT key_column_usage.*,constraint_type
> FROM information_schema.key_column_usage
> LEFT JOIN information_schema.table_constraints USING
> (table_schema,table_name,constraint_name)
> WHERE table_schema='whatever' and
"Tony Marston" <[EMAIL PROTECTED]> writes:
> If I am logged on as a user other than 'postgres' and I try the query
> SELECT * FROM information_schema.schemata
> I get no results. Yet if I try the equivalent query
> SELECT * FROM pg_namespace
> I can see all the available schema names.
> Why is the
The following bug has been logged online:
Bug reference: 2852
Logged by: Pavel Golub
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.x
Operating system: Windows XP
Description:User-defined type name begins with the underscore
character (_) can be created
Detail
The following bug has been logged online:
Bug reference: 2851
Logged by: Gurjeet Singh
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0
Operating system: Windows XP Professional
Description:Error in documentation or in code?
Details:
The documentation at
h
On 12/21/06, Gurjeet Singh <[EMAIL PROTECTED]> wrote:
The following bug has been logged online:
Bug reference: 2849
Logged by: Gurjeet Singh
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0
Operating system: Windows
Description:Erroronous UPDATE syntax i
The following bug has been logged online:
Bug reference: 2850
Logged by: Tony Marston
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Windows XP
Description:Cannot select from information_schema.schemat
Details:
If I am logged on as a user
The following bug has been logged online:
Bug reference: 2849
Logged by: Gurjeet Singh
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0
Operating system: Windows
Description:Erroronous UPDATE syntax in documentation
Details:
The documentation at
http://w
The following bug has been logged online:
Bug reference: 2848
Logged by: Tony Marston
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Windows XP
Description:information_schema.key_column_usage does not work
Details:
I have the following qu
22 matches
Mail list logo
