poch from '2011-03-14'::date) - extract(epoch
from '2011-03-13'::date);
?column?
--
86400
(1 row)
5432 josh@josh*# select extract(epoch from '2011-03-15'::date) - extract(epoch
from '2011-03-14'::date);
?column?
--
86400
(1 row)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
me deleted,insert operation,
> mistakes occur again
You haven't actually said what the error is, or what "mistakes" you've
noticed. Without those details we can't do much to help you.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
dumped/reloaded recently? Did you manually back up or copy the table?
Alternatively, perhaps at some point you've added data to that column, rather
than relying on PostgreSQL to supply a default value.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
entifier *in = (uniqueidentifier *) PG_GETARG_POINTER(0);
if (in == NULL)
PG_RETURN_CSTRING (NULL);
...and...
CREATE OR REPLACE FUNCTION uniqueidentifier_in(cstring)
returns uniqueidentifier
as 'MODULE_PATHNAME'
language 'c';
It should use PG_ARGISNULL(0), no?
--
J
how much
updating and deleting has happened since the last vacuum, there's really no
way of guessing how vacuum-needy something might be based only on available
statistics. last_vacuum is just a nice way of verifying that [auto]vacuum
happens on the table sometimes, and influencing an administ
n my
systems, the table name in the error message would all be lowercase. In any
event, as a rule, if you're going to quote your identifiers once, you need to
quote them all the time. For that reason, many people choose to stick with all
lowercase table and column names.
[1] http://www.po
omething like dump the
schema first, and then dump data into that schema, there's little pg_dump can
do to avoid problems such as you describe.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
old us what you tried, what happend, or what you expected to happen.
Please see http://www.postgresql.org/docs/current/static/bug-reporting.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
gt; tried in Navicat but no luck.
You can't change column order without dropping and recreating the columns,
recreating the table, or something similar. Sorry.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
ug; you'd be better served addressing your
question to pgsql-gene...@postgresql.org.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
will complain if its version doesn't match the server version, but
that's neither a bug nor, in this case, a bad thing. You have pg_dump's -i
option which will squelch this message and allow pg_dump to continue.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpo
me;
> ERROR: failed to build any 3-way joins
> <
Just a guess, but I'd bet this was fixed by the very recent commit to
fix this: http://archives.postgresql.org/pgsql-hackers/2010-05/msg01203.php
--
Joshua Tolley / eggyknap
End Point Corporation
--
S
On Sat, May 22, 2010 at 5:56 PM, Tom Molesworth wrote:
> Surely this is normal, expected behaviour - exactly the same as you'd get
> from the mysql commandline client, for example?
> Note that I'm not the original submitter - so I could be missing the point
> entirely here!
If you were missing
connection drop rather than
> attempting reconnect and continuing with further statements.
Does PostgreSQL log anything more detailed? What if you update some
other table similarly? It looks like some sort of data corruption on
the table you're updating.
--
Joshua Tolley / eggyknap
End Poin
I accidentally rejected this message while moderating -bugs, so I'm forwarding
it to the list to atone for myself. Apologies to all involved...
- Forwarded message from pgsql-bugs-ow...@postgresql.org -
Content-Description: Original message
From: Rens Admiraal
Date: Fri, 26 Mar 2010 20:0
application try to do with pg_dump? There's not much detail here to
allow us to help you out.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
ts. See the documentation for more details:
http://www.postgresql.org/docs/8.4/interactive/app-pgdump.html
http://www.postgresql.org/docs/8.4/interactive/release-8-4.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Tue, Mar 02, 2010 at 10:08:55AM +, Julien wrote:
> Description:PGAdmin: SQL Query Editor does not (always) open files
A better place for pgadmin problems is the pgadmin-support list:
http://www.pgadmin.org/support/list.php
--
Joshua Tolley / eggyknap
End Point Corporation
h
plicate Oracle's synonyms in PostgreSQL depends on your
specific use case. You might consider emailing pgsql-general with details
about what precisely you use synonyms for, to get help on your porting
project.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Thu, Dec 03, 2009 at 03:56:05PM +, Thomas Hamilton wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5231
> Logged by: Thomas Hamilton
> Email address: thomashamilto...@yahoo.com
> PostgreSQL version: 8.3.8
> Operating system: Ubuntu 4.2.4
> Descr
ice that I needed
to approve #5085. I did get one for 5804 and 5806, FWIW.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
addition to the original text_field value.
http://www.postgresql.org/docs/current/static/citext.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
hem with. For instance, there's
an example of PL/Perl versions available embedded in the code here:
http://tr.im/rPDA
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
ime. However, patches are welcome, if
you'd like it enough to implement it. It's on my list of things that might be
interesting to write, for example, but there are other things higher up on
that list.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Wed, Feb 25, 2009 at 08:11:02PM +0100, David Seres wrote:
>Hello!
>I encountered a problem trying to install the RPostgreSQL package for R. I
>get an error message whenever I try to load the package, namely that it
>doesn't find the reference number 108 in the LIBPQ.dll. What doe
On Tue, Feb 03, 2009 at 11:31:31AM -0700, Joshua Tolley wrote:
> Unless, of course,
> I'm missing something.
Yep, I was missing something. I didn't realize ROLLBACK TO SAVEPOINT
didn't destroy the newer savepoint like RELEASE SAVEPOINT does. Adding
RELEASE SAVEPOINT calls to
The SAVEPOINT documentation says that a new savepoint created with the
same name as an existing savepoint masks but does not destroy the old
savepoint, and rolling back to the savepoint will then make the old
savepoint available for RELEASE SAVEPOINT and ROLLBACK TO SAVEPOINT
calls. 8.3.5 and my 8.
On Mon, Jan 05, 2009 at 07:25:56AM +, V KUMAR wrote:
> we are experiencing the following error intermittenly in saving and opening
> the data.
>
> While saving:
>
> Database error: Error in saving the FMB MAP(Tippan). An I/O error
> occured while sending to the backend.
>
>
>
On Thu, Oct 16, 2008 at 10:33 AM, manish singh
<[EMAIL PROTECTED]> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4482
> Logged by: manish singh
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.3
> Operating system: Centos 64bit
> Description:
On Fri, Sep 26, 2008 at 8:11 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Brendan Jurd" <[EMAIL PROTECTED]> writes:
>> I have some thoughts on this and other issues surrounding AM/PM, but
>> perhaps they are better reserved for a separate thread. Might I
>> suggest we apply Alex's bugfix and hold of
I'm running this on 8.4devel built from CVS HEAD as of 9:44 AM Moutain
Daylight time today, on a 32-bit Ubuntu 7.04 box. This is a completely
new database.
[EMAIL PROTECTED]:~/devel/raybo$ psql raybo -f test.sql
CREATE TABLE
INSERT 0 1
INSERT 0 1
psql:test.sql:21: ERROR: invalid AM/PM string
psql
31 matches
Mail list logo
