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
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
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
On Thu, Feb 17, 2011 at 4:08 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
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:
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,
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 triggers.
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,
Jeremy Palmer jpal...@linz.govt.nz 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
Steven Elliott sellio...@austin.rr.com 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
-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 should
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
On Thu, Feb 17, 2011 at 4:16 AM, Alessandro Candini cand...@meeo.it 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
2011/2/16 Merlin Moncure mmonc...@gmail.com
On Tue, Feb 15, 2011 at 7:51 AM, Dmitriy Igrishin dmit...@gmail.com
wrote:
2011/2/15 Merlin Moncure mmonc...@gmail.com
On Mon, Feb 14, 2011 at 8:37 AM, Dmitriy Igrishin dmit...@gmail.com
wrote:
2011/2/14 Merlin Moncure
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
akp geek akpg...@gmail.com 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
thanks . It worked
Regards
On Thu, Feb 17, 2011 at 2:05 PM, Radosław Smogura
rsmog...@softperience.euwrote:
akp geek akpg...@gmail.com 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
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)
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?
-
-
that's right. Thanks again all for the help
On Thu, Feb 17, 2011 at 2:09 PM, David Kerr d...@mr-paradox.net 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
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
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
-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
and set them to
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
-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 key
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
-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
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
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
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
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
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
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 =
On Thu, Feb 17, 2011 at 11:35, prabakaran.a prabakara...@zohocorp.comwrote:
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
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
34 matches
Mail list logo