Jay wrote:
> Hi,
>
> I'm somewhat new to SQL so I need a bit of help with this problem. So
> I have 2 tables: "selection" and "master", both have two columns in
> each: "user_id" and "date".
>
> The "selection" contains one row for each "user_id" and depicts _one_
> "date" value for each user.
I'd like to dump to text the full SQL required to create/replace all
user-defined functions within a specific schema - but JUST the function
declarations.
We are doing server migration and there are some network paths in the code I
would like to search and replace.
Carlo
--
Sent via pgsq
Carlo Stonebanks wrote:
> I'd like to dump to text the full SQL required to create/replace all
> user-defined functions within a specific schema - but JUST the function
> declarations.
>
> We are doing server migration and there are some network paths in the
> code I would like to search and
Dear All,
I have a query in postgresql if any one can support.
A transaction table in a vehicle tracking application is inserted with the
current position of each vehicle at regular interval (seconds).
This transaction table consists of 12 columns, which are of the type varchar,
time, numeric
On Sat, Mar 20, 2010 at 2:47 AM, Deepa Thulasidasan
wrote:
> Dear All,
>
> I have a query in postgresql if any one can support.
>
> A transaction table in a vehicle tracking application is inserted with the
> current position of each vehicle at regular interval (seconds).
> This transaction tab
On Sat, Mar 20, 2010 at 5:26 AM, Scott Marlowe wrote:
> On Sat, Mar 20, 2010 at 2:47 AM, Deepa Thulasidasan
> wrote:
> > Dear All,
> >
> > I have a query in postgresql if any one can support.
> >
> > A transaction table in a vehicle tracking application is inserted with
> the current position of
quoth Greg Smith:
Herouth Maoz wrote:
Aren't socket writes supposed to have time outs of some sort? Stupid
policies notwithstanding, processes on the client side can disappear
for any number of reasons - bugs, power failures, whatever - and this
is not something that is supposed to cause a ba
On Sat, Mar 20, 2010 at 11:44 AM, Herouth Maoz wrote:
> The server version is 8.3.1. Migration to a higher version might be
> difficult as far as policies go, if there isn't a supported debian package
> for it, but if you can point out a version where this has been fixed I might
> be able to persu
? Scott Marlowe:
On Sat, Mar 20, 2010 at 11:44 AM, Herouth Maoz wrote:
The server version is 8.3.1. Migration to a higher version might be
difficult as far as policies go, if there isn't a supported debian package
for it, but if you can point out a version where this has been fixed I mig
Hi,
I'm trying to set up an internal general-purpose PostgreSQL server
installation. I want most users with login access to the server to be able to
create databases, but only with names that follow a specified naming convention
(in particular, approximately "is prefixed with the owner'
On Sat, Mar 20, 2010 at 3:57 PM, Herouth Maoz wrote:
>
>
> The problem is not so much danger in upgrading, but the fact that doing so
> without using the system's usual security/bugfix update path means
> non-standard work for the sysadmin, meaning he has to upgrade every package
> on the system u
Thanks!
But, since the master can contain many users (user2, user3, and so on)
I suppose this won't be a proper solution?
Sorry if I was a bit unclear in my description.
I.e., the master is of the form:
user_id date
User1 20010101
User1 2101
User1 19990101
User1 19970101
User2 ...
...
Btw, I
Hi,
I'm trying to set up an internal general-purpose PostgreSQL server
installation. I want most users with login access to the server to be able to
create databases, but only with names that follow a specified naming convention
(in particular, approximately "is prefixed with the owner'
On Sat, Mar 20, 2010 at 5:24 PM, Adam Seering wrote:
> Hi,
>I'm trying to set up an internal general-purpose PostgreSQL server
> installation. I want most users with login access to the server to be able
> to create databases, but only with names that follow a specified naming
> conventi
On Mar 20, 2010, at 2:24 PM, Adam Seering wrote:
> Hi,
> I'm trying to set up an internal general-purpose PostgreSQL server
> installation. I want most users with login access to the server to be able
> to create databases, but only with names that follow a specified naming
> convention
I am using Postgresql 8.1 tsearch2.
I need to match a like operation in tsearch. Such as,
Sample data:
Document
..
Rumman went to iftekhar to solve it.
select ...
from ...
where document like '%ifte%'
need to be written in tsearch. Here "ifte" is a name
But in tsearch wh
We introduced prefix support in 8.4, so one may use:
=# select to_tsvector('Rumman went to iftekhar to solve it') @@
to_tsquery('ifte:*') as c;
c
---
t
(1 row)
On Sun, 21 Mar 2010, AI Rumman wrote:
I am using Postgresql 8.1 tsearch2.
I need to match a like operation in tsearch. Such as,
Is pg_get_functiondef an 8.4 appears to be an 8.4 function?
I don't see it in the 8.3 documentation and the servers in question are all
8.3.
Any alternatives for 8.3? pg_proc has the code body, but not the function
declaration, etc.
"Andreas Kretschmer" wrote in message
news:20100320081
Does any one use Wordpress-Mu with Postgresql?
If yes, please tell me the way.
19 matches
Mail list logo
