On 18 Feb 2011, at 5:55, Adarsh Sharma wrote:
> One is :
>
> could not connect to server : Connection refused
> (0x274D/10061) Is the server running on host
> "127.0.0.1" and accepting TCP/Ip connections on port 5432?
> I chang C:/Windows/System32/Drvers/etc/host file to have below line
>
>
On Thu, Feb 17, 2011 at 11:35, prabakaran.a wrote:
> Dear All,
>
> In Mysql, If we create a directory under mysql/data, mysql treated as
> database instance without starting mysql server.
> Is there any similar provision in postgres where we can create a database
> instance without starting post
Here's my query:
SELECT R.RecipeId, R.Title, R.Description, R.ImageUrl, R.Rating,
R.PrepTime, R.CookTime, R.OwnerId, U.Alias
FROM Recipes R
INNER JOIN Users U ON U.UserId = R.OwnerId
WHERE (R.PrepTime <= :maxprep)
ORDER BY R.Rating DESC LIMIT 100;
SELECT COUNT(*) FROM Recipes R
WHERE (R.PrepTime <
Dear All, In Mysql, If we create a directory under mysql/data, mysql treated as database instance without starting mysql server. Is there any similar provision in postgres where we can create a database instance without starting postgresql server.Thanks,Prabakaran A
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
set local session_replication_role = replica;
But that does not seem provide the expected relief.
How exactly did this fail? This should absolutely disable all
triggers for you, unless you've mucked with the trigge
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I thought we had tried this before, but with an embedded BEGIN. I get
the same result, although I used the -1 switch instead of the BEGIN/COMMIT:
psql:backup.txt:2077303: ERROR: insert or update on table "custome
On 02/17/11 8:55 PM, Adarsh Sharma wrote:
Dear all,
I am working on Linux based Systems and install several times
*postgresplus-8.4.1.2* binary
postgresqlplus is a commercial product of EnterpriseDB, you should
contact them for support
--
Sent via pgsql-general mailing list (pgsql-gener
Dear all,
I am working on Linux based Systems and install several times
*postgresplus-8.4.1.2* binary and faced no issues.
But Today I need to install it on Windows XP based system and fail to
install it correctly.
I faced to issues :
One is :
*
could not connect to server : Connection refuse
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> psql:test.sql:11: ERROR: current transaction is aborted, commands
> ignored until end of transaction block
Oops my bad, I forgot to tell you I have
\set ON_ERROR_ROLLBACK on
in my .psqlrc. So you'll need to add that to the top of
the scri
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I thought we had tried this before, but with an embedded BEGIN. I get
the same result, although I used the -1 switch instead of the BEGIN/COMMIT:
psql:backup.txt:2077303: ERROR: insert or update on table "custome
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I thought we had tried this before, but with an embedded BEGIN. I get
> the same result, although I used the -1 switch instead of the BEGIN/COMMIT:
>
> psql:backup.txt:2077303: ERROR: insert or update on table "customer"
> violates foreign
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
set local session_replication_role = replica;
But that does not seem provide the expected relief.
How exactly did this fail? This should absolutely disable all
triggers for you, unless you've mucked with the trigge
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>>> set local session_replication_role = replica;
>>>
>>> But that does not seem provide the expected relief.
>>
>> How exactly did this fail? This should absolutely disable all
>> triggers for you, unless you've mucked with the triggers
>> a
On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
> Hi all -
>
> I am trying to write a query to find all the column names in
> database that has a underscore in it (_) example souce_id. I know like will
> not work , if where column_name like '%_%' Can you please help?
where col
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
We were trying to accomplish this without having to hack the dump to
much. We attempted adding:
set local session_replication_role = replica;
But that does not seem provide the expected relief.
How exactly did
that's right. Thanks again all for the help
On Thu, Feb 17, 2011 at 2:09 PM, David Kerr wrote:
> On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
> - Hi all -
> -
> - I am trying to write a query to find all the column names in
> - database that has a underscore in it (_) exam
On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
- Hi all -
-
- I am trying to write a query to find all the column names in
- database that has a underscore in it (_) example souce_id. I know like will
- not work , if where column_name like '%_%' Can you please help?
-
- Regar
Try just using the string function "position". You'll need to check the
documentation or wait for others to determine which specific system views
you will need to obtain the column name (if you do not already know that
part).
position(substring in string) int
Non-Zero (or maybe >= 0) indic
thanks . It worked
Regards
On Thu, Feb 17, 2011 at 2:05 PM, Radosław Smogura
wrote:
> akp geek Thursday 17 February 2011 19:55:46
> > Hi all -
> >
> > I am trying to write a query to find all the column names in
> > database that has a underscore in it (_) example souce_id. I know lik
akp geek Thursday 17 February 2011 19:55:46
> Hi all -
>
> I am trying to write a query to find all the column names in
> database that has a underscore in it (_) example souce_id. I know like will
> not work , if where column_name like '%_%' Can you please help?
>
> Regards
Try SELECT
Hi all -
I am trying to write a query to find all the column names in
database that has a underscore in it (_) example souce_id. I know like will
not work , if where column_name like '%_%' Can you please help?
Regards
2011/2/16 Merlin Moncure
> On Tue, Feb 15, 2011 at 7:51 AM, Dmitriy Igrishin
> wrote:
> >
> >
> > 2011/2/15 Merlin Moncure
> >>
> >> On Mon, Feb 14, 2011 at 8:37 AM, Dmitriy Igrishin
> >> wrote:
> >> > 2011/2/14 Merlin Moncure
> >> >>
> >> >> On Mon, Feb 7, 2011 at 3:15 PM, Julia Jacobson
> >
On Thu, Feb 17, 2011 at 4:16 AM, Alessandro Candini wrote:
> I'm dealing witch a C function embedded into postgresql-9.0.2.
>
> I'm returning a set of rows and following the example here
> http://www.postgresql.org/docs/9.0/static/xfunc-c.html everything works
> fine, but only if I use the C strin
Hi Francisco,
I tried changing that one line to use UTF-8 encoder, but the password packet
didn't get fixed. It works smoothly if kept in byte array instead of string.
I think changing the AuthenticationSSPI case to use context.Host may break
the cases Brar's mentioned.
--
View this message i
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> We were trying to accomplish this without having to hack the dump to
> much. We attempted adding:
>
> set local session_replication_role = replica;
>
> But that does not seem provide the expected relief.
How exactly did this fail? This sho
Steven Elliott writes:
> I don't think the current behavior is particularly harmful, but maybe
> PostgreSQL could be made to idle more quietly.
Yeah, this is something that's on my personal to-do list. It's not
really an efficiency/performance issue, but in a machine that's
otherwise idle this b
Jeremy Palmer writes:
> When I have a query that uses DESC reserved word within the function the
> following variable substitution occurs:
> ERROR: syntax error at or near "$1"
> LINE 1: SELECT foo.bar, foo."desc" FROM foo."desc" ORDER BY foo."desc"
> $1
>
Recently I became curious about the WAL log writer. I noticed that with
a default ACID complaint configuration that the the WAL log writer wakes
up every 200 msec (the default indicated by "wal_log_writer") and does
nothing. Here's a typical strace:
21:37:07.194809 select(0, NULL, NULL, NULL, {
On Feb 17, 2011, at 6:59 AM, Geoffrey Myers wrote:
>> Unless something very big changed when I wasn't looking, the
>> constraints are actually implemented as triggers under the hood. But
>> you're right that it'd be cleaner to drop the constraints and re-add
>> them than to fool with system trig
In order to implement sending in binary mode timestamps with / without
timezone I want to create pseudo type. Driver should create this
autmaticly, if it will have enough permissions. What method should I
implement?
1) Of course cast to timestamp, date, time with / without time zone,
in, out,
On Thu, Feb 17, 2011 at 4:08 AM, Adarsh Sharma wrote:
> Dear all,
>
> Today I got to have a strong issue while craeting table in a database.
>
> pdc_uima=# create table clause2_naxal as select * from clause2 c
> ,page_naxal_v3 p where c.source_id = p.crawled_page_id;
> ERROR: could not extend re
Andrew Sullivan wrote:
On Wed, Feb 16, 2011 at 10:08:53AM -0500, David Johnston wrote:
I may be off-track here but triggers do not enforce referential integrity -
constraints do. If you need to disable triggers you can do so via the ALTER
TABLE command.
Unless something very big changed when
I'm dealing witch a C function embedded into postgresql-9.0.2.
I'm returning a set of rows and following the example here
http://www.postgresql.org/docs/9.0/static/xfunc-c.html everything works
fine, but only if I use the C string approach.
I'm using libpq to retrieve data and something like
Dear all,
Today I got to have a strong issue while craeting table in a database.
pdc_uima=# create table clause2_naxal as select * from clause2 c
,page_naxal_v3 p where c.source_id = p.crawled_page_id;
ERROR: could not extend relation pg_tblspc/17208/17216/23098672: No
space left on device
34 matches
Mail list logo
