On Wed, Aug 13, 2014 at 6:54 AM, Vik Fearing wrote:
> On 08/12/2014 11:49 PM, Daniele Varrazzo wrote:
>> Hello,
>>
>> I'm going to add support to the jsonb data type in psycopg2, in order
>> to have the type behaving like json currently does
>> (http://initd.org/psycopg/docs/extras.html#json-adapt
On 08/12/2014 11:49 PM, Daniele Varrazzo wrote:
> Hello,
>
> I'm going to add support to the jsonb data type in psycopg2, in order
> to have the type behaving like json currently does
> (http://initd.org/psycopg/docs/extras.html#json-adaptation).
>
> Is it correct that oid and arrayoid for the ty
Hello,
I'm going to add support to the jsonb data type in psycopg2, in order
to have the type behaving like json currently does
(http://initd.org/psycopg/docs/extras.html#json-adaptation).
Is it correct that oid and arrayoid for the type will be 3802 and 3807
and that they won't change before the
On 10/7/2013 6:46 PM, David Kerr wrote:
On Mon, Oct 07, 2013 at 06:32:57PM -0400, Guy Rouillier wrote: - So,
I ran "select pg_relation_filenode(614804)" and got no results. Any
- suggestions on how I can uncover the identify of this node? - -
Thanks much.
You could try oid2name:
http://www.post
On Mon, Oct 07, 2013 at 06:32:57PM -0400, Guy Rouillier wrote:
- On 10/7/2013 5:58 PM, Steve Atkins wrote:
- >
- >On Oct 7, 2013, at 2:48 PM, Guy Rouillier
- >wrote:
- >
- >>We have a fairly large (1 TB) database we put on all SSDs because
- >>of a very high insert and update rate (38 million rows
On 10/7/2013 5:58 PM, Steve Atkins wrote:
On Oct 7, 2013, at 2:48 PM, Guy Rouillier
wrote:
We have a fairly large (1 TB) database we put on all SSDs because
of a very high insert and update rate (38 million rows/day). As
our business has grown, we've been running into space constraints,
so w
On Oct 7, 2013, at 2:48 PM, Guy Rouillier wrote:
> We have a fairly large (1 TB) database we put on all SSDs because of a very
> high insert and update rate (). As our business has grown, we've been
> running into space constraints, so we went looking for files we might be able
> to delete.
We have a fairly large (1 TB) database we put on all SSDs because of a
very high insert and update rate (). As our business has grown, we've
been running into space constraints, so we went looking for files we
might be able to delete.
We found a large number (662 out of 1465 total ) and size
On Sunday 14 March 2010 1:09:37 pm fka...@googlemail.com wrote:
> Adrian Klaver:
> > > AFAIK the dump/restore does not rebuild the original OID
> > > values, so all relations built accross OIDs fail.
> > >
> > > (1)
> > > Is there a way to keep the original OID values somehow?
> >
> > From here:
>
Adrian Klaver:
> > AFAIK the dump/restore does not rebuild the original OID
> > values, so all relations built accross OIDs fail.
> >
> > (1)
> > Is there a way to keep the original OID values somehow?
>
> From here:
> http://www.postgresql.org/docs/8.4/interactive/app-pgdump.html
>
> -o
> --oid
On Sunday 14 March 2010 9:21:06 am fka...@googlemail.com wrote:
> Hi all,
>
> I have several databases here which I would like to update
> from 8.2 to 8.4, which in turn requires a dump/restore.
>
> However, the databases are OIDs depending, so, some values
> depend on OIDs in other tables.
>
> AFA
On 14/03/2010 16:21, fka...@googlemail.com wrote:
> (2)
> If I need to go the long way and replace the OIDs with
> SERIALs first, updating all relations to it etc: Would a
> dump/restore then restore the original values in a SERIAL
> column?
So-called SERIAL types are actually just integer column
Hi all,
I have several databases here which I would like to update
from 8.2 to 8.4, which in turn requires a dump/restore.
However, the databases are OIDs depending, so, some values
depend on OIDs in other tables.
AFAIK the dump/restore does not rebuild the original OID
values, so all relations
Bob Pawley wrote:
> All of my tables are without oids.
>
> I have an application in which I drop, then recreate a table (to reset
> serial numbers) and with an update on the new information I get an error
> about a specific oid missing.
This is a known problem. It was fixed in 8.3 -- you may
On Mon, Feb 11, 2008 at 10:38:55AM -0800, Bob Pawley wrote:
> All of my tables are without oids.
>
> I have an application in which I drop, then recreate a table (to reset
> serial numbers) and with an update on the new information I get an error
> about a specific oid missing.
>
> Any thoughts
;Erik Jones" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "PostgreSQL"
Sent: Monday, February 11, 2008 10:29 AM
Subject: Re: [GENERAL] oids
On Feb 11, 2008, at 12:15 PM, Bob Pawley wrote:
I'm running Postgresql 8.2 on Windows.
If I crea
On Feb 11, 2008, at 12:15 PM, Bob Pawley wrote:
I'm running Postgresql 8.2 on Windows.
If I create a table 'without oids' are oids still in use behind the
scenes??
Yes and no. WITHOUT OIDS specifies that you don't want each row to
get its own oid. You will often here of "a table's oid"
On Mon, Feb 11, 2008 at 10:15:40AM -0800, Bob Pawley wrote:
> I'm running Postgresql 8.2 on Windows.
>
> If I create a table 'without oids' are oids still in use behind the scenes??
Nope.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who ma
I'm running Postgresql 8.2 on Windows.
If I create a table 'without oids' are oids still in use behind the scenes??
Bob
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Purusothaman A wrote:
Richard Huxton,
In my system also its 2048 bytes chunk.
The below output shows clearly that the last chunk differs in its length.
You might have noticed in my previous mail that the string
"\015\012\015\012" is
missing some characters in SFRS2, SFRS1 and FASP_AVT database
Richard Huxton,
In my system also its 2048 bytes chunk.
The below output shows clearly that the last chunk differs in its length.
You might have noticed in my previous mail that the string
"\015\012\015\012" is
missing some characters in SFRS2, SFRS1 and FASP_AVT database outputs.
Have a look a
Purusothaman A wrote:
Richard Huxton,
Thanks for your detailed reply.
I am maintaining various database of same kind in postgresql.
Here I have shown various corrupted last line of output of select * from
pg_largeobject where oid = xx; in 5 databases.
I have used '\o e:\\filename.xml' befo
Richard Huxton,
Thanks for your detailed reply.
I am maintaining various database of same kind in postgresql.
Here I have shown various corrupted last line of output of select * from
pg_largeobject where oid = xx; in 5 databases.
I have used '\o e:\\filename.xml' before executing query and
Purusothaman A wrote:
Dear Richard Huxton,
Thanks for your quick reply.
only the first 3 values(HX, MASK, Rockey4ND) are file object's oid value.
the other two are are not oid values.
Umm - OK. Can I suggest perhaps having different tables for different
types of data?
I have shown origina
Dear Richard Huxton,
Thanks for your quick reply.
only the first 3 values(HX, MASK, Rockey4ND) are file object's oid value.
the other two are are not oid values.
I have shown original output values displayed by postgresql client.
I can explain more.
1. HX is a XML file. after downloading that
Purusothaman A wrote:
Thanks Richard Huxton for your reply.
I use client side api for uploading and downloading files.
Its not happening immediately. But when database grows with data, file
object got corrupted.
Yes, but *HOW* - is it a different file, length is different, what?
My table st
Thanks Richard Huxton for your reply.
I use client side api for uploading and downloading files.
Its not happening immediately. But when database grows with data, file
object got corrupted.
My table structure is as follows.
Table "public.conf"
Column | Type | Modif
Purusothaman A wrote:
Hi all,
I am using Postgresql 8.2.
8.2.which?
I am using client side api to upload/download files to/from postgresql
using
calls lo_export()/lo_import();
If I download a file from postgresql, few weeks later, files object's
contents got damaged.
I don't know why.
Do
Hi all,
I am using Postgresql 8.2.
I am using client side api to upload/download files to/from postgresql using
calls lo_export()/lo_import();
If I download a file from postgresql, few weeks later, files object's
contents got damaged.
I don't know why.
Do any of you have encountered same probl
"Aaron Harsh" <[EMAIL PROTECTED]> writes:
>> Tom Lane <[EMAIL PROTECTED]> 08/03/05 1:33 PM >>>
>> OID wraparound would explain that ...
> Fantastic. Will our plan ('set without oids', pg_dump, pg_restore) take care
> of the problem?
Only temporarily (ie, till the counter wraps around again). I
> Tom Lane <[EMAIL PROTECTED]> 08/03/05 1:33 PM >>>
> "Aaron Harsh" <[EMAIL PROTECTED]> writes:
> > We've just recently started seeing sporadic constraint violations on system
> > tables. For example:
> > duplicate key violates unique constraint "pg_class_oid_index" [for
> > Statement "CREATE
"Aaron Harsh" <[EMAIL PROTECTED]> writes:
> We've just recently started seeing sporadic constraint violations on system
> tables. For example:
> duplicate key violates unique constraint "pg_class_oid_index" [for
> Statement "CREATE TEMPORARY TABLE...
OID wraparound would explain that ...
> a
We've just recently started seeing sporadic constraint violations on system
tables. For example:
duplicate key violates unique constraint "pg_class_oid_index" [for Statement
"CREATE TEMPORARY TABLE...
and
duplicate key violates unique constraint "pg_toast_4292803267_index" [for
Statement
Tino Wildenhain wrote:
Google or your favourite search engine helps :-)
http://www.postgresql.org/files/documentation/books/aw_pgsql/node71.html
is among the first results.
Unfortunately those docs are quite out of date. This page is better:
http://developer.postgresql.org/docs/postgres/data
Am Montag, den 20.06.2005, 11:57 -0400 schrieb Hrishikesh Deshmukh:
> Hi All,
>
> I have 7.4.7 version, my question is what are OIDS user for? What can
> one do with it!
Google or your favourite search engine helps :-)
http://www.postgresql.org/files/documentation/books/aw_pgsql/node71.html
is
Hrishikesh Deshmukh writes:
>I have 7.4.7 version, my question is what are OIDS user for? What can
>one do with it!
they're for internal use only, they may go away, so don't do anything
with them, pretend that they aren't even there.
richard
---(end of broadcast)
Hi All,
I have 7.4.7 version, my question is what are OIDS user for? What can
one do with it!
Thanks,
Hrishi
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hi Amir Khawaja ,
I have a rather trivial (I hope) question about OID types and
PostgreSQL. Since PostgreSQL creates tables "WITH OIDS" by default,
I'm wondering if it is bad practice to allow the default behaviour.
For example, if I have a database with 60+ tables (all tables have
their own P
Kapil Tilwani writes:
> I would like to make it impossible to be traced as to which record came in
> first and which next, however, being sequential reveal that... How should I
> ensure this?
If you want cryptographic security you will need to use advanced
algorithms to shuffle your data. In a
ot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, June 30, 2001 9:53 PM
Subject: Re: [GENERAL] OIDs
> Kapil Tilwani writes:
>
> > What happens when OIDs overflow?
>
> You might get spurious problems when you are altering your schema (unique
> contraint viola
Hi folks,
Here's what I have:
create table contact (
contact_id serial,
...
primary key (contact_id)
);
create table customers (
customer_id serial,
shipping_contact_id int4,
billing_contact_id int4,
...
primary key (customer_id)
);
Well,
41 matches
Mail list logo
