On 04/01/11 10:15 PM, Annamalai Gurusami wrote:
It is a big story, but I thought the background will help highlight
our context. Can you guys provide more information that would help us
to make informed decisions?
what you describe is neither postgres nor SQL
perhaps you should look at a stor
On 2 April 2011 03:47, John R Pierce wrote:
> how would you implement SQL without parsing, etc? Annamali asked
> specifically for an implementation of the existing client-server protocol
> without TCP/IP, and thats exactly what the Unix socket interface is.
>
Maybe a little background here
I was under the impression that QUEL was actually a good language in some ways,
and that it was more relational and better than SQL in some ways.
http://en.wikipedia.org/wiki/QUEL_query_languages
Maybe bringing it back would be a good idea, but as an alternative to SQL rather
than a replacem
I'm trying to partition a table that has a btyea field used to store pdf
data. Basically the procedure filters by date, and creates a new table every
month. I'm having problems with the executed sql string that moves the data
into the partitioned table from the main insert.
I'm setting
n_document
On 04/01/11 2:54 PM, Merlin Moncure wrote:
On Fri, Apr 1, 2011 at 4:47 PM, John R Pierce wrote:
On 03/31/11 9:34 AM, Annamalai Gurusami wrote:
Would it be possible to implement the client server protocol into an API
interface, without involving the TCP/IP network?
sure, done already. 'domain
On Fri, Apr 1, 2011 at 4:47 PM, John R Pierce wrote:
> On 03/31/11 9:34 AM, Annamalai Gurusami wrote:
>>
>> Would it be possible to implement the client server protocol into an API
>> interface, without involving the TCP/IP network?
>
> sure, done already. 'domain sockets', the default for local
On 03/31/11 9:34 AM, Annamalai Gurusami wrote:
Would it be possible to implement the client server protocol into an
API interface, without involving the TCP/IP network?
sure, done already. 'domain sockets', the default for local connections
that don't expressly call for localhost
--
Sent
On Wed, Mar 30, 2011 at 3:56 PM, Mike Orr wrote:
> I'm converting a MySQL webapp to PostgreSQL. I have a backup server
> which is refreshed twice daily with mysqldump/mysql and has a
> continuously-running copy of the webapp. I want to replicate this with
> pg_dump/pg_restore. Ideally I'd like to
On Thu, Mar 31, 2011 at 11:34 AM, Annamalai Gurusami
wrote:
> Hi All,
>
> I would like to know about the best approach to take for providing a merged
> model of libpq library. When I say "merged model" it means that the client
> and server would be running as a single process. A single client li
Smells like April first to me.
http://en.wikipedia.org/wiki/April_Fools'_Day
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rajasekhar Yakkali
Sent: Friday, April 01, 2011 10:08 AM
To: dp...@postgresql.org
Cc: pgsql-general@postgresql.org; pgsql
After trying out the JDBC4 driver in DBCP, I see that
Connection.createArray(...) still just creates a big string under the
covers. Is that the expected behavior? Am I doing it wrong?
On Thu, Mar 31, 2011 at 8:04 PM, bubba postgres wrote:
> Hello!
> In my current application I am sending a lot o
"Following a great deal of discussion, I'm pleased to announce that the
PostgreSQL Core team has decided that the major theme for the 9.1
release, due in 2011, will be 'NoSQL'.
"... the intention is to remove SQL support from
Postgres, and replace it with a language called 'QUEL'. This will
provid
I was able to upgrade the machine on Wednesday to 9.0.3 and we saw the spike
on Thursday, right on the 8 day schedule. I will keep my eye out next
Friday to see if it happens again. This will have the whole period on the
new version.
Thanks
George
On Wed, Mar 16, 2011 at 7:12 PM, Aleksey Tsalol
On Fri, 1 Apr 2011, Raghavendra wrote:
Try out this...
alter table add primary key(column name);
Raghavendra,
Aha! I missed noticing that I need parentheses around the column name.
Much thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Hi,
Query to list the tables and its concerned indexes.
SELECT indexrelid::regclass as index , relid::regclass as
table FROM pg_stat_user_indexes JOIN pg_index USING
(indexrelid) WHERE idx_scan < 100 AND indisunique IS FALSE;
Query will list the contraints.
SELECT relname FROM pg_class WHERE oi
Try out this...
alter table add primary key(column name);
Best Regards,
Raghavendra
EnterpriseDB Corporation
On Fri, Apr 1, 2011 at 9:09 PM, Rich Shepard wrote:
> In -9.0.3 I used ALTER TABLE to replace a varchar() column with a bigint
> column so it can be assigned as the table's primary k
In -9.0.3 I used ALTER TABLE to replace a varchar() column with a bigint
column so it can be assigned as the table's primary key. From the 9.0.3
manual I tried various flavors of ALTER TABLE ADD CONSTRAINT but
cannot find the proper syntax to create the PK. Do I need to first make the
column UN
Hi.
How to convet xmin field (32bit) to format used by txid_current (64bit) ?
I use it to track updates in table.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi!
I want to migrate some database to PG.
I want to make intelligens migrator, that makes the list of the SQL-s what
need to do to get same table structure in PG as in the Source DB.
All things I can get from the views about tables, except the indices.
These indices are not containing the const
Hello.
When you jail a process, all its attempt to bind to 127.0.0.1 address
will be unsuccessful, and all its attempt to bind to * (all addresses)
will be successful, but in fact it will bind only to jail's IP. So, when
you try to connect to jail's pgsql from jail process will use jail's ip
a
20 matches
Mail list logo
