I just tried pg_upgrade from the Postgres 10 Beta1 (from the BigSQL
distribution) to upgrade a 9.6 cluster.
pg_upgrade --check fails with the following messages:
Performing Consistency Checks
-
Checking cluster versions ok
Checking d
Tom Lane schrieb am 26.05.2017 um 20:18:
I just tried pg_upgrade from the Postgres 10 Beta1 (from the BigSQL
distribution) to upgrade a 9.6 cluster.
pg_upgrade --check fails with the following messages:
could not load library "$libdir/pgxml":
ERROR: could not load library
"d:/etc/po
Adrian Klaver schrieb am 26.05.2017 um 23:16:
could not load library "$libdir/pgxml":
ERROR: could not load library
"d:/etc/postgres-10/pgsql/lib/postgresql/pgxml.dll": unknown error 126
Apparently BigSQL forgot to include contrib/xml2 in their distribution;
you should ping them abo
Adrian Klaver schrieb am 26.05.2017 um 23:41:
If that's coming from port/dynloader/win32.c, as I think it must be
because the non-conformant-to-message-style-guidelines phrase "unknown
error" appears nowhere else in our tree, then that's an error code that
FormatMessage doesn't recognize. Anybod
Tom Lane schrieb am 26.05.2017 um 20:18:
I just tried pg_upgrade from the Postgres 10 Beta1 (from the BigSQL
distribution) to upgrade a 9.6 cluster.
pg_upgrade --check fails with the following messages:
could not load library "$libdir/pgxml":
ERROR: could not load library
"d:/etc/po
Adrian Klaver schrieb am 28.05.2017 um 17:51:
After I finally found the EnterpriseDB Beta binaries (they are pretty well
hidden) I tested with those, and everything works fine there.
For those following along, where would that be?
Here they are:
https://www.enterprisedb.com/products-service
Joshua Ma schrieb am 30.05.2017 um 22:56:
We're going to fix usages of this to
instead do (a = b && a = c) instead of (a = b = c).
That has to be (a = b AND a = c)
The && operator is not valid for booleans
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
Nicolas Paris schrieb am 31.05.2017 um 16:43:
Hi,
I have dumps from oracle and microsoft sql server (no more details). Is it possible to
load them "directly" into postgres (without oracle/mssql license)?
dump -> csv -> postgtres
or something ?
If those are binary dumps (e.g. a DataPump dump
kbran...@pwhome.com schrieb am 09.06.2017 um 20:57:
Neil Anderson wrote:
I've been exploring the pg_catalog tables and pointed a couple of tools at
it to extract an ER diagram for a blog post. At first I thought it was a bug
in the drawing tool but it appears that the relationships between the
Israel Brewster schrieb am 19.06.2017 um 22:17:
SELECT
...
(SELECT
array_agg(to_json(row(notedate,username,note)))
FROM sabrenotes
INNER JOIN users ON author=users.id
WHERE ticket=sabretickets.id ) notes
FROM tickets
WHERE ...
The only problem with this query is that the notes aren't sorted. Of
Andreas Kretschmer schrieb am 23.06.2017 um 20:58:
I expected to find binaries for 9.6.3 at
https://www.enterprisedb.com/download-postgresql-binaries but I only
see
9.6.2.
Am I looking at the wrong place?
Yeah, use the community version from postgresql.org ;-)
Regards, Andreas
There are n
Hans Schou schrieb am 05.07.2017 um 14:27:
> The dburl (or dburi) has become common to use by many systems
> connecting to a database. The feature is that one can pass all
> parameters in a string, which has similar pattern as http-URI do.
>
> Especially when using psql in a script, having the cred
marcelo schrieb am 14.07.2017 um 13:59:
> Could I select a specific schema in the connection string? Say, by example
> database=mydb.schemanumbertwo ?
The JDBC driver does indeed support that:
jdbc:postgresql://localhost/somedatabase?currentSchema=some_schema
I think in the backround it the
Hello,
recently I have seen a Postgres configuration with the following values:
seq_page_cost = 0.5
random_page_cost = 0.6
Is there any advantage (or maybe disadvantage) compared to using e.g. 1.0 and
1.2?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgr
유상지 schrieb am 31.08.2017 um 04:03:
> Cluster secondary indexes were faster than those without cluster indexes in
> pg, but slower than mariadb.
There is no such thing as a "clustered index" in Postgres.
The Postgres "cluster" command physically sorts the rows of a table according
to the sort
Ryan Murphy schrieb am 05.09.2017 um 16:19:
> Thanks, I saw that page earlier; what I'm looking for is kind of the
> opposite - instead of comparing a single value to see if it matches
> any of a list of patterns, I'm trying to take a list of values and
> see if any of them match a given pattern.
>
Paul A Jungwirth schrieb am 21.09.2017 um 23:05:
but maybe I could write my own extension to
load regular files into Postgres arrays, sort of getting the best of
both worlds.
There is a foreign data wrapper for that:
https://github.com/adunstan/file_text_array_fdw
but it's pretty old and s
Joy Arulraj schrieb am 08.10.2017 um 13:50:
> Hi folks -- We developed a static analysis tool, called SQLCheck, for
> automatically identifying anti-patterns in SQL queries.
>
> https://github.com/jarulraj/sqlcheck
>
> Our goal is to provide hints to the developers about potential
> performance a
When increasing the length constraint on a varchar column, Postgres is smart
enough to not rewrite the table.
I expected the same thing to be true when increasing the size of a numeric
column.
However this does not seem to be the case:
Consider the following table:
create table foo
Seamus Abshere schrieb am 13.10.2017 um 18:43:
On Fri, Oct 13, 2017 at 8:49 AM, Seamus Abshere wrote:
Theoretically / blue sky, could there be a table or column type that
transparently handles "shared strings" like this, reducing size on disk
at the cost of lookup overhead for all queries?
(I gu
Melvin Davidson schrieb am 13.10.2017 um 21:42:
If that is what you need to do, then definitely use multiple schemas.
In PostgreSQL, the only way to do cross db queries / DML, is with the
dblink extension, and from personal use, it is a PIA to use.
dblink is not the only way to do that.
Nowada
Melvin Davidson schrieb am 14.10.2017 um 17:32:
More than likely, the optimizer has determined that a table scan is best, in
which case it will use a table lock.
That means one updates will be blocking each other.
Since when does Postgres lock the whole table during an update?
--
Sent via
I don't know if this is intentional, but the Postgres 10 manual started to use
lowercase IDs as anchors in the manual.
So, if I have e.g.: the following URL open in my browser:
https://www.postgresql.org/docs/current/static/sql-createindex.html#sql-createindex-concurrently
I cannot simply s
rverghese schrieb am 11.10.2017 um 20:38:
> You mean at the user permissions level? Yes, I could, but would mean doing so
> table by table, which is not our current structure. I guess there is nothing
> at the database level.
Not at the database level, but at the schema level:
You can revoke thos
Fabricio Pedroso Jorge schrieb am 18.10.2017 um 19:37:
is there a "official" monitoring tool for PostgreSQL databases? For
example, i come from Oracle Database, and there, we have Enterprise
Manager to monitor and administrer the product... is there such a
similar tool for PostgreSQL?
There is
When using explain (analyze, buffers) things like this can show up:
Buffers: shared hit=137 read=6545 dirtied=46
Given the description in the manual:
The number of blocks dirtied indicates the number of previously unmodified
blocks that were changed by this query
I am a bit surpri
Rob Sargent schrieb am 06.11.2017 um 23:09:
> Gosh I wish I could learn to proof-read my posts.
> My support crew graciously set
>
> idle_transaction_timeout = 1
>
> Now to ponder if I need zero or some large number.
The unit of that setting is milliseconds (if no unit is specified).
zero disab
Steven De Vriendt wrote on 28.02.2008 21:42:
Hi list,
I'm using the latest postgreSQL with the lastest postgis.
When executing every command I want to use, I get the following error
message:
postgis=# createdb;
ERROR: syntax error at or near "createdb"
LINE 1: createdb;
^
I can us
abracadabuda wrote on 29.02.2008 19:28:
Hi,
i need to export pgsql structure of tables, vies, PK, FK etc. etc.
into simple XML structure.
My 3 hour searching ended with one result: postgresql-autodoc, but i
don't have enough rights on server to install it.
Is there any solution for my problem
Hello,
I was writing a statement retrieve dependency information out of the system
catalog, when I noticed something that I didn't expect.
I wanted to use the following statement to "translate" the relkind column to a
more descriptive value:
select c.relname
case
when c.relk
Adam Rich wrote on 01.03.2008 01:02:
"The data types of all the result expressions must be convertible to a
single output type."
The type of the field pg_class.relkind appears to be "char" which is
described in the notes as:
The type "char" (note the quotes) is different from char(1) in that i
robert, 06.03.2008 15:32:
Hi all,
I've successfully converted a huge mssql ddl to postgres 8.1.9 - I
could upgrade if need be. We run both db's for our app depending on
the customer. We have a new feature, storing serialized java objects
in the db, and I'm having trouble with on this insert:
IN
Conor McTernan wrote on 06.03.2008 04:33:
I have been using DBDesigner by FabForce for a couple of years, but
development has stopped
It seems that someone picked up the source. There is a new project on
sourceforge that seems to continue the work on DbDesigner:
https://sourceforge.net/proj
A. Kretschmer wrote on 11.03.2008 19:50:
am Tue, dem 11.03.2008, um 10:51:21 -0700 mailte CaseT folgendes:
Hi All,
I'm a novice but learning quickly and I'm stumped on how to do this.
I need to convert postgres timestamp to date format -mm-dd in a
sql statement.
pt.created_date below is t
Marc Horvath, 14.03.2008 12:35:
I was wondering if anyone had any working sample code of inserting a
blob into a table and then retrieving one from a table for viewing?
I’m using Postgres 8.2, the jdbc is postgresql-8.2-504.jdbc3, and the
Java is 1.6.
I’m also running on a Windows XP Pro bo
Jeff Williams wrote on 22.03.2008 05:20:
I would like to install PostgreSQL manually as part of my applications
install using InnoSetup.
Is there anywhere the steps required to do this and if so where would I find
them?
Many thanks
Jeff
I think you should be able to use the -no-binaries ZIP
Alain Roger wrote on 24.03.2008 15:45:
SELECT count(*) INTO existing_email FROM cust_portal.tmp_newsletterreg;
if (existing_email <>0) then
{
result = false;
}
else
{
result = true;
INSERT INTO cust_portal.tmp_newsletterreg VALUES
(
Bill Wordsworth wrote on 25.03.2008 19:16:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they similar to Oracle's RAC
"clusters", except that they are not aware of each other?
No, absolutely not. Each client request is handled by a
Bill Wordsworth wrote on 25.03.2008 21:04:
On Tue, Mar 25, 2008 at 2:24 PM, Thomas Kellerer <[EMAIL PROTECTED]> wrote:
Bill Wordsworth wrote on 25.03.2008 19:16:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they
Hi,
in my office we were discussing the various ways statement level read
consistency is implemented in different databases, namely Oracle and Postgres.
I am interested in the technical details on how PG determines that a block needs to be
read from from "some other place than the data block"
Pavan Deolasee, 22.04.2008 12:57:
On Tue, Apr 22, 2008 at 4:11 PM, Thomas Kellerer <[EMAIL PROTECTED]> wrote:
I am interested in the technical details on how PG determines that a block
needs to be read from from "some other place than the data block" because
another transac
Roberts, Jon, 22.04.2008 14:56:
As far as I can tell (from the PDF and your quote) Postgres uses a
very
similar concept as Oracle. .
Each transaction has a uniqe number and each tuple contains the
information for which transaction number it is visible.
Oracle moves the old row(s) to the rollb
Hi,
I'm trying to download the HTML version of the manual (8.3.1). It does not seem to be part of the Windows installer any more. Instead the a chm version is included.
At http://www.postgresql.org/docs/manuals/ it says the HTML can be downloaded in the FTP area, but I cannot find any download
Klint Gore, 20.05.2008 09:39:
Thomas Kellerer wrote:
Hi,
I'm trying to download the HTML version of the manual (8.3.1). It does
not seem to be part of the Windows installer any more. Instead the a
chm version is included.
At http://www.postgresql.org/docs/manuals/ it says the HTML c
Enrico SABBADIN, 20.05.2008 15:13:
Hi, I’m evaluating different er modeling tools .. I have to support the
same logical db on postgresql and sqlserver ..
All tools I tried so far ignore the schema information .. all tables end
up living in the default schema.
Have a look at Power*Architect it
Hi,
I am using xpath_table to convert elements from an XML column to "rows".
Now according to
http://www.postgresql.org/docs/8.3/static/xml2.html
this function will be removed in a future version.
That chapter also claims that the new XML syntax covers the functionality of
the xml2 module,
Peter Eisentraut wrote on 24.05.2008 13:35:
Am Mittwoch, 21. Mai 2008 schrieb Thomas Kellerer:
How would I achieve the same without using the deprecated xml2 module?
xpath_table is probably the major piece that is not directly covered by the
new system. So until we have a replacement, we
jcvlz wrote on 25.05.2008 04:41:
/** Not-free **/
Microsoft Visio - (If you already have it, it does work quite well)
DataStudio - 30 day trial
http://www.aquafold.com
DBWrench - 30 day trial
http://www.dbwrench.com/
There are some more non-free ones (although Windows only)
DeZign: htt
D. Dante Lorenso wrote on 15.06.2008 01:00:
I need a tool that will compare 2 database schemas and allow me to
migrate changes from one database to another. What tools do the rest of
you use to accomplish this task?
You can try my SQL Workbench/J:.
http://www.sql-workbench.net/manual/wb-comma
Steve Atkins wrote on 23.06.2008 20:21:
> In real use you're unlikely to hit any limits, theoretical or practical,
I imagine that the 1GB column-value limit is something that could be reached
though. Especially for BLOB (aka bytea) or CLOB (aka text) columns.
Thomas
--
Sent via pgsql-genera
Postgres User wrote on 08.06.2009 23:03:
Hi,
I'm writing a small ORM tool and have written a number of queries to
retrieve table metadata. One piece of data that I'm having trouble
hunting down is the size of a CHAR field. For example, one table has
a 'user_id' column of type CHAR(36). But wh
subodh chaudhari, 17.06.2009 09:05:
Hi ,
I am working on project which include merging of two databases within
postgresql on Linux. I have searched for s/w but didnt get any useful.
So if any one having any information about such s/w please help me out.
This s/w should have GPL. (Opensource s
Mike Christensen wrote on 22.06.2009 00:10:
I just tracked down a bug in my software due to an "unexpected" behavior
in Postgres.. Can someone clarify why this doesn't work (I haven't
tried it on MSSQL or anything else, so I'm not sure if this is the
official SQL standard or anything)..
CREA
Albe Laurenz, 22.06.2009 09:52:
Sorry to be nitpicking, but maybe in that case it adds to clarity:
A comparison with NULL does not return FALSE, but "undefined" or NULL.
Try to run the following queries:
SELECT 1 = 2;
and
SELECT 1 = NULL;
and observe the different result.
In the context of t
Mike Christensen wrote on 23.06.2009 19:37:
Does anyone actually have that (any node can go down and the others still
replicate amongst themselves?)
I think this is what Oracle promises with their RAC technology.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Craig Ringer wrote on 24.06.2009 04:07:
Thomas Kellerer wrote:
Mike Christensen wrote on 23.06.2009 19:37:
Does anyone actually have that (any node can go down and the others still
replicate amongst themselves?)
I think this is what Oracle promises with their RAC technology.
Isn't
fe...@crowfix.com wrote on 30.06.2009 00:08:
I'd like to dump a database schema to a file, probably XML but
anything reasonable is good enough. By "schema", I don't mean the
narrow postgres keyword, but rather the table names, columns,
foreignkeys, triggers, constraints, etc.
I'd really like so
Hi,
the project page of pg_migrator still shows it as a release candidate.
Will there be an official release of it, now that 8.4 is out of the door?
Including Windows binaries?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
Bruce Momjian wrote on 05.07.2009 02:13:
Will there be an official release of it, now that 8.4 is out of the door?
Including Windows binaries?
Yes, I expect sometime in the next five days.
Great, thanks for the info.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
Andreas Wenk wrote on 07.07.2009 09:33:
originally posted at BUGS list - now answering at GENERAL list
Pavel Golub schrieb:
Hello, Oscar.
First of all you shouldn't post such messages here since this is not a
bug for sure.
Take a look on MicroOLAP Database Designer for PostgreSQL at
http://mi
Philippe Lang, 13.07.2009 08:05:
Hi,
Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is
there a chance we can see one day "START WITH... CONNECT BY" in
Postgresql, or is that something 100% oracle-specific?
START WITH is Oracle specific whereas recursive CTEs are an ANSI
David Fetter, 13.07.2009 16:32:
START WITH is Oracle specific whereas recursive CTEs are an ANSI
Standard (supported by PostgreSQL, Firebird and SQL Server).
Not to mention DB2. I'm not sure how close Firebird is to actually
shipping them...
Interesting, didn't know DB2 had them as well.
Martie Krukkeland wrote on 13.07.2009 21:11:
If you are using Windows:
Windows has the build in: Scheduled-Task (this is the Windows-equivelant of
the Unix-Cron).
It can be found in the Configuration-Screen.
Or simply using the "at" command
--
Sent via pgsql-general mailing list (pgsql-ge
Jim Michaels, 15.07.2009 01:47:
most programmer's text editors can't handle more than 2000 characters
per line.
and I want to be able to edit my dumps.
I don't know what you are using, but the following editors can certainly handle
more than 2000 characters:
OpenSource and free:
http://www.p
Steve Choi, 16.07.2009 07:43:
Hello. Thank you for your interesting.
Any person know that how to db export XML file in PostgreSQL?
I use Ver. 8.4 and Operating System Linux. Have a nice day.
I'm not sure I understand your question.
Do you want to export the data of your database into a (
Relyea, Mike wrote on 16.07.2009 21:40:
I need help understanding what I'm doing wrong with an insert statement.
I'm running 8.3.7 on Windows and the DB is complaining about the select
statement in my insert statement.
When using a SELECT for an INSERT the values part is not needed in fact its
Andreas wrote on 17.07.2009 20:06:
Hi,
I'd like to read a csv file into PG 8.4.
COPY relations FROM E'd:\\relations.csv' CSV HEADER;
It throws (translated):
ERROR: can't open file >>d:\relations.csv<< for reading
file or directory not found
Try
COPY relations FROM 'd:/relations.csv' CSV HEAD
Pavel Stehule, 23.07.2009 13:45:
Hello
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
regards
Pavel Stehule
That collection of tips is really nice.
Why isn't there a link from the Postgres Wiki to your page?
Regards
Thomas
-
Pavel Stehule, 23.07.2009 14:50:
look on http://wiki.postgresql.org/wiki/Category:Snippets
That page is not accessible from the Wiki's main page (at least I can't find an
easy way to navigate there)
I think there should be a prominent link right at the start page that links to
that page and
Alban Hertroys, 24.07.2009 13:07:
It would be nice if there were a tool that could do a diff between two
dumps resulting in a new dump with just the statements necessary to
apply the differences. I don't think there is such a tool yet though
(some light Googling does bring up such a tool for sq
Hi,
I was trying to use information from the pg_stats view, when I remembered that 8.4 now has the cool
unnest function.
However I can't seem to get this to work with a column defined as anyarray.
So my query is:
select histogram_bounds
from pg_stats
where tablename = 'my_table'
and attname
Jeff Davis wrote on 25.07.2009 22:44:
It's generally hard to work with values of type anyarray. You have to
cast them to text and then to a normal array type.
For example:
select unnest(histogram_bounds::text::oid[]) from pg_stats where
tablename='pg_amop' and attname='amopopr';
G
Robert James wrote on 26.07.2009 21:35:
Anything like CONNECT BY?
Or any recommended way of querying hiearchial data?
Yes, recursive common table expression (since 8.4)
http://www.postgresql.org/docs/current/static/queries-with.html
Thomas
--
Sent via pgsql-general mailing list (pgsql-gener
Tory M Blue wrote on 27.07.2009 22:45:
And those that have multiple TB's of data, weee another dump and
restore upgrade (pt!)
Isn't that what pg_migrator is for?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
blackwater dev, 28.07.2009 15:12:
I have a table with a lot of columns. One of the columns I want to
alias so have a query of:
select *, column as newname from mytable.
The problem is I now have column and newname in the results. I don't
want to select column by column. How can I do a sele
Hi,
is there a reason why pg_stat_activity is not documented in the chapter "System Catalogs"?
Is this not a "offical" view?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
Magnus Hagander, 30.07.2009 09:24:
On Thu, Jul 30, 2009 at 08:37, Thomas Kellerer wrote:
Hi,
is there a reason why pg_stat_activity is not documented in the chapter
"System Catalogs"?
Is this not a "offical" view?
It's not a catalog, it's a statistics view.
Albe Laurenz, 30.07.2009 11:55:
is there a reason why pg_stat_activity is not documented in
the chapter "System Catalogs"?
I guess it is because they are documented in
http://www.postgresql.org/docs/8.4/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE
in Chapter 26.
Maybe a remark in
Jennifer Trey, 31.07.2009 12:17:
Hi,
I wanted to start with the TuningWizard and then configure the one they
suggested, thinking that I am starting from good default values.
But I am not able to run TuningWizard for some strange reason, but I am
actually mostly interested in some few setting
Raymond O'Donnell wrote on 31.07.2009 18:12:
On 31/07/2009 16:57, Wang Kuo-Ying wrote:
Command:
copy test to 'c:/test.csv'
delimiters ',' ;
but the error ERROR: could not open file "c:/test.csv" for writing:
Permission denied
Looks like a permissions problem - check that the user as which t
Paul Taylor, 04.08.2009 15:48:
Thats a shame, I wanted to write junit test for a java program that
queried a database, requiring a full database to be available for unit
tests is not really an environment I want to have.
Well if you want to test the database, you will need a full database.
Paul Taylor wrote on 04.08.2009 17:04:
Well if you want to test the database, you will need a full database.
It was a simple question, does Postgres have an embedded mode (which is
still a full database) but unfortunately it does not.
I'm just trying to help get your test environment into prop
Hi,
I was going through the list of application at
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
and was wondering whom I should contact to get my application listed there as well.
It is a Java based SQL tool (http://www.sql-workbench.net) and supports
PostgreSQL (
Craig Ringer, 24.08.2009 08:51:
You'll probably want to initdb, edit the postgresql.conf created by
initdb as desired, then start the postmaster manually using pg_ctl
(making sure to point pg_ctl at the data directory you created). It's
not hard.
Yep, I have done that as well (to quickly set up
Alvaro Herrera wrote on 24.08.2009 04:24:
I think that page is pretty much unmaintained. Feel free to add your
product, provided you don't turn it into a marketing opportunity (and be
prepared for others to edit your description).
Well, as it is a open source project, marketing doesn't really
Hi,
it seems that you cannot download PostgreSQL from the EnterpriseDB website without first registering with EnterpriseDB. I can somhow understand this cumbersome requirement for their own products, but I do not like the taste of it for the "plain" PostgreSQL builds. This doesn't sound right to
Magnus Hagander wrote on 26.08.2009 20:37:
You can certainly get it without registering. The link from the
PostgreSQL download page points to
http://www.enterprisedb.com/products/pgdownload.do, where no
registration is required.
How did you end up at the page above? Perhaps we have a link that
BlackMage wrote on 27.08.2009 20:09:
I've been trying to figure this problem out with just using sql but I'm not
sure how too. I have a table that holds events for each week but I only want
to select events happening for the current week(Mon-Sun). So can anyone help
me out with this just using sq
Sam Mason wrote on 27.08.2009 21:06:
The OP leaves it somewhat open, but wouldn't date_trunc be better here?
Otherwise you'll end up getting values for other years as well as the
current one.
Good point, I didn't think of that :)
As an alternative, one could explicitely add the year into the
Hi,
I'm trying to extend the Postgres support in my SQL tool. I'm trying to recreate the SQL for a sequence, and I wonder if there is a way to find out the column to which a sequence "belongs".
I'm talking either about sequences that are created automatically by PG when
using the serial datat
Sam Mason wrote on 27.08.2009 21:51:
The information is all in the system catalogs; I've not had much
opportunity to fiddle with them so far but the following may be a start
to help get things out for you.
SELECT c.relname, a.attname, t.relname
FROM pg_class c, pg_depend d, pg_class t, pg_at
Gauthier, Dave wrote on 27.08.2009 23:17:
Are there any GUI apps out there that can be used to edit (insert,
update, delete) table data? SOmething with enough smarts to sniff out
constraint violations and report accordingly. Also, ability to eval
constraints at commit time inside a transactio
Gauthier, Dave, 28.08.2009 16:08:
H.. I didn't see anything in
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
that stood out in terms of being able to edit table content in a GUI.
Maybe MSACCESS, but my PG DB is served on Linux.
The question is: what do you mean wit
Inigo Barandiaran, 02.09.2009 12:39:
We have included PostgreSQL 8.3(exe) installation in the installation
process of our software, and we are experimenting some errors, mainly
related with Windows Vista. The problem is that the installation of
PosgreSQL seems to be correct, but the service is no
Inigo Barandiaran, 02.09.2009 14:53:
Thanks Thomas!.
That sounds very interesting. How can I set privileges for writing in data
directory for the postgres user account?.
Right click on the directory and choose "Security". Anything after that is
off-topic in this list ;)
Or is it very to di
Inigo Barandiaran, 03.09.2009 14:47:
Finally, I installed posgre database out of "program Files" as Thomas
suggested and I gave full privileges to posgre user to data folder and
everything works correctly :)
Do you know how can I install posgre in "program Files" in Vista?. I might
some users of
Hi,
if someone from EnterpriseDB is "listening":
The links for Windows and OSX binaries at
http://www.enterprisedb.com/products/pgbindownload.do
are interchanged.
When clicking on the Windows icon, you'll get the Mac binaries, when clicking
on the Mac icon, you'll get the windows binarie
I can not find command in postgres - With ... as
You need Postgres 8.4 for that:
http://www.postgresql.org/docs/current/static/queries-with.html
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpr
NTPT wrote on 11.09.2009 03:06:
Hi all. is there available some freeware and/or opensource visual
database design tool for postgresql ? Something like commercial microOLAP ?
thanx for help
I like Power*Architect although it does have some quirks.
I recently discovered another one, which als
Daniel Schuchardt wrote on 13.09.2009 18:51:
UPDATE belzeil_frei SET bz_zubez= '*', bz_zubez_rtf=
'{\\rtf1\\ansi\\deff0{\\fonttbl{\\f0\\fnil\\fcharset0
Arial;}}\r\n\\viewkind4\\uc1\\pard\\lang1031\\fs20 *\r\n\\par }\r\n\0'
WHERE dbrid=295116
Result : ERROR: invalid byte sequence for encoding
301 - 400 of 804 matches
Mail list logo
