> \dtv *.*
> for all tables and views in all schemas. (Unfortunately, you are then
> stuck with noise from pg_catalog and information_schema.)
Thanks for the clarification!
(Truly sorry for the spam, you guys are great!)
Ben
| Type | Owner
+---+--+---
back | some_table_id_seq | sequence | benmorgan
front | another | table| benmorgan
front | another_id_seq| sequence | benmorgan
front | some_table| view | benmorgan
(4
The following bug has been logged online:
Bug reference: 6065
Logged by: Ben
Email address: bwtes...@yahoo.com
PostgreSQL version: 9.0.4
Operating system: üLinux version 2.6.21-uc0 on ARM processor
(NXP-LPC2478)
Description:FATAL: lock 0 not held
Details:
while
ld be preferred since it is the
more flexible option.
perhaps this is already possible but i just haven't managed to find
it. any help appreciated.
thanks,
ben...
On Aug 21, 2007, at 7:53 PM, Randolf Richardson wrote:
The following bug has been logged online:
Bug reference: 3563
neither does he use the tab-completion), but would
rather Apple fixed it because his GIS software suite is very based on using
Apple OSX frameworks where they exist.
cheers
Ben
On 15/04/2010, at 12:13 , Tom Lane wrote:
> I wrote:
>> It's fairly easy to reproduce in the regre
27;re installed. See:
I have the developer tools installed - but I think only because I needed them
installed to install something ages ago.
cheers
Ben
--
Ben Madin
AusVet Animal Health Services
P.O. Box 5467
Broome WA 6725
Australia
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
The following bug has been logged online:
Bug reference: 5418
Logged by: Ben Madin
Email address: b...@ausvet.com.au
PostgreSQL version: 8.4.3
Operating system: Mac OS X 10.6.3
Description:psql exits after using tab-completion with error message
Details:
G
On Feb 21, 2010, at 4:28 AM, Robert Haas wrote:
> On Wed, Feb 17, 2010 at 1:06 PM, Ben Chobot wrote:
>> -> Hash (cost=153.63..153.63 rows=2178408 width=4) (actual
>> time=0.207..0.207 rows=1 loops=1)
>> -> Nested Loop (cost=4.58..
I have a query which performs much better on 8.1.19 than on 8.4.2, unless I add
"offset 0" to the subqueries. I believe this is due to miscalculating the
expected row count of nest loop joins. I cannot give you my data, but I can
give you the query and the plans. Let me know if anything else wou
Thanks Tom,
I hadn't tried double-quoting, which worked fine. I'm only so well
acquainted with SQL and had only tried single quotes and backticks.
So, there is a way, and I'm satisfied with it. "Bug" retracted - thanks!
-Ben
On Mon, Jan 4, 2010 at 1:30 PM, Tom La
;re taking.
On Mon, Jan 4, 2010 at 5:36 AM, Peter Eisentraut wrote:
> On mån, 2010-01-04 at 03:48 +, Ben Woosley wrote:
> > However, unique and foreign key constraints added using the "alter
> > table add
> > constraint" syntax fail on the column name. At this p
The following bug has been logged online:
Bug reference: 5258
Logged by: Ben Woosley
Email address: ben.woos...@gmail.com
PostgreSQL version: 8.4.2
Operating system: Mac OS 10.6
Description:Unique and foreign key constraints fail on columns with
reserved names, but
http://www.postgresql.org/about/news.1013
Amen.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Fri Nov 09, 2007 at 16:53:08 +0100, Peter Eisentraut wrote:
>Am Freitag, 9. November 2007 schrieb Ben Leslie:
>> # select xmlpi(name "xml-stylesheet");
>> ERROR: invalid XML processing instruction
>> DETAIL: XML processing instruction target name cannot start w
The following bug has been logged online:
Bug reference: 3734
Logged by: Ben Leslie
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3 beta2
Operating system: Mac OS X
Description:Invalid XML schema output.
Details:
database_to_xml_and_xmlschema creates an
The following bug has been logged online:
Bug reference: 3735
Logged by: Ben Leslie
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3 beta 2
Operating system: Mac OS X
Description:Can't create xml-stylesheet processing instruction
Details:
# select
Thanks. We upgraded the server.
On Fri, 31 Aug 2007, Alvaro Herrera wrote:
Ben Kim wrote:
The following bug has been logged online:
Bug reference: 3591
Logged by: Ben Kim
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: Solaris 8
Description
The following bug has been logged online:
Bug reference: 3591
Logged by: Ben Kim
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: Solaris 8
Description:autovacuum crash
Details:
The server crashed suddenly the second time since two days
The following bug has been logged online:
Bug reference: 2163
Logged by: ben
Email address: [EMAIL PROTECTED]
PostgreSQL version: na
Operating system: all
Description:feature req: create schema with tablespace foo
Details:
request for support of default tablespace
The following bug has been logged online:
Bug reference: 2114
Logged by: Ben Gould
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: Mac OS X 10.4.3
Description:(patch) COPY FROM ... end of copy marker corrupt
Details:
With a table like
On Thu, 04 Sep 2003, Tom Lane wrote:
> Ben Grimm <[EMAIL PROTECTED]> writes:
> > I haven't tried the 7.4 beta, so it may be fixed there - but in
> > 7.3.4, pg_dumpall doesn't output global database ACL's.
>
> This is fixed for 7.4.
Is there a patch to
On Mon, 08 Sep 2003, Tom Lane wrote:
> Ben Grimm <[EMAIL PROTECTED]> writes:
> > On Thu, 04 Sep 2003, Tom Lane wrote:
> >> Ben Grimm <[EMAIL PROTECTED]> writes:
> >>> I haven't tried the 7.4 beta, so it may be fixed there - but in
> >>
users
that own the schemas.
On Thu, 04 Sep 2003, Ben Grimm wrote:
> I haven't tried the 7.4 beta, so it may be fixed there - but in
> 7.3.4, pg_dumpall doesn't generate the commands to create schemas
> in the right order. This bug may have been reported before, but
> I saw
I haven't tried the 7.4 beta, so it may be fixed there - but in
7.3.4, pg_dumpall doesn't generate the commands to create schemas
in the right order. This bug may have been reported before, but
I saw no response to it in the lists.
Try this in a fresh database after an initdb:
template1=# cr
I haven't tried the 7.4 beta, so it may be fixed there - but in
7.3.4, pg_dumpall doesn't output global database ACL's. Try this
in a fresh database after an initdb:
template1=# create user test nocreatedb nocreateuser;
CREATE USER
template1=# create database testdb;
CREATE DATABASE
template1=#
was being
executed twice in the /sbin/rc3.d directory, and this was causing the socket
file to get deleted. It wasn't a cron job.
Ben Kinsey
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 24, 2003 11:04 AM
To: Giles Lean
Cc: [EMAIL PROTECTED]; [
On Fri, 15 Mar 2002, Tom Lane wrote:
> "'Ben Grimm'" <[EMAIL PROTECTED]> writes:
> > When these bugs are fixed there is still the issue of bug #3 that I
> > came across. The one that I work around by resetting log_cnt to 0 when a
> > backend in
now that's
worked around by my 'reset_logcnt' flag in the patch, but I know that it
may not be an ideal solution. But, since sequences are just tuples like
everything else I don't see an obvious way to prevent it.
-- Ben
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
ence fall back
to its initial state. The XLogInserts that occur from the table
inserts must not happen in the same xact as the nextval's
XLogInserts. I can demonstrate the behavior quite easilly, and
Bruce posted results that confirmed it.
-- Ben
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
esses a sequence for the first time.
That's probably overkill... But I still believe that the XLogFlush
after XLogInsert is necessary to ensure that the WAL value is written
to disk immediately. In my testing this patch works fine, YMMV.
-- Ben
*** src/backend/commands/sequence.c.orig
cycle ...
I haven't been able to reproduce that, even checkpointing multiple
times on several open backends. But I also found a couple mistakes
in my patch that make it a little better. I can forward the new
patch if you'd like to see it.
-- Ben
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
truct to say whether its been logged yet - this seems like overkill..
but it works for me :-) (at least in the scenarios I've tried)
-- Ben
*** src/backend/commands/sequence.c Wed Mar 13 11:14:42 2002
--- src/backend/commands/sequence.c.origTue Mar 12 18:58:55 2002
***
: /usr/bin/psql: undefined symbol:
pg_encoding_to_char
createdb: database
creation failed
--
Ben Trout III, CNE
ICQ#19524206
mailto:[EMAIL PROTECTED]
I am having a hard time using pgaccess on LinuxPPC. I installed the 7.0.2
RPMs and have sucsessfully created new users and databases. However, when
trying to open a database, create or view tables in pgaccess, I get the
following error window:
ERROR: getattproperties: no attribute tupl
34 matches
Mail list logo
