The following bug has been logged on the website:
Bug reference: 6428
Logged by: Keith
Email address: ke...@omniti.com
PostgreSQL version: 9.1.2
Operating system: Any
Description:
Working on a tool that iterates through the pg_restore -l list for doing
more advanced
The following bug has been logged on the website:
Bug reference: 6581
Logged by: Keith Fiske
Email address: ke...@omniti.com
PostgreSQL version: 9.1.3
Operating system: Any
Description:
Using the --no-tablespaces option for pg_dumpall correctly stops tablespace
The following bug has been logged on the website:
Bug reference: 7716
Logged by: Keith Fiske
Email address: ke...@omniti.com
PostgreSQL version: 9.2.1
Operating system: Any
Description:
This is documented in the DROP TRIGGER section of the documentation, but it
The following bug has been logged on the website:
Bug reference: 7923
Logged by: Keith Fiske
Email address: ke...@omniti.com
PostgreSQL version: 9.2.3
Operating system: Debian/Ubuntu/Solaris
Description:
Running into an issue when we tried to add a password to a gpg
The following bug has been logged online:
Bug reference: 4854
Logged by: Keith Pierno
Email address: kpie...@lulu.com
PostgreSQL version: 8.3.6
Operating system: Red Hat Enterprise Linux AS release 4 (Nahant Update 6)
PPC64
Description:Problems with replaying WAL
have been able to recover without them. If it helps
I can send a copy of the WAL files and my postgres.conf files.
Keith
Tom Lane wrote:
"Keith Pierno" writes:
2009-06-15 13:25:12 EDT <::> PANIC: unexpected timeline ID 6 (after 4) in
checkpoint record
database from this afternoon and this seems to be working
fine. I am just worried that another WAL file will throw the same error
and I will be without a warm standby.
Thanks again,
Keith
Tom Lane wrote:
Keith Pierno writes:
Thanks for the prompt response. If such a file is needed for
pgwalarchives]#
Keith
Tom Lane wrote:
Keith Pierno writes:
I was able to find the file, which was from the date of the failure
(Tuesday June 9th). My question is why the backup from this morning
would all of a sudden require a file from the 9th even though 5 hours
of logs were able to be
n 16 08:46 archive_status
-rw--- 1 postgres postgres 16777216 Jun 9 13:45 xlogtemp.17243
-rw--- 1 postgres postgres 16777216 Jun 9 13:45 xlogtemp.17244
-rw--- 1 postgres postgres 16777216 Jun 9 13:52 xlogtemp.17397
[postg...@db01pri ~]$
Thanks again,
Keith
Tom Lane wrote:
Ke
The following bug has been logged online:
Bug reference: 5032
Logged by: Keith Cascio
Email address: ke...@cs.ucla.edu
PostgreSQL version: 8.4.0
Operating system: CentOS 5.3 (Linux)
Description:unexpected syntax error for plpgsql function returns
table
Details:
Do
g to me. Please comment on the fact that the following code succeeds:
create function reproduce() returns table(foo integer) language plpgsql as
'begin return query select 1 bar; end;';
Output in psql is:
CREATE FUNCTION
Why should it succeed with "bar" but not with "foo&q
Pavel,
On Thu, 3 Sep 2009, Pavel Stehule wrote:
> 2009/9/3 Keith Cascio :
> > Why should it succeed with "bar" but not with "foo"?
>
> because bar isn't declared as variable
I understand now. returns table(v1 t1, v2 t2,...) is equivalent to declaring
O
dialog
starts "Passwords may not conain quotes..." missing the "t" in contain.
Keith
The following bug has been logged online:
Bug reference: 3644
Logged by: keith atkinson
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: windows xp pro
Description:website no showing playlist for radio
Details:
i recently updated my
The following bug has been logged online:
Bug reference: 4041
Logged by: keith chan
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3
Operating system: Windows XP with SP2
Description:error in Application Stack Builder
Details:
I did followings
1. click
Hi,
I recently installed 7.3.4 (complete install from scratch) and both 'select
nextval('my_seq') from my_table' and 'select currval('my_seq') from my_table'
return a number of rows equal to the number of rows in the table.
The sequence was created with a SERIAL type if that helps.
In 'psql'
The following bug has been logged online:
Bug reference: 1366
Logged by: keith berrington
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: not applicable
Description:spam from yourselves
Details:
I have been trying unsuccessfully for over
ld be addressed as a bug.
Thanks for your help,
Keith Browne
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
lishes the connection to the database.
It would appear that psql is doing something right here which we have
had to go out of our way to get with psycopg.
Keith Browne
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
ll fix the complaint or not.
It sounds like this could work for us, if it would disable sequential
searches into a table which grows from 0 to >60,000 rows in one session.
Is breaking and re-establishing the database session the best
workaround, or is there a better way to provide a hint
The following bug has been logged online:
Bug reference: 1913
Logged by: Keith Randall
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1beta2
Operating system: Linux 2.4.21-15 Redhat enterprise
Description:select into a table missing a row part 2
Details
The following bug has been logged online:
Bug reference: 1912
Logged by: Keith Randall
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1beta2
Operating system: Linux 2.4.21-15 Redhat enterprise
Description:select into a table missing a row
Details:
I&#
The following bug has been logged online:
Bug reference: 2072
Logged by: Keith Randall
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: Linux
Description:CPPFLAGS clobbered
Details:
In src/template/linux the
CPPFLAGS="-D_GNU_S
The following bug has been logged online:
Bug reference: 6264
Logged by: Keith Fiske
Email address: ke...@omniti.com
PostgreSQL version: 9.1.1
Operating system: Debian
Description:Superuser does not have inherent Replication permission
Details:
Was testing out an
On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane wrote:
> "Keith Fiske" writes:
>> The documentation says replication is inherent to a superuser.
>
> What it actually says is that superusers get the replication privilege
> by default --- but you can create a superuser w
to the
database.
postgres=# \c dbname
WARNING: invalid value for parameter "default_tablespace": "alldata1"
DETAIL: Tablespace "alldata1" does not exist.
You are now connected to database "dbname" as user "postgres".
dbname=#
Again, easily fixed wi
On Fri, Nov 30, 2012 at 7:02 PM, Jeff Davis wrote:
> On Fri, 2012-11-30 at 23:41 +, ke...@omniti.com wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 7716
>> Logged by: Keith Fiske
>> Email address: ke...
I can.
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 3:50 PM
To: Chan, Keith (LESA IT)
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4041: error in Application Stack Builder
On Mon, Mar 17, 2008 at 10:15 PM, keith chan <[EM
Can you tell me what I need to enter at HTTP proxy and Port, FTP proxy
and Port?
Thanks
Keith
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 1:28 AM
To: Chan, Keith (LESA IT)
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4041: error
on so troublesome for the version.
Thanks
Keith
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 12:12 PM
To: Chan, Keith (LESA IT)
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4041: error in Application Stack Builder
On Tue, Mar 18, 2008 at
30 matches
Mail list logo
