[BUGS] BUG #7923: PGP secret key with password decryption not working

2013-03-06 Thread keith
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

[BUGS] BUG #7716: Only owner can drop trigger?

2012-11-30 Thread keith
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

Re: [BUGS] BUG #7716: Only owner can drop trigger?

2012-11-30 Thread Keith Fiske
On Fri, Nov 30, 2012 at 7:02 PM, Jeff Davis pg...@j-davis.com 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...@omniti.com PostgreSQL version

[BUGS] BUG #6581: pg_dumpall --no-tablespaces option still sets default tablespace

2012-04-11 Thread keith
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

Re: [BUGS] BUG #6581: pg_dumpall --no-tablespaces option still sets default tablespace

2012-04-11 Thread Keith Fiske
not exist. You are now connected to database dbname as user postgres. dbname=# Again, easily fixed with running another ALTER after the database is up and running. But figured I'd report it. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. 443.325.1357 x251 -- Sent via pgsql

[BUGS] BUG #6428: pg_restore -l not consistent with function comments

2012-02-01 Thread keith
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

Re: [BUGS] BUG #6264: Superuser does not have inherent Replication permission

2011-10-24 Thread Keith Fiske
On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane t...@sss.pgh.pa.us wrote: Keith Fiske ke...@omniti.com 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 without

[BUGS] BUG #6264: Superuser does not have inherent Replication permission

2011-10-21 Thread Keith Fiske
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

Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-03 Thread Keith Cascio
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? Thanks, Keith 2009/9/3 Keith Cascio ke

Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-03 Thread Keith Cascio
Pavel, On Thu, 3 Sep 2009, Pavel Stehule wrote: 2009/9/3 Keith Cascio ke...@cs.ucla.edu: 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 OUT parameters, therefore foo

[BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-02 Thread Keith Cascio
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

Re: [BUGS] BUG #4854: Problems with replaying WAL files on Warm Standby

2009-06-16 Thread Keith Pierno
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

[BUGS] BUG #4854: Problems with replaying WAL files on Warm Standby

2009-06-15 Thread Keith Pierno
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

Re: [BUGS] BUG #4854: Problems with replaying WAL files on Warm Standby

2009-06-15 Thread Keith Pierno
and 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" kpie...@lulu.com writes: 2009-06-15 13:25:12 EDT :: PANIC: unexpected timeline ID 6 (after 4) in checkpoint record

Re: [BUGS] BUG #4854: Problems with replaying WAL files on Warm Standby

2009-06-15 Thread Keith Pierno
the 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 kpie...@lulu.com writes: Thanks for the prompt response

Re: [BUGS] BUG #4854: Problems with replaying WAL files on Warm Standby

2009-06-15 Thread Keith Pierno
pgwalarchives]# Keith Tom Lane wrote: Keith Pierno kpie...@lulu.com 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

Re: [BUGS] BUG #4041: error in Application Stack Builder

2008-03-18 Thread Chan, Keith (LESA IT)
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

Re: [BUGS] BUG #4041: error in Application Stack Builder

2008-03-18 Thread Chan, Keith (LESA IT)
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 3:52

[BUGS] BUG #4041: error in Application Stack Builder

2008-03-17 Thread keith chan
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

Re: [BUGS] BUG #4041: error in Application Stack Builder

2008-03-17 Thread Chan, Keith (LESA IT)
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 [EMAIL

[BUGS] BUG #3644: website no showing playlist for radio

2007-09-29 Thread keith atkinson
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

[BUGS] Spelling error in 8.1.6-1 Windows Error Dialog typo

2007-02-25 Thread Keith Turner
dialog starts Passwords may not conain quotes... missing the t in contain. Keith

[BUGS] BUG #1913: select into a table missing a row part 2

2005-09-27 Thread Keith Randall
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

[BUGS] BUG #1912: select into a table missing a row

2005-09-27 Thread Keith Randall
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'm

Re: [BUGS] BUG #1552: massive performance hit between 7.4 and 8.0.1

2005-03-23 Thread Keith Browne
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

[BUGS] BUG #1366: spam from yourselves

2004-12-29 Thread keith berrington
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

[BUGS] currval and nextval in 7.3.4

2003-10-23 Thread Keith Marr
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'